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_PAYMENTS

Line 446: FROM ASO_PAYMENTS

442: PROCEDURE PROCESS_HDR_TSN(p_quote_header_id NUMBER) IS
443:
444: CURSOR c_hdr_pyt_exists IS
445: SELECT payment_id
446: FROM ASO_PAYMENTS
447: WHERE quote_header_id = p_quote_header_id;
448:
449: CURSOR c_hdr_smc_exists IS
450: SELECT shipment_id

Line 557: l_req_payment_term_id ASO_PAYMENTS.payment_term_id%TYPE;

553: and olk.VIEW_APPLICATION_ID = 660
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;

Line 561: l_payment_id ASO_PAYMENTS.payment_id%TYPE;

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;
564:
565:

Line 567: lx_payment_id ASO_PAYMENTS.payment_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;
568:
569: l_shipment_rec ASO_QUOTE_PUB.shipment_rec_type;
570: lx_shipment_id ASO_SHIPMENTS.shipment_id%TYPE;
571:

Line 618: UPDATE ASO_PAYMENTS

614: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
615: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No Header Level Payment TSN exists hence update with from value...',1,'Y');
616: END IF;
617: IF l_payment_id IS NOT NULL THEN
618: UPDATE ASO_PAYMENTS
619: SET payment_term_id = payment_term_id_from
620: WHERE quote_header_id = p_quote_header_id
621: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
622: AND quote_line_id IS NULL;

Line 637: ASO_PAYMENTS_PKG.Insert_Row(

633: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
634: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No Payment Record Exists...Before Payment Insert Row',1,'Y');
635: END IF;
636: lx_PAYMENT_ID := NULL;
637: ASO_PAYMENTS_PKG.Insert_Row(
638: px_PAYMENT_ID => lx_PAYMENT_ID,
639: p_CREATION_DATE => SYSDATE,
640: p_CREATED_BY => G_USER_ID,
641: p_LAST_UPDATE_DATE => sysdate,

Line 699: UPDATE ASO_PAYMENTS

695: aso_debug_pub.add('ASO_PRICING_CORE_PVT: Header Level Payment TSN exists...',1,'Y');
696: END IF;
697: IF l_payment_id IS NOT NULL or lx_payment_id IS NOT NULL
698: THEN
699: UPDATE ASO_PAYMENTS
700: SET payment_term_id = l_req_payment_term_id
701: WHERE quote_header_id = p_quote_header_id
702: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
703: AND quote_line_id IS NULL;

Line 1049: lx_payment_id ASO_PAYMENTS.payment_id%TYPE;

1045:
1046:
1047: -- Added for Line Level Payment TSN
1048: l_payment_rec ASO_QUOTE_PUB.payment_rec_type;
1049: lx_payment_id ASO_PAYMENTS.payment_id%TYPE;
1050: l_payment_id NUMBER;
1051: l_req_payment_term_id NUMBER;
1052: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
1053: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

Line 1057: FROM ASO_PAYMENTS

1053: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
1054:
1055: CURSOR c_line_pyt_exists (p_quote_line_id NUMBER) IS
1056: SELECT payment_id
1057: FROM ASO_PAYMENTS
1058: WHERE quote_header_id = p_quote_header_id
1059: and quote_line_id = p_quote_line_id;
1060:
1061: CURSOR c_line_pyt_tsn(p_quote_line_id NUMBER) IS

Line 1137: UPDATE ASO_PAYMENTS

1133: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1134: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No Line Level Payment TSN exists hence update with from value...',1,'Y');
1135: END IF;
1136:
1137: UPDATE ASO_PAYMENTS
1138: SET payment_term_id = payment_term_id_from
1139: WHERE quote_header_id = p_quote_header_id
1140: AND quote_line_id = l_qte_ln_rec.quote_line_id;
1141:

Line 1150: UPDATE ASO_PAYMENTS

1146: ELSIF l_substitution_value_to IS NOT NULL AND l_payment_id IS NOT NULL THEN
1147: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1148: aso_debug_pub.add('ASO_PRICING_CORE_PVT: Inside ELSIF l_substitution_value_to IS NOT NULLAND l_payment_id IS NOT NULL:',1,'Y');
1149: END IF;
1150: UPDATE ASO_PAYMENTS
1151: SET payment_term_id = l_substitution_value_to
1152: WHERE quote_header_id = p_quote_header_id
1153: and quote_line_id = l_qte_ln_rec.quote_line_id;
1154:

Line 1161: ASO_PAYMENTS_PKG.Insert_Row(

1157: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No Line Level Payment Record Exists...Before Payment Insert Row',1,'Y');
1158: aso_debug_pub.add('ASO_PRICING_CORE_PVT: l_substitution_value_to'||l_substitution_value_to,1,'Y');
1159: END IF;
1160: lx_PAYMENT_ID := null;
1161: ASO_PAYMENTS_PKG.Insert_Row(
1162: px_PAYMENT_ID => lx_PAYMENT_ID,
1163: p_CREATION_DATE => SYSDATE,
1164: p_CREATED_BY => G_USER_ID,
1165: p_LAST_UPDATE_DATE => sysdate,

Line 1347: UPDATE ASO_PAYMENTS

1343: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1344: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No Line Level Payment TSN exists hence update with from value...',1,'Y');
1345: END IF;
1346:
1347: UPDATE ASO_PAYMENTS
1348: SET payment_term_id = payment_term_id_from
1349: WHERE quote_header_id = p_quote_header_id
1350: AND quote_line_id = l_qte_ln_rec.quote_line_id;
1351:

Line 1360: UPDATE ASO_PAYMENTS

1356: ELSIF l_substitution_value_to IS NOT NULL AND l_payment_id IS NOT NULL THEN
1357: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1358: aso_debug_pub.add('ASO_PRICING_CORE_PVT: Inside ELSIF l_substitution_value_to IS NOT NULLAND l_payment_id IS NOT NULL:',1,'Y');
1359: END IF;
1360: UPDATE ASO_PAYMENTS
1361: SET payment_term_id = l_substitution_value_to
1362: WHERE quote_header_id = p_quote_header_id
1363: and quote_line_id = l_qte_ln_rec.quote_line_id;
1364:

Line 1371: ASO_PAYMENTS_PKG.Insert_Row(

1367: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No Line Level Payment Record Exists...Before Payment Insert Row',1,'Y');
1368: aso_debug_pub.add('ASO_PRICING_CORE_PVT: l_substitution_value_to'||l_substitution_value_to,1,'Y');
1369: END IF;
1370: lx_PAYMENT_ID := null;
1371: ASO_PAYMENTS_PKG.Insert_Row(
1372: px_PAYMENT_ID => lx_PAYMENT_ID,
1373: p_CREATION_DATE => SYSDATE,
1374: p_CREATED_BY => G_USER_ID,
1375: p_LAST_UPDATE_DATE => sysdate,