DBA Data[Home] [Help]

APPS.PA_FP_COPY_FROM_PKG dependencies on FND_GLOBAL

Line 700: ,fnd_global.user_id

696: ,l_default_all_curr_flag_tbl(i)
697: ,l_project_currency_flag_tbl(i)
698: ,l_projfunc_currency_flag_tbl(i)
699: ,SYSDATE
700: ,fnd_global.user_id
701: ,SYSDATE
702: ,fnd_global.user_id
703: ,fnd_global.login_id
704: ,l_pc_cost_exchange_rate_tbl(i)

Line 702: ,fnd_global.user_id

698: ,l_projfunc_currency_flag_tbl(i)
699: ,SYSDATE
700: ,fnd_global.user_id
701: ,SYSDATE
702: ,fnd_global.user_id
703: ,fnd_global.login_id
704: ,l_pc_cost_exchange_rate_tbl(i)
705: ,l_pc_rev_exchange_rate_tbl(i)
706: ,l_pfc_cost_exchange_rate_tbl(i)

Line 703: ,fnd_global.login_id

699: ,SYSDATE
700: ,fnd_global.user_id
701: ,SYSDATE
702: ,fnd_global.user_id
703: ,fnd_global.login_id
704: ,l_pc_cost_exchange_rate_tbl(i)
705: ,l_pc_rev_exchange_rate_tbl(i)
706: ,l_pfc_cost_exchange_rate_tbl(i)
707: ,l_pfc_rev_exchange_rate_tbl(i)

Line 1380: --l_baselined_by_person_id := FND_GLOBAL.USER_ID;

1376: -- Stamp employee_id in baseliend_by_person_id of pa_budget_versions table when
1377: -- a budget version is baselined instead of user id.
1378:
1379: l_baselined_date := SYSDATE;
1380: --l_baselined_by_person_id := FND_GLOBAL.USER_ID;
1381:
1382: SELECT employee_id
1383: INTO l_baselined_by_person_id
1384: FROM fnd_user

Line 1385: where user_id = FND_GLOBAL.USER_ID;

1381:
1382: SELECT employee_id
1383: INTO l_baselined_by_person_id
1384: FROM fnd_user
1385: where user_id = FND_GLOBAL.USER_ID;
1386: --End of bug 3858601
1387:
1388: -- Bug # 2615988. The message 'Copy' Should not be suffixed to
1389: -- the version name when the mode is 'B'.

Line 1565: ,fnd_global.user_id

1561: ,pbv.budget_type_code
1562: ,l_version_number --local_variable
1563: ,l_budget_status_code --local_variable
1564: ,sysdate
1565: ,fnd_global.user_id
1566: ,sysdate
1567: ,fnd_global.user_id
1568: ,fnd_global.login_id
1569: ,l_current_flag --local_variable

Line 1567: ,fnd_global.user_id

1563: ,l_budget_status_code --local_variable
1564: ,sysdate
1565: ,fnd_global.user_id
1566: ,sysdate
1567: ,fnd_global.user_id
1568: ,fnd_global.login_id
1569: ,l_current_flag --local_variable
1570: ,DECODE(p_copy_mode, PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_WORKING ,'N',
1571: DECODE (l_version_number,1,'Y','N')) --original_flag

Line 1568: ,fnd_global.login_id

1564: ,sysdate
1565: ,fnd_global.user_id
1566: ,sysdate
1567: ,fnd_global.user_id
1568: ,fnd_global.login_id
1569: ,l_current_flag --local_variable
1570: ,DECODE(p_copy_mode, PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_WORKING ,'N',
1571: DECODE (l_version_number,1,'Y','N')) --original_flag
1572: ,DECODE(p_copy_mode, PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_WORKING ,'N',

Line 1633: ,NULL -- bug 3079891, 01-AUG-03, jwhite: replaced fnd_global.conc_request_id

1629: ,pbv.total_tp_cost_out
1630: ,pbv.total_tp_revenue_in
1631: ,pbv.total_tp_revenue_out
1632: ,1 --record_version_number
1633: ,NULL -- bug 3079891, 01-AUG-03, jwhite: replaced fnd_global.conc_request_id
1634: ,DECODE(l_adj_percentage, 0,
1635: pbv.total_project_raw_cost, NULL)
1636: ,DECODE(l_adj_percentage, 0,
1637: pbv.total_project_burdened_cost, NULL)

Line 1776: ,request_id = NULL --FND_GLOBAL.conc_request_id fix for bug 4463404

1772: ,total_tp_cost_out = l_bv_rec.total_tp_cost_out
1773: ,total_tp_revenue_in = l_bv_rec.total_tp_revenue_in
1774: ,total_tp_revenue_out = l_bv_rec.total_tp_revenue_out
1775: ,record_version_number = record_version_number + 1
1776: ,request_id = NULL --FND_GLOBAL.conc_request_id fix for bug 4463404
1777: ,total_project_raw_cost = DECODE(l_adj_percentage, 0, DECODE(l_cost_flag,'Y',l_bv_rec.total_project_raw_cost,NULL), NULL)
1778: ,total_project_burdened_cost = DECODE(l_adj_percentage, 0, DECODE(l_cost_flag,'Y',l_bv_rec.total_project_burdened_cost,NULL), NULL)
1779: ,total_project_revenue = DECODE(l_adj_percentage, 0, DECODE(l_revenue_flag,'Y',l_bv_rec.total_project_revenue,NULL), NULL)
1780: ,object_type_code = l_bv_rec.object_type_code

Line 1821: X_created_by => FND_GLOBAL.USER_ID,

1817: (X_from_entity_name => 'PA_BUDGET_VERSIONS',
1818: X_from_pk1_value => to_char(p_source_version_id),
1819: X_to_entity_name => 'PA_BUDGET_VERSIONS',
1820: X_to_pk1_value => px_target_version_id,
1821: X_created_by => FND_GLOBAL.USER_ID,
1822: X_last_update_login => FND_GLOBAL.LOGIN_ID,
1823: X_program_application_id => FND_GLOBAL.PROG_APPL_ID);
1824:
1825:

Line 1822: X_last_update_login => FND_GLOBAL.LOGIN_ID,

1818: X_from_pk1_value => to_char(p_source_version_id),
1819: X_to_entity_name => 'PA_BUDGET_VERSIONS',
1820: X_to_pk1_value => px_target_version_id,
1821: X_created_by => FND_GLOBAL.USER_ID,
1822: X_last_update_login => FND_GLOBAL.LOGIN_ID,
1823: X_program_application_id => FND_GLOBAL.PROG_APPL_ID);
1824:
1825:
1826: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 1823: X_program_application_id => FND_GLOBAL.PROG_APPL_ID);

1819: X_to_entity_name => 'PA_BUDGET_VERSIONS',
1820: X_to_pk1_value => px_target_version_id,
1821: X_created_by => FND_GLOBAL.USER_ID,
1822: X_last_update_login => FND_GLOBAL.LOGIN_ID,
1823: X_program_application_id => FND_GLOBAL.PROG_APPL_ID);
1824:
1825:
1826: IF P_PA_DEBUG_MODE = 'Y' THEN
1827: pa_debug.g_err_stage := 'Exiting copy_budget_version';

Line 2516: ,fnd_global.user_id

2512: ,l_target_project_id
2513: ,pfrmt.target_task_id
2514: ,pfrmt.system_reference4 -- Bug 3615617 resource_list_member_id
2515: ,sysdate
2516: ,fnd_global.user_id
2517: ,sysdate
2518: ,fnd_global.user_id
2519: ,fnd_global.login_id
2520: ,pra.unit_of_measure

Line 2518: ,fnd_global.user_id

2514: ,pfrmt.system_reference4 -- Bug 3615617 resource_list_member_id
2515: ,sysdate
2516: ,fnd_global.user_id
2517: ,sysdate
2518: ,fnd_global.user_id
2519: ,fnd_global.login_id
2520: ,pra.unit_of_measure
2521: ,pra.track_as_labor_flag
2522: ,DECODE(l_adj_percentage,0,DECODE(l_revenue_flag,'Y',total_plan_revenue,NULL),NULL)

Line 2519: ,fnd_global.login_id

2515: ,sysdate
2516: ,fnd_global.user_id
2517: ,sysdate
2518: ,fnd_global.user_id
2519: ,fnd_global.login_id
2520: ,pra.unit_of_measure
2521: ,pra.track_as_labor_flag
2522: ,DECODE(l_adj_percentage,0,DECODE(l_revenue_flag,'Y',total_plan_revenue,NULL),NULL)
2523: ,DECODE(l_adj_percentage,0,DECODE(l_cost_flag,'Y',total_plan_raw_cost,NULL),NULL)

Line 2796: ,fnd_global.user_id

2792: ,l_target_project_id
2793: ,pfrmt.target_task_id
2794: ,pfrmt.system_reference4 -- Bug 3615617 resource_list_member_id
2795: ,sysdate
2796: ,fnd_global.user_id
2797: ,sysdate
2798: ,fnd_global.user_id
2799: ,fnd_global.login_id
2800: ,pra.unit_of_measure

Line 2798: ,fnd_global.user_id

2794: ,pfrmt.system_reference4 -- Bug 3615617 resource_list_member_id
2795: ,sysdate
2796: ,fnd_global.user_id
2797: ,sysdate
2798: ,fnd_global.user_id
2799: ,fnd_global.login_id
2800: ,pra.unit_of_measure
2801: ,pra.track_as_labor_flag
2802: ,DECODE(l_adj_percentage,0,DECODE(l_revenue_flag,'Y',total_plan_revenue,NULL),NULL)

Line 2799: ,fnd_global.login_id

2795: ,sysdate
2796: ,fnd_global.user_id
2797: ,sysdate
2798: ,fnd_global.user_id
2799: ,fnd_global.login_id
2800: ,pra.unit_of_measure
2801: ,pra.track_as_labor_flag
2802: ,DECODE(l_adj_percentage,0,DECODE(l_revenue_flag,'Y',total_plan_revenue,NULL),NULL)
2803: ,DECODE(l_adj_percentage,0,DECODE(l_cost_flag,'Y',total_plan_raw_cost,NULL),NULL)

Line 3064: ,fnd_global.user_id

3060: ,l_target_project_id
3061: ,pra.task_id
3062: ,pra.resource_list_member_id
3063: ,sysdate
3064: ,fnd_global.user_id
3065: ,sysdate
3066: ,fnd_global.user_id
3067: ,fnd_global.login_id
3068: ,pra.unit_of_measure

Line 3066: ,fnd_global.user_id

3062: ,pra.resource_list_member_id
3063: ,sysdate
3064: ,fnd_global.user_id
3065: ,sysdate
3066: ,fnd_global.user_id
3067: ,fnd_global.login_id
3068: ,pra.unit_of_measure
3069: ,pra.track_as_labor_flag
3070: ,DECODE(l_adj_percentage,0,DECODE(l_revenue_flag,'Y',total_plan_revenue,NULL),NULL)

Line 3067: ,fnd_global.login_id

3063: ,sysdate
3064: ,fnd_global.user_id
3065: ,sysdate
3066: ,fnd_global.user_id
3067: ,fnd_global.login_id
3068: ,pra.unit_of_measure
3069: ,pra.track_as_labor_flag
3070: ,DECODE(l_adj_percentage,0,DECODE(l_revenue_flag,'Y',total_plan_revenue,NULL),NULL)
3071: ,DECODE(l_adj_percentage,0,DECODE(l_cost_flag,'Y',total_plan_raw_cost,NULL),NULL)

Line 3326: ,fnd_global.user_id

3322: ,l_target_project_id
3323: ,pra.task_id
3324: ,prlmt.resource_list_member_id
3325: ,sysdate
3326: ,fnd_global.user_id
3327: ,sysdate
3328: ,fnd_global.user_id
3329: ,fnd_global.login_id
3330: ,pra.unit_of_measure

Line 3328: ,fnd_global.user_id

3324: ,prlmt.resource_list_member_id
3325: ,sysdate
3326: ,fnd_global.user_id
3327: ,sysdate
3328: ,fnd_global.user_id
3329: ,fnd_global.login_id
3330: ,pra.unit_of_measure
3331: ,pra.track_as_labor_flag
3332: ,DECODE(l_adj_percentage,0,DECODE(l_revenue_flag,'Y',total_plan_revenue,NULL),NULL)

Line 3329: ,fnd_global.login_id

3325: ,sysdate
3326: ,fnd_global.user_id
3327: ,sysdate
3328: ,fnd_global.user_id
3329: ,fnd_global.login_id
3330: ,pra.unit_of_measure
3331: ,pra.track_as_labor_flag
3332: ,DECODE(l_adj_percentage,0,DECODE(l_revenue_flag,'Y',total_plan_revenue,NULL),NULL)
3333: ,DECODE(l_adj_percentage,0,DECODE(l_cost_flag,'Y',total_plan_raw_cost,NULL),NULL)

Line 3596: ,fnd_global.user_id

3592: ,l_target_project_id
3593: ,pelm.target_task_id
3594: ,prlmt.resource_list_member_id
3595: ,sysdate
3596: ,fnd_global.user_id
3597: ,sysdate
3598: ,fnd_global.user_id
3599: ,fnd_global.login_id
3600: ,pra.unit_of_measure

Line 3598: ,fnd_global.user_id

3594: ,prlmt.resource_list_member_id
3595: ,sysdate
3596: ,fnd_global.user_id
3597: ,sysdate
3598: ,fnd_global.user_id
3599: ,fnd_global.login_id
3600: ,pra.unit_of_measure
3601: ,pra.track_as_labor_flag
3602: ,DECODE(l_adj_percentage,0,DECODE(l_revenue_flag,'Y',total_plan_revenue,NULL),NULL)

Line 3599: ,fnd_global.login_id

3595: ,sysdate
3596: ,fnd_global.user_id
3597: ,sysdate
3598: ,fnd_global.user_id
3599: ,fnd_global.login_id
3600: ,pra.unit_of_measure
3601: ,pra.track_as_labor_flag
3602: ,DECODE(l_adj_percentage,0,DECODE(l_revenue_flag,'Y',total_plan_revenue,NULL),NULL)
3603: ,DECODE(l_adj_percentage,0,DECODE(l_cost_flag,'Y',total_plan_raw_cost,NULL),NULL)

Line 3871: ,fnd_global.user_id

3867: ,l_target_project_id
3868: ,pelm.target_task_id
3869: ,pra.resource_list_member_id
3870: ,sysdate
3871: ,fnd_global.user_id
3872: ,sysdate
3873: ,fnd_global.user_id
3874: ,fnd_global.login_id
3875: ,pra.unit_of_measure

Line 3873: ,fnd_global.user_id

3869: ,pra.resource_list_member_id
3870: ,sysdate
3871: ,fnd_global.user_id
3872: ,sysdate
3873: ,fnd_global.user_id
3874: ,fnd_global.login_id
3875: ,pra.unit_of_measure
3876: ,pra.track_as_labor_flag
3877: ,DECODE(l_adj_percentage,0,DECODE(l_revenue_flag,'Y',total_plan_revenue,NULL),NULL)

Line 3874: ,fnd_global.login_id

3870: ,sysdate
3871: ,fnd_global.user_id
3872: ,sysdate
3873: ,fnd_global.user_id
3874: ,fnd_global.login_id
3875: ,pra.unit_of_measure
3876: ,pra.track_as_labor_flag
3877: ,DECODE(l_adj_percentage,0,DECODE(l_revenue_flag,'Y',total_plan_revenue,NULL),NULL)
3878: ,DECODE(l_adj_percentage,0,DECODE(l_cost_flag,'Y',total_plan_raw_cost,NULL),NULL)

Line 5012: ,fnd_global.user_id

5008: ,p_target_plan_version_id /* FPB2 */
5009: ,pra.resource_assignment_id
5010: ,pbl.start_date
5011: ,sysdate
5012: ,fnd_global.user_id
5013: ,sysdate
5014: ,fnd_global.user_id
5015: ,fnd_global.login_id
5016: ,pbl.end_date

Line 5014: ,fnd_global.user_id

5010: ,pbl.start_date
5011: ,sysdate
5012: ,fnd_global.user_id
5013: ,sysdate
5014: ,fnd_global.user_id
5015: ,fnd_global.login_id
5016: ,pbl.end_date
5017: ,pbl.period_name
5018: ,pbl.quantity

Line 5015: ,fnd_global.login_id

5011: ,sysdate
5012: ,fnd_global.user_id
5013: ,sysdate
5014: ,fnd_global.user_id
5015: ,fnd_global.login_id
5016: ,pbl.end_date
5017: ,pbl.period_name
5018: ,pbl.quantity
5019: ,pbl.display_quantity --IPM Arch Enhancement Bug 4865563.

Line 5054: ,fnd_global.conc_request_id

5050: ,other_rejection_code
5051: ,code_combination_id
5052: ,ccid_gen_status_code
5053: ,ccid_gen_rej_message
5054: ,fnd_global.conc_request_id
5055: ,borrowed_revenue
5056: ,tp_revenue_in
5057: ,tp_revenue_out
5058: ,revenue_adj

Line 5526: ,fnd_global.user_id

5522: ,period_amount50
5523: ,period_amount51
5524: ,period_amount52
5525: ,sysdate
5526: ,fnd_global.user_id
5527: ,sysdate
5528: ,fnd_global.user_id
5529: ,fnd_global.login_id
5530: ,pfrmt.parent_assignment_id --parent_assignment_id

Line 5528: ,fnd_global.user_id

5524: ,period_amount52
5525: ,sysdate
5526: ,fnd_global.user_id
5527: ,sysdate
5528: ,fnd_global.user_id
5529: ,fnd_global.login_id
5530: ,pfrmt.parent_assignment_id --parent_assignment_id
5531: FROM PA_PROJ_PERIODS_DENORM pppd
5532: ,PA_FP_RA_MAP_TMP pfrmt

Line 5529: ,fnd_global.login_id

5525: ,sysdate
5526: ,fnd_global.user_id
5527: ,sysdate
5528: ,fnd_global.user_id
5529: ,fnd_global.login_id
5530: ,pfrmt.parent_assignment_id --parent_assignment_id
5531: FROM PA_PROJ_PERIODS_DENORM pppd
5532: ,PA_FP_RA_MAP_TMP pfrmt
5533: WHERE budget_version_id = p_source_plan_version_id

Line 6525: ,x_created_by => FND_GLOBAL.USER_ID

6521: ,x_to_pk2_value => NULL
6522: ,x_to_pk3_value => NULL
6523: ,x_to_pk4_value => NULL
6524: ,x_to_pk5_value => NULL
6525: ,x_created_by => FND_GLOBAL.USER_ID
6526: ,x_last_update_login => FND_GLOBAL.LOGIN_ID
6527: ,x_program_application_id => FND_GLOBAL.PROG_APPL_ID()
6528: ,x_program_id => NULL
6529: ,x_request_id => NULL

Line 6526: ,x_last_update_login => FND_GLOBAL.LOGIN_ID

6522: ,x_to_pk3_value => NULL
6523: ,x_to_pk4_value => NULL
6524: ,x_to_pk5_value => NULL
6525: ,x_created_by => FND_GLOBAL.USER_ID
6526: ,x_last_update_login => FND_GLOBAL.LOGIN_ID
6527: ,x_program_application_id => FND_GLOBAL.PROG_APPL_ID()
6528: ,x_program_id => NULL
6529: ,x_request_id => NULL
6530: ,x_automatically_added_flag => NULL);

Line 6527: ,x_program_application_id => FND_GLOBAL.PROG_APPL_ID()

6523: ,x_to_pk4_value => NULL
6524: ,x_to_pk5_value => NULL
6525: ,x_created_by => FND_GLOBAL.USER_ID
6526: ,x_last_update_login => FND_GLOBAL.LOGIN_ID
6527: ,x_program_application_id => FND_GLOBAL.PROG_APPL_ID()
6528: ,x_program_id => NULL
6529: ,x_request_id => NULL
6530: ,x_automatically_added_flag => NULL);
6531: END OF BUG FIX 2955827 */

Line 7658: ,fnd_global.user_id

7654: ,DECODE(l_target_time_phased_code,
7655: PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_N,nvl(l_target_proj_start_date , pbl.start_date + l_shift_days), --Bug 4739375,l_target_proj_start_date.--bug 3841942 l_target_proj_start_date,
7656: pbl.start_date ) -- start_date
7657: ,sysdate
7658: ,fnd_global.user_id
7659: ,sysdate
7660: ,fnd_global.user_id
7661: ,fnd_global.login_id
7662: -- Commented by skkoppul for bug 7238582 and replaced this with the decode statement below

Line 7660: ,fnd_global.user_id

7656: pbl.start_date ) -- start_date
7657: ,sysdate
7658: ,fnd_global.user_id
7659: ,sysdate
7660: ,fnd_global.user_id
7661: ,fnd_global.login_id
7662: -- Commented by skkoppul for bug 7238582 and replaced this with the decode statement below
7663: -- ,DECODE(l_target_time_phased_code,
7664: -- PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_N, nvl(l_target_proj_completion_date, pbl.end_date + l_shift_days), --Bug 4739375,l_target_proj_completion_date,--bug 3841942 l_target_proj_completion_date,

Line 7661: ,fnd_global.login_id

7657: ,sysdate
7658: ,fnd_global.user_id
7659: ,sysdate
7660: ,fnd_global.user_id
7661: ,fnd_global.login_id
7662: -- Commented by skkoppul for bug 7238582 and replaced this with the decode statement below
7663: -- ,DECODE(l_target_time_phased_code,
7664: -- PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_N, nvl(l_target_proj_completion_date, pbl.end_date + l_shift_days), --Bug 4739375,l_target_proj_completion_date,--bug 3841942 l_target_proj_completion_date,
7665: -- pbl.end_date ) -- end_date

Line 7714: ,fnd_global.conc_request_id

7710: ,other_rejection_code
7711: ,code_combination_id
7712: ,ccid_gen_status_code
7713: ,ccid_gen_rej_message
7714: ,fnd_global.conc_request_id
7715: ,borrowed_revenue
7716: ,tp_revenue_in
7717: ,tp_revenue_out
7718: ,revenue_adj

Line 7973: ,fnd_global.user_id

7969: ,p_target_plan_version_id /* FPB2 */
7970: ,pra.resource_assignment_id
7971: ,pptmp.start_date
7972: ,sysdate
7973: ,fnd_global.user_id
7974: ,sysdate
7975: ,fnd_global.user_id
7976: ,fnd_global.login_id
7977: ,pptmp.end_date

Line 7975: ,fnd_global.user_id

7971: ,pptmp.start_date
7972: ,sysdate
7973: ,fnd_global.user_id
7974: ,sysdate
7975: ,fnd_global.user_id
7976: ,fnd_global.login_id
7977: ,pptmp.end_date
7978: ,pptmp.period_name
7979: ,pbl.quantity

Line 7976: ,fnd_global.login_id

7972: ,sysdate
7973: ,fnd_global.user_id
7974: ,sysdate
7975: ,fnd_global.user_id
7976: ,fnd_global.login_id
7977: ,pptmp.end_date
7978: ,pptmp.period_name
7979: ,pbl.quantity
7980: ,pbl.display_quantity --IPM Arch Enhancement Bug 4865563

Line 8015: ,fnd_global.conc_request_id

8011: ,other_rejection_code
8012: ,code_combination_id
8013: ,ccid_gen_status_code
8014: ,ccid_gen_rej_message
8015: ,fnd_global.conc_request_id
8016: ,borrowed_revenue
8017: ,tp_revenue_in
8018: ,tp_revenue_out
8019: ,revenue_adj

Line 9846: ,fnd_global.user_id -- last_updated_by

9842: ,p_target_plan_version_id
9843: ,pra.resource_assignment_id
9844: ,rec_group_source_budget_lines.start_date
9845: ,sysdate -- last_update_date
9846: ,fnd_global.user_id -- last_updated_by
9847: ,sysdate -- creation_date
9848: ,fnd_global.user_id -- created_by
9849: ,fnd_global.login_id -- last_update_login
9850: ,l_end_dateTab(l_ref)

Line 9848: ,fnd_global.user_id -- created_by

9844: ,rec_group_source_budget_lines.start_date
9845: ,sysdate -- last_update_date
9846: ,fnd_global.user_id -- last_updated_by
9847: ,sysdate -- creation_date
9848: ,fnd_global.user_id -- created_by
9849: ,fnd_global.login_id -- last_update_login
9850: ,l_end_dateTab(l_ref)
9851: ,l_period_nameTab(l_ref)
9852: ,l_quantity_tot

Line 9849: ,fnd_global.login_id -- last_update_login

9845: ,sysdate -- last_update_date
9846: ,fnd_global.user_id -- last_updated_by
9847: ,sysdate -- creation_date
9848: ,fnd_global.user_id -- created_by
9849: ,fnd_global.login_id -- last_update_login
9850: ,l_end_dateTab(l_ref)
9851: ,l_period_nameTab(l_ref)
9852: ,l_quantity_tot
9853: ,DECODE(l_adj_percentage,0,DECODE(l_cost_flag,'Y', l_raw_cost_tot,NULL),NULL) -- raw_cost

Line 10258: ,last_updated_by = FND_GLOBAL.user_id

10254: ,labor_quantity = 0
10255: ,equipment_quantity = 0
10256: */
10257: ,last_update_date = SYSDATE
10258: ,last_updated_by = FND_GLOBAL.user_id
10259: ,last_update_login = FND_GLOBAL.login_id
10260: ,record_version_number = record_version_number + 1
10261: WHERE budget_version_id = p_wp_version_id;
10262:

Line 10259: ,last_update_login = FND_GLOBAL.login_id

10255: ,equipment_quantity = 0
10256: */
10257: ,last_update_date = SYSDATE
10258: ,last_updated_by = FND_GLOBAL.user_id
10259: ,last_update_login = FND_GLOBAL.login_id
10260: ,record_version_number = record_version_number + 1
10261: WHERE budget_version_id = p_wp_version_id;
10262:
10263: -- Update pa_proj_fp_options entity

Line 10289: ,last_updated_by = FND_GLOBAL.user_id

10285: ,cost_burden_rate_sch_id = parent_plan_type_rec.cost_burden_rate_sch_id
10286: ,rbs_version_id = parent_plan_type_rec.rbs_version_id -- Bug 3725414
10287: ,record_version_number = record_version_number + 1
10288: ,last_update_date = SYSDATE
10289: ,last_updated_by = FND_GLOBAL.user_id
10290: ,last_update_login = FND_GLOBAL.login_id
10291: WHERE proj_fp_options_id = wp_version_options_rec.proj_fp_options_id;
10292:
10293: -- Copy MC currencies from plan type

Line 10290: ,last_update_login = FND_GLOBAL.login_id

10286: ,rbs_version_id = parent_plan_type_rec.rbs_version_id -- Bug 3725414
10287: ,record_version_number = record_version_number + 1
10288: ,last_update_date = SYSDATE
10289: ,last_updated_by = FND_GLOBAL.user_id
10290: ,last_update_login = FND_GLOBAL.login_id
10291: WHERE proj_fp_options_id = wp_version_options_rec.proj_fp_options_id;
10292:
10293: -- Copy MC currencies from plan type
10294:

Line 10412: ,last_updated_by = FND_GLOBAL.user_id

10408: SET rbs_element_id = l_rbs_element_id_tbl(i)
10409: ,txn_accum_header_id = l_txn_accum_header_id_tbl(i)
10410: ,record_version_number = record_version_number + 1
10411: ,last_update_date = SYSDATE
10412: ,last_updated_by = FND_GLOBAL.user_id
10413: ,last_update_login = FND_GLOBAL.login_id
10414: WHERE budget_version_id = p_wp_version_id
10415: AND resource_assignment_id = l_txn_source_id_tbl(i);
10416: END IF;

Line 10413: ,last_update_login = FND_GLOBAL.login_id

10409: ,txn_accum_header_id = l_txn_accum_header_id_tbl(i)
10410: ,record_version_number = record_version_number + 1
10411: ,last_update_date = SYSDATE
10412: ,last_updated_by = FND_GLOBAL.user_id
10413: ,last_update_login = FND_GLOBAL.login_id
10414: WHERE budget_version_id = p_wp_version_id
10415: AND resource_assignment_id = l_txn_source_id_tbl(i);
10416: END IF;
10417: