[Home] [Help]
1: PACKAGE BODY cs_sr_delete_util AS
2: /* $Header: csvsrdlb.pls 120.10 2008/01/24 10:51:53 nveerara ship $ */
3:
4: --------------------------------------------------------------------------------
5: -- Package level definitions
3:
4: --------------------------------------------------------------------------------
5: -- Package level definitions
6: --------------------------------------------------------------------------------
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CS_SR_DELETE_UTIL';
8:
9: TYPE t_number_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
10: TYPE t_date_tbl IS TABLE OF DATE INDEX BY BINARY_INTEGER;
11: TYPE t_string_tbl IS TABLE OF VARCHAR2(3) INDEX BY BINARY_INTEGER;
94: -- Description
95: -- This API physically removes the SRs and all its child objects after
96: -- performing validations wherever required. This is a wrapper which
97: -- delegates the work to another helper API named
98: -- cs_sr_delete_util.delete_servicerequest
99: --
100: -- HISTORY
101: --
102: ----------------+------------+--------------------------------------------------
107: ----------------+------------+--------------------------------------------------
108: /*#
109: * This API physically removes the SRs and all its child objects after
110: * performing validations wherever required. This is a wrapper which delegates
111: * the work to another helper API named cs_sr_delete_util.delete_servicerequest
112: * @param p_object_type Type of object for which this procedure is being called.
113: * (Here it will be 'SR')
114: * @param p_processing_set_id Id that helps the API in identifying the set of
115: * SRs for which the child objects have to be deleted.
1001: (
1002: fnd_log.level_statement
1003: , L_LOG_MODULE || 'contacts_purge_start'
1004: , 'calling the Contacts purge API '
1005: || 'cs_sr_delete_util.delete_contacts'
1006: );
1007: END IF ;
1008:
1009: -- This procedure deletes all the contacts related to SRs present in the
1010: -- global temp table with purge status NULL, and also the contact audit
1011: -- information, party role extended attributes and party role extended
1012: -- attributes audit information related to the contacts.
1013:
1014: CS_SR_DELETE_UTIL.Delete_Contacts
1015: (
1016: p_api_version_number => '1.0'
1017: , p_init_msg_list => FND_API.G_FALSE
1018: , p_commit => FND_API.G_FALSE
1049: (
1050: fnd_log.level_statement
1051: , L_LOG_MODULE || 'sr_attr_purge_start'
1052: , 'calling the SR Extended Attribs purge API '
1053: || 'cs_sr_delete_util.delete_sr_attributes'
1054: );
1055: END IF ;
1056:
1057: -- This procedure deletes all the extended attributes related to SRs
1057: -- This procedure deletes all the extended attributes related to SRs
1058: -- present in the global temp table with purge status NULL and also the
1059: -- audit information related to the extended attributes.
1060:
1061: CS_SR_DELETE_UTIL.Delete_Sr_Attributes
1062: (
1063: p_api_version_number => '1.0'
1064: , p_init_msg_list => FND_API.G_FALSE
1065: , p_commit => FND_API.G_FALSE
1096: (
1097: fnd_log.level_statement
1098: , L_LOG_MODULE || 'sr_audit_purge_start'
1099: , 'calling the SR Audit purge API '
1100: || 'cs_sr_delete_util.delete_audit_records'
1101: );
1102: END IF ;
1103:
1104: -- This procedure deletes all the audit information related to SRs
1103:
1104: -- This procedure deletes all the audit information related to SRs
1105: -- present in the global temp table with purge status NULL
1106:
1107: CS_SR_DELETE_UTIL.Delete_Audit_Records
1108: (
1109: p_api_version_number => '1.0'
1110: , p_init_msg_list => FND_API.G_FALSE
1111: , p_commit => FND_API.G_FALSE
3620: END IF;
3621: END IF;
3622: END Check_User_Termination;
3623: --------------------------------------------------------------------------------
3624: END cs_sr_delete_util;