APPS.XDP_PURGE dependencies on XNP_TIMER_REGISTRY

Line 176: SELECT COUNT(*) INTO l_no_records FROM XNP_TIMER_REGISTRY

172: WHERE ORDER_ID = p_order_id;
173: RECORDS_PURGED_MSGS(l_no_records,'XNP_CALLBACK_EVENTS WHERE ORDER_ID = '||p_order_id,
174: 'XDP_FOUND_REC',0);
175:
176: SELECT COUNT(*) INTO l_no_records FROM XNP_TIMER_REGISTRY
177: WHERE ORDER_ID = p_order_id;
178: RECORDS_PURGED_MSGS(l_no_records,'XNP_TIMER_REGISTRY WHERE ORDER_ID = '||p_order_id,
179: 'XDP_FOUND_REC',0);
180:

Line 178: RECORDS_PURGED_MSGS(l_no_records,'XNP_TIMER_REGISTRY WHERE ORDER_ID = '||p_order_id,

174: 'XDP_FOUND_REC',0);
175:
176: SELECT COUNT(*) INTO l_no_records FROM XNP_TIMER_REGISTRY
177: WHERE ORDER_ID = p_order_id;
178: RECORDS_PURGED_MSGS(l_no_records,'XNP_TIMER_REGISTRY WHERE ORDER_ID = '||p_order_id,
179: 'XDP_FOUND_REC',0);
180:
181: SELECT COUNT(*) INTO l_no_records FROM XNP_SYNC_REGISTRATION
182: WHERE ORDER_ID = p_order_id;

Line 807: SELECT COUNT(*) INTO l_temp FROM XNP_TIMER_REGISTRY

803: SELECT COUNT(*) INTO l_temp FROM XNP_CALLBACK_EVENTS
804: WHERE order_id = p_order_id;
805: RECORDS_PURGED_MSGS(l_temp,'XNP_CALLBACK_EVENTS WHERE ORDER_ID = '
806: ||p_order_id ,l_rec_name,0);
807: SELECT COUNT(*) INTO l_temp FROM XNP_TIMER_REGISTRY
808: WHERE order_id = p_order_id;
809: RECORDS_PURGED_MSGS(l_temp,'XNP_TIMER_REGISTRY WHERE ORDER_ID = '
810: ||p_order_id ,l_rec_name,0);
811: SELECT COUNT(*) INTO l_temp FROM XNP_SYNC_REGISTRATION

Line 809: RECORDS_PURGED_MSGS(l_temp,'XNP_TIMER_REGISTRY WHERE ORDER_ID = '

805: RECORDS_PURGED_MSGS(l_temp,'XNP_CALLBACK_EVENTS WHERE ORDER_ID = '
806: ||p_order_id ,l_rec_name,0);
807: SELECT COUNT(*) INTO l_temp FROM XNP_TIMER_REGISTRY
808: WHERE order_id = p_order_id;
809: RECORDS_PURGED_MSGS(l_temp,'XNP_TIMER_REGISTRY WHERE ORDER_ID = '
810: ||p_order_id ,l_rec_name,0);
811: SELECT COUNT(*) INTO l_temp FROM XNP_SYNC_REGISTRATION
812: WHERE order_id = p_order_id;
813: RECORDS_PURGED_MSGS(l_temp,'XNP_SYNC_REGISTRATION WHERE ORDER_ID = '

Line 843: DELETE FROM XNP_TIMER_REGISTRY

839:
840: DELETE FROM XNP_CALLBACK_EVENTS
841: WHERE order_id = p_order_id;
842:
843: DELETE FROM XNP_TIMER_REGISTRY
844: WHERE order_id = p_order_id;
845: DELETE FROM XNP_SYNC_REGISTRATION
846: WHERE order_id = p_order_id ;
847: DELETE FROM XDP_ORDER_HEADERS

Line 1034: DELETE FROM xnp_timer_registry WHERE timer_id = p_msg_id;

1030: -- timers associated with orders are purged with orders
1031: --
1032: PROCEDURE XDP_PRUGE_TIMER(p_msg_id IN NUMBER) IS
1033: BEGIN
1034: DELETE FROM xnp_timer_registry WHERE timer_id = p_msg_id;
1035: END XDP_PRUGE_TIMER;
1036:
1037: -- Procedure XDP_PURGE_MESSAGES
1038: -- Purge runtime messages from SFM