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_AK_QUOTE_HEADER_V

Line 80: IF p_database_object_name = 'ASO_AK_QUOTE_HEADER_V' THEN

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

Line 133: IF p_database_object_name = 'ASO_AK_QUOTE_HEADER_V' THEN

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

Line 215: IF p_database_object_name = 'ASO_AK_QUOTE_HEADER_V' THEN

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

Line 219: aso_debug_pub.add('Function Get_CustAcct_From_CustParty Database Object ASO_AK_QUOTE_HEADER_V '||

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');
221: END IF;
222:
223: ELSIF p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN

Line 306: IF p_database_object_name = 'ASO_AK_QUOTE_HEADER_V' THEN

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

Line 310: aso_debug_pub.add('Function Get_PriceList_From_Agreement Database Object ASO_AK_QUOTE_HEADER_V '||

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');
312: END IF;
313:
314: ELSIF p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN

Line 396: IF p_database_object_name = 'ASO_AK_QUOTE_HEADER_V' THEN

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

Line 400: aso_debug_pub.add('Function Get_PriceList_From_CustAcct Database Object ASO_AK_QUOTE_HEADER_V '||

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');
402: END IF;
403:
404: ELSIF p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN

Line 473: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' THEN

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

Line 477: aso_debug_pub.add('Function Get_PriceList_From_OrderType Database Object ASO_AK_QUOTE_HEADER_V '||

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');
479: END IF;
480:
481: ELSIF p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN

Line 547: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' THEN

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

Line 551: aso_debug_pub.add('Function Get_PaymentTerm_From_Agreement Database Object ASO_AK_QUOTE_HEADER_V '||

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');
553: END IF;
554:
555: ELSIF p_database_object_name='ASO_AK_QUOTE_OPPTY_V' THEN

Line 619: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' THEN

615: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
616: aso_debug_pub.add('Function Get_PaymentTerm_From_Customer --- Begin : ' ,1,'N');
617: END IF;
618:
619: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' THEN
620: l_cust_acct_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_Cust_Account_id;
621:
622: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
623: aso_debug_pub.add('Function Get_PaymentTerm_From_Customer Database Object ASO_AK_QUOTE_HEADER_V '||

Line 623: aso_debug_pub.add('Function Get_PaymentTerm_From_Customer Database Object ASO_AK_QUOTE_HEADER_V '||

619: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' THEN
620: l_cust_acct_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_Cust_Account_id;
621:
622: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
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;

Line 791: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' THEN

787: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
788: aso_debug_pub.add('Function Get_QuotePhone --- Begin ',1,'N');
789: END IF;
790:
791: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' THEN
792: l_cust_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.q_cust_party_id;
793: l_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.q_party_id;
794:
795: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 796: aso_debug_pub.add('Function Get_QuotePhone Database Object ASO_AK_QUOTE_HEADER_V '||

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

Line 798: aso_debug_pub.add('Function Get_QuotePhone Database Object ASO_AK_QUOTE_HEADER_V '||

794:
795: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
796: aso_debug_pub.add('Function Get_QuotePhone Database Object ASO_AK_QUOTE_HEADER_V '||
797: ' l_cust_party_id :' || l_cust_party_id ,1,'N');
798: aso_debug_pub.add('Function Get_QuotePhone Database Object ASO_AK_QUOTE_HEADER_V '||
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

Line 914: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' THEN

910: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
911: aso_debug_pub.add('Function Get_QuoteAddress --- Begin :',1,'N');
912: END IF;
913:
914: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' THEN
915: l_cust_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_cust_party_id;
916: l_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_party_id;
917:
918: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 919: aso_debug_pub.add('Function Get_QuoteAddress Database Object ASO_AK_QUOTE_HEADER_V '||

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

Line 921: aso_debug_pub.add('Function Get_QuoteAddress Database Object ASO_AK_QUOTE_HEADER_V '||

917:
918: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
919: aso_debug_pub.add('Function Get_QuoteAddress Database Object ASO_AK_QUOTE_HEADER_V '||
920: ' l_cust_party_id :' || l_cust_party_id ,1,'N');
921: aso_debug_pub.add('Function Get_QuoteAddress Database Object ASO_AK_QUOTE_HEADER_V '||
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

Line 1136: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' THEN

1132: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1133: aso_debug_pub.add('Function Get_BillAddress --- Begin : ',1,'N');
1134: END IF;
1135:
1136: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' THEN
1137: --l_cust_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_cust_party_id;
1138: l_cust_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_INV_TO_CUST_PTY_ID ;
1139: --l_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_party_id;
1140: l_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_INV_TO_PTY_ID ;

Line 1143: aso_debug_pub.add('Function Get_BillAddress Database Object ASO_AK_QUOTE_HEADER_V '||

1139: --l_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_party_id;
1140: l_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_INV_TO_PTY_ID ;
1141:
1142: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1143: aso_debug_pub.add('Function Get_BillAddress Database Object ASO_AK_QUOTE_HEADER_V '||
1144: ' l_cust_party_id :' || l_cust_party_id ,1,'N');
1145: aso_debug_pub.add('Function Get_BillAddress Database Object ASO_AK_QUOTE_HEADER_V '||
1146: ' l_party_id :' || l_party_id ,1,'N');
1147: END IF;

Line 1145: aso_debug_pub.add('Function Get_BillAddress Database Object ASO_AK_QUOTE_HEADER_V '||

1141:
1142: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1143: aso_debug_pub.add('Function Get_BillAddress Database Object ASO_AK_QUOTE_HEADER_V '||
1144: ' l_cust_party_id :' || l_cust_party_id ,1,'N');
1145: aso_debug_pub.add('Function Get_BillAddress Database Object ASO_AK_QUOTE_HEADER_V '||
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

Line 1363: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' THEN

1359: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1360: aso_debug_pub.add('Function Get_ShipAddress --- Begin : ',1,'N');
1361: END IF;
1362:
1363: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' THEN
1364:
1365: /* Done code change for Bug - 5763528, commented following code -
1366:
1367: --l_cust_party_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_cust_party_id;

Line 1380: aso_debug_pub.add('Function Get_ShipAddress Database Object ASO_AK_QUOTE_HEADER_V '||

1376:
1377: -- End of code for Bug - 5763528
1378:
1379: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1380: aso_debug_pub.add('Function Get_ShipAddress Database Object ASO_AK_QUOTE_HEADER_V '||
1381: ' l_cust_party_id :' || l_cust_party_id ,1,'N');
1382: aso_debug_pub.add('Function Get_ShipAddress Database Object ASO_AK_QUOTE_HEADER_V '||
1383: ' l_party_id :' || l_party_id ,1,'N');
1384: END IF;

Line 1382: aso_debug_pub.add('Function Get_ShipAddress Database Object ASO_AK_QUOTE_HEADER_V '||

1378:
1379: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1380: aso_debug_pub.add('Function Get_ShipAddress Database Object ASO_AK_QUOTE_HEADER_V '||
1381: ' l_cust_party_id :' || l_cust_party_id ,1,'N');
1382: aso_debug_pub.add('Function Get_ShipAddress Database Object ASO_AK_QUOTE_HEADER_V '||
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

Line 1605: IF p_database_object_name = 'ASO_AK_QUOTE_HEADER_V' THEN

1601: aso_debug_pub.add('Function Get_SalesGroup_From_Salesrep -- Automatic Team Assign'||fnd_profile.value('ASO_AUTO_TEAM_ASSIGN'),1,'N');
1602: return null;
1603: End If;
1604:
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;

Line 1676: IF p_database_object_name = 'ASO_AK_QUOTE_HEADER_V' THEN

1672: aso_debug_pub.add('Function Get_SalesGroup_From_Profile -- Automatic Team Assign'||fnd_profile.value('ASO_AUTO_TEAM_ASSIGN'),1,'N');
1673: return null;
1674: End If;
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;

Line 1753: IF p_database_object_name = 'ASO_AK_QUOTE_HEADER_V' THEN

1749: aso_debug_pub.add('Function Get_SalesRep -- Automatic Team Assign'||fnd_profile.value('ASO_AUTO_TEAM_ASSIGN'),1,'N');
1750: return null;
1751: End If;
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;

Line 1855: IF p_database_object_name = 'ASO_AK_QUOTE_HEADER_V' THEN

1851: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1852: aso_debug_pub.add('Function Get_Currency_from_pricelist --- Begin : ',1,'N');
1853: END IF;
1854:
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;

Line 1905: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' OR

1901: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1902: aso_debug_pub.add('Function Get_Currency_from_Profile --- Begin :',1,'N');
1903: END IF;
1904:
1905: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' OR
1906: p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN
1907: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1908: aso_debug_pub.add('Function Get_Currency_From_Profile Profile ICX_PREFERRED_CURRENCY : '||
1909: fnd_profile.Value('ICX_PREFERRED_CURRENCY') ,1,'N');

Line 1958: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' THEN

1954: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1955: aso_debug_pub.add('Function Get_RequestedDateType --- Begin : ',1,'N');
1956: END IF;
1957:
1958: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' THEN
1959: l_acct_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_cust_account_id;
1960:
1961: IF ( l_acct_id IS NOT NULL AND
1962: l_acct_id <> FND_API.G_MISS_NUM ) THEN