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 626: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' THEN

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

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

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

Line 798: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' THEN

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

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

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

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

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

Line 921: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' THEN

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

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

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

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

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

Line 1143: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' THEN

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

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

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

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

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

Line 1374: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' THEN

1370: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1371: aso_debug_pub.add('Function Get_ShipAddress --- Begin : ',1,'N');
1372: END IF;
1373:
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;

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

1387:
1388: -- End of code for Bug - 5763528
1389:
1390: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1391: aso_debug_pub.add('Function Get_ShipAddress Database Object ASO_AK_QUOTE_HEADER_V '||
1392: ' l_cust_party_id :' || l_cust_party_id ,1,'N');
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;

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

1389:
1390: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1391: aso_debug_pub.add('Function Get_ShipAddress Database Object ASO_AK_QUOTE_HEADER_V '||
1392: ' l_cust_party_id :' || l_cust_party_id ,1,'N');
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

Line 1619: IF p_database_object_name = 'ASO_AK_QUOTE_HEADER_V' THEN

1615: aso_debug_pub.add('Function Get_SalesGroup_From_Salesrep -- Automatic Team Assign'||fnd_profile.value('ASO_AUTO_TEAM_ASSIGN'),1,'N');
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;

Line 1690: IF p_database_object_name = 'ASO_AK_QUOTE_HEADER_V' THEN

1686: aso_debug_pub.add('Function Get_SalesGroup_From_Profile -- Automatic Team Assign'||fnd_profile.value('ASO_AUTO_TEAM_ASSIGN'),1,'N');
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;

Line 1767: IF p_database_object_name = 'ASO_AK_QUOTE_HEADER_V' THEN

1763: aso_debug_pub.add('Function Get_SalesRep -- Automatic Team Assign'||fnd_profile.value('ASO_AUTO_TEAM_ASSIGN'),1,'N');
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;

Line 1869: IF p_database_object_name = 'ASO_AK_QUOTE_HEADER_V' THEN

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

Line 1919: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' OR

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

Line 1972: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' THEN

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