DBA Data[Home] [Help]

APPS.HZ_CUSTOMER_INT dependencies on FND_PROFILE

Line 1200: l_num_of_workers := NVL(FND_PROFILE.VALUE(l_profile), 1);

1196: ELSIF l_times IN ( 2, 4 ) THEN
1197: -- read profile option.
1198: l_profile := 'HZ_CINTERFACE_NUM_OF_WORKERS';
1199:
1200: l_num_of_workers := NVL(FND_PROFILE.VALUE(l_profile), 1);
1201:
1202: FND_FILE.PUT_LINE(FND_FILE.LOG,
1203: l_profile || ' = ' || TO_CHAR(l_num_of_workers));
1204:

Line 2330: decode(fnd_profile.value ('HZ_PROFILE_VERSION'),'NEW_VERSION','C','NO_VERSION','U',

2326: -- The cursor is used to select interface related value for user-entered
2327: -- profile.
2328: CURSOR c_entity IS
2329: SELECT /* decode(trunc(org.effective_start_date),trunc(sysdate),'U','C') create_update_flag,*/
2330: decode(fnd_profile.value ('HZ_PROFILE_VERSION'),'NEW_VERSION','C','NO_VERSION','U',
2331: decode(trunc(org.effective_start_date),trunc(sysdate),'U','C')) create_update_flag,
2332: org.organization_profile_id,
2333: org.party_id,
2334: -- User NVL for bug 1404725. We do not need NVL on

Line 2647: decode(fnd_profile.value ('HZ_PROFILE_VERSION'),'NEW_VERSION','C','NO_VERSION','U',

2643: -- The cursor is used to select interface related value for user-entered
2644: -- profile.
2645: CURSOR c_entity IS
2646: SELECT /* decode(trunc(per.effective_start_date),trunc(sysdate),'U','C') create_update_flag, */
2647: decode(fnd_profile.value ('HZ_PROFILE_VERSION'),'NEW_VERSION','C','NO_VERSION','U',
2648: decode(trunc(per.effective_start_date),trunc(sysdate),'U','C')) create_update_flag,
2649: per.person_profile_id,
2650: per.party_id,
2651: -- User NVL for bug 1404725 when we have to take