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.

[Home] [Help]

APPS.ASO_PRICING_CORE_PVT dependencies on ASO_PAYMENTS

Line 431: FROM ASO_PAYMENTS

427: PROCEDURE PROCESS_HDR_TSN(p_quote_header_id NUMBER) IS
428:
429: CURSOR c_hdr_pyt_exists IS
430: SELECT payment_id
431: FROM ASO_PAYMENTS
432: WHERE quote_header_id = p_quote_header_id;
433:
434: CURSOR c_hdr_smc_exists IS
435: SELECT shipment_id

Line 542: l_req_payment_term_id ASO_PAYMENTS.payment_term_id%TYPE;

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

Line 546: l_payment_id ASO_PAYMENTS.payment_id%TYPE;

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;
549:
550:

Line 552: lx_payment_id ASO_PAYMENTS.payment_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;
553:
554: l_shipment_rec ASO_QUOTE_PUB.shipment_rec_type;
555: lx_shipment_id ASO_SHIPMENTS.shipment_id%TYPE;
556:

Line 603: UPDATE ASO_PAYMENTS

599: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
600: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No Header Level Payment TSN exists hence update with from value...',1,'Y');
601: END IF;
602: IF l_payment_id IS NOT NULL THEN
603: UPDATE ASO_PAYMENTS
604: SET payment_term_id = payment_term_id_from
605: WHERE quote_header_id = p_quote_header_id
606: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
607: AND quote_line_id IS NULL;

Line 622: ASO_PAYMENTS_PKG.Insert_Row(

618: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
619: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No Payment Record Exists...Before Payment Insert Row',1,'Y');
620: END IF;
621: lx_PAYMENT_ID := NULL;
622: ASO_PAYMENTS_PKG.Insert_Row(
623: px_PAYMENT_ID => lx_PAYMENT_ID,
624: p_CREATION_DATE => SYSDATE,
625: p_CREATED_BY => G_USER_ID,
626: p_LAST_UPDATE_DATE => sysdate,

Line 684: UPDATE ASO_PAYMENTS

680: aso_debug_pub.add('ASO_PRICING_CORE_PVT: Header Level Payment TSN exists...',1,'Y');
681: END IF;
682: IF l_payment_id IS NOT NULL or lx_payment_id IS NOT NULL
683: THEN
684: UPDATE ASO_PAYMENTS
685: SET payment_term_id = l_req_payment_term_id
686: WHERE quote_header_id = p_quote_header_id
687: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
688: AND quote_line_id IS NULL;

Line 1034: lx_payment_id ASO_PAYMENTS.payment_id%TYPE;

1030:
1031:
1032: -- Added for Line Level Payment TSN
1033: l_payment_rec ASO_QUOTE_PUB.payment_rec_type;
1034: lx_payment_id ASO_PAYMENTS.payment_id%TYPE;
1035: l_payment_id NUMBER;
1036: l_req_payment_term_id NUMBER;
1037: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
1038: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

Line 1042: FROM ASO_PAYMENTS

1038: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
1039:
1040: CURSOR c_line_pyt_exists (p_quote_line_id NUMBER) IS
1041: SELECT payment_id
1042: FROM ASO_PAYMENTS
1043: WHERE quote_header_id = p_quote_header_id
1044: and quote_line_id = p_quote_line_id;
1045:
1046: CURSOR c_line_pyt_tsn(p_quote_line_id NUMBER) IS

Line 1122: UPDATE ASO_PAYMENTS

1118: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1119: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No Line Level Payment TSN exists hence update with from value...',1,'Y');
1120: END IF;
1121:
1122: UPDATE ASO_PAYMENTS
1123: SET payment_term_id = payment_term_id_from
1124: WHERE quote_header_id = p_quote_header_id
1125: AND quote_line_id = l_qte_ln_rec.quote_line_id;
1126:

Line 1135: UPDATE ASO_PAYMENTS

1131: ELSIF l_substitution_value_to IS NOT NULL AND l_payment_id IS NOT NULL THEN
1132: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1133: 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');
1134: END IF;
1135: UPDATE ASO_PAYMENTS
1136: SET payment_term_id = l_substitution_value_to
1137: WHERE quote_header_id = p_quote_header_id
1138: and quote_line_id = l_qte_ln_rec.quote_line_id;
1139:

Line 1146: ASO_PAYMENTS_PKG.Insert_Row(

1142: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No Line Level Payment Record Exists...Before Payment Insert Row',1,'Y');
1143: aso_debug_pub.add('ASO_PRICING_CORE_PVT: l_substitution_value_to'||l_substitution_value_to,1,'Y');
1144: END IF;
1145: lx_PAYMENT_ID := null;
1146: ASO_PAYMENTS_PKG.Insert_Row(
1147: px_PAYMENT_ID => lx_PAYMENT_ID,
1148: p_CREATION_DATE => SYSDATE,
1149: p_CREATED_BY => G_USER_ID,
1150: p_LAST_UPDATE_DATE => sysdate,

Line 1332: UPDATE ASO_PAYMENTS

1328: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1329: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No Line Level Payment TSN exists hence update with from value...',1,'Y');
1330: END IF;
1331:
1332: UPDATE ASO_PAYMENTS
1333: SET payment_term_id = payment_term_id_from
1334: WHERE quote_header_id = p_quote_header_id
1335: AND quote_line_id = l_qte_ln_rec.quote_line_id;
1336:

Line 1345: UPDATE ASO_PAYMENTS

1341: ELSIF l_substitution_value_to IS NOT NULL AND l_payment_id IS NOT NULL THEN
1342: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1343: 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');
1344: END IF;
1345: UPDATE ASO_PAYMENTS
1346: SET payment_term_id = l_substitution_value_to
1347: WHERE quote_header_id = p_quote_header_id
1348: and quote_line_id = l_qte_ln_rec.quote_line_id;
1349:

Line 1356: ASO_PAYMENTS_PKG.Insert_Row(

1352: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No Line Level Payment Record Exists...Before Payment Insert Row',1,'Y');
1353: aso_debug_pub.add('ASO_PRICING_CORE_PVT: l_substitution_value_to'||l_substitution_value_to,1,'Y');
1354: END IF;
1355: lx_PAYMENT_ID := null;
1356: ASO_PAYMENTS_PKG.Insert_Row(
1357: px_PAYMENT_ID => lx_PAYMENT_ID,
1358: p_CREATION_DATE => SYSDATE,
1359: p_CREATED_BY => G_USER_ID,
1360: p_LAST_UPDATE_DATE => sysdate,