eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 2515: ,fnd_global.user_id

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

Line 2517: ,fnd_global.user_id

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

Line 2518: ,fnd_global.login_id

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

Line 2793: ,fnd_global.user_id

2789: ,l_target_project_id
2790: ,pfrmt.target_task_id
2791: ,pfrmt.system_reference4 -- Bug 3615617 resource_list_member_id
2792: ,sysdate
2793: ,fnd_global.user_id
2794: ,sysdate
2795: ,fnd_global.user_id
2796: ,fnd_global.login_id
2797: ,pra.unit_of_measure

Line 2795: ,fnd_global.user_id

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

Line 2796: ,fnd_global.login_id

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

Line 3059: ,fnd_global.user_id

3055: ,l_target_project_id
3056: ,pra.task_id
3057: ,pra.resource_list_member_id
3058: ,sysdate
3059: ,fnd_global.user_id
3060: ,sysdate
3061: ,fnd_global.user_id
3062: ,fnd_global.login_id
3063: ,pra.unit_of_measure

Line 3061: ,fnd_global.user_id

3057: ,pra.resource_list_member_id
3058: ,sysdate
3059: ,fnd_global.user_id
3060: ,sysdate
3061: ,fnd_global.user_id
3062: ,fnd_global.login_id
3063: ,pra.unit_of_measure
3064: ,pra.track_as_labor_flag
3065: ,DECODE(l_adj_percentage,0,DECODE(l_revenue_flag,'Y',total_plan_revenue,NULL),NULL)

Line 3062: ,fnd_global.login_id

3058: ,sysdate
3059: ,fnd_global.user_id
3060: ,sysdate
3061: ,fnd_global.user_id
3062: ,fnd_global.login_id
3063: ,pra.unit_of_measure
3064: ,pra.track_as_labor_flag
3065: ,DECODE(l_adj_percentage,0,DECODE(l_revenue_flag,'Y',total_plan_revenue,NULL),NULL)
3066: ,DECODE(l_adj_percentage,0,DECODE(l_cost_flag,'Y',total_plan_raw_cost,NULL),NULL)

Line 3319: ,fnd_global.user_id

3315: ,l_target_project_id
3316: ,pra.task_id
3317: ,prlmt.resource_list_member_id
3318: ,sysdate
3319: ,fnd_global.user_id
3320: ,sysdate
3321: ,fnd_global.user_id
3322: ,fnd_global.login_id
3323: ,pra.unit_of_measure

Line 3321: ,fnd_global.user_id

3317: ,prlmt.resource_list_member_id
3318: ,sysdate
3319: ,fnd_global.user_id
3320: ,sysdate
3321: ,fnd_global.user_id
3322: ,fnd_global.login_id
3323: ,pra.unit_of_measure
3324: ,pra.track_as_labor_flag
3325: ,DECODE(l_adj_percentage,0,DECODE(l_revenue_flag,'Y',total_plan_revenue,NULL),NULL)

Line 3322: ,fnd_global.login_id

3318: ,sysdate
3319: ,fnd_global.user_id
3320: ,sysdate
3321: ,fnd_global.user_id
3322: ,fnd_global.login_id
3323: ,pra.unit_of_measure
3324: ,pra.track_as_labor_flag
3325: ,DECODE(l_adj_percentage,0,DECODE(l_revenue_flag,'Y',total_plan_revenue,NULL),NULL)
3326: ,DECODE(l_adj_percentage,0,DECODE(l_cost_flag,'Y',total_plan_raw_cost,NULL),NULL)

Line 3587: ,fnd_global.user_id

3583: ,l_target_project_id
3584: ,pelm.target_task_id
3585: ,prlmt.resource_list_member_id
3586: ,sysdate
3587: ,fnd_global.user_id
3588: ,sysdate
3589: ,fnd_global.user_id
3590: ,fnd_global.login_id
3591: ,pra.unit_of_measure

Line 3589: ,fnd_global.user_id

3585: ,prlmt.resource_list_member_id
3586: ,sysdate
3587: ,fnd_global.user_id
3588: ,sysdate
3589: ,fnd_global.user_id
3590: ,fnd_global.login_id
3591: ,pra.unit_of_measure
3592: ,pra.track_as_labor_flag
3593: ,DECODE(l_adj_percentage,0,DECODE(l_revenue_flag,'Y',total_plan_revenue,NULL),NULL)

Line 3590: ,fnd_global.login_id

3586: ,sysdate
3587: ,fnd_global.user_id
3588: ,sysdate
3589: ,fnd_global.user_id
3590: ,fnd_global.login_id
3591: ,pra.unit_of_measure
3592: ,pra.track_as_labor_flag
3593: ,DECODE(l_adj_percentage,0,DECODE(l_revenue_flag,'Y',total_plan_revenue,NULL),NULL)
3594: ,DECODE(l_adj_percentage,0,DECODE(l_cost_flag,'Y',total_plan_raw_cost,NULL),NULL)

Line 3860: ,fnd_global.user_id

3856: ,l_target_project_id
3857: ,pelm.target_task_id
3858: ,pra.resource_list_member_id
3859: ,sysdate
3860: ,fnd_global.user_id
3861: ,sysdate
3862: ,fnd_global.user_id
3863: ,fnd_global.login_id
3864: ,pra.unit_of_measure

Line 3862: ,fnd_global.user_id

3858: ,pra.resource_list_member_id
3859: ,sysdate
3860: ,fnd_global.user_id
3861: ,sysdate
3862: ,fnd_global.user_id
3863: ,fnd_global.login_id
3864: ,pra.unit_of_measure
3865: ,pra.track_as_labor_flag
3866: ,DECODE(l_adj_percentage,0,DECODE(l_revenue_flag,'Y',total_plan_revenue,NULL),NULL)

Line 3863: ,fnd_global.login_id

3859: ,sysdate
3860: ,fnd_global.user_id
3861: ,sysdate
3862: ,fnd_global.user_id
3863: ,fnd_global.login_id
3864: ,pra.unit_of_measure
3865: ,pra.track_as_labor_flag
3866: ,DECODE(l_adj_percentage,0,DECODE(l_revenue_flag,'Y',total_plan_revenue,NULL),NULL)
3867: ,DECODE(l_adj_percentage,0,DECODE(l_cost_flag,'Y',total_plan_raw_cost,NULL),NULL)

Line 5000: ,fnd_global.user_id

4996: ,p_target_plan_version_id /* FPB2 */
4997: ,pra.resource_assignment_id
4998: ,pbl.start_date
4999: ,sysdate
5000: ,fnd_global.user_id
5001: ,sysdate
5002: ,fnd_global.user_id
5003: ,fnd_global.login_id
5004: ,pbl.end_date

Line 5002: ,fnd_global.user_id

4998: ,pbl.start_date
4999: ,sysdate
5000: ,fnd_global.user_id
5001: ,sysdate
5002: ,fnd_global.user_id
5003: ,fnd_global.login_id
5004: ,pbl.end_date
5005: ,pbl.period_name
5006: ,pbl.quantity

Line 5003: ,fnd_global.login_id

4999: ,sysdate
5000: ,fnd_global.user_id
5001: ,sysdate
5002: ,fnd_global.user_id
5003: ,fnd_global.login_id
5004: ,pbl.end_date
5005: ,pbl.period_name
5006: ,pbl.quantity
5007: ,pbl.display_quantity --IPM Arch Enhancement Bug 4865563.

Line 5042: ,fnd_global.conc_request_id

5038: ,other_rejection_code
5039: ,code_combination_id
5040: ,ccid_gen_status_code
5041: ,ccid_gen_rej_message
5042: ,fnd_global.conc_request_id
5043: ,borrowed_revenue
5044: ,tp_revenue_in
5045: ,tp_revenue_out
5046: ,revenue_adj

Line 5514: ,fnd_global.user_id

5510: ,period_amount50
5511: ,period_amount51
5512: ,period_amount52
5513: ,sysdate
5514: ,fnd_global.user_id
5515: ,sysdate
5516: ,fnd_global.user_id
5517: ,fnd_global.login_id
5518: ,pfrmt.parent_assignment_id --parent_assignment_id

Line 5516: ,fnd_global.user_id

5512: ,period_amount52
5513: ,sysdate
5514: ,fnd_global.user_id
5515: ,sysdate
5516: ,fnd_global.user_id
5517: ,fnd_global.login_id
5518: ,pfrmt.parent_assignment_id --parent_assignment_id
5519: FROM PA_PROJ_PERIODS_DENORM pppd
5520: ,PA_FP_RA_MAP_TMP pfrmt

Line 5517: ,fnd_global.login_id

5513: ,sysdate
5514: ,fnd_global.user_id
5515: ,sysdate
5516: ,fnd_global.user_id
5517: ,fnd_global.login_id
5518: ,pfrmt.parent_assignment_id --parent_assignment_id
5519: FROM PA_PROJ_PERIODS_DENORM pppd
5520: ,PA_FP_RA_MAP_TMP pfrmt
5521: WHERE budget_version_id = p_source_plan_version_id

Line 6508: ,x_created_by => FND_GLOBAL.USER_ID

6504: ,x_to_pk2_value => NULL
6505: ,x_to_pk3_value => NULL
6506: ,x_to_pk4_value => NULL
6507: ,x_to_pk5_value => NULL
6508: ,x_created_by => FND_GLOBAL.USER_ID
6509: ,x_last_update_login => FND_GLOBAL.LOGIN_ID
6510: ,x_program_application_id => FND_GLOBAL.PROG_APPL_ID()
6511: ,x_program_id => NULL
6512: ,x_request_id => NULL

Line 6509: ,x_last_update_login => FND_GLOBAL.LOGIN_ID

6505: ,x_to_pk3_value => NULL
6506: ,x_to_pk4_value => NULL
6507: ,x_to_pk5_value => NULL
6508: ,x_created_by => FND_GLOBAL.USER_ID
6509: ,x_last_update_login => FND_GLOBAL.LOGIN_ID
6510: ,x_program_application_id => FND_GLOBAL.PROG_APPL_ID()
6511: ,x_program_id => NULL
6512: ,x_request_id => NULL
6513: ,x_automatically_added_flag => NULL);

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

6506: ,x_to_pk4_value => NULL
6507: ,x_to_pk5_value => NULL
6508: ,x_created_by => FND_GLOBAL.USER_ID
6509: ,x_last_update_login => FND_GLOBAL.LOGIN_ID
6510: ,x_program_application_id => FND_GLOBAL.PROG_APPL_ID()
6511: ,x_program_id => NULL
6512: ,x_request_id => NULL
6513: ,x_automatically_added_flag => NULL);
6514: END OF BUG FIX 2955827 */

Line 7639: ,fnd_global.user_id

7635: ,DECODE(l_target_time_phased_code,
7636: 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,
7637: pbl.start_date ) -- start_date
7638: ,sysdate
7639: ,fnd_global.user_id
7640: ,sysdate
7641: ,fnd_global.user_id
7642: ,fnd_global.login_id
7643: -- Commented by skkoppul for bug 7238582 and replaced this with the decode statement below

Line 7641: ,fnd_global.user_id

7637: pbl.start_date ) -- start_date
7638: ,sysdate
7639: ,fnd_global.user_id
7640: ,sysdate
7641: ,fnd_global.user_id
7642: ,fnd_global.login_id
7643: -- Commented by skkoppul for bug 7238582 and replaced this with the decode statement below
7644: -- ,DECODE(l_target_time_phased_code,
7645: -- 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 7642: ,fnd_global.login_id

7638: ,sysdate
7639: ,fnd_global.user_id
7640: ,sysdate
7641: ,fnd_global.user_id
7642: ,fnd_global.login_id
7643: -- Commented by skkoppul for bug 7238582 and replaced this with the decode statement below
7644: -- ,DECODE(l_target_time_phased_code,
7645: -- 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,
7646: -- pbl.end_date ) -- end_date

Line 7695: ,fnd_global.conc_request_id

7691: ,other_rejection_code
7692: ,code_combination_id
7693: ,ccid_gen_status_code
7694: ,ccid_gen_rej_message
7695: ,fnd_global.conc_request_id
7696: ,borrowed_revenue
7697: ,tp_revenue_in
7698: ,tp_revenue_out
7699: ,revenue_adj

Line 7946: ,fnd_global.user_id

7942: ,p_target_plan_version_id /* FPB2 */
7943: ,pra.resource_assignment_id
7944: ,pptmp.start_date
7945: ,sysdate
7946: ,fnd_global.user_id
7947: ,sysdate
7948: ,fnd_global.user_id
7949: ,fnd_global.login_id
7950: ,pptmp.end_date

Line 7948: ,fnd_global.user_id

7944: ,pptmp.start_date
7945: ,sysdate
7946: ,fnd_global.user_id
7947: ,sysdate
7948: ,fnd_global.user_id
7949: ,fnd_global.login_id
7950: ,pptmp.end_date
7951: ,pptmp.period_name
7952: ,pbl.quantity

Line 7949: ,fnd_global.login_id

7945: ,sysdate
7946: ,fnd_global.user_id
7947: ,sysdate
7948: ,fnd_global.user_id
7949: ,fnd_global.login_id
7950: ,pptmp.end_date
7951: ,pptmp.period_name
7952: ,pbl.quantity
7953: ,pbl.display_quantity --IPM Arch Enhancement Bug 4865563

Line 7988: ,fnd_global.conc_request_id

7984: ,other_rejection_code
7985: ,code_combination_id
7986: ,ccid_gen_status_code
7987: ,ccid_gen_rej_message
7988: ,fnd_global.conc_request_id
7989: ,borrowed_revenue
7990: ,tp_revenue_in
7991: ,tp_revenue_out
7992: ,revenue_adj

Line 9819: ,fnd_global.user_id -- last_updated_by

9815: ,p_target_plan_version_id
9816: ,pra.resource_assignment_id
9817: ,rec_group_source_budget_lines.start_date
9818: ,sysdate -- last_update_date
9819: ,fnd_global.user_id -- last_updated_by
9820: ,sysdate -- creation_date
9821: ,fnd_global.user_id -- created_by
9822: ,fnd_global.login_id -- last_update_login
9823: ,l_end_dateTab(l_ref)

Line 9821: ,fnd_global.user_id -- created_by

9817: ,rec_group_source_budget_lines.start_date
9818: ,sysdate -- last_update_date
9819: ,fnd_global.user_id -- last_updated_by
9820: ,sysdate -- creation_date
9821: ,fnd_global.user_id -- created_by
9822: ,fnd_global.login_id -- last_update_login
9823: ,l_end_dateTab(l_ref)
9824: ,l_period_nameTab(l_ref)
9825: ,l_quantity_tot

Line 9822: ,fnd_global.login_id -- last_update_login

9818: ,sysdate -- last_update_date
9819: ,fnd_global.user_id -- last_updated_by
9820: ,sysdate -- creation_date
9821: ,fnd_global.user_id -- created_by
9822: ,fnd_global.login_id -- last_update_login
9823: ,l_end_dateTab(l_ref)
9824: ,l_period_nameTab(l_ref)
9825: ,l_quantity_tot
9826: ,DECODE(l_adj_percentage,0,DECODE(l_cost_flag,'Y', l_raw_cost_tot,NULL),NULL) -- raw_cost

Line 10231: ,last_updated_by = FND_GLOBAL.user_id

10227: ,labor_quantity = 0
10228: ,equipment_quantity = 0
10229: */
10230: ,last_update_date = SYSDATE
10231: ,last_updated_by = FND_GLOBAL.user_id
10232: ,last_update_login = FND_GLOBAL.login_id
10233: ,record_version_number = record_version_number + 1
10234: WHERE budget_version_id = p_wp_version_id;
10235:

Line 10232: ,last_update_login = FND_GLOBAL.login_id

10228: ,equipment_quantity = 0
10229: */
10230: ,last_update_date = SYSDATE
10231: ,last_updated_by = FND_GLOBAL.user_id
10232: ,last_update_login = FND_GLOBAL.login_id
10233: ,record_version_number = record_version_number + 1
10234: WHERE budget_version_id = p_wp_version_id;
10235:
10236: -- Update pa_proj_fp_options entity

Line 10262: ,last_updated_by = FND_GLOBAL.user_id

10258: ,cost_burden_rate_sch_id = parent_plan_type_rec.cost_burden_rate_sch_id
10259: ,rbs_version_id = parent_plan_type_rec.rbs_version_id -- Bug 3725414
10260: ,record_version_number = record_version_number + 1
10261: ,last_update_date = SYSDATE
10262: ,last_updated_by = FND_GLOBAL.user_id
10263: ,last_update_login = FND_GLOBAL.login_id
10264: WHERE proj_fp_options_id = wp_version_options_rec.proj_fp_options_id;
10265:
10266: -- Copy MC currencies from plan type

Line 10263: ,last_update_login = FND_GLOBAL.login_id

10259: ,rbs_version_id = parent_plan_type_rec.rbs_version_id -- Bug 3725414
10260: ,record_version_number = record_version_number + 1
10261: ,last_update_date = SYSDATE
10262: ,last_updated_by = FND_GLOBAL.user_id
10263: ,last_update_login = FND_GLOBAL.login_id
10264: WHERE proj_fp_options_id = wp_version_options_rec.proj_fp_options_id;
10265:
10266: -- Copy MC currencies from plan type
10267:

Line 10385: ,last_updated_by = FND_GLOBAL.user_id

10381: SET rbs_element_id = l_rbs_element_id_tbl(i)
10382: ,txn_accum_header_id = l_txn_accum_header_id_tbl(i)
10383: ,record_version_number = record_version_number + 1
10384: ,last_update_date = SYSDATE
10385: ,last_updated_by = FND_GLOBAL.user_id
10386: ,last_update_login = FND_GLOBAL.login_id
10387: WHERE budget_version_id = p_wp_version_id
10388: AND resource_assignment_id = l_txn_source_id_tbl(i);
10389: END IF;

Line 10386: ,last_update_login = FND_GLOBAL.login_id

10382: ,txn_accum_header_id = l_txn_accum_header_id_tbl(i)
10383: ,record_version_number = record_version_number + 1
10384: ,last_update_date = SYSDATE
10385: ,last_updated_by = FND_GLOBAL.user_id
10386: ,last_update_login = FND_GLOBAL.login_id
10387: WHERE budget_version_id = p_wp_version_id
10388: AND resource_assignment_id = l_txn_source_id_tbl(i);
10389: END IF;
10390: