DBA Data[Home] [Help]

APPS.QOT_DEFAULT_PVT dependencies on ASO_QUOTE_HEADER_DEF_HDLR

Line 81: l_org_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_Org_id;

77: aso_debug_pub.add('Function Get_OrderType Default -- Begin :',1,'N');
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:

Line 134: l_org_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_Org_id;

130: aso_debug_pub.add('Function Get_ContractTemplate Default -- Begin :',1,'N');
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:

Line 216: l_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_cust_party_id;

212: aso_debug_pub.add('Function Get_CustAcct_From_CustParty -- Begin :',1,'N');
213: END IF;
214:
215: IF p_database_object_name = 'ASO_AK_QUOTE_HEADER_V' THEN
216: l_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_cust_party_id;
217:
218: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' 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');

Line 307: l_agreement_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_contract_id;

303: END IF;
304:
305:
306: IF p_database_object_name = 'ASO_AK_QUOTE_HEADER_V' THEN
307: l_agreement_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_contract_id;
308:
309: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' 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');

Line 397: l_acct_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_cust_account_id;

393: aso_debug_pub.add('Function Get_PriceList_From_CustAcct -- Begin :',1,'N');
394: END IF;
395:
396: IF p_database_object_name = 'ASO_AK_QUOTE_HEADER_V' THEN
397: l_acct_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_cust_account_id;
398:
399: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' 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');

Line 474: l_order_type_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_order_type_id;

470: aso_debug_pub.add('Function Get_PriceList_From_OrderType -- Begin : ',1,'N');
471: END IF;
472:
473: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' THEN
474: l_order_type_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_order_type_id;
475:
476: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' 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');

Line 548: l_agreement_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_contract_id;

544: aso_debug_pub.add('Function Get_PaymentTerm_From_Agreement --- Begin : ' ,1,'N');
545: END IF;
546:
547: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' THEN
548: l_agreement_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_contract_id;
549:
550: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' 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');

Line 627: l_cust_acct_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_Cust_Account_id;

623: aso_debug_pub.add('Function Get_PaymentTerm_From_Customer --- Begin : ' ,1,'N');
624: END IF;
625:
626: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' THEN
627: l_cust_acct_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_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_HEADER_V '||
631: ' l_cust_acct_id : ' || l_cust_acct_id ,1,'N');

Line 799: l_cust_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.q_cust_party_id;

795: aso_debug_pub.add('Function Get_QuotePhone --- Begin ',1,'N');
796: END IF;
797:
798: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' THEN
799: l_cust_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.q_cust_party_id;
800: l_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.q_party_id;
801:
802: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
803: aso_debug_pub.add('Function Get_QuotePhone Database Object ASO_AK_QUOTE_HEADER_V '||

Line 800: l_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.q_party_id;

796: END IF;
797:
798: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' THEN
799: l_cust_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.q_cust_party_id;
800: l_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.q_party_id;
801:
802: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
803: aso_debug_pub.add('Function Get_QuotePhone Database Object ASO_AK_QUOTE_HEADER_V '||
804: ' l_cust_party_id :' || l_cust_party_id ,1,'N');

Line 922: l_cust_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_cust_party_id;

918: aso_debug_pub.add('Function Get_QuoteAddress --- Begin :',1,'N');
919: END IF;
920:
921: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' THEN
922: l_cust_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_cust_party_id;
923: l_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_party_id;
924:
925: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
926: aso_debug_pub.add('Function Get_QuoteAddress Database Object ASO_AK_QUOTE_HEADER_V '||

Line 923: l_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_party_id;

919: END IF;
920:
921: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' THEN
922: l_cust_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_cust_party_id;
923: l_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_party_id;
924:
925: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
926: aso_debug_pub.add('Function Get_QuoteAddress Database Object ASO_AK_QUOTE_HEADER_V '||
927: ' l_cust_party_id :' || l_cust_party_id ,1,'N');

Line 1144: --l_cust_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_cust_party_id;

1140: aso_debug_pub.add('Function Get_BillAddress --- Begin : ',1,'N');
1141: END IF;
1142:
1143: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' THEN
1144: --l_cust_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_cust_party_id;
1145: l_cust_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_INV_TO_CUST_PTY_ID ;
1146: --l_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_party_id;
1147: l_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_INV_TO_PTY_ID ;
1148:

Line 1145: l_cust_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_INV_TO_CUST_PTY_ID ;

1141: END IF;
1142:
1143: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' THEN
1144: --l_cust_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_cust_party_id;
1145: l_cust_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_INV_TO_CUST_PTY_ID ;
1146: --l_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_party_id;
1147: l_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_INV_TO_PTY_ID ;
1148:
1149: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 1146: --l_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_party_id;

1142:
1143: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' THEN
1144: --l_cust_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_cust_party_id;
1145: l_cust_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_INV_TO_CUST_PTY_ID ;
1146: --l_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_party_id;
1147: l_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_INV_TO_PTY_ID ;
1148:
1149: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1150: aso_debug_pub.add('Function Get_BillAddress Database Object ASO_AK_QUOTE_HEADER_V '||

Line 1147: l_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_INV_TO_PTY_ID ;

1143: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' THEN
1144: --l_cust_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_cust_party_id;
1145: l_cust_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_INV_TO_CUST_PTY_ID ;
1146: --l_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_party_id;
1147: l_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_INV_TO_PTY_ID ;
1148:
1149: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1150: aso_debug_pub.add('Function Get_BillAddress Database Object ASO_AK_QUOTE_HEADER_V '||
1151: ' l_cust_party_id :' || l_cust_party_id ,1,'N');

Line 1378: --l_cust_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_cust_party_id;

1374: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' THEN
1375:
1376: /* Done code change for Bug - 5763528, commented following code -
1377:
1378: --l_cust_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_cust_party_id;
1379: l_cust_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_INV_TO_CUST_PTY_ID;
1380: --l_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_party_id;
1381: l_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_INV_TO_PTY_ID; */
1382:

Line 1379: l_cust_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_INV_TO_CUST_PTY_ID;

1375:
1376: /* Done code change for Bug - 5763528, commented following code -
1377:
1378: --l_cust_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_cust_party_id;
1379: l_cust_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_INV_TO_CUST_PTY_ID;
1380: --l_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_party_id;
1381: l_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_INV_TO_PTY_ID; */
1382:
1383: -- Following code replaced above code

Line 1380: --l_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_party_id;

1376: /* Done code change for Bug - 5763528, commented following code -
1377:
1378: --l_cust_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_cust_party_id;
1379: l_cust_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_INV_TO_CUST_PTY_ID;
1380: --l_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_party_id;
1381: l_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_INV_TO_PTY_ID; */
1382:
1383: -- Following code replaced above code
1384:

Line 1381: l_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_INV_TO_PTY_ID; */

1377:
1378: --l_cust_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_cust_party_id;
1379: l_cust_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_INV_TO_CUST_PTY_ID;
1380: --l_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_party_id;
1381: l_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_INV_TO_PTY_ID; */
1382:
1383: -- Following code replaced above code
1384:
1385: l_cust_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_SHIP_TO_CUST_PARTY_ID;

Line 1385: l_cust_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_SHIP_TO_CUST_PARTY_ID;

1381: l_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_INV_TO_PTY_ID; */
1382:
1383: -- Following code replaced above code
1384:
1385: l_cust_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_SHIP_TO_CUST_PARTY_ID;
1386: l_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_SHIP_TO_PARTY_ID;
1387:
1388: -- End of code for Bug - 5763528
1389:

Line 1386: l_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_SHIP_TO_PARTY_ID;

1382:
1383: -- Following code replaced above code
1384:
1385: l_cust_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_SHIP_TO_CUST_PARTY_ID;
1386: l_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_SHIP_TO_PARTY_ID;
1387:
1388: -- End of code for Bug - 5763528
1389:
1390: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 1620: l_resource_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_resource_id;

1616: return null;
1617: End If;
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;

Line 1621: l_org_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_Org_id;

1617: End If;
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;

Line 1691: l_org_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_Org_id;

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

Line 1768: l_org_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_ORG_ID;

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

Line 1870: l_price_list_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.q_price_list_id;

1866: aso_debug_pub.add('Function Get_Currency_from_pricelist --- Begin : ',1,'N');
1867: END IF;
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:

Line 1973: l_acct_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_cust_account_id;

1969: aso_debug_pub.add('Function Get_RequestedDateType --- Begin : ',1,'N');
1970: END IF;
1971:
1972: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' THEN
1973: l_acct_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_cust_account_id;
1974:
1975: IF ( l_acct_id IS NOT NULL AND
1976: l_acct_id <> FND_API.G_MISS_NUM ) THEN
1977: OPEN C_Get_RDT (l_acct_id);