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 436: FROM ASO_SHIPMENTS

432: WHERE quote_header_id = p_quote_header_id;
433:
434: CURSOR c_hdr_smc_exists IS
435: SELECT shipment_id
436: FROM ASO_SHIPMENTS
437: WHERE quote_header_id = p_quote_header_id;
438:
439: CURSOR c_hdr_ftc_exists IS
440: SELECT shipment_id

Line 441: FROM ASO_SHIPMENTS

437: WHERE quote_header_id = p_quote_header_id;
438:
439: CURSOR c_hdr_ftc_exists IS
440: SELECT shipment_id
441: FROM ASO_SHIPMENTS
442: WHERE quote_header_id = p_quote_header_id;
443:
444: CURSOR c_hdr_tsn_count IS
445: SELECT /*+ LEADING (lines) INDEX (lines, QP_PREQ_LINES_TMP_N1) USE_NL (lines A B ) */

Line 543: l_req_ship_method_code ASO_SHIPMENTS.ship_method_code%TYPE;

539: and olk.SECURITY_GROUP_ID =0;
540:
541:
542: l_req_payment_term_id ASO_PAYMENTS.payment_term_id%TYPE;
543: l_req_ship_method_code ASO_SHIPMENTS.ship_method_code%TYPE;
544: l_req_freight_terms_code ASO_SHIPMENTS.freight_terms_code%TYPE;
545:
546: l_payment_id ASO_PAYMENTS.payment_id%TYPE;
547: l_shipment_id ASO_SHIPMENTS.shipment_id%TYPE;

Line 544: l_req_freight_terms_code ASO_SHIPMENTS.freight_terms_code%TYPE;

540:
541:
542: l_req_payment_term_id ASO_PAYMENTS.payment_term_id%TYPE;
543: l_req_ship_method_code ASO_SHIPMENTS.ship_method_code%TYPE;
544: l_req_freight_terms_code ASO_SHIPMENTS.freight_terms_code%TYPE;
545:
546: l_payment_id ASO_PAYMENTS.payment_id%TYPE;
547: l_shipment_id ASO_SHIPMENTS.shipment_id%TYPE;
548: l_freight_shipment_id ASO_SHIPMENTS.shipment_id%TYPE;

Line 547: l_shipment_id ASO_SHIPMENTS.shipment_id%TYPE;

543: l_req_ship_method_code ASO_SHIPMENTS.ship_method_code%TYPE;
544: l_req_freight_terms_code ASO_SHIPMENTS.freight_terms_code%TYPE;
545:
546: l_payment_id ASO_PAYMENTS.payment_id%TYPE;
547: l_shipment_id ASO_SHIPMENTS.shipment_id%TYPE;
548: l_freight_shipment_id ASO_SHIPMENTS.shipment_id%TYPE;
549:
550:
551: l_payment_rec ASO_QUOTE_PUB.payment_rec_type;

Line 548: l_freight_shipment_id ASO_SHIPMENTS.shipment_id%TYPE;

544: l_req_freight_terms_code ASO_SHIPMENTS.freight_terms_code%TYPE;
545:
546: l_payment_id ASO_PAYMENTS.payment_id%TYPE;
547: l_shipment_id ASO_SHIPMENTS.shipment_id%TYPE;
548: l_freight_shipment_id ASO_SHIPMENTS.shipment_id%TYPE;
549:
550:
551: l_payment_rec ASO_QUOTE_PUB.payment_rec_type;
552: lx_payment_id ASO_PAYMENTS.payment_id%TYPE;

Line 555: lx_shipment_id ASO_SHIPMENTS.shipment_id%TYPE;

551: l_payment_rec ASO_QUOTE_PUB.payment_rec_type;
552: lx_payment_id ASO_PAYMENTS.payment_id%TYPE;
553:
554: l_shipment_rec ASO_QUOTE_PUB.shipment_rec_type;
555: lx_shipment_id ASO_SHIPMENTS.shipment_id%TYPE;
556:
557:
558: l_freight_rec ASO_QUOTE_PUB.shipment_rec_type;
559: lx_freight_shipment_id ASO_SHIPMENTS.shipment_id%TYPE;

Line 559: lx_freight_shipment_id ASO_SHIPMENTS.shipment_id%TYPE;

555: lx_shipment_id ASO_SHIPMENTS.shipment_id%TYPE;
556:
557:
558: l_freight_rec ASO_QUOTE_PUB.shipment_rec_type;
559: lx_freight_shipment_id ASO_SHIPMENTS.shipment_id%TYPE;
560:
561: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
562: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
563:

Line 716: UPDATE ASO_SHIPMENTS aso

712: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No Header Level Ship Method Code TSN exists hence update with From value...',1,'Y');
713: END IF;
714: IF l_shipment_id IS NOT NULL
715: THEN
716: UPDATE ASO_SHIPMENTS aso
717: SET aso.ship_method_code = ship_method_code_from
718: WHERE quote_header_id = p_quote_header_id
719: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
720: AND quote_line_id IS NULL;

Line 733: ASO_SHIPMENTS_PKG.Insert_Row(

729: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No Shipment Record exists...Before Shipment Insert Rows ',1,'Y');
730: END IF;
731:
732: lx_shipment_id := NULL;
733: ASO_SHIPMENTS_PKG.Insert_Row(
734: px_SHIPMENT_ID => lx_shipment_id,
735: p_CREATION_DATE => SYSDATE,
736: p_CREATED_BY => G_USER_ID,
737: p_LAST_UPDATE_DATE => SYSDATE,

Line 805: UPDATE ASO_SHIPMENTS aso

801: aso_debug_pub.add('ASO_PRICING_CORE_PVT: Header Level Shipment TSN exists...',1,'Y');
802: END IF;
803: IF l_shipment_id IS NOT NULL or lx_shipment_id IS NOT NULL
804: THEN
805: UPDATE ASO_SHIPMENTS aso
806: SET aso.ship_method_code = l_req_ship_method_code
807: WHERE quote_header_id = p_quote_header_id
808: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
809: AND quote_line_id IS NULL

Line 837: UPDATE ASO_SHIPMENTS aso

833: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
834: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No Header Level Freight Terms Code TSN exists hence update with From value...',1,'Y');
835: END IF;
836: IF l_freight_shipment_id IS NOT NULL THEN
837: UPDATE ASO_SHIPMENTS aso
838: SET aso.freight_terms_code = freight_terms_code_from
839: WHERE quote_header_id = p_quote_header_id
840: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
841: AND quote_line_id IS NULL;

Line 854: ASO_SHIPMENTS_PKG.Insert_Row(

850: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
851: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No Shipment(Freight) Record exists...Before Shipment(Freight) Insert Rows ',1,'Y');
852: END IF;
853: lx_freight_shipment_id := NULL;
854: ASO_SHIPMENTS_PKG.Insert_Row(
855: px_SHIPMENT_ID => lx_freight_shipment_id,
856: p_CREATION_DATE => SYSDATE,
857: p_CREATED_BY => G_USER_ID,
858: p_LAST_UPDATE_DATE => SYSDATE,

Line 925: UPDATE ASO_SHIPMENTS aso

921: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
922: aso_debug_pub.add('ASO_PRICING_CORE_PVT: Header Level Freight TSN exists...',1,'Y');
923: END IF;
924: IF l_freight_shipment_id IS NOT NULL or lx_freight_shipment_id IS NOT NULL THEN
925: UPDATE ASO_SHIPMENTS aso
926: SET aso.freight_terms_code = l_req_freight_terms_code
927: WHERE quote_header_id = p_quote_header_id
928: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
929: AND quote_line_id IS NULL;

Line 1027: l_req_ship_method_code ASO_SHIPMENTS.ship_method_code%TYPE;

1023: and olk.LANGUAGE = USERENV('LANG')
1024: and olk.VIEW_APPLICATION_ID = 660
1025: and olk.SECURITY_GROUP_ID =0;
1026:
1027: l_req_ship_method_code ASO_SHIPMENTS.ship_method_code%TYPE;
1028: l_req_freight_terms_code ASO_SHIPMENTS.freight_terms_code%TYPE;
1029:
1030:
1031:

Line 1028: l_req_freight_terms_code ASO_SHIPMENTS.freight_terms_code%TYPE;

1024: and olk.VIEW_APPLICATION_ID = 660
1025: and olk.SECURITY_GROUP_ID =0;
1026:
1027: l_req_ship_method_code ASO_SHIPMENTS.ship_method_code%TYPE;
1028: l_req_freight_terms_code ASO_SHIPMENTS.freight_terms_code%TYPE;
1029:
1030:
1031:
1032: -- Added for Line Level Payment TSN

Line 1216: UPDATE ASO_SHIPMENTS aso

1212: CLOSE c_ln_smc_tsn;
1213: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1214: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No Line Level Ship Method Code TSN exists hence update with From value...',1,'Y');
1215: END IF;
1216: UPDATE ASO_SHIPMENTS aso
1217: SET aso.ship_method_code = ship_method_code_from
1218: WHERE aso.quote_header_id = p_quote_header_id
1219: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
1220: AND aso.quote_line_id = l_qte_ln_rec.quote_line_id

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: Line Level Shipment TSN exists...',1,'Y');
1230: END IF;
1231: UPDATE ASO_SHIPMENTS aso
1232: SET aso.ship_method_code = l_req_ship_method_code
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 1257: UPDATE ASO_SHIPMENTS aso

1253: CLOSE c_ln_ftc_tsn;
1254: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1255: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No Line Level Freight Terms Code TSN exists hence update with From value...',1,'Y');
1256: END IF;
1257: UPDATE ASO_SHIPMENTS aso
1258: SET aso.freight_terms_code = freight_terms_code_from
1259: WHERE aso.quote_header_id = p_quote_header_id
1260: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
1261: 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: Line Level Freight TSN exists...',1,'Y');
1271: END IF;
1272: UPDATE ASO_SHIPMENTS aso
1273: SET aso.freight_terms_code = l_req_freight_terms_code
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 1426: UPDATE ASO_SHIPMENTS aso

1422: CLOSE c_ln_smc_tsn;
1423: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1424: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No Line Level Ship Method Code TSN exists hence update with From value...',1,'Y');
1425: END IF;
1426: UPDATE ASO_SHIPMENTS aso
1427: SET aso.ship_method_code = ship_method_code_from
1428: WHERE aso.quote_header_id = p_quote_header_id
1429: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
1430: 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: Line Level Shipment TSN exists...',1,'Y');
1440: END IF;
1441: UPDATE ASO_SHIPMENTS aso
1442: SET aso.ship_method_code = l_req_ship_method_code
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 1467: UPDATE ASO_SHIPMENTS aso

1463: CLOSE c_ln_ftc_tsn;
1464: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1465: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No Line Level Freight Terms Code TSN exists hence update with From value...',1,'Y');
1466: END IF;
1467: UPDATE ASO_SHIPMENTS aso
1468: SET aso.freight_terms_code = freight_terms_code_from
1469: WHERE aso.quote_header_id = p_quote_header_id
1470: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
1471: 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: Line Level Freight TSN exists...',1,'Y');
1481: END IF;
1482: UPDATE ASO_SHIPMENTS aso
1483: SET aso.freight_terms_code = l_req_freight_terms_code
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 10542: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before Update ASO_SHIPMENTS:l_hdr_shipping_charge: '

10538: If (p_control_rec.pricing_event = 'BATCH') OR (p_control_rec.pricing_event = 'ORDER') then
10539:
10540: l_hdr_shipping_charge := ASO_SHIPPING_INT.Get_Header_Freight_Charges(p_qte_header_rec.quote_header_id);
10541: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
10542: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before Update ASO_SHIPMENTS:l_hdr_shipping_charge: '
10543: ||l_hdr_shipping_charge,1,'Y');
10544: END IF;
10545: UPDATE ASO_SHIPMENTS
10546: SET SHIP_QUOTE_PRICE = l_hdr_shipping_charge,

Line 10545: UPDATE ASO_SHIPMENTS

10541: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
10542: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before Update ASO_SHIPMENTS:l_hdr_shipping_charge: '
10543: ||l_hdr_shipping_charge,1,'Y');
10544: END IF;
10545: UPDATE ASO_SHIPMENTS
10546: SET SHIP_QUOTE_PRICE = l_hdr_shipping_charge,
10547: last_update_date = l_last_update_date,
10548: last_updated_by = G_USER_ID,
10549: last_update_login = G_LOGIN_ID

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

10558: FOR i IN 1..ls_qte_line_tbl.count LOOP
10559: l_line_shipping_charge := ASO_SHIPPING_INT.get_line_freight_charges
10560: (p_qte_header_rec.quote_header_id,ls_qte_line_tbl(i).quote_line_id);
10561: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
10562: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before Update ASO_SHIPMENTS:quote_line_id: '||ls_qte_line_tbl(i).quote_line_id
10563: ||' line charge for the quote line:'||l_line_shipping_charge,1,'Y');
10564: END IF;
10565:
10566: UPDATE ASO_SHIPMENTS

Line 10566: UPDATE ASO_SHIPMENTS

10562: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before Update ASO_SHIPMENTS:quote_line_id: '||ls_qte_line_tbl(i).quote_line_id
10563: ||' line charge for the quote line:'||l_line_shipping_charge,1,'Y');
10564: END IF;
10565:
10566: UPDATE ASO_SHIPMENTS
10567: SET SHIP_QUOTE_PRICE = l_line_shipping_charge,
10568: QUANTITY = ls_qte_line_tbl(i).quantity,
10569: last_update_date = l_last_update_date,
10570: last_updated_by = G_USER_ID,