DBA Data[Home] [Help]

APPS.PJI_FM_SUM_PSI dependencies on FND_GLOBAL

Line 2362: l_last_updated_by := FND_GLOBAL.USER_ID;

2358:
2359: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');
2360:
2361: l_last_update_date := sysdate;
2362: l_last_updated_by := FND_GLOBAL.USER_ID;
2363: l_creation_date := sysdate;
2364: l_created_by := FND_GLOBAL.USER_ID;
2365: l_last_update_login := FND_GLOBAL.LOGIN_ID;
2366:

Line 2364: l_created_by := FND_GLOBAL.USER_ID;

2360:
2361: l_last_update_date := sysdate;
2362: l_last_updated_by := FND_GLOBAL.USER_ID;
2363: l_creation_date := sysdate;
2364: l_created_by := FND_GLOBAL.USER_ID;
2365: l_last_update_login := FND_GLOBAL.LOGIN_ID;
2366:
2367: insert /*+ append parallel(hdr_i) */ into PJI_FP_TXN_ACCUM_HEADER hdr_i
2368: (

Line 2365: l_last_update_login := FND_GLOBAL.LOGIN_ID;

2361: l_last_update_date := sysdate;
2362: l_last_updated_by := FND_GLOBAL.USER_ID;
2363: l_creation_date := sysdate;
2364: l_created_by := FND_GLOBAL.USER_ID;
2365: l_last_update_login := FND_GLOBAL.LOGIN_ID;
2366:
2367: insert /*+ append parallel(hdr_i) */ into PJI_FP_TXN_ACCUM_HEADER hdr_i
2368: (
2369: TXN_ACCUM_HEADER_ID,

Line 2541: l_last_updated_by := FND_GLOBAL.USER_ID;

2537:
2538: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');
2539:
2540: l_last_update_date := sysdate;
2541: l_last_updated_by := FND_GLOBAL.USER_ID;
2542: l_creation_date := sysdate;
2543: l_created_by := FND_GLOBAL.USER_ID;
2544: l_last_update_login := FND_GLOBAL.LOGIN_ID;
2545:

Line 2543: l_created_by := FND_GLOBAL.USER_ID;

2539:
2540: l_last_update_date := sysdate;
2541: l_last_updated_by := FND_GLOBAL.USER_ID;
2542: l_creation_date := sysdate;
2543: l_created_by := FND_GLOBAL.USER_ID;
2544: l_last_update_login := FND_GLOBAL.LOGIN_ID;
2545:
2546: if (l_extraction_type = 'FULL' or
2547: l_extraction_type = 'PARTIAL') then

Line 2544: l_last_update_login := FND_GLOBAL.LOGIN_ID;

2540: l_last_update_date := sysdate;
2541: l_last_updated_by := FND_GLOBAL.USER_ID;
2542: l_creation_date := sysdate;
2543: l_created_by := FND_GLOBAL.USER_ID;
2544: l_last_update_login := FND_GLOBAL.LOGIN_ID;
2545:
2546: if (l_extraction_type = 'FULL' or
2547: l_extraction_type = 'PARTIAL') then
2548:

Line 3183: l_last_updated_by := FND_GLOBAL.USER_ID;

3179:
3180: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');
3181:
3182: l_last_update_date := sysdate;
3183: l_last_updated_by := FND_GLOBAL.USER_ID;
3184: l_creation_date := sysdate;
3185: l_created_by := FND_GLOBAL.USER_ID;
3186: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3187:

Line 3185: l_created_by := FND_GLOBAL.USER_ID;

3181:
3182: l_last_update_date := sysdate;
3183: l_last_updated_by := FND_GLOBAL.USER_ID;
3184: l_creation_date := sysdate;
3185: l_created_by := FND_GLOBAL.USER_ID;
3186: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3187:
3188: if (l_extraction_type = 'INCREMENTAL') then
3189:

Line 3186: l_last_update_login := FND_GLOBAL.LOGIN_ID;

3182: l_last_update_date := sysdate;
3183: l_last_updated_by := FND_GLOBAL.USER_ID;
3184: l_creation_date := sysdate;
3185: l_created_by := FND_GLOBAL.USER_ID;
3186: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3187:
3188: if (l_extraction_type = 'INCREMENTAL') then
3189:
3190: insert /*+ append parallel(bal) */ into PJI_FP_TXN_ACCUM bal

Line 3448: l_last_updated_by := FND_GLOBAL.USER_ID;

3444: (PJI_FM_SUM_MAIN.g_process,
3445: 'EXTRACT_COMMITMENTS');
3446:
3447: l_last_update_date := sysdate;
3448: l_last_updated_by := FND_GLOBAL.USER_ID;
3449: l_creation_date := sysdate;
3450: l_created_by := FND_GLOBAL.USER_ID;
3451: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3452:

Line 3450: l_created_by := FND_GLOBAL.USER_ID;

3446:
3447: l_last_update_date := sysdate;
3448: l_last_updated_by := FND_GLOBAL.USER_ID;
3449: l_creation_date := sysdate;
3450: l_created_by := FND_GLOBAL.USER_ID;
3451: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3452:
3453: if ((l_extraction_type = 'FULL' or
3454: l_extraction_type = 'PARTIAL') and

Line 3451: l_last_update_login := FND_GLOBAL.LOGIN_ID;

3447: l_last_update_date := sysdate;
3448: l_last_updated_by := FND_GLOBAL.USER_ID;
3449: l_creation_date := sysdate;
3450: l_created_by := FND_GLOBAL.USER_ID;
3451: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3452:
3453: if ((l_extraction_type = 'FULL' or
3454: l_extraction_type = 'PARTIAL') and
3455: l_extract_commitments = 'Y') then

Line 3693: l_last_updated_by := FND_GLOBAL.USER_ID;

3689: (PJI_FM_SUM_MAIN.g_process,
3690: 'EXTRACT_COMMITMENTS');
3691:
3692: l_last_update_date := sysdate;
3693: l_last_updated_by := FND_GLOBAL.USER_ID;
3694: l_creation_date := sysdate;
3695: l_created_by := FND_GLOBAL.USER_ID;
3696: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3697:

Line 3695: l_created_by := FND_GLOBAL.USER_ID;

3691:
3692: l_last_update_date := sysdate;
3693: l_last_updated_by := FND_GLOBAL.USER_ID;
3694: l_creation_date := sysdate;
3695: l_created_by := FND_GLOBAL.USER_ID;
3696: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3697:
3698: if (l_extraction_type = 'INCREMENTAL' and l_extract_commitments = 'Y') then
3699:

Line 3696: l_last_update_login := FND_GLOBAL.LOGIN_ID;

3692: l_last_update_date := sysdate;
3693: l_last_updated_by := FND_GLOBAL.USER_ID;
3694: l_creation_date := sysdate;
3695: l_created_by := FND_GLOBAL.USER_ID;
3696: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3697:
3698: if (l_extraction_type = 'INCREMENTAL' and l_extract_commitments = 'Y') then
3699:
3700: insert /*+ append parallel(bal) */ into PJI_FP_TXN_ACCUM1 bal

Line 4257: l_last_updated_by := FND_GLOBAL.USER_ID;

4253:
4254: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
4255:
4256: l_last_update_date := sysdate;
4257: l_last_updated_by := FND_GLOBAL.USER_ID;
4258: l_last_update_login := FND_GLOBAL.LOGIN_ID;
4259:
4260: if (l_extraction_type = 'INCREMENTAL') then
4261:

Line 4258: l_last_update_login := FND_GLOBAL.LOGIN_ID;

4254: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
4255:
4256: l_last_update_date := sysdate;
4257: l_last_updated_by := FND_GLOBAL.USER_ID;
4258: l_last_update_login := FND_GLOBAL.LOGIN_ID;
4259:
4260: if (l_extraction_type = 'INCREMENTAL') then
4261:
4262: update PJI_FP_TXN_ACCUM psi

Line 4456: l_last_updated_by := FND_GLOBAL.USER_ID;

4452:
4453: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
4454:
4455: l_last_update_date := sysdate;
4456: l_last_updated_by := FND_GLOBAL.USER_ID;
4457: l_creation_date := sysdate;
4458: l_created_by := FND_GLOBAL.USER_ID;
4459: l_last_update_login := FND_GLOBAL.LOGIN_ID;
4460:

Line 4458: l_created_by := FND_GLOBAL.USER_ID;

4454:
4455: l_last_update_date := sysdate;
4456: l_last_updated_by := FND_GLOBAL.USER_ID;
4457: l_creation_date := sysdate;
4458: l_created_by := FND_GLOBAL.USER_ID;
4459: l_last_update_login := FND_GLOBAL.LOGIN_ID;
4460:
4461: if (l_extraction_type = 'INCREMENTAL') then
4462:

Line 4459: l_last_update_login := FND_GLOBAL.LOGIN_ID;

4455: l_last_update_date := sysdate;
4456: l_last_updated_by := FND_GLOBAL.USER_ID;
4457: l_creation_date := sysdate;
4458: l_created_by := FND_GLOBAL.USER_ID;
4459: l_last_update_login := FND_GLOBAL.LOGIN_ID;
4460:
4461: if (l_extraction_type = 'INCREMENTAL') then
4462:
4463: insert /*+ append parallel(bal_i) */ into PJI_FP_TXN_ACCUM bal_i

Line 4727: l_last_updated_by := FND_GLOBAL.USER_ID;

4723:
4724: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
4725:
4726: l_last_update_date := sysdate;
4727: l_last_updated_by := FND_GLOBAL.USER_ID;
4728: l_creation_date := sysdate;
4729: l_created_by := FND_GLOBAL.USER_ID;
4730: l_last_update_login := FND_GLOBAL.LOGIN_ID;
4731:

Line 4729: l_created_by := FND_GLOBAL.USER_ID;

4725:
4726: l_last_update_date := sysdate;
4727: l_last_updated_by := FND_GLOBAL.USER_ID;
4728: l_creation_date := sysdate;
4729: l_created_by := FND_GLOBAL.USER_ID;
4730: l_last_update_login := FND_GLOBAL.LOGIN_ID;
4731:
4732: if (l_extraction_type = 'INCREMENTAL') then
4733:

Line 4730: l_last_update_login := FND_GLOBAL.LOGIN_ID;

4726: l_last_update_date := sysdate;
4727: l_last_updated_by := FND_GLOBAL.USER_ID;
4728: l_creation_date := sysdate;
4729: l_created_by := FND_GLOBAL.USER_ID;
4730: l_last_update_login := FND_GLOBAL.LOGIN_ID;
4731:
4732: if (l_extraction_type = 'INCREMENTAL') then
4733:
4734: insert /*+ append parallel(bal_i) */ into PJI_FP_TXN_ACCUM1 bal_i