APPS.XDP_PURGE dependencies on XDP_ORDER_PARAMETERS

Line 159: SELECT COUNT(*) INTO l_no_records FROM XDP_ORDER_PARAMETERS

155:
156: RECORDS_PURGED_MSGS(l_no_records,'XNP_MSGS WHERE ORDER_ID = '||p_order_id,
157: 'XDP_FOUND_REC',0);
158:
159: SELECT COUNT(*) INTO l_no_records FROM XDP_ORDER_PARAMETERS
160: WHERE ORDER_ID = p_order_id;
161:
162: RECORDS_PURGED_MSGS(l_no_records,'XDP_ORDER_PARAMETERS WHERE ORDER_ID = '||p_order_id,
163: 'XDP_FOUND_REC',0);

Line 162: RECORDS_PURGED_MSGS(l_no_records,'XDP_ORDER_PARAMETERS WHERE ORDER_ID = '||p_order_id,

158:
159: SELECT COUNT(*) INTO l_no_records FROM XDP_ORDER_PARAMETERS
160: WHERE ORDER_ID = p_order_id;
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;

Line 780: SELECT COUNT(*) INTO l_temp FROM XDP_ORDER_PARAMETERS

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 = '
783: ||p_order_id,l_rec_name,0);
784:

Line 782: RECORDS_PURGED_MSGS(l_temp,'XDP_ORDER_PARAMETERS WHERE 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 = '
783: ||p_order_id,l_rec_name,0);
784:
785: -- If p_purge_msg is true, purge both internal and external
786: -- messages associated with the order

Line 822: DELETE FROM XDP_ORDER_PARAMETERS

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: --
825: -- if this flag is true, we will delete all messages associated with this order
826: -- else we will only delete internal messages that are associated with this order