DBA Data[Home] [Help]

APPS.PJI_FM_SUM_PSI dependencies on FND_GLOBAL

Line 2340: l_last_updated_by := FND_GLOBAL.USER_ID;

2336:
2337: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');
2338:
2339: l_last_update_date := sysdate;
2340: l_last_updated_by := FND_GLOBAL.USER_ID;
2341: l_creation_date := sysdate;
2342: l_created_by := FND_GLOBAL.USER_ID;
2343: l_last_update_login := FND_GLOBAL.LOGIN_ID;
2344:

Line 2342: l_created_by := FND_GLOBAL.USER_ID;

2338:
2339: l_last_update_date := sysdate;
2340: l_last_updated_by := FND_GLOBAL.USER_ID;
2341: l_creation_date := sysdate;
2342: l_created_by := FND_GLOBAL.USER_ID;
2343: l_last_update_login := FND_GLOBAL.LOGIN_ID;
2344:
2345: insert /*+ append parallel(hdr_i) */ into PJI_FP_TXN_ACCUM_HEADER hdr_i
2346: (

Line 2343: l_last_update_login := FND_GLOBAL.LOGIN_ID;

2339: l_last_update_date := sysdate;
2340: l_last_updated_by := FND_GLOBAL.USER_ID;
2341: l_creation_date := sysdate;
2342: l_created_by := FND_GLOBAL.USER_ID;
2343: l_last_update_login := FND_GLOBAL.LOGIN_ID;
2344:
2345: insert /*+ append parallel(hdr_i) */ into PJI_FP_TXN_ACCUM_HEADER hdr_i
2346: (
2347: TXN_ACCUM_HEADER_ID,

Line 2511: l_last_updated_by := FND_GLOBAL.USER_ID;

2507:
2508: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');
2509:
2510: l_last_update_date := sysdate;
2511: l_last_updated_by := FND_GLOBAL.USER_ID;
2512: l_creation_date := sysdate;
2513: l_created_by := FND_GLOBAL.USER_ID;
2514: l_last_update_login := FND_GLOBAL.LOGIN_ID;
2515:

Line 2513: l_created_by := FND_GLOBAL.USER_ID;

2509:
2510: l_last_update_date := sysdate;
2511: l_last_updated_by := FND_GLOBAL.USER_ID;
2512: l_creation_date := sysdate;
2513: l_created_by := FND_GLOBAL.USER_ID;
2514: l_last_update_login := FND_GLOBAL.LOGIN_ID;
2515:
2516: if (l_extraction_type = 'FULL' or
2517: l_extraction_type = 'PARTIAL') then

Line 2514: l_last_update_login := FND_GLOBAL.LOGIN_ID;

2510: l_last_update_date := sysdate;
2511: l_last_updated_by := FND_GLOBAL.USER_ID;
2512: l_creation_date := sysdate;
2513: l_created_by := FND_GLOBAL.USER_ID;
2514: l_last_update_login := FND_GLOBAL.LOGIN_ID;
2515:
2516: if (l_extraction_type = 'FULL' or
2517: l_extraction_type = 'PARTIAL') then
2518:

Line 2896: l_last_updated_by := FND_GLOBAL.USER_ID;

2892:
2893: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');
2894:
2895: l_last_update_date := sysdate;
2896: l_last_updated_by := FND_GLOBAL.USER_ID;
2897: l_creation_date := sysdate;
2898: l_created_by := FND_GLOBAL.USER_ID;
2899: l_last_update_login := FND_GLOBAL.LOGIN_ID;
2900:

Line 2898: l_created_by := FND_GLOBAL.USER_ID;

2894:
2895: l_last_update_date := sysdate;
2896: l_last_updated_by := FND_GLOBAL.USER_ID;
2897: l_creation_date := sysdate;
2898: l_created_by := FND_GLOBAL.USER_ID;
2899: l_last_update_login := FND_GLOBAL.LOGIN_ID;
2900:
2901: if (l_extraction_type = 'INCREMENTAL') then
2902:

Line 2899: l_last_update_login := FND_GLOBAL.LOGIN_ID;

2895: l_last_update_date := sysdate;
2896: l_last_updated_by := FND_GLOBAL.USER_ID;
2897: l_creation_date := sysdate;
2898: l_created_by := FND_GLOBAL.USER_ID;
2899: l_last_update_login := FND_GLOBAL.LOGIN_ID;
2900:
2901: if (l_extraction_type = 'INCREMENTAL') then
2902:
2903: insert /*+ append parallel(bal) */ into PJI_FP_TXN_ACCUM bal

Line 3096: l_last_updated_by := FND_GLOBAL.USER_ID;

3092: (PJI_FM_SUM_MAIN.g_process,
3093: 'EXTRACT_COMMITMENTS');
3094:
3095: l_last_update_date := sysdate;
3096: l_last_updated_by := FND_GLOBAL.USER_ID;
3097: l_creation_date := sysdate;
3098: l_created_by := FND_GLOBAL.USER_ID;
3099: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3100:

Line 3098: l_created_by := FND_GLOBAL.USER_ID;

3094:
3095: l_last_update_date := sysdate;
3096: l_last_updated_by := FND_GLOBAL.USER_ID;
3097: l_creation_date := sysdate;
3098: l_created_by := FND_GLOBAL.USER_ID;
3099: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3100:
3101: if ((l_extraction_type = 'FULL' or
3102: l_extraction_type = 'PARTIAL') and

Line 3099: l_last_update_login := FND_GLOBAL.LOGIN_ID;

3095: l_last_update_date := sysdate;
3096: l_last_updated_by := FND_GLOBAL.USER_ID;
3097: l_creation_date := sysdate;
3098: l_created_by := FND_GLOBAL.USER_ID;
3099: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3100:
3101: if ((l_extraction_type = 'FULL' or
3102: l_extraction_type = 'PARTIAL') and
3103: l_extract_commitments = 'Y') then

Line 3274: l_last_updated_by := FND_GLOBAL.USER_ID;

3270: (PJI_FM_SUM_MAIN.g_process,
3271: 'EXTRACT_COMMITMENTS');
3272:
3273: l_last_update_date := sysdate;
3274: l_last_updated_by := FND_GLOBAL.USER_ID;
3275: l_creation_date := sysdate;
3276: l_created_by := FND_GLOBAL.USER_ID;
3277: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3278:

Line 3276: l_created_by := FND_GLOBAL.USER_ID;

3272:
3273: l_last_update_date := sysdate;
3274: l_last_updated_by := FND_GLOBAL.USER_ID;
3275: l_creation_date := sysdate;
3276: l_created_by := FND_GLOBAL.USER_ID;
3277: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3278:
3279: if (l_extraction_type = 'INCREMENTAL' and l_extract_commitments = 'Y') then
3280:

Line 3277: l_last_update_login := FND_GLOBAL.LOGIN_ID;

3273: l_last_update_date := sysdate;
3274: l_last_updated_by := FND_GLOBAL.USER_ID;
3275: l_creation_date := sysdate;
3276: l_created_by := FND_GLOBAL.USER_ID;
3277: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3278:
3279: if (l_extraction_type = 'INCREMENTAL' and l_extract_commitments = 'Y') then
3280:
3281: insert /*+ append parallel(bal) */ into PJI_FP_TXN_ACCUM1 bal

Line 3771: l_last_updated_by := FND_GLOBAL.USER_ID;

3767:
3768: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
3769:
3770: l_last_update_date := sysdate;
3771: l_last_updated_by := FND_GLOBAL.USER_ID;
3772: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3773:
3774: if (l_extraction_type = 'INCREMENTAL') then
3775:

Line 3772: l_last_update_login := FND_GLOBAL.LOGIN_ID;

3768: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
3769:
3770: l_last_update_date := sysdate;
3771: l_last_updated_by := FND_GLOBAL.USER_ID;
3772: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3773:
3774: if (l_extraction_type = 'INCREMENTAL') then
3775:
3776: update PJI_FP_TXN_ACCUM psi

Line 3970: l_last_updated_by := FND_GLOBAL.USER_ID;

3966:
3967: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
3968:
3969: l_last_update_date := sysdate;
3970: l_last_updated_by := FND_GLOBAL.USER_ID;
3971: l_creation_date := sysdate;
3972: l_created_by := FND_GLOBAL.USER_ID;
3973: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3974:

Line 3972: l_created_by := FND_GLOBAL.USER_ID;

3968:
3969: l_last_update_date := sysdate;
3970: l_last_updated_by := FND_GLOBAL.USER_ID;
3971: l_creation_date := sysdate;
3972: l_created_by := FND_GLOBAL.USER_ID;
3973: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3974:
3975: if (l_extraction_type = 'INCREMENTAL') then
3976:

Line 3973: l_last_update_login := FND_GLOBAL.LOGIN_ID;

3969: l_last_update_date := sysdate;
3970: l_last_updated_by := FND_GLOBAL.USER_ID;
3971: l_creation_date := sysdate;
3972: l_created_by := FND_GLOBAL.USER_ID;
3973: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3974:
3975: if (l_extraction_type = 'INCREMENTAL') then
3976:
3977: insert /*+ append parallel(bal_i) */ into PJI_FP_TXN_ACCUM bal_i

Line 4238: l_last_updated_by := FND_GLOBAL.USER_ID;

4234:
4235: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
4236:
4237: l_last_update_date := sysdate;
4238: l_last_updated_by := FND_GLOBAL.USER_ID;
4239: l_creation_date := sysdate;
4240: l_created_by := FND_GLOBAL.USER_ID;
4241: l_last_update_login := FND_GLOBAL.LOGIN_ID;
4242:

Line 4240: l_created_by := FND_GLOBAL.USER_ID;

4236:
4237: l_last_update_date := sysdate;
4238: l_last_updated_by := FND_GLOBAL.USER_ID;
4239: l_creation_date := sysdate;
4240: l_created_by := FND_GLOBAL.USER_ID;
4241: l_last_update_login := FND_GLOBAL.LOGIN_ID;
4242:
4243: if (l_extraction_type = 'INCREMENTAL') then
4244:

Line 4241: l_last_update_login := FND_GLOBAL.LOGIN_ID;

4237: l_last_update_date := sysdate;
4238: l_last_updated_by := FND_GLOBAL.USER_ID;
4239: l_creation_date := sysdate;
4240: l_created_by := FND_GLOBAL.USER_ID;
4241: l_last_update_login := FND_GLOBAL.LOGIN_ID;
4242:
4243: if (l_extraction_type = 'INCREMENTAL') then
4244:
4245: insert /*+ append parallel(bal_i) */ into PJI_FP_TXN_ACCUM1 bal_i