eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_RESALE_COMMON_PVT dependencies on OZF_RESALE_LINES

Line 217: -- This procedure checks null values from ozf_resale_lines_int_all table

213: -- PROCEDURE
214: -- Log_Null_Values
215: --
216: -- PURPOSE
217: -- This procedure checks null values from ozf_resale_lines_int_all table
218: --
219: -- PARAMETERS
220: --
221: --

Line 248: FROM ozf_resale_lines_int_all

244: WHERE resale_batch_id = p_id;
245: -- bugfix
246: CURSOR null_columns_csr (p_start_date IN DATE, p_end_date IN DATE) IS
247: SELECT resale_line_int_id, 'OZF_RESALE_ORD_NUM_MISS', 'ORDER_NUMBER', NULL
248: FROM ozf_resale_lines_int_all
249: WHERE resale_batch_id = p_batch_id
250: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
251: AND order_number IS NULL
252: UNION ALL

Line 254: FROM ozf_resale_lines_int_all

250: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
251: AND order_number IS NULL
252: UNION ALL
253: SELECT resale_line_int_id, 'OZF_RESALE_ORD_DATE_MISS', 'DATE_ORDERED', NULL
254: FROM ozf_resale_lines_int_all
255: WHERE resale_batch_id = p_batch_id
256: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
257: AND date_ordered IS NULL
258: UNION ALL

Line 260: FROM ozf_resale_lines_int_all

256: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
257: AND date_ordered IS NULL
258: UNION ALL
259: SELECT resale_line_int_id, 'OZF_ORD_DATE_LT_START', 'DATE_ORDERED', TO_CHAR(date_ordered)
260: FROM ozf_resale_lines_int_all
261: WHERE resale_batch_id = p_batch_id
262: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
263: AND date_ordered IS NOT NULL
264: AND date_ordered < p_start_date

Line 267: FROM ozf_resale_lines_int_all

263: AND date_ordered IS NOT NULL
264: AND date_ordered < p_start_date
265: UNION ALL
266: SELECT resale_line_int_id, 'OZF_ORD_DATE_GT_END', 'DATE_ORDERED', TO_CHAR(date_ordered)
267: FROM ozf_resale_lines_int_all
268: WHERE resale_batch_id = p_batch_id
269: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
270: AND date_ordered IS NOT NULL
271: AND date_ordered > p_end_date

Line 274: FROM ozf_resale_lines_int_all

270: AND date_ordered IS NOT NULL
271: AND date_ordered > p_end_date
272: UNION ALL
273: SELECT resale_line_int_id, 'OZF_RESALE_PRODUCT_ID_MISS', 'INVENTORY_ITEM_ID', NULL
274: FROM ozf_resale_lines_int_all
275: WHERE resale_batch_id = p_batch_id
276: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
277: AND inventory_item_id IS NULL
278: UNION ALL

Line 280: FROM ozf_resale_lines_int_all

276: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
277: AND inventory_item_id IS NULL
278: UNION ALL
279: SELECT resale_line_int_id, 'OZF_RESALE_UOM_MISS', 'UOM_CODE', NULL
280: FROM ozf_resale_lines_int_all
281: WHERE resale_batch_id = p_batch_id
282: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
283: AND uom_code IS NULL
284: UNION ALL

Line 286: FROM ozf_resale_lines_int_all

282: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
283: AND uom_code IS NULL
284: UNION ALL
285: SELECT resale_line_int_id, 'OZF_RESALE_SOLD_FROM_MISS', 'SOLD_FROM_CUST_ACCOUNT_ID', NULL
286: FROM ozf_resale_lines_int_all
287: WHERE resale_batch_id = p_batch_id
288: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
289: AND sold_from_cust_account_id IS NULL
290: UNION ALL

Line 292: FROM ozf_resale_lines_int_all

288: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
289: AND sold_from_cust_account_id IS NULL
290: UNION ALL
291: SELECT resale_line_int_id, 'OZF_RESALE_SHIP_FROM_MISS', 'SHIP_FROM_CUST_ACCOUNT_ID', NULL
292: FROM ozf_resale_lines_int_all
293: WHERE resale_batch_id = p_batch_id
294: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
295: AND ship_from_cust_account_id IS NULL
296: UNION ALL

Line 298: FROM ozf_resale_lines_int_all

294: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
295: AND ship_from_cust_account_id IS NULL
296: UNION ALL
297: SELECT resale_line_int_id, 'OZF_RESALE_PRICE_LIST_NULL', 'AGREEMENT_ID', NULL
298: FROM ozf_resale_lines_int_all
299: WHERE resale_batch_id = p_batch_id
300: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
301: AND agreement_type = 'PL'
302: AND agreement_id IS NULL

Line 305: FROM ozf_resale_lines_int_all

301: AND agreement_type = 'PL'
302: AND agreement_id IS NULL
303: UNION ALL
304: SELECT resale_line_int_id, 'OZF_RESALE_AGREE_NUM_NULL', 'AGREEMENT_ID', NULL
305: FROM ozf_resale_lines_int_all
306: WHERE resale_batch_id = p_batch_id
307: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
308: AND agreement_type = 'SPO'
309: AND agreement_id IS NULL;

Line 370: -- This procedure checks invalid values from ozf_resale_lines_int_all table

366: -- PROCEDURE
367: -- Log_Invalid_Values
368: --
369: -- PURPOSE
370: -- This procedure checks invalid values from ozf_resale_lines_int_all table
371: --
372: -- PARAMETERS
373: --
374: -- NOTES:

Line 395: FROM ozf_resale_lines_int_all orsl

391: SELECT orsl.resale_line_int_id
392: , 'OZF_CLAIM_CUST_NOT_IN_DB'
393: , 'SOLD_FROM_CUST_ACCOUNT_ID'
394: , to_char(orsl.sold_from_cust_account_id)
395: FROM ozf_resale_lines_int_all orsl
396: WHERE orsl.status_code = 'OPEN'
397: AND orsl.direct_customer_flag = 'T'
398: AND orsl.resale_batch_id = p_resale_batch_id
399: AND orsl.sold_from_cust_account_id IS NOT NULL

Line 408: FROM ozf_resale_lines_int_all orsl

404: SELECT orsl.resale_line_int_id
405: , 'OZF_CLAIM_CUST_NOT_IN_DB'
406: , 'SHIP_FROM_CUST_ACCOUNT_ID'
407: , to_char(orsl.ship_from_cust_account_id)
408: FROM ozf_resale_lines_int_all orsl
409: WHERE orsl.status_code = 'OPEN'
410: AND orsl.direct_customer_flag = 'T'
411: AND orsl.resale_batch_id = p_resale_batch_id
412: AND orsl.ship_from_cust_account_id IS NOT NULL

Line 421: FROM ozf_resale_lines_int_all orsl

417: SELECT orsl.resale_line_int_id
418: , 'OZF_RESALE_UOM_NOT_IN_DB'
419: , 'UOM_CODE'
420: , orsl.uom_code
421: FROM ozf_resale_lines_int_all orsl
422: WHERE orsl.direct_customer_flag ='T'
423: AND orsl.status_code = 'OPEN'
424: AND orsl.resale_batch_id = p_resale_batch_id
425: AND orsl.uom_code IS NOT NULL

Line 434: FROM ozf_resale_lines_int_all orsl

430: SELECT orsl.resale_line_int_id
431: , 'OZF_RESALE_ORDTYPE_NOT_IN_DB'
432: , 'ORDER_TYPE_ID'
433: , to_char(orsl.order_type_id)
434: FROM ozf_resale_lines_int_all orsl
435: WHERE orsl.status_code = 'OPEN'
436: AND orsl.direct_customer_flag = 'T'
437: AND orsl.order_type_id IS NOT NULL
438: AND orsl.resale_batch_id = p_resale_batch_id

Line 448: FROM ozf_resale_lines_int_all orsl

444: SELECT orsl.resale_line_int_id
445: , 'OZF_RESALE_PRICE_NOT_IN_DB'
446: , 'AGREEMENT_ID'
447: , to_char(orsl.agreement_id)
448: FROM ozf_resale_lines_int_all orsl
449: WHERE orsl.status_code = 'OPEN'
450: AND orsl.direct_customer_flag = 'T'
451: AND orsl.resale_batch_id = p_resale_batch_id
452: AND orsl.agreement_id IS NOT NULL

Line 463: FROM ozf_resale_lines_int_all orsl

459: SELECT orsl.resale_line_int_id
460: , 'OZF_RESALE_PRODUCT_NOT_IN_DB'
461: , 'INVENTORY_ITEM_ID'
462: , to_char(orsl.inventory_item_id)
463: FROM ozf_resale_lines_int_all orsl
464: WHERE orsl.status_code = 'OPEN'
465: AND orsl.direct_customer_flag = 'T'
466: AND orsl.resale_batch_id = p_resale_batch_id
467: AND orsl.inventory_item_id IS NOT NULL

Line 553: UPDATE ozf_resale_lines_int_all orli

549: OZF_UTILITY_PVT.debug_message(l_api_name||': Start');
550: END IF;
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'

Line 641: FROM ozf_resale_lines_int

637: l_need_tolerance BOOLEAN;
638: --
639: CURSOR tolerance_line_count_csr (p_id NUMBER)IS
640: SELECT count(1)
641: FROM ozf_resale_lines_int
642: WHERE status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED
643: AND tolerance_flag = 'T'
644: AND resale_batch_id = p_id;
645:

Line 648: FROM ozf_resale_lines_int

644: AND resale_batch_id = p_id;
645:
646: CURSOR invalid_line_count_csr (p_id NUMBER)IS
647: SELECT count(1)
648: FROM ozf_resale_lines_int
649: WHERE status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED
650: AND dispute_code = OZF_RESALE_COMMON_PVT.G_INVALD_DISPUTE_CODE
651: AND resale_batch_id = p_id;
652:

Line 661: FROM ozf_resale_lines_int_all

657:
658: CURSOR csr_duplicated_dispute_amount(p_resale_batch_id IN NUMBER) IS
659: SELECT NVL(COUNT(resale_line_int_id), 0)
660: , NVL(SUM(total_claimed_amount), 0)
661: FROM ozf_resale_lines_int_all
662: WHERE resale_batch_id = p_resale_batch_id
663: AND status_code = 'DUPLICATED';
664:
665: BEGIN

Line 1033: UPDATE ozf_resale_lines_int_all

1029: l_total_allowed_amount := p_allowed_amount * ABS(p_line_quantity);
1030: END IF;
1031: -- bug 5969118 end
1032:
1033: UPDATE ozf_resale_lines_int_all
1034: SET accepted_amount = l_accepted_amount,
1035: -- total_accepted_amount = l_accepted_amount * ABS(p_line_quantity),
1036: -- bug 5969118 Ship and Debit return order generates positive claim amount
1037: total_accepted_amount = l_total_accepted_amount,

Line 1128: FROM ozf_resale_lines_all orl,

1124: CURSOR dup_line_direct_resale_csr ( p_resale_line_int_id IN NUMBER )
1125: IS
1126: SELECT orl.resale_line_id
1127: -- Bug 4670154 (+)
1128: FROM ozf_resale_lines_all orl,
1129: ozf_resale_lines_int_all orli
1130: /*
1131: FROM ozf_resale_lines orl,
1132: ozf_resale_lines_int orli

Line 1129: ozf_resale_lines_int_all orli

1125: IS
1126: SELECT orl.resale_line_id
1127: -- Bug 4670154 (+)
1128: FROM ozf_resale_lines_all orl,
1129: ozf_resale_lines_int_all orli
1130: /*
1131: FROM ozf_resale_lines orl,
1132: ozf_resale_lines_int orli
1133: */

Line 1131: FROM ozf_resale_lines orl,

1127: -- Bug 4670154 (+)
1128: FROM ozf_resale_lines_all orl,
1129: ozf_resale_lines_int_all orli
1130: /*
1131: FROM ozf_resale_lines orl,
1132: ozf_resale_lines_int orli
1133: */
1134: -- Bug 4670154 (-)
1135: WHERE orl.order_number = orli.order_number

Line 1132: ozf_resale_lines_int orli

1128: FROM ozf_resale_lines_all orl,
1129: ozf_resale_lines_int_all orli
1130: /*
1131: FROM ozf_resale_lines orl,
1132: ozf_resale_lines_int orli
1133: */
1134: -- Bug 4670154 (-)
1135: WHERE orl.order_number = orli.order_number
1136: AND orl.date_ordered = orli.date_ordered

Line 1158: FROM ozf_resale_lines_all orl,

1154: CURSOR dup_line_indirect_resale_csr ( p_resale_line_int_id IN NUMBER )
1155: IS
1156: SELECT orl.resale_line_id
1157: -- Bug 4670154 (+)
1158: FROM ozf_resale_lines_all orl,
1159: ozf_resale_lines_int_all orli
1160: /*
1161: FROM ozf_resale_lines orl,
1162: ozf_resale_lines_int orli

Line 1159: ozf_resale_lines_int_all orli

1155: IS
1156: SELECT orl.resale_line_id
1157: -- Bug 4670154 (+)
1158: FROM ozf_resale_lines_all orl,
1159: ozf_resale_lines_int_all orli
1160: /*
1161: FROM ozf_resale_lines orl,
1162: ozf_resale_lines_int orli
1163: */

Line 1161: FROM ozf_resale_lines orl,

1157: -- Bug 4670154 (+)
1158: FROM ozf_resale_lines_all orl,
1159: ozf_resale_lines_int_all orli
1160: /*
1161: FROM ozf_resale_lines orl,
1162: ozf_resale_lines_int orli
1163: */
1164: -- Bug 4670154 (-)
1165: WHERE orl.order_number = orli.order_number

Line 1162: ozf_resale_lines_int orli

1158: FROM ozf_resale_lines_all orl,
1159: ozf_resale_lines_int_all orli
1160: /*
1161: FROM ozf_resale_lines orl,
1162: ozf_resale_lines_int orli
1163: */
1164: -- Bug 4670154 (-)
1165: WHERE orl.order_number = orli.order_number
1166: AND orl.date_ordered = orli.date_ordered

Line 1210: FROM ozf_resale_lines_int_all orlo,

1206: CURSOR dup_line_direct_iface_csr ( p_resale_line_int_id IN NUMBER )
1207: IS
1208: SELECT orlo.resale_line_int_id
1209: -- Bug 4670154 (+)
1210: FROM ozf_resale_lines_int_all orlo,
1211: ozf_resale_lines_int_all orli
1212: /*
1213: FROM ozf_resale_lines_int orlo,
1214: ozf_resale_lines_int orli

Line 1211: ozf_resale_lines_int_all orli

1207: IS
1208: SELECT orlo.resale_line_int_id
1209: -- Bug 4670154 (+)
1210: FROM ozf_resale_lines_int_all orlo,
1211: ozf_resale_lines_int_all orli
1212: /*
1213: FROM ozf_resale_lines_int orlo,
1214: ozf_resale_lines_int orli
1215: */

Line 1213: FROM ozf_resale_lines_int orlo,

1209: -- Bug 4670154 (+)
1210: FROM ozf_resale_lines_int_all orlo,
1211: ozf_resale_lines_int_all orli
1212: /*
1213: FROM ozf_resale_lines_int orlo,
1214: ozf_resale_lines_int orli
1215: */
1216: -- Bug 4670154 (-)
1217: WHERE orlo.order_number = orli.order_number

Line 1214: ozf_resale_lines_int orli

1210: FROM ozf_resale_lines_int_all orlo,
1211: ozf_resale_lines_int_all orli
1212: /*
1213: FROM ozf_resale_lines_int orlo,
1214: ozf_resale_lines_int orli
1215: */
1216: -- Bug 4670154 (-)
1217: WHERE orlo.order_number = orli.order_number
1218: AND orlo.date_ordered = orli.date_ordered

Line 1245: FROM ozf_resale_lines_int_all orlo,

1241: CURSOR dup_line_indirect_iface_csr ( p_resale_line_int_id IN NUMBER )
1242: IS
1243: SELECT orlo.resale_line_int_id
1244: -- Bug 4670154 (+)
1245: FROM ozf_resale_lines_int_all orlo,
1246: ozf_resale_lines_int_all orli
1247: /*
1248: FROM ozf_resale_lines_int orlo,
1249: ozf_resale_lines_int orli

Line 1246: ozf_resale_lines_int_all orli

1242: IS
1243: SELECT orlo.resale_line_int_id
1244: -- Bug 4670154 (+)
1245: FROM ozf_resale_lines_int_all orlo,
1246: ozf_resale_lines_int_all orli
1247: /*
1248: FROM ozf_resale_lines_int orlo,
1249: ozf_resale_lines_int orli
1250: */

Line 1248: FROM ozf_resale_lines_int orlo,

1244: -- Bug 4670154 (+)
1245: FROM ozf_resale_lines_int_all orlo,
1246: ozf_resale_lines_int_all orli
1247: /*
1248: FROM ozf_resale_lines_int orlo,
1249: ozf_resale_lines_int orli
1250: */
1251: -- Bug 4670154 (-)
1252: WHERE orlo.order_number = orli.order_number

Line 1249: ozf_resale_lines_int orli

1245: FROM ozf_resale_lines_int_all orlo,
1246: ozf_resale_lines_int_all orli
1247: /*
1248: FROM ozf_resale_lines_int orlo,
1249: ozf_resale_lines_int orli
1250: */
1251: -- Bug 4670154 (-)
1252: WHERE orlo.order_number = orli.order_number
1253: AND orlo.date_ordered = orli.date_ordered

Line 1281: FROM ozf_resale_lines_all orl,

1277:
1278: CURSOR dup_line_nondirect_resale_csr ( p_resale_line_int_id IN NUMBER )
1279: IS
1280: SELECT orl.resale_line_id
1281: FROM ozf_resale_lines_all orl,
1282: ozf_resale_lines_int_all orli
1283: -- Bug 4670154 (+)
1284: /*
1285: FROM ozf_resale_lines orl,

Line 1282: ozf_resale_lines_int_all orli

1278: CURSOR dup_line_nondirect_resale_csr ( p_resale_line_int_id IN NUMBER )
1279: IS
1280: SELECT orl.resale_line_id
1281: FROM ozf_resale_lines_all orl,
1282: ozf_resale_lines_int_all orli
1283: -- Bug 4670154 (+)
1284: /*
1285: FROM ozf_resale_lines orl,
1286: ozf_resale_lines_int orli

Line 1285: FROM ozf_resale_lines orl,

1281: FROM ozf_resale_lines_all orl,
1282: ozf_resale_lines_int_all orli
1283: -- Bug 4670154 (+)
1284: /*
1285: FROM ozf_resale_lines orl,
1286: ozf_resale_lines_int orli
1287: */
1288: -- Bug 4670154 (-)
1289: WHERE orl.order_number = orli.order_number

Line 1286: ozf_resale_lines_int orli

1282: ozf_resale_lines_int_all orli
1283: -- Bug 4670154 (+)
1284: /*
1285: FROM ozf_resale_lines orl,
1286: ozf_resale_lines_int orli
1287: */
1288: -- Bug 4670154 (-)
1289: WHERE orl.order_number = orli.order_number
1290: AND orl.date_ordered = orli.date_ordered

Line 1313: FROM ozf_resale_lines_int_all orlo,

1309: CURSOR dup_line_nondirect_iface_csr ( p_resale_line_int_id IN NUMBER )
1310: IS
1311: SELECT orlo.resale_line_int_id
1312: -- Bug 4670154 (+)
1313: FROM ozf_resale_lines_int_all orlo,
1314: ozf_resale_lines_int_all orli
1315: /*
1316: FROM ozf_resale_lines_int orlo,
1317: ozf_resale_lines_int orli

Line 1314: ozf_resale_lines_int_all orli

1310: IS
1311: SELECT orlo.resale_line_int_id
1312: -- Bug 4670154 (+)
1313: FROM ozf_resale_lines_int_all orlo,
1314: ozf_resale_lines_int_all orli
1315: /*
1316: FROM ozf_resale_lines_int orlo,
1317: ozf_resale_lines_int orli
1318: */

Line 1316: FROM ozf_resale_lines_int orlo,

1312: -- Bug 4670154 (+)
1313: FROM ozf_resale_lines_int_all orlo,
1314: ozf_resale_lines_int_all orli
1315: /*
1316: FROM ozf_resale_lines_int orlo,
1317: ozf_resale_lines_int orli
1318: */
1319: -- Bug 4670154 (-)
1320: WHERE orlo.order_number = orli.order_number

Line 1317: ozf_resale_lines_int orli

1313: FROM ozf_resale_lines_int_all orlo,
1314: ozf_resale_lines_int_all orli
1315: /*
1316: FROM ozf_resale_lines_int orlo,
1317: ozf_resale_lines_int orli
1318: */
1319: -- Bug 4670154 (-)
1320: WHERE orlo.order_number = orli.order_number
1321: AND orlo.date_ordered = orli.date_ordered

Line 1349: FROM ozf_resale_lines_int_all orlo,

1345:
1346: CURSOR dup_line_dir_iface_self_csr ( p_resale_line_int_id IN NUMBER )
1347: IS
1348: SELECT orlo.resale_line_int_id
1349: FROM ozf_resale_lines_int_all orlo,
1350: ozf_resale_lines_int_all orli
1351: WHERE orlo.order_number = orli.order_number
1352: AND orlo.date_ordered = orli.date_ordered
1353: -- 6704619 (+)

Line 1350: ozf_resale_lines_int_all orli

1346: CURSOR dup_line_dir_iface_self_csr ( p_resale_line_int_id IN NUMBER )
1347: IS
1348: SELECT orlo.resale_line_int_id
1349: FROM ozf_resale_lines_int_all orlo,
1350: ozf_resale_lines_int_all orli
1351: WHERE orlo.order_number = orli.order_number
1352: AND orlo.date_ordered = orli.date_ordered
1353: -- 6704619 (+)
1354: AND (orlo.date_shipped = orli.date_shipped

Line 1377: FROM ozf_resale_lines_int_all orlo,

1373:
1374: CURSOR dup_line_indir_iface_self_csr ( p_resale_line_int_id IN NUMBER )
1375: IS
1376: SELECT orlo.resale_line_int_id
1377: FROM ozf_resale_lines_int_all orlo,
1378: ozf_resale_lines_int_all orli
1379: WHERE orlo.order_number = orli.order_number
1380: AND orlo.date_ordered = orli.date_ordered
1381: -- 6704619 (+)

Line 1378: ozf_resale_lines_int_all orli

1374: CURSOR dup_line_indir_iface_self_csr ( p_resale_line_int_id IN NUMBER )
1375: IS
1376: SELECT orlo.resale_line_int_id
1377: FROM ozf_resale_lines_int_all orlo,
1378: ozf_resale_lines_int_all orli
1379: WHERE orlo.order_number = orli.order_number
1380: AND orlo.date_ordered = orli.date_ordered
1381: -- 6704619 (+)
1382: AND (orlo.date_shipped = orli.date_shipped

Line 1406: FROM ozf_resale_lines_int_all orlo,

1402:
1403: CURSOR dup_line_nondir_iface_self_csr ( p_resale_line_int_id IN NUMBER )
1404: IS
1405: SELECT orlo.resale_line_int_id
1406: FROM ozf_resale_lines_int_all orlo,
1407: ozf_resale_lines_int_all orli
1408: WHERE orlo.order_number = orli.order_number
1409: AND orlo.date_ordered = orli.date_ordered
1410: -- 6704619 (+)

Line 1407: ozf_resale_lines_int_all orli

1403: CURSOR dup_line_nondir_iface_self_csr ( p_resale_line_int_id IN NUMBER )
1404: IS
1405: SELECT orlo.resale_line_int_id
1406: FROM ozf_resale_lines_int_all orlo,
1407: ozf_resale_lines_int_all orli
1408: WHERE orlo.order_number = orli.order_number
1409: AND orlo.date_ordered = orli.date_ordered
1410: -- 6704619 (+)
1411: AND (orlo.date_shipped = orli.date_shipped

Line 1649: FROM ozf_resale_lines_int

1645: l_claimed_amount_tbl number_tbl_type;
1646: --
1647: CURSOR open_lines_csr(p_id IN NUMBER) IS
1648: SELECT resale_line_int_id, direct_customer_flag, claimed_amount
1649: FROM ozf_resale_lines_int
1650: -- WHERE status_code =OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN
1651: WHERE resale_batch_id = p_id;
1652:
1653: CURSOR batch_count_csr(pc_batch_id NUMBER) IS

Line 1660: FROM ozf_resale_lines_int

1656: WHERE resale_batch_id = pc_batch_id;
1657:
1658: CURSOR duplicate_count_csr(p_id NUMBER) IS
1659: SELECT count(1)
1660: FROM ozf_resale_lines_int
1661: WHERE status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED
1662: AND resale_batch_id = p_id;
1663:
1664: BEGIN

Line 1698: UPDATE ozf_resale_lines_int_all

1694: IF l_open_lines_tbl.EXISTS(1) THEN
1695: FOR i IN 1..l_open_lines_tbl.LAST
1696: LOOP
1697: -- BUG 4670154 (+)
1698: UPDATE ozf_resale_lines_int_all
1699: SET duplicated_line_id = NULL
1700: , duplicated_adjustment_id = NULL
1701: WHERE resale_line_int_id = l_open_lines_tbl(i);
1702: -- BUG 4670154 (-)

Line 1726: UPDATE ozf_resale_lines_int

1722: OZF_UTILITY_PVT.error_message('OZF_RESALE_CHK_DUP_ERR');
1723: ELSE
1724: IF l_dup_adjustment_id IS NOT NULL AND l_reprocessing THEN
1725: -- Set the line and adjustment as duplicates
1726: UPDATE ozf_resale_lines_int
1727: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED
1728: , duplicated_line_id = l_dup_line_id
1729: , duplicated_adjustment_id = l_dup_adjustment_id
1730: , dispute_code = 'OZF_RESALE_DUP'

Line 1747: UPDATE ozf_resale_lines_int

1743: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1744: END IF;
1745: ELSE
1746: -- record dup line if necessary
1747: UPDATE ozf_resale_lines_int
1748: SET duplicated_line_id = l_dup_line_id
1749: , duplicated_adjustment_id = l_dup_adjustment_id
1750: WHERE resale_line_int_id = l_open_lines_tbl(i);
1751: END IF;

Line 1789: UPDATE ozf_resale_lines_int

1785: x_batch_status := 'OPEN';
1786: --
1787: BEGIN
1788: -- set DISPUTED_code to NULL for the lines to be processed.
1789: UPDATE ozf_resale_lines_int
1790: SET dispute_code = NULL
1791: WHERE resale_batch_id = p_resale_batch_id
1792: AND status_code= OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN;
1793:

Line 1795: UPDATE ozf_resale_lines_int

1791: WHERE resale_batch_id = p_resale_batch_id
1792: AND status_code= OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN;
1793:
1794: -- UPDATE tracing order lines to processed for this order to be processed
1795: UPDATE ozf_resale_lines_int
1796: SET status_code= OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED
1797: WHERE resale_batch_id = p_resale_batch_id
1798: AND status_code= OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN
1799: AND tracing_flag = 'T';

Line 1909: FROM ozf_resale_lines_int

1905: WHERE resale_batch_id = p_resale_batch_id;
1906:
1907: CURSOR int_line_count_csr IS
1908: SELECT count(1)
1909: FROM ozf_resale_lines_int
1910: WHERE resale_batch_id = p_resale_batch_id;
1911:
1912: CURSOR line_count_csr IS
1913: SELECT count(1)

Line 2613: UPDATE ozf_resale_lines_int_all

2609: RAISE FND_API.g_exc_unexpected_error;
2610: END IF;
2611:
2612: -- update the interface duplicated line
2613: UPDATE ozf_resale_lines_int_all
2614: SET duplicated_line_id = p_line_id
2615: , duplicated_adjustment_id =l_adjustment_id
2616: WHERE duplicated_line_id = p_line_int_rec.resale_line_int_id
2617: AND duplicated_adjustment_id = -1;

Line 2956: ozf_resale_lines c

2952: SELECT a.resale_adjustment_id,
2953: a.total_accepted_amount
2954: FROM ozf_resale_adjustments a,
2955: ozf_resale_batches b,
2956: ozf_resale_lines c
2957: WHERE a.resale_line_id = p_line_id
2958: AND a.resale_batch_id = b.resale_batch_id
2959: AND b.batch_type = p_batch_type
2960: AND b.status_code = OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED

Line 3178: UPDATE ozf_resale_lines_int_all

3174: END IF;
3175: ELSE
3176: -- This IS a duplicate. No need to create utilization
3177: -- SLKRISHN move update to resale common pvt
3178: UPDATE ozf_resale_lines_int_all
3179: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED,
3180: duplicated_line_id = p_line_id,
3181: duplicated_adjustment_id = l_dup_adjustment_id
3182: WHERE resale_line_int_id = l_line_int_rec.resale_line_int_id;

Line 3721: OZF_RESALE_LINES_PKG.Insert_Row(

3717: OZF_UTILITY_PVT.debug_message('before line INSERT: header id' || p_header_id);
3718: OZF_UTILITY_PVT.debug_message('before line INSERT:' || l_line_id);
3719: END IF;
3720:
3721: OZF_RESALE_LINES_PKG.Insert_Row(
3722: p_resale_line_id => l_line_id ,
3723: p_resale_header_id => p_header_id ,
3724: p_resale_transfer_type => p_line_int_rec.resale_transfer_type ,
3725: px_object_version_number => l_obj_ver_num,

Line 4180: FROM OZF_RESALE_LINES_INT b

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
4182: AND a.resale_id = b.resale_line_int_id
4183: AND a.resale_id_type = G_ID_TYPE_IFACE
4184: );

Line 4531: -- p_resale_line_rec IN OZF_RESALE_LINES%ROWTYPE

4527: --
4528: -- PARAMETERS
4529: -- p_caller_type IN VARCHAR2
4530: -- p_resale_line_int_rec IN OZF_RESALE_COMMON_PVT.g_interface_rec_csr%ROWTYPE
4531: -- p_resale_line_rec IN OZF_RESALE_LINES%ROWTYPE
4532: --
4533: -- NOTES
4534: --
4535: ---------------------------------------------------------------------

Line 4545: ,p_resale_line_rec IN OZF_RESALE_LINES%ROWTYPE

4541: ,p_caller_type IN VARCHAR2
4542: ,p_line_index IN NUMBER
4543: ,p_resale_line_int_rec IN OZF_RESALE_COMMON_PVT.g_interface_rec_csr%ROWTYPE
4544: ,p_resale_header_rec IN OZF_RESALE_HEADERS%ROWTYPE
4545: ,p_resale_line_rec IN OZF_RESALE_LINES%ROWTYPE
4546: ,x_return_status OUT NOCOPY VARCHAR2
4547: ,x_msg_count OUT NOCOPY NUMBER
4548: ,x_msg_data OUT NOCOPY VARCHAR2
4549: )