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.ASO_PRICING_CORE_PVT dependencies on ASO_SHIPMENTS

Line 451: FROM ASO_SHIPMENTS

447: WHERE quote_header_id = p_quote_header_id;
448:
449: CURSOR c_hdr_smc_exists IS
450: SELECT shipment_id
451: FROM ASO_SHIPMENTS
452: WHERE quote_header_id = p_quote_header_id;
453:
454: CURSOR c_hdr_ftc_exists IS
455: SELECT shipment_id

Line 456: FROM ASO_SHIPMENTS

452: WHERE quote_header_id = p_quote_header_id;
453:
454: CURSOR c_hdr_ftc_exists IS
455: SELECT shipment_id
456: FROM ASO_SHIPMENTS
457: WHERE quote_header_id = p_quote_header_id;
458:
459: CURSOR c_hdr_tsn_count IS
460: SELECT /*+ LEADING (lines) INDEX (lines, QP_PREQ_LINES_TMP_N1) USE_NL (lines A B ) */

Line 558: l_req_ship_method_code ASO_SHIPMENTS.ship_method_code%TYPE;

554: and olk.SECURITY_GROUP_ID =0;
555:
556:
557: l_req_payment_term_id ASO_PAYMENTS.payment_term_id%TYPE;
558: l_req_ship_method_code ASO_SHIPMENTS.ship_method_code%TYPE;
559: l_req_freight_terms_code ASO_SHIPMENTS.freight_terms_code%TYPE;
560:
561: l_payment_id ASO_PAYMENTS.payment_id%TYPE;
562: l_shipment_id ASO_SHIPMENTS.shipment_id%TYPE;

Line 559: l_req_freight_terms_code ASO_SHIPMENTS.freight_terms_code%TYPE;

555:
556:
557: l_req_payment_term_id ASO_PAYMENTS.payment_term_id%TYPE;
558: l_req_ship_method_code ASO_SHIPMENTS.ship_method_code%TYPE;
559: l_req_freight_terms_code ASO_SHIPMENTS.freight_terms_code%TYPE;
560:
561: l_payment_id ASO_PAYMENTS.payment_id%TYPE;
562: l_shipment_id ASO_SHIPMENTS.shipment_id%TYPE;
563: l_freight_shipment_id ASO_SHIPMENTS.shipment_id%TYPE;

Line 562: l_shipment_id ASO_SHIPMENTS.shipment_id%TYPE;

558: l_req_ship_method_code ASO_SHIPMENTS.ship_method_code%TYPE;
559: l_req_freight_terms_code ASO_SHIPMENTS.freight_terms_code%TYPE;
560:
561: l_payment_id ASO_PAYMENTS.payment_id%TYPE;
562: l_shipment_id ASO_SHIPMENTS.shipment_id%TYPE;
563: l_freight_shipment_id ASO_SHIPMENTS.shipment_id%TYPE;
564:
565:
566: l_payment_rec ASO_QUOTE_PUB.payment_rec_type;

Line 563: l_freight_shipment_id ASO_SHIPMENTS.shipment_id%TYPE;

559: l_req_freight_terms_code ASO_SHIPMENTS.freight_terms_code%TYPE;
560:
561: l_payment_id ASO_PAYMENTS.payment_id%TYPE;
562: l_shipment_id ASO_SHIPMENTS.shipment_id%TYPE;
563: l_freight_shipment_id ASO_SHIPMENTS.shipment_id%TYPE;
564:
565:
566: l_payment_rec ASO_QUOTE_PUB.payment_rec_type;
567: lx_payment_id ASO_PAYMENTS.payment_id%TYPE;

Line 570: lx_shipment_id ASO_SHIPMENTS.shipment_id%TYPE;

566: l_payment_rec ASO_QUOTE_PUB.payment_rec_type;
567: lx_payment_id ASO_PAYMENTS.payment_id%TYPE;
568:
569: l_shipment_rec ASO_QUOTE_PUB.shipment_rec_type;
570: lx_shipment_id ASO_SHIPMENTS.shipment_id%TYPE;
571:
572:
573: l_freight_rec ASO_QUOTE_PUB.shipment_rec_type;
574: lx_freight_shipment_id ASO_SHIPMENTS.shipment_id%TYPE;

Line 574: lx_freight_shipment_id ASO_SHIPMENTS.shipment_id%TYPE;

570: lx_shipment_id ASO_SHIPMENTS.shipment_id%TYPE;
571:
572:
573: l_freight_rec ASO_QUOTE_PUB.shipment_rec_type;
574: lx_freight_shipment_id ASO_SHIPMENTS.shipment_id%TYPE;
575:
576: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
577: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
578:

Line 731: UPDATE ASO_SHIPMENTS aso

727: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No Header Level Ship Method Code TSN exists hence update with From value...',1,'Y');
728: END IF;
729: IF l_shipment_id IS NOT NULL
730: THEN
731: UPDATE ASO_SHIPMENTS aso
732: SET aso.ship_method_code = ship_method_code_from
733: WHERE quote_header_id = p_quote_header_id
734: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
735: AND quote_line_id IS NULL;

Line 748: ASO_SHIPMENTS_PKG.Insert_Row(

744: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No Shipment Record exists...Before Shipment Insert Rows ',1,'Y');
745: END IF;
746:
747: lx_shipment_id := NULL;
748: ASO_SHIPMENTS_PKG.Insert_Row(
749: px_SHIPMENT_ID => lx_shipment_id,
750: p_CREATION_DATE => SYSDATE,
751: p_CREATED_BY => G_USER_ID,
752: p_LAST_UPDATE_DATE => SYSDATE,

Line 820: UPDATE ASO_SHIPMENTS aso

816: aso_debug_pub.add('ASO_PRICING_CORE_PVT: Header Level Shipment TSN exists...',1,'Y');
817: END IF;
818: IF l_shipment_id IS NOT NULL or lx_shipment_id IS NOT NULL
819: THEN
820: UPDATE ASO_SHIPMENTS aso
821: SET aso.ship_method_code = l_req_ship_method_code
822: WHERE quote_header_id = p_quote_header_id
823: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
824: AND quote_line_id IS NULL

Line 852: UPDATE ASO_SHIPMENTS aso

848: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
849: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No Header Level Freight Terms Code TSN exists hence update with From value...',1,'Y');
850: END IF;
851: IF l_freight_shipment_id IS NOT NULL THEN
852: UPDATE ASO_SHIPMENTS aso
853: SET aso.freight_terms_code = freight_terms_code_from
854: WHERE quote_header_id = p_quote_header_id
855: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
856: AND quote_line_id IS NULL;

Line 869: ASO_SHIPMENTS_PKG.Insert_Row(

865: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
866: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No Shipment(Freight) Record exists...Before Shipment(Freight) Insert Rows ',1,'Y');
867: END IF;
868: lx_freight_shipment_id := NULL;
869: ASO_SHIPMENTS_PKG.Insert_Row(
870: px_SHIPMENT_ID => lx_freight_shipment_id,
871: p_CREATION_DATE => SYSDATE,
872: p_CREATED_BY => G_USER_ID,
873: p_LAST_UPDATE_DATE => SYSDATE,

Line 940: UPDATE ASO_SHIPMENTS aso

936: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
937: aso_debug_pub.add('ASO_PRICING_CORE_PVT: Header Level Freight TSN exists...',1,'Y');
938: END IF;
939: IF l_freight_shipment_id IS NOT NULL or lx_freight_shipment_id IS NOT NULL THEN
940: UPDATE ASO_SHIPMENTS aso
941: SET aso.freight_terms_code = l_req_freight_terms_code
942: WHERE quote_header_id = p_quote_header_id
943: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
944: AND quote_line_id IS NULL;

Line 1042: l_req_ship_method_code ASO_SHIPMENTS.ship_method_code%TYPE;

1038: and olk.LANGUAGE = USERENV('LANG')
1039: and olk.VIEW_APPLICATION_ID = 660
1040: and olk.SECURITY_GROUP_ID =0;
1041:
1042: l_req_ship_method_code ASO_SHIPMENTS.ship_method_code%TYPE;
1043: l_req_freight_terms_code ASO_SHIPMENTS.freight_terms_code%TYPE;
1044:
1045:
1046:

Line 1043: l_req_freight_terms_code ASO_SHIPMENTS.freight_terms_code%TYPE;

1039: and olk.VIEW_APPLICATION_ID = 660
1040: and olk.SECURITY_GROUP_ID =0;
1041:
1042: l_req_ship_method_code ASO_SHIPMENTS.ship_method_code%TYPE;
1043: l_req_freight_terms_code ASO_SHIPMENTS.freight_terms_code%TYPE;
1044:
1045:
1046:
1047: -- Added for Line Level Payment TSN

Line 1231: UPDATE ASO_SHIPMENTS aso

1227: CLOSE c_ln_smc_tsn;
1228: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1229: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No Line Level Ship Method Code TSN exists hence update with From value...',1,'Y');
1230: END IF;
1231: UPDATE ASO_SHIPMENTS aso
1232: SET aso.ship_method_code = ship_method_code_from
1233: WHERE aso.quote_header_id = p_quote_header_id
1234: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
1235: AND aso.quote_line_id = l_qte_ln_rec.quote_line_id

Line 1246: UPDATE ASO_SHIPMENTS aso

1242: CLOSE c_ln_smc_tsn;
1243: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1244: aso_debug_pub.add('ASO_PRICING_CORE_PVT: Line Level Shipment TSN exists...',1,'Y');
1245: END IF;
1246: UPDATE ASO_SHIPMENTS aso
1247: SET aso.ship_method_code = l_req_ship_method_code
1248: WHERE aso.quote_header_id = p_quote_header_id
1249: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
1250: AND aso.quote_line_id = l_qte_ln_rec.quote_line_id

Line 1272: UPDATE ASO_SHIPMENTS aso

1268: CLOSE c_ln_ftc_tsn;
1269: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1270: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No Line Level Freight Terms Code TSN exists hence update with From value...',1,'Y');
1271: END IF;
1272: UPDATE ASO_SHIPMENTS aso
1273: SET aso.freight_terms_code = freight_terms_code_from
1274: WHERE aso.quote_header_id = p_quote_header_id
1275: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
1276: AND aso.quote_line_id = l_qte_ln_rec.quote_line_id

Line 1287: UPDATE ASO_SHIPMENTS aso

1283: CLOSE c_ln_ftc_tsn;
1284: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1285: aso_debug_pub.add('ASO_PRICING_CORE_PVT: Line Level Freight TSN exists...',1,'Y');
1286: END IF;
1287: UPDATE ASO_SHIPMENTS aso
1288: SET aso.freight_terms_code = l_req_freight_terms_code
1289: WHERE aso.quote_header_id = p_quote_header_id
1290: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
1291: AND aso.quote_line_id = l_qte_ln_rec.quote_line_id

Line 1441: UPDATE ASO_SHIPMENTS aso

1437: CLOSE c_ln_smc_tsn;
1438: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1439: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No Line Level Ship Method Code TSN exists hence update with From value...',1,'Y');
1440: END IF;
1441: UPDATE ASO_SHIPMENTS aso
1442: SET aso.ship_method_code = ship_method_code_from
1443: WHERE aso.quote_header_id = p_quote_header_id
1444: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
1445: AND aso.quote_line_id = l_qte_ln_rec.quote_line_id

Line 1456: UPDATE ASO_SHIPMENTS aso

1452: CLOSE c_ln_smc_tsn;
1453: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1454: aso_debug_pub.add('ASO_PRICING_CORE_PVT: Line Level Shipment TSN exists...',1,'Y');
1455: END IF;
1456: UPDATE ASO_SHIPMENTS aso
1457: SET aso.ship_method_code = l_req_ship_method_code
1458: WHERE aso.quote_header_id = p_quote_header_id
1459: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
1460: AND aso.quote_line_id = l_qte_ln_rec.quote_line_id

Line 1482: UPDATE ASO_SHIPMENTS aso

1478: CLOSE c_ln_ftc_tsn;
1479: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1480: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No Line Level Freight Terms Code TSN exists hence update with From value...',1,'Y');
1481: END IF;
1482: UPDATE ASO_SHIPMENTS aso
1483: SET aso.freight_terms_code = freight_terms_code_from
1484: WHERE aso.quote_header_id = p_quote_header_id
1485: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
1486: AND aso.quote_line_id = l_qte_ln_rec.quote_line_id

Line 1497: UPDATE ASO_SHIPMENTS aso

1493: CLOSE c_ln_ftc_tsn;
1494: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1495: aso_debug_pub.add('ASO_PRICING_CORE_PVT: Line Level Freight TSN exists...',1,'Y');
1496: END IF;
1497: UPDATE ASO_SHIPMENTS aso
1498: SET aso.freight_terms_code = l_req_freight_terms_code
1499: WHERE aso.quote_header_id = p_quote_header_id
1500: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
1501: AND aso.quote_line_id = l_qte_ln_rec.quote_line_id

Line 10559: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before Update ASO_SHIPMENTS:l_hdr_shipping_charge: '

10555: If (p_control_rec.pricing_event = 'BATCH') OR (p_control_rec.pricing_event = 'ORDER') then
10556:
10557: l_hdr_shipping_charge := ASO_SHIPPING_INT.Get_Header_Freight_Charges(p_qte_header_rec.quote_header_id);
10558: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
10559: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before Update ASO_SHIPMENTS:l_hdr_shipping_charge: '
10560: ||l_hdr_shipping_charge,1,'Y');
10561: END IF;
10562: UPDATE ASO_SHIPMENTS
10563: SET SHIP_QUOTE_PRICE = l_hdr_shipping_charge,

Line 10562: UPDATE ASO_SHIPMENTS

10558: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
10559: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before Update ASO_SHIPMENTS:l_hdr_shipping_charge: '
10560: ||l_hdr_shipping_charge,1,'Y');
10561: END IF;
10562: UPDATE ASO_SHIPMENTS
10563: SET SHIP_QUOTE_PRICE = l_hdr_shipping_charge,
10564: last_update_date = l_last_update_date,
10565: last_updated_by = G_USER_ID,
10566: last_update_login = G_LOGIN_ID

Line 10579: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before Update ASO_SHIPMENTS:quote_line_id: '||ls_qte_line_tbl(i).quote_line_id

10575: FOR i IN 1..ls_qte_line_tbl.count LOOP
10576: l_line_shipping_charge := ASO_SHIPPING_INT.get_line_freight_charges
10577: (p_qte_header_rec.quote_header_id,ls_qte_line_tbl(i).quote_line_id);
10578: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
10579: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before Update ASO_SHIPMENTS:quote_line_id: '||ls_qte_line_tbl(i).quote_line_id
10580: ||' line charge for the quote line:'||l_line_shipping_charge,1,'Y');
10581: END IF;
10582:
10583: UPDATE ASO_SHIPMENTS

Line 10583: UPDATE ASO_SHIPMENTS

10579: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before Update ASO_SHIPMENTS:quote_line_id: '||ls_qte_line_tbl(i).quote_line_id
10580: ||' line charge for the quote line:'||l_line_shipping_charge,1,'Y');
10581: END IF;
10582:
10583: UPDATE ASO_SHIPMENTS
10584: SET SHIP_QUOTE_PRICE = l_line_shipping_charge,
10585: QUANTITY = ls_qte_line_tbl(i).quantity,
10586: last_update_date = l_last_update_date,
10587: last_updated_by = G_USER_ID,