APPS.OZF_TRACING_ORDER_PVT dependencies on OZF_RESALE_LOGS

Line 860: INSERT INTO ozf_resale_logs_all(

856: CLOSE non_tracing_count_csr;
857:
858: IF l_non_tracing_count > 0 THEN
859: BEGIN
860: INSERT INTO ozf_resale_logs_all(
861: RESALE_LOG_ID,
862: RESALE_ID,
863: RESALE_ID_TYPE,
864: ERROR_CODE,

Line 870: ozf_resale_logs_all_s.nextval,

866: COLUMN_NAME,
867: COLUMN_VALUE,
868: ORG_ID
869: ) SELECT
870: ozf_resale_logs_all_s.nextval,
871: resale_line_int_id,
872: 'IFACE',
873: 'OZF_RESALE_NON_TRC',
874: FND_MESSAGE.get_string('OZF','OZF_RESALE_NON_TRC'),

Line 883: FROM ozf_resale_logs_all a

879: WHERE b.status_code = 'OPEN'
880: AND b.tracing_flag = 'F'
881: AND b.resale_batch_id = p_resale_batch_id
882: AND NOT EXISTS(SELECT 1
883: FROM ozf_resale_logs_all a
884: WHERE a.resale_id = b.resale_line_int_id
885: AND a.RESALE_ID_TYPE = 'IFACE'
886: AND a.error_code ='OZF_RESALE_NON_TRC'
887: );

Line 1179: DELETE FROM ozf_resale_logs

1175:
1176: For J in 1..l_order_set_tbl.LAST LOOP
1177: -- Purge the any error message that might be there.
1178: BEGIN
1179: DELETE FROM ozf_resale_logs
1180: WHERE resale_id = l_order_set_tbl(J).resale_line_int_id
1181: AND resale_id_type = OZF_RESALE_COMMON_PVT.G_ID_TYPE_IFACE;
1182: EXCEPTION
1183: WHEN OTHERS THEN