DBA Data[Home] [Help]

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 634: l_cust_acct_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_cust_account_id;

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 '||
638: ' l_cust_acct_id : ' || l_cust_acct_id ,1,'N');

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

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:
814: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

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

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:
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 '||

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

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

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

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:
937: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

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

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:
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 '||

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

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

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

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:
1161: /* Bug 9594091 -- Commented not to copy the Sold to customer contact to

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

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:
1161: /* Bug 9594091 -- Commented not to copy the Sold to customer contact to
1162: * Bill to Contact in Oppty to Quote defaulting bill to address flow */

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

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:
1161: /* Bug 9594091 -- Commented not to copy the Sold to customer contact to
1162: * Bill to Contact in Oppty to Quote defaulting bill to address flow */
1163:

Line 1164: --l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_sld_to_cont_id;

1160:
1161: /* Bug 9594091 -- Commented not to copy the Sold to customer contact to
1162: * Bill to Contact in Oppty to Quote defaulting bill to address flow */
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');

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

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
1402: * Contact in Oppty to Quote defaulting bill to address flow */

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

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
1402: * Contact in Oppty to Quote defaulting bill to address flow */
1403:

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

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
1402: * Contact in Oppty to Quote defaulting bill to address flow */
1403:
1404: --l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_sld_to_cont_id;

Line 1404: --l_party_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.o_oppty_sld_to_cont_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
1402: * Contact in Oppty to Quote defaulting bill to address flow */
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');

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

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:
1627: IF l_org_id is null or l_org_id = FND_API.G_MISS_NUM THEN

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

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:
1627: IF l_org_id is null or l_org_id = FND_API.G_MISS_NUM THEN
1628: return null;

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

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

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

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
1774: return null;

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

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;
1877: