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;
173: RECORDS_PURGED_MSGS(l_no_records,'XNP_CALLBACK_EVENTS WHERE ORDER_ID = '||p_order_id,
174: 'XDP_FOUND_REC',0);
175:
169: 'XDP_FOUND_REC',0);
170:
171: SELECT COUNT(*) INTO l_no_records FROM XNP_CALLBACK_EVENTS
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;
799: END IF;
800:
801: RECORDS_PURGED_MSGS(l_temp,'XNP_MSGS WHERE ORDER_ID = '||p_order_id
802: ,l_rec_name,0);
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
801: RECORDS_PURGED_MSGS(l_temp,'XNP_MSGS WHERE ORDER_ID = '||p_order_id
802: ,l_rec_name,0);
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 = '
836: (SELECT MSG_CODE FROM XNP_MSG_TYPES_B
837: WHERE PROTECTED_FLAG='Y');
838: END IF;
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;