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.QOT_DEFAULT_PVT dependencies on ASO_AK_QUOTE_OPPTY_V

Line 82: ELSIF p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN

78: END IF;
79:
80: IF p_database_object_name = 'ASO_AK_QUOTE_HEADER_V' THEN
81: l_org_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_Org_id;
82: ELSIF p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN
83: l_org_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.O_Org_id;
84: END IF;
85:
86: l_order_type_id := aso_utility_pvt.get_ou_attribute_value(aso_utility_pvt.GET_DEFAULT_ORDER_TYPE,l_org_id);

Line 135: ELSIF p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN

131: END IF;
132:
133: IF p_database_object_name = 'ASO_AK_QUOTE_HEADER_V' THEN
134: l_org_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_Org_id;
135: ELSIF p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN
136: l_org_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.O_Org_id;
137: END IF;
138:
139: l_contract_template_id := aso_utility_pvt.get_ou_attribute_value(aso_utility_pvt.GET_DEFAULT_CONTRACT_TEMPLATE,l_org_id);

Line 223: ELSIF p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN

219: aso_debug_pub.add('Function Get_CustAcct_From_CustParty Database Object ASO_AK_QUOTE_HEADER_V '||
220: ' l_party_id : ' || l_party_id ,1,'N');
221: END IF;
222:
223: ELSIF p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN
224: l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_cust_party_id;
225:
226: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
227: aso_debug_pub.add('Function Get_CustAcct_From_CustParty Database Object ASO_AK_QUOTE_OPPTY_V '||

Line 227: aso_debug_pub.add('Function Get_CustAcct_From_CustParty Database Object ASO_AK_QUOTE_OPPTY_V '||

223: ELSIF p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN
224: l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_cust_party_id;
225:
226: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
227: aso_debug_pub.add('Function Get_CustAcct_From_CustParty Database Object ASO_AK_QUOTE_OPPTY_V '||
228: ' l_party_id : ' || l_party_id ,1,'N');
229: END IF;
230:
231: END IF;

Line 314: ELSIF p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN

310: aso_debug_pub.add('Function Get_PriceList_From_Agreement Database Object ASO_AK_QUOTE_HEADER_V '||
311: ' l_agreement_id : ' || l_agreement_id ,1,'N');
312: END IF;
313:
314: ELSIF p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN
315: l_agreement_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_contract_id;
316:
317: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
318: aso_debug_pub.add('Function Get_PriceList_From_Agreement Database Object ASO_AK_QUOTE_OPPTY_V '||

Line 318: aso_debug_pub.add('Function Get_PriceList_From_Agreement Database Object ASO_AK_QUOTE_OPPTY_V '||

314: ELSIF p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN
315: l_agreement_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_contract_id;
316:
317: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
318: aso_debug_pub.add('Function Get_PriceList_From_Agreement Database Object ASO_AK_QUOTE_OPPTY_V '||
319: ' l_agreement_id : ' || l_agreement_id ,1,'N');
320: END IF;
321: ELSIF p_database_object_name = 'ASO_AK_QUOTE_LINE_V' THEN
322: l_agreement_id := ASO_QUOTE_LINE_DEF_HDLR.g_record.l_agreement_id;

Line 404: ELSIF p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN

400: aso_debug_pub.add('Function Get_PriceList_From_CustAcct Database Object ASO_AK_QUOTE_HEADER_V '||
401: ' l_acct_id : ' || l_acct_id ,1,'N');
402: END IF;
403:
404: ELSIF p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN
405: l_acct_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_cust_account_id;
406:
407: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
408: aso_debug_pub.add('Function Get_PriceList_From_CustAcct Database Object ASO_AK_QUOTE_OPPTY_V '||

Line 408: aso_debug_pub.add('Function Get_PriceList_From_CustAcct Database Object ASO_AK_QUOTE_OPPTY_V '||

404: ELSIF p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN
405: l_acct_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_cust_account_id;
406:
407: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
408: aso_debug_pub.add('Function Get_PriceList_From_CustAcct Database Object ASO_AK_QUOTE_OPPTY_V '||
409: ' l_acct_id : ' || l_acct_id ,1,'N');
410: END IF;
411:
412: END IF;

Line 481: ELSIF p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN

477: aso_debug_pub.add('Function Get_PriceList_From_OrderType Database Object ASO_AK_QUOTE_HEADER_V '||
478: ' l_order_type_id : ' || l_order_type_id ,1,'N');
479: END IF;
480:
481: ELSIF p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN
482: l_order_type_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_order_type_id;
483:
484: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
485: aso_debug_pub.add('Function Get_PriceList_From_OrderType Database Object ASO_AK_QUOTE_OPPTY_V '||

Line 485: aso_debug_pub.add('Function Get_PriceList_From_OrderType Database Object ASO_AK_QUOTE_OPPTY_V '||

481: ELSIF p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN
482: l_order_type_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_order_type_id;
483:
484: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
485: aso_debug_pub.add('Function Get_PriceList_From_OrderType Database Object ASO_AK_QUOTE_OPPTY_V '||
486: ' l_order_type_id : ' || l_order_type_id ,1,'N');
487: END IF;
488: END IF;
489:

Line 555: ELSIF p_database_object_name='ASO_AK_QUOTE_OPPTY_V' THEN

551: aso_debug_pub.add('Function Get_PaymentTerm_From_Agreement Database Object ASO_AK_QUOTE_HEADER_V '||
552: ' l_agreement_id : ' || l_agreement_id ,1,'N');
553: END IF;
554:
555: ELSIF p_database_object_name='ASO_AK_QUOTE_OPPTY_V' THEN
556: l_agreement_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_contract_id;
557:
558: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
559: aso_debug_pub.add('Function Get_PaymentTerm_From_Agreement Database Object ASO_AK_QUOTE_OPPTY_V '||

Line 559: aso_debug_pub.add('Function Get_PaymentTerm_From_Agreement Database Object ASO_AK_QUOTE_OPPTY_V '||

555: ELSIF p_database_object_name='ASO_AK_QUOTE_OPPTY_V' THEN
556: l_agreement_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_contract_id;
557:
558: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
559: aso_debug_pub.add('Function Get_PaymentTerm_From_Agreement Database Object ASO_AK_QUOTE_OPPTY_V '||
560: ' l_agreement_id : ' || l_agreement_id ,1,'N');
561: END IF;
562:
563: END IF;

Line 633: ELSIF p_database_object_name='ASO_AK_QUOTE_OPPTY_V' THEN

629: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
630: aso_debug_pub.add('Function Get_PaymentTerm_From_Customer Database Object ASO_AK_QUOTE_HEADER_V '||
631: ' l_cust_acct_id : ' || l_cust_acct_id ,1,'N');
632: END IF;
633: ELSIF p_database_object_name='ASO_AK_QUOTE_OPPTY_V' THEN
634: l_cust_acct_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_cust_account_id;
635:
636: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
637: aso_debug_pub.add('Function Get_PaymentTerm_From_Customer Database Object ASO_AK_QUOTE_OPPTY_V '||

Line 637: aso_debug_pub.add('Function Get_PaymentTerm_From_Customer Database Object ASO_AK_QUOTE_OPPTY_V '||

633: ELSIF p_database_object_name='ASO_AK_QUOTE_OPPTY_V' THEN
634: l_cust_acct_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_cust_account_id;
635:
636: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
637: aso_debug_pub.add('Function Get_PaymentTerm_From_Customer Database Object ASO_AK_QUOTE_OPPTY_V '||
638: ' l_cust_acct_id : ' || l_cust_acct_id ,1,'N');
639: END IF;
640: END IF;
641:

Line 809: ELSIF p_database_object_name='ASO_AK_QUOTE_OPPTY_V' THEN

805: aso_debug_pub.add('Function Get_QuotePhone Database Object ASO_AK_QUOTE_HEADER_V '||
806: ' l_party_id :' || l_party_id ,1,'N');
807: END IF;
808:
809: ELSIF p_database_object_name='ASO_AK_QUOTE_OPPTY_V' THEN
810: --l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_cust_party_id; --Bug#5195151
811: l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_cust_party_id;
812: l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_party_id;
813:

Line 815: aso_debug_pub.add('Function Get_QuotePhone Database Object ASO_AK_QUOTE_OPPTY_V '||

811: l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_cust_party_id;
812: l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_party_id;
813:
814: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
815: aso_debug_pub.add('Function Get_QuotePhone Database Object ASO_AK_QUOTE_OPPTY_V '||
816: ' l_cust_party_id :' || l_cust_party_id ,1,'N');
817: aso_debug_pub.add('Function Get_QuotePhone Database Object ASO_AK_QUOTE_OPPTY_V '||
818: ' l_party_id :' || l_party_id ,1,'N');
819: END IF;

Line 817: aso_debug_pub.add('Function Get_QuotePhone Database Object ASO_AK_QUOTE_OPPTY_V '||

813:
814: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
815: aso_debug_pub.add('Function Get_QuotePhone Database Object ASO_AK_QUOTE_OPPTY_V '||
816: ' l_cust_party_id :' || l_cust_party_id ,1,'N');
817: aso_debug_pub.add('Function Get_QuotePhone Database Object ASO_AK_QUOTE_OPPTY_V '||
818: ' l_party_id :' || l_party_id ,1,'N');
819: END IF;
820:
821: END IF;

Line 932: ELSIF p_database_object_name='ASO_AK_QUOTE_OPPTY_V' THEN

928: aso_debug_pub.add('Function Get_QuoteAddress Database Object ASO_AK_QUOTE_HEADER_V '||
929: ' l_party_id :' || l_party_id ,1,'N');
930: END IF;
931:
932: ELSIF p_database_object_name='ASO_AK_QUOTE_OPPTY_V' THEN
933: --l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_cust_party_id; --Bug#5195151
934: l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_cust_party_id;
935: l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_party_id;
936:

Line 938: aso_debug_pub.add('Function Get_QuoteAddress Database Object ASO_AK_QUOTE_OPPTY_V '||

934: l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_cust_party_id;
935: l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_party_id;
936:
937: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
938: aso_debug_pub.add('Function Get_QuoteAddress Database Object ASO_AK_QUOTE_OPPTY_V '||
939: ' l_cust_party_id :' || l_cust_party_id ,1,'N');
940: aso_debug_pub.add('Function Get_QuoteAddress Database Object ASO_AK_QUOTE_OPPTY_V '||
941: ' l_party_id :' || l_party_id ,1,'N');
942: END IF;

Line 940: aso_debug_pub.add('Function Get_QuoteAddress Database Object ASO_AK_QUOTE_OPPTY_V '||

936:
937: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
938: aso_debug_pub.add('Function Get_QuoteAddress Database Object ASO_AK_QUOTE_OPPTY_V '||
939: ' l_cust_party_id :' || l_cust_party_id ,1,'N');
940: aso_debug_pub.add('Function Get_QuoteAddress Database Object ASO_AK_QUOTE_OPPTY_V '||
941: ' l_party_id :' || l_party_id ,1,'N');
942: END IF;
943: END IF;
944:

Line 1156: ELSIF p_database_object_name='ASO_AK_QUOTE_OPPTY_V' THEN

1152: aso_debug_pub.add('Function Get_BillAddress Database Object ASO_AK_QUOTE_HEADER_V '||
1153: ' l_party_id :' || l_party_id ,1,'N');
1154: END IF;
1155:
1156: ELSIF p_database_object_name='ASO_AK_QUOTE_OPPTY_V' THEN
1157: --l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_cust_party_id;
1158: --l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_party_id;
1159: l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_cust_party_id;
1160:

Line 1167: aso_debug_pub.add('Function Get_BillAddress Database Object ASO_AK_QUOTE_OPPTY_V '||

1163:
1164: --l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_sld_to_cont_id;
1165:
1166: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1167: aso_debug_pub.add('Function Get_BillAddress Database Object ASO_AK_QUOTE_OPPTY_V '||
1168: ' l_cust_party_id :' || l_cust_party_id ,1,'N');
1169: aso_debug_pub.add('Function Get_BillAddress Database Object ASO_AK_QUOTE_OPPTY_V '||
1170: ' l_party_id :' || l_party_id ,1,'N');
1171: END IF;

Line 1169: aso_debug_pub.add('Function Get_BillAddress Database Object ASO_AK_QUOTE_OPPTY_V '||

1165:
1166: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1167: aso_debug_pub.add('Function Get_BillAddress Database Object ASO_AK_QUOTE_OPPTY_V '||
1168: ' l_cust_party_id :' || l_cust_party_id ,1,'N');
1169: aso_debug_pub.add('Function Get_BillAddress Database Object ASO_AK_QUOTE_OPPTY_V '||
1170: ' l_party_id :' || l_party_id ,1,'N');
1171: END IF;
1172:
1173: END IF;

Line 1397: ELSIF p_database_object_name='ASO_AK_QUOTE_OPPTY_V' THEN

1393: aso_debug_pub.add('Function Get_ShipAddress Database Object ASO_AK_QUOTE_HEADER_V '||
1394: ' l_party_id :' || l_party_id ,1,'N');
1395: END IF;
1396:
1397: ELSIF p_database_object_name='ASO_AK_QUOTE_OPPTY_V' THEN
1398: --l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_cust_party_id;
1399: --l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_party_id;
1400: l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_cust_party_id;
1401: /* Bug 9594091 -- Commented not to copy the Sold to customer contact to ship to

Line 1407: aso_debug_pub.add('Function Get_ShipAddress Database Object ASO_AK_QUOTE_OPPTY_V '||

1403:
1404: --l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_sld_to_cont_id;
1405:
1406: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1407: aso_debug_pub.add('Function Get_ShipAddress Database Object ASO_AK_QUOTE_OPPTY_V '||
1408: ' l_cust_party_id :' || l_cust_party_id ,1,'N');
1409: aso_debug_pub.add('Function Get_ShipAddress Database Object ASO_AK_QUOTE_OPPTY_V '||
1410: ' l_party_id :' || l_party_id ,1,'N');
1411: END IF;

Line 1409: aso_debug_pub.add('Function Get_ShipAddress Database Object ASO_AK_QUOTE_OPPTY_V '||

1405:
1406: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1407: aso_debug_pub.add('Function Get_ShipAddress Database Object ASO_AK_QUOTE_OPPTY_V '||
1408: ' l_cust_party_id :' || l_cust_party_id ,1,'N');
1409: aso_debug_pub.add('Function Get_ShipAddress Database Object ASO_AK_QUOTE_OPPTY_V '||
1410: ' l_party_id :' || l_party_id ,1,'N');
1411: END IF;
1412:
1413: END IF;

Line 1622: ELSIF p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN

1618:
1619: IF p_database_object_name = 'ASO_AK_QUOTE_HEADER_V' THEN
1620: l_resource_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_resource_id;
1621: l_org_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_Org_id;
1622: ELSIF p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN
1623: l_resource_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.O_resource_id;
1624: l_org_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.O_Org_id;
1625: END IF;
1626:

Line 1692: ELSIF p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN

1688: End If;
1689:
1690: IF p_database_object_name = 'ASO_AK_QUOTE_HEADER_V' THEN
1691: l_org_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_Org_id;
1692: ELSIF p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN
1693: l_org_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.O_Org_id;
1694: END IF;
1695:
1696: l_salesgroup_id := aso_utility_pvt.get_ou_attribute_value(aso_utility_pvt.G_DEFAULT_SALES_GROUP,l_org_id);

Line 1769: ELSIF p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN

1765: End If;
1766:
1767: IF p_database_object_name = 'ASO_AK_QUOTE_HEADER_V' THEN
1768: l_org_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_ORG_ID;
1769: ELSIF p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN
1770: l_org_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.O_ORG_ID;
1771: END IF;
1772:
1773: IF l_org_id is null or l_org_id = FND_API.G_MISS_NUM THEN

Line 1872: ELSIF p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN

1868:
1869: IF p_database_object_name = 'ASO_AK_QUOTE_HEADER_V' THEN
1870: l_price_list_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.q_price_list_id;
1871:
1872: ELSIF p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN
1873: l_price_list_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_price_list_id;
1874:
1875:
1876: END IF;

Line 1920: p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN

1916: aso_debug_pub.add('Function Get_Currency_from_Profile --- Begin :',1,'N');
1917: END IF;
1918:
1919: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' OR
1920: p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN
1921: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1922: aso_debug_pub.add('Function Get_Currency_From_Profile Profile ICX_PREFERRED_CURRENCY : '||
1923: fnd_profile.Value('ICX_PREFERRED_CURRENCY') ,1,'N');
1924: END IF;