APPS.ASL_INV_ITEM_SUMM_PUB dependencies on FND_PROFILE

Line 11: G_DEBUG VARCHAR2(1) := NVL(fnd_profile.value('APPS_DEBUG'), 'N');

7: G_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID();
8: G_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID();
9: G_user_id NUMBER := FND_GLOBAL.USER_ID();
10: G_login_id NUMBER := FND_GLOBAL.CONC_LOGIN_ID();
11: G_DEBUG VARCHAR2(1) := NVL(fnd_profile.value('APPS_DEBUG'), 'N');
12: -- 07-APR-2004 vqnguyen disabled pricing summarization.
13: -- replace the following G_PRICING declaration with the
14: -- commented one below it to re-enable
15: G_PRICING VARCHAR2(1) := 'Y';

Line 16: -- G_PRICING VARCHAR2(1) := NVL(fnd_profile.value('ASL_ALL_ITEM_PRICE_LINE'),'N');

12: -- 07-APR-2004 vqnguyen disabled pricing summarization.
13: -- replace the following G_PRICING declaration with the
14: -- commented one below it to re-enable
15: G_PRICING VARCHAR2(1) := 'Y';
16: -- G_PRICING VARCHAR2(1) := NVL(fnd_profile.value('ASL_ALL_ITEM_PRICE_LINE'),'N');
17:
18:
19: PROCEDURE Table_Load_Main(
20: ERRBUF OUT NOCOPY VARCHAR2

Line 784: SELECT FND_PROFILE.value('JTF_PROFILE_DEFAULT_CURRENCY')

780:
781: NULL;
782:
783: /*
784: SELECT FND_PROFILE.value('JTF_PROFILE_DEFAULT_CURRENCY')
785: INTO l_currency_code
786: FROM DUAL;
787:
788: IF l_category_id IS NULL THEN

Line 995: SELECT FND_PROFILE.value('JTF_PROFILE_DEFAULT_CURRENCY')

991:
992: NULL;
993:
994: /*
995: SELECT FND_PROFILE.value('JTF_PROFILE_DEFAULT_CURRENCY')
996: INTO l_currency_code
997: FROM DUAL;
998:
999: