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_INT_ALL

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

227: -- PROCEDURE
228: -- Log_Null_Values
229: --
230: -- PURPOSE
231: -- This procedure checks null values from ozf_resale_lines_int_all table
232: --
233: -- PARAMETERS
234: --
235: --

Line 262: FROM ozf_resale_lines_int_all

258: WHERE resale_batch_id = p_id;
259: -- bugfix
260: CURSOR null_columns_csr (p_start_date IN DATE, p_end_date IN DATE) IS
261: SELECT resale_line_int_id, 'OZF_RESALE_ORD_NUM_MISS', 'ORDER_NUMBER', NULL
262: FROM ozf_resale_lines_int_all
263: WHERE resale_batch_id = p_batch_id
264: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
265: AND order_number IS NULL
266: UNION ALL

Line 268: FROM ozf_resale_lines_int_all

264: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
265: AND order_number IS NULL
266: UNION ALL
267: SELECT resale_line_int_id, 'OZF_RESALE_ORD_DATE_MISS', 'DATE_ORDERED', NULL
268: FROM ozf_resale_lines_int_all
269: WHERE resale_batch_id = p_batch_id
270: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
271: AND date_ordered IS NULL
272: UNION ALL

Line 274: FROM ozf_resale_lines_int_all

270: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
271: AND date_ordered IS NULL
272: UNION ALL
273: SELECT resale_line_int_id, 'OZF_ORD_DATE_LT_START', 'DATE_ORDERED', TO_CHAR(date_ordered)
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 date_ordered IS NOT NULL
278: AND date_ordered < p_start_date

Line 281: FROM ozf_resale_lines_int_all

277: AND date_ordered IS NOT NULL
278: AND date_ordered < p_start_date
279: UNION ALL
280: SELECT resale_line_int_id, 'OZF_ORD_DATE_GT_END', 'DATE_ORDERED', TO_CHAR(date_ordered)
281: FROM ozf_resale_lines_int_all
282: WHERE resale_batch_id = p_batch_id
283: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
284: AND date_ordered IS NOT NULL
285: AND date_ordered > p_end_date

Line 288: FROM ozf_resale_lines_int_all

284: AND date_ordered IS NOT NULL
285: AND date_ordered > p_end_date
286: UNION ALL
287: SELECT resale_line_int_id, 'OZF_RESALE_PRODUCT_ID_MISS', 'INVENTORY_ITEM_ID', NULL
288: FROM ozf_resale_lines_int_all
289: WHERE resale_batch_id = p_batch_id
290: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
291: AND inventory_item_id IS NULL
292: UNION ALL

Line 294: FROM ozf_resale_lines_int_all

290: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
291: AND inventory_item_id IS NULL
292: UNION ALL
293: SELECT resale_line_int_id, 'OZF_RESALE_UOM_MISS', 'UOM_CODE', NULL
294: FROM ozf_resale_lines_int_all
295: WHERE resale_batch_id = p_batch_id
296: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
297: AND uom_code IS NULL
298: UNION ALL

Line 300: FROM ozf_resale_lines_int_all

296: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
297: AND uom_code IS NULL
298: UNION ALL
299: SELECT resale_line_int_id, 'OZF_RESALE_SOLD_FROM_MISS', 'SOLD_FROM_CUST_ACCOUNT_ID', NULL
300: FROM ozf_resale_lines_int_all
301: WHERE resale_batch_id = p_batch_id
302: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
303: AND sold_from_cust_account_id IS NULL
304: UNION ALL

Line 306: FROM ozf_resale_lines_int_all

302: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
303: AND sold_from_cust_account_id IS NULL
304: UNION ALL
305: SELECT resale_line_int_id, 'OZF_RESALE_SHIP_FROM_MISS', 'SHIP_FROM_CUST_ACCOUNT_ID', NULL
306: FROM ozf_resale_lines_int_all
307: WHERE resale_batch_id = p_batch_id
308: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
309: AND ship_from_cust_account_id IS NULL
310: UNION ALL

Line 312: FROM ozf_resale_lines_int_all

308: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
309: AND ship_from_cust_account_id IS NULL
310: UNION ALL
311: SELECT resale_line_int_id, 'OZF_RESALE_PRICE_LIST_NULL', 'AGREEMENT_ID', NULL
312: FROM ozf_resale_lines_int_all
313: WHERE resale_batch_id = p_batch_id
314: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
315: AND agreement_type = 'PL'
316: AND agreement_id IS NULL

Line 319: FROM ozf_resale_lines_int_all

315: AND agreement_type = 'PL'
316: AND agreement_id IS NULL
317: UNION ALL
318: SELECT resale_line_int_id, 'OZF_RESALE_AGREE_NUM_NULL', 'AGREEMENT_ID', NULL
319: FROM ozf_resale_lines_int_all
320: WHERE resale_batch_id = p_batch_id
321: AND status_code IN (G_BATCH_ADJ_OPEN, G_BATCH_ADJ_DISPUTED)
322: AND agreement_type = 'SPO'
323: AND agreement_id IS NULL;

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

380: -- PROCEDURE
381: -- Log_Invalid_Values
382: --
383: -- PURPOSE
384: -- This procedure checks invalid values from ozf_resale_lines_int_all table
385: --
386: -- PARAMETERS
387: --
388: -- NOTES:

Line 409: FROM ozf_resale_lines_int_all orsl

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

Line 422: FROM ozf_resale_lines_int_all orsl

418: SELECT orsl.resale_line_int_id
419: , 'OZF_CLAIM_CUST_NOT_IN_DB'
420: , 'SHIP_FROM_CUST_ACCOUNT_ID'
421: , to_char(orsl.ship_from_cust_account_id)
422: FROM ozf_resale_lines_int_all orsl
423: WHERE orsl.status_code = 'OPEN'
424: AND orsl.direct_customer_flag = 'T'
425: AND orsl.resale_batch_id = p_resale_batch_id
426: AND orsl.ship_from_cust_account_id IS NOT NULL

Line 435: FROM ozf_resale_lines_int_all orsl

431: SELECT orsl.resale_line_int_id
432: , 'OZF_RESALE_UOM_NOT_IN_DB'
433: , 'UOM_CODE'
434: , orsl.uom_code
435: FROM ozf_resale_lines_int_all orsl
436: WHERE orsl.direct_customer_flag ='T'
437: AND orsl.status_code = 'OPEN'
438: AND orsl.resale_batch_id = p_resale_batch_id
439: AND orsl.uom_code IS NOT NULL

Line 448: FROM ozf_resale_lines_int_all orsl

444: SELECT orsl.resale_line_int_id
445: , 'OZF_RESALE_ORDTYPE_NOT_IN_DB'
446: , 'ORDER_TYPE_ID'
447: , to_char(orsl.order_type_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.order_type_id IS NOT NULL
452: AND orsl.resale_batch_id = p_resale_batch_id

Line 462: FROM ozf_resale_lines_int_all orsl

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

Line 477: FROM ozf_resale_lines_int_all orsl

473: SELECT orsl.resale_line_int_id
474: , 'OZF_RESALE_PRODUCT_NOT_IN_DB'
475: , 'INVENTORY_ITEM_ID'
476: , to_char(orsl.inventory_item_id)
477: FROM ozf_resale_lines_int_all orsl
478: WHERE orsl.status_code = 'OPEN'
479: AND orsl.direct_customer_flag = 'T'
480: AND orsl.resale_batch_id = p_resale_batch_id
481: AND orsl.inventory_item_id IS NOT NULL

Line 567: UPDATE ozf_resale_lines_int_all orli

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

Line 675: FROM ozf_resale_lines_int_all

671:
672: CURSOR csr_duplicated_dispute_amount(p_resale_batch_id IN NUMBER) IS
673: SELECT NVL(COUNT(resale_line_int_id), 0)
674: , NVL(SUM(total_claimed_amount), 0)
675: FROM ozf_resale_lines_int_all
676: WHERE resale_batch_id = p_resale_batch_id
677: AND status_code = 'DUPLICATED';
678:
679: BEGIN

Line 1071: UPDATE ozf_resale_lines_int_all

1067: --//Fix for Bug: 16083006
1068: l_total_accepted_amount := OZF_UTILITY_PVT.CurrRound(l_total_accepted_amount, p_resale_line_int_rec.currency_code);
1069: l_total_allowed_amount := OZF_UTILITY_PVT.CurrRound(l_total_allowed_amount, p_resale_line_int_rec.currency_code);
1070:
1071: UPDATE ozf_resale_lines_int_all
1072: SET accepted_amount = l_accepted_amount,
1073: -- total_accepted_amount = l_accepted_amount * ABS(p_line_quantity),
1074: -- bug 5969118 Ship and Debit return order generates positive claim amount
1075: total_accepted_amount = l_total_accepted_amount,

Line 1171: ozf_resale_lines_int_all orli

1167: IS
1168: SELECT orl.resale_line_id
1169: -- Bug 4670154 (+)
1170: FROM ozf_resale_lines_all orl,
1171: ozf_resale_lines_int_all orli
1172: /*
1173: FROM ozf_resale_lines orl,
1174: ozf_resale_lines_int orli
1175: */

Line 1201: ozf_resale_lines_int_all orli

1197: IS
1198: SELECT orl.resale_line_id
1199: -- Bug 4670154 (+)
1200: FROM ozf_resale_lines_all orl,
1201: ozf_resale_lines_int_all orli
1202: /*
1203: FROM ozf_resale_lines orl,
1204: ozf_resale_lines_int orli
1205: */

Line 1253: FROM ozf_resale_lines_int_all orlo,

1249: CURSOR dup_line_direct_iface_csr ( p_resale_line_int_id IN NUMBER )
1250: IS
1251: SELECT orlo.resale_line_int_id
1252: -- Bug 4670154 (+)
1253: FROM ozf_resale_lines_int_all orlo,
1254: ozf_resale_lines_int_all orli
1255: /*
1256: FROM ozf_resale_lines_int orlo,
1257: ozf_resale_lines_int orli

Line 1254: ozf_resale_lines_int_all orli

1250: IS
1251: SELECT orlo.resale_line_int_id
1252: -- Bug 4670154 (+)
1253: FROM ozf_resale_lines_int_all orlo,
1254: ozf_resale_lines_int_all orli
1255: /*
1256: FROM ozf_resale_lines_int orlo,
1257: ozf_resale_lines_int orli
1258: */

Line 1289: FROM ozf_resale_lines_int_all orlo,

1285: CURSOR dup_line_indirect_iface_csr ( p_resale_line_int_id IN NUMBER )
1286: IS
1287: SELECT orlo.resale_line_int_id
1288: -- Bug 4670154 (+)
1289: FROM ozf_resale_lines_int_all orlo,
1290: ozf_resale_lines_int_all orli
1291: /*
1292: FROM ozf_resale_lines_int orlo,
1293: ozf_resale_lines_int orli

Line 1290: ozf_resale_lines_int_all orli

1286: IS
1287: SELECT orlo.resale_line_int_id
1288: -- Bug 4670154 (+)
1289: FROM ozf_resale_lines_int_all orlo,
1290: ozf_resale_lines_int_all orli
1291: /*
1292: FROM ozf_resale_lines_int orlo,
1293: ozf_resale_lines_int orli
1294: */

Line 1326: ozf_resale_lines_int_all orli

1322: CURSOR dup_line_nondirect_resale_csr ( p_resale_line_int_id IN NUMBER )
1323: IS
1324: SELECT orl.resale_line_id
1325: FROM ozf_resale_lines_all orl,
1326: ozf_resale_lines_int_all orli
1327: -- Bug 4670154 (+)
1328: /*
1329: FROM ozf_resale_lines orl,
1330: ozf_resale_lines_int orli

Line 1358: FROM ozf_resale_lines_int_all orlo,

1354: CURSOR dup_line_nondirect_iface_csr ( p_resale_line_int_id IN NUMBER )
1355: IS
1356: SELECT orlo.resale_line_int_id
1357: -- Bug 4670154 (+)
1358: FROM ozf_resale_lines_int_all orlo,
1359: ozf_resale_lines_int_all orli
1360: /*
1361: FROM ozf_resale_lines_int orlo,
1362: ozf_resale_lines_int orli

Line 1359: ozf_resale_lines_int_all orli

1355: IS
1356: SELECT orlo.resale_line_int_id
1357: -- Bug 4670154 (+)
1358: FROM ozf_resale_lines_int_all orlo,
1359: ozf_resale_lines_int_all orli
1360: /*
1361: FROM ozf_resale_lines_int orlo,
1362: ozf_resale_lines_int orli
1363: */

Line 1395: FROM ozf_resale_lines_int_all orlo,

1391:
1392: CURSOR dup_line_dir_iface_self_csr ( p_resale_line_int_id IN NUMBER )
1393: IS
1394: SELECT orlo.resale_line_int_id
1395: FROM ozf_resale_lines_int_all orlo,
1396: ozf_resale_lines_int_all orli
1397: WHERE orlo.order_number = orli.order_number
1398: AND nvl (orlo.order_line_number, 0) = nvl (orli.order_line_number, 0) -- For Bug#9447673 SSD IDSM ER
1399: AND orlo.date_ordered = orli.date_ordered

Line 1396: ozf_resale_lines_int_all orli

1392: CURSOR dup_line_dir_iface_self_csr ( p_resale_line_int_id IN NUMBER )
1393: IS
1394: SELECT orlo.resale_line_int_id
1395: FROM ozf_resale_lines_int_all orlo,
1396: ozf_resale_lines_int_all orli
1397: WHERE orlo.order_number = orli.order_number
1398: AND nvl (orlo.order_line_number, 0) = nvl (orli.order_line_number, 0) -- For Bug#9447673 SSD IDSM ER
1399: AND orlo.date_ordered = orli.date_ordered
1400: -- 6704619 (+)

Line 1424: FROM ozf_resale_lines_int_all orlo,

1420:
1421: CURSOR dup_line_indir_iface_self_csr ( p_resale_line_int_id IN NUMBER )
1422: IS
1423: SELECT orlo.resale_line_int_id
1424: FROM ozf_resale_lines_int_all orlo,
1425: ozf_resale_lines_int_all orli
1426: WHERE orlo.order_number = orli.order_number
1427: AND orlo.date_ordered = orli.date_ordered
1428: AND nvl (orlo.order_line_number, 0) = nvl (orli.order_line_number, 0) -- For Bug#9447673 SSD IDSM ER

Line 1425: ozf_resale_lines_int_all orli

1421: CURSOR dup_line_indir_iface_self_csr ( p_resale_line_int_id IN NUMBER )
1422: IS
1423: SELECT orlo.resale_line_int_id
1424: FROM ozf_resale_lines_int_all orlo,
1425: ozf_resale_lines_int_all orli
1426: WHERE orlo.order_number = orli.order_number
1427: AND orlo.date_ordered = orli.date_ordered
1428: AND nvl (orlo.order_line_number, 0) = nvl (orli.order_line_number, 0) -- For Bug#9447673 SSD IDSM ER
1429: -- 6704619 (+)

Line 1454: FROM ozf_resale_lines_int_all orlo,

1450:
1451: CURSOR dup_line_nondir_iface_self_csr ( p_resale_line_int_id IN NUMBER )
1452: IS
1453: SELECT orlo.resale_line_int_id
1454: FROM ozf_resale_lines_int_all orlo,
1455: ozf_resale_lines_int_all orli
1456: WHERE orlo.order_number = orli.order_number
1457: AND nvl (orlo.order_line_number, 0) = nvl (orli.order_line_number, 0) -- For Bug#9447673 SSD IDSM ER
1458: AND orlo.date_ordered = orli.date_ordered

Line 1455: ozf_resale_lines_int_all orli

1451: CURSOR dup_line_nondir_iface_self_csr ( p_resale_line_int_id IN NUMBER )
1452: IS
1453: SELECT orlo.resale_line_int_id
1454: FROM ozf_resale_lines_int_all orlo,
1455: ozf_resale_lines_int_all orli
1456: WHERE orlo.order_number = orli.order_number
1457: AND nvl (orlo.order_line_number, 0) = nvl (orli.order_line_number, 0) -- For Bug#9447673 SSD IDSM ER
1458: AND orlo.date_ordered = orli.date_ordered
1459: -- 6704619 (+)

Line 1485: ozf_resale_lines_int_all orli ';

1481: -- Start RSATYAVA Bug#10085365 fix
1482:
1483: l_dup_resl_csr_stmt VARCHAR2(4000) := ' SELECT orl.resale_line_id
1484: FROM ozf_resale_lines_all orl,
1485: ozf_resale_lines_int_all orli ';
1486:
1487: l_dup_resl_exclus_whr_cls_stmt VARCHAR2(4000) := ' WHERE orli.resale_line_int_id = :resale_line_int_id ';
1488:
1489: -- For Bug#9447673 SSD IDSM ER(+)

Line 1513: FROM ozf_resale_lines_int_all orlo,

1509: AND rownum = 1 ' ;
1510:
1511:
1512: l_dup_iface_csr_stmt VARCHAR2(4000) :=' SELECT orlo.resale_line_int_id
1513: FROM ozf_resale_lines_int_all orlo,
1514: ozf_resale_lines_int_all orli ';
1515:
1516: l_dup_iface_exc_wr_cls_stmt VARCHAR2(4000) := ' WHERE orlo.resale_line_int_id <> :resale_line_int_id
1517: AND orli.resale_line_int_id = :resale_line_int_id';

Line 1514: ozf_resale_lines_int_all orli ';

1510:
1511:
1512: l_dup_iface_csr_stmt VARCHAR2(4000) :=' SELECT orlo.resale_line_int_id
1513: FROM ozf_resale_lines_int_all orlo,
1514: ozf_resale_lines_int_all orli ';
1515:
1516: l_dup_iface_exc_wr_cls_stmt VARCHAR2(4000) := ' WHERE orlo.resale_line_int_id <> :resale_line_int_id
1517: AND orli.resale_line_int_id = :resale_line_int_id';
1518:

Line 2087: UPDATE ozf_resale_lines_int_all

2083: IF l_open_lines_tbl.EXISTS(1) THEN
2084: FOR i IN 1..l_open_lines_tbl.LAST
2085: LOOP
2086: -- BUG 4670154 (+)
2087: UPDATE ozf_resale_lines_int_all
2088: SET duplicated_line_id = NULL
2089: , duplicated_adjustment_id = NULL
2090: WHERE resale_line_int_id = l_open_lines_tbl(i);
2091: -- BUG 4670154 (-)

Line 3009: UPDATE ozf_resale_lines_int_all

3005: RAISE FND_API.g_exc_unexpected_error;
3006: END IF;
3007:
3008: -- update the interface duplicated line
3009: UPDATE ozf_resale_lines_int_all
3010: SET duplicated_line_id = p_line_id
3011: , duplicated_adjustment_id =l_adjustment_id
3012: WHERE duplicated_line_id = p_line_int_rec.resale_line_int_id
3013: AND duplicated_adjustment_id = -1;

Line 3938: UPDATE ozf_resale_lines_int_all

3934: END IF;
3935: ELSE
3936: -- This IS a duplicate. No need to create utilization
3937: -- SLKRISHN move update to resale common pvt
3938: UPDATE ozf_resale_lines_int_all
3939: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED,
3940: duplicated_line_id = p_line_id,
3941: duplicated_adjustment_id = l_dup_adjustment_id
3942: WHERE resale_line_int_id = l_line_int_rec.resale_line_int_id;

Line 5788: FROM ozf_resale_lines_int_all

5784: l_exist_billto_party_id NUMBER;
5785:
5786: CURSOR csr_orig_billto_count (cv_resale_batch_id IN NUMBER) IS
5787: SELECT COUNT(DISTINCT bill_to_party_name)
5788: FROM ozf_resale_lines_int_all
5789: WHERE resale_batch_id = cv_resale_batch_id
5790: AND status_code = 'PROCESSED'
5791: AND ( duplicated_line_id IS NULL
5792: OR ( duplicated_line_id IS NOT NULL AND duplicated_adjustment_id = -1)

Line 5800: FROM ozf_resale_lines_int_all

5796: AND bill_to_party_name IS NOT NULL;
5797:
5798: CURSOR csr_exist_billto_party_id (cv_resale_batch_id IN NUMBER, cv_billto_party_name IN VARCHAR2) IS
5799: SELECT bill_to_party_id
5800: FROM ozf_resale_lines_int_all
5801: WHERE resale_batch_id = cv_resale_batch_id
5802: AND bill_to_party_name = cv_billto_party_name
5803: AND status_code = 'PROCESSED'
5804: AND ( duplicated_line_id IS NULL

Line 5818: FROM ozf_resale_lines_int_all

5814: , bill_to_city
5815: , bill_to_state
5816: , bill_to_postal_code
5817: , bill_to_country
5818: FROM ozf_resale_lines_int_all
5819: WHERE resale_batch_id = cv_resale_batch_id
5820: AND status_code = 'PROCESSED'
5821: AND ( duplicated_line_id IS NULL
5822: OR ( duplicated_line_id IS NOT NULL AND duplicated_adjustment_id = -1)

Line 5910: UPDATE ozf_resale_lines_int_all

5906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5907: END IF;
5908:
5909: --Update bill_to_party_id, bill_to_party_site_id and bill_to_site_use_id
5910: UPDATE ozf_resale_lines_int_all
5911: SET bill_to_party_id = l_new_party_rec.party_id,
5912: bill_to_party_site_id = l_new_party_rec.party_site_id,
5913: bill_to_site_use_id = l_new_party_rec.party_site_use_id
5914: WHERE bill_to_party_id IS NULL

Line 6021: FROM ozf_resale_lines_int_all

6017: l_exist_billto_party_site_id NUMBER;
6018:
6019: CURSOR csr_orig_shipto_count (cv_resale_batch_id IN NUMBER) IS
6020: SELECT COUNT(DISTINCT ship_to_party_name)
6021: FROM ozf_resale_lines_int_all
6022: WHERE resale_batch_id = cv_resale_batch_id
6023: AND status_code = 'PROCESSED'
6024: AND ( duplicated_line_id IS NULL
6025: OR ( duplicated_line_id IS NOT NULL AND duplicated_adjustment_id = -1)

Line 6033: FROM ozf_resale_lines_int_all

6029: AND ship_to_party_name IS NOT NULL;
6030:
6031: CURSOR csr_exist_shipto_party_id (cv_resale_batch_id IN NUMBER, cv_shipto_party_name IN VARCHAR2) IS
6032: SELECT ship_to_party_id
6033: FROM ozf_resale_lines_int_all
6034: WHERE resale_batch_id = cv_resale_batch_id
6035: AND ship_to_party_name = cv_shipto_party_name
6036: AND status_code = 'PROCESSED'
6037: AND ( duplicated_line_id IS NULL

Line 6046: FROM ozf_resale_lines_int_all

6042: ORDER BY ship_to_party_id;
6043:
6044: CURSOR csr_exist_billto_party_id (cv_resale_batch_id IN NUMBER, cv_billto_party_name IN VARCHAR2) IS
6045: SELECT bill_to_party_id
6046: FROM ozf_resale_lines_int_all
6047: WHERE resale_batch_id = cv_resale_batch_id
6048: AND bill_to_party_name = cv_billto_party_name
6049: AND status_code = 'PROCESSED'
6050: AND ( duplicated_line_id IS NULL

Line 6068: FROM ozf_resale_lines_int_all

6064: cv_bill_to_postal_code IN VARCHAR2,
6065: cv_bill_to_country IN VARCHAR2
6066: ) IS
6067: SELECT bill_to_party_site_id
6068: FROM ozf_resale_lines_int_all
6069: WHERE resale_batch_id = cv_resale_batch_id
6070: AND status_code = 'PROCESSED'
6071: AND ( duplicated_line_id IS NULL
6072: OR ( duplicated_line_id IS NOT NULL AND duplicated_adjustment_id = -1)

Line 6092: FROM ozf_resale_lines_int_all

6088: , ship_to_city
6089: , ship_to_state
6090: , ship_to_postal_code
6091: , ship_to_country
6092: FROM ozf_resale_lines_int_all
6093: WHERE resale_batch_id = cv_resale_batch_id
6094: AND status_code = 'PROCESSED'
6095: AND ( duplicated_line_id IS NULL
6096: OR ( duplicated_line_id IS NOT NULL AND duplicated_adjustment_id = -1)

Line 6222: UPDATE ozf_resale_lines_int_all

6218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6219: END IF;
6220:
6221: --Update ship_to_party_id, ship_to_party_site_id and ship_to_site_use_id
6222: UPDATE ozf_resale_lines_int_all
6223: SET ship_to_party_id = l_new_party_rec.party_id,
6224: ship_to_party_site_id = l_new_party_rec.party_site_id,
6225: ship_to_site_use_id = l_new_party_rec.party_site_use_id
6226: WHERE ship_to_party_id IS NULL

Line 6331: FROM ozf_resale_lines_int_all

6327: l_exist_end_cust_party_id NUMBER;
6328:
6329: CURSOR csr_orig_end_cust_count (cv_resale_batch_id IN NUMBER) IS
6330: SELECT COUNT(DISTINCT end_cust_party_name)
6331: FROM ozf_resale_lines_int_all
6332: WHERE resale_batch_id = cv_resale_batch_id
6333: AND status_code = 'PROCESSED'
6334: AND ( duplicated_line_id IS NULL
6335: OR ( duplicated_line_id IS NOT NULL AND duplicated_adjustment_id = -1)

Line 6342: FROM ozf_resale_lines_int_all

6338: AND end_cust_party_name IS NOT NULL;
6339:
6340: CURSOR csr_exist_end_cust_party_id (cv_resale_batch_id IN NUMBER, cv_end_cust_party_name IN VARCHAR2) IS
6341: SELECT end_cust_party_id
6342: FROM ozf_resale_lines_int_all
6343: WHERE resale_batch_id = cv_resale_batch_id
6344: AND end_cust_party_name = cv_end_cust_party_name
6345: AND status_code = 'PROCESSED'
6346: AND ( duplicated_line_id IS NULL

Line 6361: FROM ozf_resale_lines_int_all

6357: , end_cust_state
6358: , end_cust_postal_code
6359: , end_cust_country
6360: , end_cust_site_use_code
6361: FROM ozf_resale_lines_int_all
6362: WHERE resale_batch_id = cv_resale_batch_id
6363: AND status_code = 'PROCESSED'
6364: AND ( duplicated_line_id IS NULL
6365: OR ( duplicated_line_id IS NOT NULL AND duplicated_adjustment_id = -1)

Line 6452: UPDATE ozf_resale_lines_int_all

6448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6449: END IF;
6450:
6451: --Update end_cust_party_id, end_cust_party_site_id and end_cust_site_use_id
6452: UPDATE ozf_resale_lines_int_all
6453: SET end_cust_party_id = l_new_party_rec.party_id,
6454: end_cust_party_site_id = l_new_party_rec.party_site_id,
6455: end_cust_site_use_id = l_new_party_rec.party_site_use_id
6456: WHERE end_cust_party_id IS NULL