APPS.XDP_PURGE dependencies on XDP_ORDER_BUNDLES

Line 165: SELECT COUNT(*) INTO l_no_records FROM XDP_ORDER_BUNDLES

161:
162: RECORDS_PURGED_MSGS(l_no_records,'XDP_ORDER_PARAMETERS WHERE ORDER_ID = '||p_order_id,
163: 'XDP_FOUND_REC',0);
164:
165: SELECT COUNT(*) INTO l_no_records FROM XDP_ORDER_BUNDLES
166: WHERE ORDER_ID = p_order_id;
167:
168: RECORDS_PURGED_MSGS(l_no_records,'XDP_ORDER_BUNDLES WHERE ORDER_ID = '||p_order_id,
169: 'XDP_FOUND_REC',0);

Line 168: RECORDS_PURGED_MSGS(l_no_records,'XDP_ORDER_BUNDLES WHERE ORDER_ID = '||p_order_id,

164:
165: SELECT COUNT(*) INTO l_no_records FROM XDP_ORDER_BUNDLES
166: WHERE ORDER_ID = p_order_id;
167:
168: RECORDS_PURGED_MSGS(l_no_records,'XDP_ORDER_BUNDLES WHERE ORDER_ID = '||p_order_id,
169: 'XDP_FOUND_REC',0);
170:
171: SELECT COUNT(*) INTO l_no_records FROM XNP_CALLBACK_EVENTS
172: WHERE ORDER_ID = p_order_id;

Line 771: SELECT COUNT(*) INTO l_temp FROM XDP_ORDER_BUNDLES

767: DELETE_LINE_ITEMS(p_order_id,p_run_mode);
768: DELETE_WF_ITEMS(p_order_id,p_run_mode);
769:
770: IF ((bAudit = 'TRUE') AND (p_run_mode = 'PURGE')) or (p_run_mode = 'VERIFY') THEN
771: SELECT COUNT(*) INTO l_temp FROM XDP_ORDER_BUNDLES
772: WHERE order_id = p_order_id;
773:
774: RECORDS_PURGED_MSGS(l_temp,'XDP_ORDER_BUNDLES WHERE ORDER_ID = '
775: ||p_order_id,l_rec_name,0);

Line 774: RECORDS_PURGED_MSGS(l_temp,'XDP_ORDER_BUNDLES WHERE ORDER_ID = '

770: IF ((bAudit = 'TRUE') AND (p_run_mode = 'PURGE')) or (p_run_mode = 'VERIFY') THEN
771: SELECT COUNT(*) INTO l_temp FROM XDP_ORDER_BUNDLES
772: WHERE order_id = p_order_id;
773:
774: RECORDS_PURGED_MSGS(l_temp,'XDP_ORDER_BUNDLES WHERE ORDER_ID = '
775: ||p_order_id,l_rec_name,0);
776: SELECT COUNT(*) INTO l_temp FROM XDP_ORDER_RELATIONSHIPS
777: WHERE order_id = p_order_id;
778: RECORDS_PURGED_MSGS(l_temp,'XDP_ORDER_RELATIONSHIPS WHERE ORDER_ID = '

Line 818: DELETE FROM XDP_ORDER_BUNDLES

814: ||p_order_id ,l_rec_name,0);
815: END IF;
816:
817: IF p_run_mode = 'PURGE' THEN
818: DELETE FROM XDP_ORDER_BUNDLES
819: WHERE order_id = p_order_id;
820: DELETE FROM XDP_ORDER_RELATIONSHIPS
821: WHERE order_id = p_order_id;
822: DELETE FROM XDP_ORDER_PARAMETERS