APPS.QP_CUST_MRG_DATA_CLEANUP dependencies on QP_CUST_MRG_DATA_CLEANUP

Line 1: PACKAGE BODY QP_CUST_MRG_DATA_CLEANUP AS

1: PACKAGE BODY QP_CUST_MRG_DATA_CLEANUP AS
2: /* $Header: QPXCMDCB.pls 120.0 2005/06/02 00:32:10 appldev noship $ */
3:
4: g_count NUMBER := 0;
5:

Line 33: oe_debug_pub.add('Begin QP_CUST_MRG_DATA_CLEANUP.Agreement_Merge()');

29: for update nowait;
30:
31: BEGIN
32:
33: oe_debug_pub.add('Begin QP_CUST_MRG_DATA_CLEANUP.Agreement_Merge()');
34:
35: /**************************************************
36: Merge Agreements at both site and customer Level
37: **************************************************/

Line 101: oe_debug_pub.add('End QP_CUST_MRG_DATA_CLEANUP.Agreement_Merge()');

97: oe_debug_pub.add(g_count || ' rows updated');
98:
99: END IF;
100:
101: oe_debug_pub.add('End QP_CUST_MRG_DATA_CLEANUP.Agreement_Merge()');
102:
103: EXCEPTION
104: WHEN OTHERS THEN
105: oe_debug_pub.add('Error in QP_CUST_MRG_DATA_CLEANUP.Agreement_Merge()');

Line 105: oe_debug_pub.add('Error in QP_CUST_MRG_DATA_CLEANUP.Agreement_Merge()');

101: oe_debug_pub.add('End QP_CUST_MRG_DATA_CLEANUP.Agreement_Merge()');
102:
103: EXCEPTION
104: WHEN OTHERS THEN
105: oe_debug_pub.add('Error in QP_CUST_MRG_DATA_CLEANUP.Agreement_Merge()');
106: oe_debug_pub.add(substr(sqlerrm, 1, 2000));
107: raise;
108:
109: END Agreement_Merge;

Line 174: oe_debug_pub.add('Begin QP_CUST_MRG_DATA_CLEANUP.Qualifier_Merge()');

170: for update nowait;
171:
172: BEGIN
173:
174: oe_debug_pub.add('Begin QP_CUST_MRG_DATA_CLEANUP.Qualifier_Merge()');
175:
176: /**************************************************
177: Merge Qualifiers at both site and customer Level
178: **************************************************/

Line 312: oe_debug_pub.add('End QP_CUST_MRG_DATA_CLEANUP.Qualifier_Merge()');

308:
309:
310: END IF;
311:
312: oe_debug_pub.add('End QP_CUST_MRG_DATA_CLEANUP.Qualifier_Merge()');
313:
314: EXCEPTION
315: WHEN OTHERS THEN
316: oe_debug_pub.add('Error in QP_CUST_MRG_DATA_CLEANUP.Qualifier_Merge()');

Line 316: oe_debug_pub.add('Error in QP_CUST_MRG_DATA_CLEANUP.Qualifier_Merge()');

312: oe_debug_pub.add('End QP_CUST_MRG_DATA_CLEANUP.Qualifier_Merge()');
313:
314: EXCEPTION
315: WHEN OTHERS THEN
316: oe_debug_pub.add('Error in QP_CUST_MRG_DATA_CLEANUP.Qualifier_Merge()');
317: oe_debug_pub.add(substr(sqlerrm, 1, 2000));
318: raise;
319:
320: END Qualifier_Merge;

Line 326: oe_debug_pub.add('Begin QP_CUST_MRG_DATA_CLEANUP.Merge()');

322:
323: PROCEDURE Merge (req_id NUMBER, set_num NUMBER, process_mode VARCHAR2) IS
324: BEGIN
325:
326: oe_debug_pub.add('Begin QP_CUST_MRG_DATA_CLEANUP.Merge()');
327:
328: Agreement_Merge(req_id, set_num, process_mode);
329: Qualifier_Merge(req_id, set_num, process_mode);
330:

Line 331: oe_debug_pub.add('End QP_CUST_MRG_DATA_CLEANUP.Merge()');

327:
328: Agreement_Merge(req_id, set_num, process_mode);
329: Qualifier_Merge(req_id, set_num, process_mode);
330:
331: oe_debug_pub.add('End QP_CUST_MRG_DATA_CLEANUP.Merge()');
332:
333: EXCEPTION
334: when others then
335: raise;

Line 339: END QP_CUST_MRG_DATA_CLEANUP;

335: raise;
336:
337: END Merge;
338:
339: END QP_CUST_MRG_DATA_CLEANUP;