APPS.XDP_PURGE dependencies on XDP_ORDER_RELATIONSHIPS

Line 147: SELECT COUNT(*) INTO l_no_records FROM XDP_ORDER_RELATIONSHIPS

143: IF l_no_records > 0 THEN
144: l_order_exist := TRUE;
145: END IF;
146:
147: SELECT COUNT(*) INTO l_no_records FROM XDP_ORDER_RELATIONSHIPS
148: WHERE ORDER_ID = p_order_id;
149:
150: RECORDS_PURGED_MSGS(l_no_records ,'XDP_ORDER_RELATIONSHIPS WHERE ORDER_ID = '||p_order_id,
151: 'XDP_FOUND_REC',0);

Line 150: RECORDS_PURGED_MSGS(l_no_records ,'XDP_ORDER_RELATIONSHIPS WHERE ORDER_ID = '||p_order_id,

146:
147: SELECT COUNT(*) INTO l_no_records FROM XDP_ORDER_RELATIONSHIPS
148: WHERE ORDER_ID = p_order_id;
149:
150: RECORDS_PURGED_MSGS(l_no_records ,'XDP_ORDER_RELATIONSHIPS WHERE ORDER_ID = '||p_order_id,
151: 'XDP_FOUND_REC',0);
152:
153: SELECT COUNT(*) INTO l_no_records FROM XNP_MSGS
154: WHERE ORDER_ID = p_order_id;

Line 381: FROM XDP_ORDER_RELATIONSHIPS

377: -- purging conditions, then the current order is not deletable.
378: --
379: CURSOR c_order_relation(p_order_id VARCHAR2) IS
380: SELECT RELATED_ORDER_ID
381: FROM XDP_ORDER_RELATIONSHIPS
382: START WITH ORDER_ID = p_order_id
383: CONNECT BY PRIOR RELATED_ORDER_ID = ORDER_ID;
384:
385: l_order_state XDP_ORDER_HEADERS.STATUS_CODE%TYPE;

Line 776: SELECT COUNT(*) INTO l_temp FROM XDP_ORDER_RELATIONSHIPS

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 = '
779: ||p_order_id,l_rec_name,0);
780: SELECT COUNT(*) INTO l_temp FROM XDP_ORDER_PARAMETERS

Line 778: RECORDS_PURGED_MSGS(l_temp,'XDP_ORDER_RELATIONSHIPS WHERE ORDER_ID = '

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 = '
779: ||p_order_id,l_rec_name,0);
780: SELECT COUNT(*) INTO l_temp FROM XDP_ORDER_PARAMETERS
781: WHERE order_id = p_order_id;
782: RECORDS_PURGED_MSGS(l_temp,'XDP_ORDER_PARAMETERS WHERE ORDER_ID = '

Line 820: DELETE FROM XDP_ORDER_RELATIONSHIPS

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
823: WHERE order_id = p_order_id;
824: --