insert | insert | AUTO_ID: servicePlanGroupApprovalChkID
PRE_DATA_ACCESS: yes
| Method to insert SPG Approval check details. | |
readWithSPGType | ns | | Read the record given by the unique ID in the key and return all of the details along with the type code for the Service Plan Group. | SQL |
modify | modify | OPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
| Method to modify SPG Approval check details. | |
searchWithSPGTypeByUsername | nsmulti | | List all service plan group approval check entries for a given username and include the service plan group type code for display purposes. | SQL |
cancel | nsmodify | OPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
| Method to cancel SPG Approval check details. | |
validateCancel | | | Ensures validations are done before data modification for Service Plan Group Approval Check. | |
validateDetails | | | Ensures common validations are done before inserting and modifying data for Service Plan Group Approval Check | |
validateInsert | | | Ensures common validations are done before inserting data for Service Plan Group Approval Check | |
validateModify | | | Ensures common validations are done before modifying data for Service Plan Group Approval Check | |
countByUsername | ns | | Count existing entries that match for estimatedCost, planItemID, statusCode, and userName. Essentially look for duplicate entries
| SQL |
countByUsernameAllTypes | ns | | Count all entries that match userName, estimatedCost, statusCode and a null servicePlanGroupID | SQL |
countByUsernameForModify | ns | | Count entries that match this one based on userName, estimatedCost, statusCode, servicePlanGroupID and which do not match the provided unique ID. Essentially this is checking for duplicates of an entry that is about to be modified. | SQL |
countByUsernameAllTypesForModify | ns | | Count entries that match this one based on userName, estimatedCost, statusCode, have a null servicePlanGroupID, and which do not match the provided unique ID. Essentially this is checking for duplicates of an entry that is about to be modified | SQL |
readStatus | nsread | | Return the status details for a given entry | |