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

Line 83: l_org_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.O_Org_id;

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);
87:

Line 136: l_org_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.O_Org_id;

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);
140:

Line 224: l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_cust_party_id;

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 '||
228: ' l_party_id : ' || l_party_id ,1,'N');

Line 315: l_agreement_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_contract_id;

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 '||
319: ' l_agreement_id : ' || l_agreement_id ,1,'N');

Line 405: l_acct_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_cust_account_id;

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 '||
409: ' l_acct_id : ' || l_acct_id ,1,'N');

Line 482: l_order_type_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_order_type_id;

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 '||
486: ' l_order_type_id : ' || l_order_type_id ,1,'N');

Line 556: l_agreement_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_contract_id;

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 '||
560: ' l_agreement_id : ' || l_agreement_id ,1,'N');

Line 627: l_cust_acct_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_cust_account_id;

623: aso_debug_pub.add('Function Get_PaymentTerm_From_Customer Database Object ASO_AK_QUOTE_HEADER_V '||
624: ' l_cust_acct_id : ' || l_cust_acct_id ,1,'N');
625: END IF;
626: ELSIF p_database_object_name='ASO_AK_QUOTE_OPPTY_V' THEN
627: l_cust_acct_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_cust_account_id;
628:
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_OPPTY_V '||
631: ' l_cust_acct_id : ' || l_cust_acct_id ,1,'N');

Line 803: --l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_cust_party_id; --Bug#5195151

799: ' l_party_id :' || l_party_id ,1,'N');
800: END IF;
801:
802: ELSIF p_database_object_name='ASO_AK_QUOTE_OPPTY_V' THEN
803: --l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_cust_party_id; --Bug#5195151
804: l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_cust_party_id;
805: l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_party_id;
806:
807: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 804: l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_cust_party_id;

800: END IF;
801:
802: ELSIF p_database_object_name='ASO_AK_QUOTE_OPPTY_V' THEN
803: --l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_cust_party_id; --Bug#5195151
804: l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_cust_party_id;
805: l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_party_id;
806:
807: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
808: aso_debug_pub.add('Function Get_QuotePhone Database Object ASO_AK_QUOTE_OPPTY_V '||

Line 805: l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_party_id;

801:
802: ELSIF p_database_object_name='ASO_AK_QUOTE_OPPTY_V' THEN
803: --l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_cust_party_id; --Bug#5195151
804: l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_cust_party_id;
805: l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_party_id;
806:
807: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
808: aso_debug_pub.add('Function Get_QuotePhone Database Object ASO_AK_QUOTE_OPPTY_V '||
809: ' l_cust_party_id :' || l_cust_party_id ,1,'N');

Line 926: --l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_cust_party_id; --Bug#5195151

922: ' l_party_id :' || l_party_id ,1,'N');
923: END IF;
924:
925: ELSIF p_database_object_name='ASO_AK_QUOTE_OPPTY_V' THEN
926: --l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_cust_party_id; --Bug#5195151
927: l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_cust_party_id;
928: l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_party_id;
929:
930: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 927: l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_cust_party_id;

923: END IF;
924:
925: ELSIF p_database_object_name='ASO_AK_QUOTE_OPPTY_V' THEN
926: --l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_cust_party_id; --Bug#5195151
927: l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_cust_party_id;
928: l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_party_id;
929:
930: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
931: aso_debug_pub.add('Function Get_QuoteAddress Database Object ASO_AK_QUOTE_OPPTY_V '||

Line 928: l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_party_id;

924:
925: ELSIF p_database_object_name='ASO_AK_QUOTE_OPPTY_V' THEN
926: --l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_cust_party_id; --Bug#5195151
927: l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_cust_party_id;
928: l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_party_id;
929:
930: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
931: aso_debug_pub.add('Function Get_QuoteAddress Database Object ASO_AK_QUOTE_OPPTY_V '||
932: ' l_cust_party_id :' || l_cust_party_id ,1,'N');

Line 1150: --l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_cust_party_id;

1146: ' l_party_id :' || l_party_id ,1,'N');
1147: END IF;
1148:
1149: ELSIF p_database_object_name='ASO_AK_QUOTE_OPPTY_V' THEN
1150: --l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_cust_party_id;
1151: --l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_party_id;
1152: l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_cust_party_id;
1153: l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_sld_to_cont_id;
1154:

Line 1151: --l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_party_id;

1147: END IF;
1148:
1149: ELSIF p_database_object_name='ASO_AK_QUOTE_OPPTY_V' THEN
1150: --l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_cust_party_id;
1151: --l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_party_id;
1152: l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_cust_party_id;
1153: l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_sld_to_cont_id;
1154:
1155: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 1152: l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_cust_party_id;

1148:
1149: ELSIF p_database_object_name='ASO_AK_QUOTE_OPPTY_V' THEN
1150: --l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_cust_party_id;
1151: --l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_party_id;
1152: l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_cust_party_id;
1153: l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_sld_to_cont_id;
1154:
1155: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1156: aso_debug_pub.add('Function Get_BillAddress Database Object ASO_AK_QUOTE_OPPTY_V '||

Line 1153: l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_sld_to_cont_id;

1149: ELSIF p_database_object_name='ASO_AK_QUOTE_OPPTY_V' THEN
1150: --l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_cust_party_id;
1151: --l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_party_id;
1152: l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_cust_party_id;
1153: l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_sld_to_cont_id;
1154:
1155: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1156: aso_debug_pub.add('Function Get_BillAddress Database Object ASO_AK_QUOTE_OPPTY_V '||
1157: ' l_cust_party_id :' || l_cust_party_id ,1,'N');

Line 1387: --l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_cust_party_id;

1383: ' l_party_id :' || l_party_id ,1,'N');
1384: END IF;
1385:
1386: ELSIF p_database_object_name='ASO_AK_QUOTE_OPPTY_V' THEN
1387: --l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_cust_party_id;
1388: --l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_party_id;
1389: l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_cust_party_id;
1390: l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_sld_to_cont_id;
1391:

Line 1388: --l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_party_id;

1384: END IF;
1385:
1386: ELSIF p_database_object_name='ASO_AK_QUOTE_OPPTY_V' THEN
1387: --l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_cust_party_id;
1388: --l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_party_id;
1389: l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_cust_party_id;
1390: l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_sld_to_cont_id;
1391:
1392: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 1389: l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_cust_party_id;

1385:
1386: ELSIF p_database_object_name='ASO_AK_QUOTE_OPPTY_V' THEN
1387: --l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_cust_party_id;
1388: --l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_party_id;
1389: l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_cust_party_id;
1390: l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_sld_to_cont_id;
1391:
1392: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1393: aso_debug_pub.add('Function Get_ShipAddress Database Object ASO_AK_QUOTE_OPPTY_V '||

Line 1390: l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_sld_to_cont_id;

1386: ELSIF p_database_object_name='ASO_AK_QUOTE_OPPTY_V' THEN
1387: --l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_cust_party_id;
1388: --l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_party_id;
1389: l_cust_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_cust_party_id;
1390: l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_sld_to_cont_id;
1391:
1392: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1393: aso_debug_pub.add('Function Get_ShipAddress Database Object ASO_AK_QUOTE_OPPTY_V '||
1394: ' l_cust_party_id :' || l_cust_party_id ,1,'N');

Line 1609: l_resource_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.O_resource_id;

1605: IF p_database_object_name = 'ASO_AK_QUOTE_HEADER_V' THEN
1606: l_resource_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_resource_id;
1607: l_org_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_Org_id;
1608: ELSIF p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN
1609: l_resource_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.O_resource_id;
1610: l_org_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.O_Org_id;
1611: END IF;
1612:
1613: IF l_org_id is null or l_org_id = FND_API.G_MISS_NUM THEN

Line 1610: l_org_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.O_Org_id;

1606: l_resource_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_resource_id;
1607: l_org_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_Org_id;
1608: ELSIF p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN
1609: l_resource_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.O_resource_id;
1610: l_org_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.O_Org_id;
1611: END IF;
1612:
1613: IF l_org_id is null or l_org_id = FND_API.G_MISS_NUM THEN
1614: return null;

Line 1679: l_org_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.O_Org_id;

1675:
1676: IF p_database_object_name = 'ASO_AK_QUOTE_HEADER_V' THEN
1677: l_org_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_Org_id;
1678: ELSIF p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN
1679: l_org_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.O_Org_id;
1680: END IF;
1681:
1682: l_salesgroup_id := aso_utility_pvt.get_ou_attribute_value(aso_utility_pvt.G_DEFAULT_SALES_GROUP,l_org_id);
1683:

Line 1756: l_org_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.O_ORG_ID;

1752:
1753: IF p_database_object_name = 'ASO_AK_QUOTE_HEADER_V' THEN
1754: l_org_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_ORG_ID;
1755: ELSIF p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN
1756: l_org_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.O_ORG_ID;
1757: END IF;
1758:
1759: IF l_org_id is null or l_org_id = FND_API.G_MISS_NUM THEN
1760: return null;

Line 1859: l_price_list_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_price_list_id;

1855: IF p_database_object_name = 'ASO_AK_QUOTE_HEADER_V' THEN
1856: l_price_list_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.q_price_list_id;
1857:
1858: ELSIF p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN
1859: l_price_list_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_price_list_id;
1860:
1861:
1862: END IF;
1863: