APPS.OZF_RESALE_COMMON_PVT dependencies on OZF_RESALE_LOGS_ALL

Line 50: -- This procedure inserts a record in ozf_resale_logs_all table

46: -- PROCEDURE
47: -- Insert_Resale_Log
48: --
49: -- PURPOSE
50: -- This procedure inserts a record in ozf_resale_logs_all table
51: --
52: -- PARAMETERS
53: --
54: --

Line 148: -- This procedure inserts a lot of records in ozf_resale_logs_all table

144: -- PROCEDURE
145: -- Bulk_Insert_Resale_Log
146: --
147: -- PURPOSE
148: -- This procedure inserts a lot of records in ozf_resale_logs_all table
149: --
150: -- PARAMETERS
151: --
152: --

Line 188: INSERT INTO ozf_resale_logs_all (

184: -- End: bug # 5997978 fixed
185:
186: -- bulk insert into resale logs table for above id's
187: FORALL i in 1..p_id_value.count
188: INSERT INTO ozf_resale_logs_all (
189: RESALE_LOG_ID,
190: RESALE_ID,
191: RESALE_ID_TYPE,
192: ERROR_CODE,

Line 198: ozf_resale_logs_all_s.nextval,

194: COLUMN_NAME,
195: COLUMN_VALUE,
196: ORG_ID
197: ) VALUES (
198: ozf_resale_logs_all_s.nextval,
199: p_id_value(i),
200: p_id_type,
201: p_error_code(i),
202: FND_MESSAGE.get_string('OZF',p_error_code(i)),

Line 569: FROM ozf_resale_logs_all orl

565: --
566: BEGIN
567: UPDATE ozf_resale_lines_int_all orli
568: SET orli.dispute_code = (SELECT orl.error_code
569: FROM ozf_resale_logs_all orl
570: WHERE orl.resale_id = orli.resale_line_int_id
571: AND resale_id_type = 'IFACE'
572: AND rownum = 1)
573: , orli.status_code = G_BATCH_ADJ_DISPUTED

Line 580: FROM ozf_resale_logs_all c

576: , response_code = 'N'
577: WHERE orli.resale_batch_id = p_batch_id
578: AND orli.status_code = p_line_status
579: AND EXISTS( SELECT 1
580: FROM ozf_resale_logs_all c
581: WHERE c.resale_id = orli.resale_line_int_id
582: AND c.resale_id_type = 'IFACE');
583: EXCEPTION
584: WHEN OTHERS THEN