APPS.OZF_TRACING_ORDER_PVT dependencies on OZF_RESALE_LOGS_ALL

Line 803: INSERT INTO ozf_resale_logs_all(

799: CLOSE non_tracing_count_csr;
800:
801: IF l_non_tracing_count > 0 THEN
802: BEGIN
803: INSERT INTO ozf_resale_logs_all(
804: RESALE_LOG_ID,
805: RESALE_ID,
806: RESALE_ID_TYPE,
807: ERROR_CODE,

Line 813: ozf_resale_logs_all_s.nextval,

809: COLUMN_NAME,
810: COLUMN_VALUE,
811: ORG_ID
812: ) SELECT
813: ozf_resale_logs_all_s.nextval,
814: resale_line_int_id,
815: 'IFACE',
816: 'OZF_RESALE_NON_TRC',
817: FND_MESSAGE.get_string('OZF','OZF_RESALE_NON_TRC'),

Line 826: FROM ozf_resale_logs_all a

822: WHERE b.status_code = 'OPEN'
823: AND b.tracing_flag = 'F'
824: AND b.resale_batch_id = p_resale_batch_id
825: AND NOT EXISTS(SELECT 1
826: FROM ozf_resale_logs_all a
827: WHERE a.resale_id = b.resale_line_int_id
828: AND a.RESALE_ID_TYPE = 'IFACE'
829: AND a.error_code ='OZF_RESALE_NON_TRC'
830: );