DBA Data[Home] [Help]

APPS.OE_CREDIT_EXPOSURE_PVT dependencies on FND_INSTALLATION

Line 5419: l_ret := FND_INSTALLATION.get_app_info('ONT',l_status,l_industry,l_ont_schema);

5415: oe_debug_pub.add( 'Value of the profile OM: Preserve External Credit Balances is :' || NVL(FND_PROFILE.VALUE('ONT_PRESERVE_EXT_CR_BAL'),'Y'),2);
5416: END IF;
5417:
5418: --8567481 start
5419: l_ret := FND_INSTALLATION.get_app_info('ONT',l_status,l_industry,l_ont_schema);
5420: l_sql_stmnt_hwm := 'ANALYZE TABLE '|| l_ont_schema||'.oe_credit_summaries ESTIMATE STATISTICS';
5421: EXECUTE IMMEDIATE l_sql_stmnt_hwm;
5422: --8567481 end
5423:

Line 5435: l_ret := FND_INSTALLATION.get_app_info('ONT',l_status,l_industry,l_ont_schema); --This API is used to get schema name

5431: WHERE balance_type IN(1,2,3,4,5,6,7,8,9,10,11,13,14,15,16,17,20,21,22,23,24,25,26,27,28,29,30,31,32
5432: ,33,34,35,36);
5433: --14689044 end
5434: ELSE
5435: l_ret := FND_INSTALLATION.get_app_info('ONT',l_status,l_industry,l_ont_schema); --This API is used to get schema name
5436: l_sql_stmnt := 'truncate table '||l_ont_schema ||'.oe_credit_summaries';
5437: EXECUTE IMMEDIATE l_sql_stmnt;
5438: END IF;
5439: