DBA Data[Home] [Help]

APPS.PJI_RESOURCE_UTILZ dependencies on FND_PROFILE

Line 849: SELECT NVL(fnd_profile.value('PA_RES_UTIL_DEF_CALC_METHOD'),'CAPACITY')

845: ,x_msg_data => x_msg_data
846: );
847: END IF;
848:
849: SELECT NVL(fnd_profile.value('PA_RES_UTIL_DEF_CALC_METHOD'),'CAPACITY')
850: INTO g_calc_mthd
851: FROM DUAL;
852:
853: --Calculate expected utilization and put it

Line 1375: SELECT fnd_profile.value('PA_RES_UTIL_DEF_PERIOD_TYPE')

1371: l_msg_index_out NUMBER; -- -- Bug Ref : 7010273
1372: BEGIN
1373: x_return_status := FND_API.G_RET_STS_SUCCESS;
1374: --Get the site level profile option of the user
1375: SELECT fnd_profile.value('PA_RES_UTIL_DEF_PERIOD_TYPE')
1376: INTO l_pa_res_util_def_pd_types
1377: FROM dual;
1378:
1379: IF (l_pa_res_util_def_pd_types = 'GL') THEN