APPS.OZF_RESALE_COMMON_PVT dependencies on OZF_RESALE_LOGS

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 110: OZF_RESALE_LOGS_PKG.Insert_Row(

106: CLOSE OZF_RESALE_COMMON_PVT.gc_iface_org_id;
107: END IF;
108:
109: BEGIN
110: OZF_RESALE_LOGS_PKG.Insert_Row(
111: px_resale_log_id => l_log_id,
112: p_resale_id => p_id_value,
113: p_resale_id_type => p_id_type,
114: p_error_code => p_error_code,

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

Line 4999: DELETE FROM OZF_RESALE_LOGS

4995: -- Initialize API return status to sucess
4996: x_return_status := FND_API.G_RET_STS_SUCCESS;
4997:
4998: -- delete batch logs
4999: DELETE FROM OZF_RESALE_LOGS
5000: WHERE resale_id = p_resale_batch_id
5001: AND resale_id_type = G_ID_TYPE_BATCH;
5002:
5003: -- delete interface logs

Line 5004: DELETE FROM OZF_RESALE_LOGS a

5000: WHERE resale_id = p_resale_batch_id
5001: AND resale_id_type = G_ID_TYPE_BATCH;
5002:
5003: -- delete interface logs
5004: DELETE FROM OZF_RESALE_LOGS a
5005: WHERE exists (
5006: SELECT 1
5007: FROM OZF_RESALE_LINES_INT b
5008: WHERE b.resale_batch_id = p_resale_batch_id