APPS.OZF_RESALE_COMMON_PVT dependencies on OZF_RESALE_LOGS

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

32: -- PROCEDURE
33: -- Insert_Resale_Log
34: --
35: -- PURPOSE
36: -- This procedure inserts a record in ozf_resale_logs_all table
37: --
38: -- PARAMETERS
39: --
40: --

Line 96: OZF_RESALE_LOGS_PKG.Insert_Row(

92: CLOSE OZF_RESALE_COMMON_PVT.gc_iface_org_id;
93: END IF;
94:
95: BEGIN
96: OZF_RESALE_LOGS_PKG.Insert_Row(
97: px_resale_log_id => l_log_id,
98: p_resale_id => p_id_value,
99: p_resale_id_type => p_id_type,
100: p_error_code => p_error_code,

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

130: -- PROCEDURE
131: -- Bulk_Insert_Resale_Log
132: --
133: -- PURPOSE
134: -- This procedure inserts a lot of records in ozf_resale_logs_all table
135: --
136: -- PARAMETERS
137: --
138: --

Line 174: INSERT INTO ozf_resale_logs_all (

170: -- End: bug # 5997978 fixed
171:
172: -- bulk insert into resale logs table for above id's
173: FORALL i in 1..p_id_value.count
174: INSERT INTO ozf_resale_logs_all (
175: RESALE_LOG_ID,
176: RESALE_ID,
177: RESALE_ID_TYPE,
178: ERROR_CODE,

Line 184: ozf_resale_logs_all_s.nextval,

180: COLUMN_NAME,
181: COLUMN_VALUE,
182: ORG_ID
183: ) VALUES (
184: ozf_resale_logs_all_s.nextval,
185: p_id_value(i),
186: p_id_type,
187: p_error_code(i),
188: FND_MESSAGE.get_string('OZF',p_error_code(i)),

Line 555: FROM ozf_resale_logs_all orl

551: --
552: BEGIN
553: UPDATE ozf_resale_lines_int_all orli
554: SET orli.dispute_code = (SELECT orl.error_code
555: FROM ozf_resale_logs_all orl
556: WHERE orl.resale_id = orli.resale_line_int_id
557: AND resale_id_type = 'IFACE'
558: AND rownum = 1)
559: , orli.status_code = G_BATCH_ADJ_DISPUTED

Line 566: FROM ozf_resale_logs_all c

562: , response_code = 'N'
563: WHERE orli.resale_batch_id = p_batch_id
564: AND orli.status_code = p_line_status
565: AND EXISTS( SELECT 1
566: FROM ozf_resale_logs_all c
567: WHERE c.resale_id = orli.resale_line_int_id
568: AND c.resale_id_type = 'IFACE');
569: EXCEPTION
570: WHEN OTHERS THEN

Line 4172: DELETE FROM OZF_RESALE_LOGS

4168: -- Initialize API return status to sucess
4169: x_return_status := FND_API.G_RET_STS_SUCCESS;
4170:
4171: -- delete batch logs
4172: DELETE FROM OZF_RESALE_LOGS
4173: WHERE resale_id = p_resale_batch_id
4174: AND resale_id_type = G_ID_TYPE_BATCH;
4175:
4176: -- delete interface logs

Line 4177: DELETE FROM OZF_RESALE_LOGS a

4173: WHERE resale_id = p_resale_batch_id
4174: AND resale_id_type = G_ID_TYPE_BATCH;
4175:
4176: -- delete interface logs
4177: DELETE FROM OZF_RESALE_LOGS a
4178: WHERE exists (
4179: SELECT 1
4180: FROM OZF_RESALE_LINES_INT b
4181: WHERE b.resale_batch_id = p_resale_batch_id