DBA Data[Home] [Help]

APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on FND_GLOBAL

Line 1854: ,last_updated_by = fnd_global.user_id

1850: version_name = DECODE(version_name,null,l_bv_version_name
1851: ||'-'||to_char(l_budget_version_id),
1852: version_name)
1853: ,last_update_date = sysdate
1854: ,last_updated_by = fnd_global.user_id
1855: ,last_update_login = fnd_global.login_id
1856: ,revenue = 0
1857: ,raw_cost = 0
1858: ,burdened_cost = 0

Line 1855: ,last_update_login = fnd_global.login_id

1851: ||'-'||to_char(l_budget_version_id),
1852: version_name)
1853: ,last_update_date = sysdate
1854: ,last_updated_by = fnd_global.user_id
1855: ,last_update_login = fnd_global.login_id
1856: ,revenue = 0
1857: ,raw_cost = 0
1858: ,burdened_cost = 0
1859: ,labor_quantity = 0

Line 2508: ,fnd_global.user_id

2504: ,l_fe_assignment_id_tab(i)
2505: ,l_fe_resource_id_tab(i)
2506: ,1
2507: ,sysdate
2508: ,fnd_global.user_id
2509: ,fnd_global.login_id
2510: ,fnd_global.user_id
2511: ,sysdate);
2512:

Line 2509: ,fnd_global.login_id

2505: ,l_fe_resource_id_tab(i)
2506: ,1
2507: ,sysdate
2508: ,fnd_global.user_id
2509: ,fnd_global.login_id
2510: ,fnd_global.user_id
2511: ,sysdate);
2512:
2513: l_records_affected := SQL%ROWCOUNT;

Line 2510: ,fnd_global.user_id

2506: ,1
2507: ,sysdate
2508: ,fnd_global.user_id
2509: ,fnd_global.login_id
2510: ,fnd_global.user_id
2511: ,sysdate);
2512:
2513: l_records_affected := SQL%ROWCOUNT;
2514:

Line 2590: ,fnd_global.user_id

2586: ,l_fl_lent_resource_cost_tab(j)
2587: ,l_fl_unassigned_time_cost_tab(j)
2588: ,1
2589: ,sysdate
2590: ,fnd_global.user_id
2591: ,fnd_global.login_id
2592: ,fnd_global.user_id
2593: ,sysdate);
2594:

Line 2591: ,fnd_global.login_id

2587: ,l_fl_unassigned_time_cost_tab(j)
2588: ,1
2589: ,sysdate
2590: ,fnd_global.user_id
2591: ,fnd_global.login_id
2592: ,fnd_global.user_id
2593: ,sysdate);
2594:
2595: l_records_affected := SQL%ROWCOUNT;

Line 2592: ,fnd_global.user_id

2588: ,1
2589: ,sysdate
2590: ,fnd_global.user_id
2591: ,fnd_global.login_id
2592: ,fnd_global.user_id
2593: ,sysdate);
2594:
2595: l_records_affected := SQL%ROWCOUNT;
2596:

Line 3229: ,fnd_global.user_id

3225: ,l_bl_utilization_hours_tab(i)
3226: ,l_bl_capacity_tab(i)
3227: ,l_bl_head_count_tab(i)
3228: ,sysdate
3229: ,fnd_global.user_id
3230: ,fnd_global.login_id
3231: ,fnd_global.user_id
3232: ,sysdate);
3233:

Line 3230: ,fnd_global.login_id

3226: ,l_bl_capacity_tab(i)
3227: ,l_bl_head_count_tab(i)
3228: ,sysdate
3229: ,fnd_global.user_id
3230: ,fnd_global.login_id
3231: ,fnd_global.user_id
3232: ,sysdate);
3233:
3234: END IF;

Line 3231: ,fnd_global.user_id

3227: ,l_bl_head_count_tab(i)
3228: ,sysdate
3229: ,fnd_global.user_id
3230: ,fnd_global.login_id
3231: ,fnd_global.user_id
3232: ,sysdate);
3233:
3234: END IF;
3235: l_stage := 9100;

Line 3288: ,last_updated_by = fnd_global.user_id

3284:
3285: UPDATE pa_resource_assignments
3286: SET
3287: last_update_date = sysdate
3288: ,last_updated_by = fnd_global.user_id
3289: ,last_update_login = fnd_global.login_id
3290: ,total_plan_revenue = budget_lines_rec(1).revenue
3291: ,total_plan_raw_cost = budget_lines_rec(1).raw_cost
3292: ,total_plan_burdened_cost = budget_lines_rec(1).burdened_cost

Line 3289: ,last_update_login = fnd_global.login_id

3285: UPDATE pa_resource_assignments
3286: SET
3287: last_update_date = sysdate
3288: ,last_updated_by = fnd_global.user_id
3289: ,last_update_login = fnd_global.login_id
3290: ,total_plan_revenue = budget_lines_rec(1).revenue
3291: ,total_plan_raw_cost = budget_lines_rec(1).raw_cost
3292: ,total_plan_burdened_cost = budget_lines_rec(1).burdened_cost
3293: ,total_plan_quantity = budget_lines_rec(1).quantity

Line 3676: ,fnd_global.user_id

3672: ,l_bl_utilization_hours_tab(i)
3673: ,l_bl_capacity_tab(i)
3674: ,l_bl_head_count_tab(i)
3675: ,sysdate
3676: ,fnd_global.user_id
3677: ,fnd_global.login_id
3678: ,fnd_global.user_id
3679: ,sysdate);
3680:

Line 3677: ,fnd_global.login_id

3673: ,l_bl_capacity_tab(i)
3674: ,l_bl_head_count_tab(i)
3675: ,sysdate
3676: ,fnd_global.user_id
3677: ,fnd_global.login_id
3678: ,fnd_global.user_id
3679: ,sysdate);
3680:
3681: l_stage := 10400;

Line 3678: ,fnd_global.user_id

3674: ,l_bl_head_count_tab(i)
3675: ,sysdate
3676: ,fnd_global.user_id
3677: ,fnd_global.login_id
3678: ,fnd_global.user_id
3679: ,sysdate);
3680:
3681: l_stage := 10400;
3682: -- hr_utility.trace(to_char(l_stage));

Line 3733: ,last_updated_by = fnd_global.user_id

3729: END IF;
3730: UPDATE pa_resource_assignments
3731: SET
3732: last_update_date = sysdate
3733: ,last_updated_by = fnd_global.user_id
3734: ,last_update_login = fnd_global.login_id
3735: ,total_plan_revenue = budget_lines_rec(1).revenue
3736: ,total_plan_raw_cost = budget_lines_rec(1).raw_cost
3737: ,total_plan_burdened_cost = budget_lines_rec(1).burdened_cost

Line 3734: ,last_update_login = fnd_global.login_id

3730: UPDATE pa_resource_assignments
3731: SET
3732: last_update_date = sysdate
3733: ,last_updated_by = fnd_global.user_id
3734: ,last_update_login = fnd_global.login_id
3735: ,total_plan_revenue = budget_lines_rec(1).revenue
3736: ,total_plan_raw_cost = budget_lines_rec(1).raw_cost
3737: ,total_plan_burdened_cost = budget_lines_rec(1).burdened_cost
3738: ,total_plan_quantity = budget_lines_rec(1).quantity

Line 3771: ,last_updated_by = fnd_global.user_id

3767: ,version_name = DECODE(version_name,null,l_bv_version_name
3768: ||'-'||to_char(l_budget_version_id),
3769: version_name)
3770: ,last_update_date = sysdate
3771: ,last_updated_by = fnd_global.user_id
3772: ,last_update_login = fnd_global.login_id
3773: ,revenue = budget_lines_rec(1).revenue
3774: ,raw_cost = budget_lines_rec(1).raw_cost
3775: ,burdened_cost = budget_lines_rec(1).burdened_cost

Line 3772: ,last_update_login = fnd_global.login_id

3768: ||'-'||to_char(l_budget_version_id),
3769: version_name)
3770: ,last_update_date = sysdate
3771: ,last_updated_by = fnd_global.user_id
3772: ,last_update_login = fnd_global.login_id
3773: ,revenue = budget_lines_rec(1).revenue
3774: ,raw_cost = budget_lines_rec(1).raw_cost
3775: ,burdened_cost = budget_lines_rec(1).burdened_cost
3776: ,labor_quantity = budget_lines_rec(1).quantity

Line 5185: ,fnd_global.user_id

5181: ,l_target_project_id
5182: ,pfrmt.target_task_id
5183: ,pfrmt.system_reference4 -- Bug 3615617 resource_list_member_id
5184: ,sysdate
5185: ,fnd_global.user_id
5186: ,sysdate
5187: ,fnd_global.user_id
5188: ,fnd_global.login_id
5189: ,pra.unit_of_measure

Line 5187: ,fnd_global.user_id

5183: ,pfrmt.system_reference4 -- Bug 3615617 resource_list_member_id
5184: ,sysdate
5185: ,fnd_global.user_id
5186: ,sysdate
5187: ,fnd_global.user_id
5188: ,fnd_global.login_id
5189: ,pra.unit_of_measure
5190: ,pra.track_as_labor_flag
5191: ,DECODE(l_adj_percentage,0,DECODE(l_revenue_flag,'Y',total_plan_revenue,NULL),NULL)

Line 5188: ,fnd_global.login_id

5184: ,sysdate
5185: ,fnd_global.user_id
5186: ,sysdate
5187: ,fnd_global.user_id
5188: ,fnd_global.login_id
5189: ,pra.unit_of_measure
5190: ,pra.track_as_labor_flag
5191: ,DECODE(l_adj_percentage,0,DECODE(l_revenue_flag,'Y',total_plan_revenue,NULL),NULL)
5192: ,DECODE(l_adj_percentage,0,DECODE(l_cost_flag,'Y',total_plan_raw_cost,NULL),NULL)

Line 5453: ,fnd_global.user_id

5449: ,l_target_project_id
5450: ,pfrmt.target_task_id
5451: ,pfrmt.system_reference4 -- Bug 3615617 resource_list_member_id
5452: ,sysdate
5453: ,fnd_global.user_id
5454: ,sysdate
5455: ,fnd_global.user_id
5456: ,fnd_global.login_id
5457: ,pra.unit_of_measure

Line 5455: ,fnd_global.user_id

5451: ,pfrmt.system_reference4 -- Bug 3615617 resource_list_member_id
5452: ,sysdate
5453: ,fnd_global.user_id
5454: ,sysdate
5455: ,fnd_global.user_id
5456: ,fnd_global.login_id
5457: ,pra.unit_of_measure
5458: ,pra.track_as_labor_flag
5459: ,DECODE(l_adj_percentage,0,DECODE(l_revenue_flag,'Y',total_plan_revenue,NULL),NULL)

Line 5456: ,fnd_global.login_id

5452: ,sysdate
5453: ,fnd_global.user_id
5454: ,sysdate
5455: ,fnd_global.user_id
5456: ,fnd_global.login_id
5457: ,pra.unit_of_measure
5458: ,pra.track_as_labor_flag
5459: ,DECODE(l_adj_percentage,0,DECODE(l_revenue_flag,'Y',total_plan_revenue,NULL),NULL)
5460: ,DECODE(l_adj_percentage,0,DECODE(l_cost_flag,'Y',total_plan_raw_cost,NULL),NULL)

Line 5931: ,fnd_global.user_id

5927: ,p_target_plan_version_id /* FPB2 */
5928: ,pfrmt.target_res_assignment_id
5929: ,pbl.start_date
5930: ,sysdate
5931: ,fnd_global.user_id
5932: ,sysdate
5933: ,fnd_global.user_id
5934: ,fnd_global.login_id
5935: ,pbl.end_date

Line 5933: ,fnd_global.user_id

5929: ,pbl.start_date
5930: ,sysdate
5931: ,fnd_global.user_id
5932: ,sysdate
5933: ,fnd_global.user_id
5934: ,fnd_global.login_id
5935: ,pbl.end_date
5936: ,pbl.period_name
5937: ,pbl.quantity

Line 5934: ,fnd_global.login_id

5930: ,sysdate
5931: ,fnd_global.user_id
5932: ,sysdate
5933: ,fnd_global.user_id
5934: ,fnd_global.login_id
5935: ,pbl.end_date
5936: ,pbl.period_name
5937: ,pbl.quantity
5938: ,DECODE(l_cost_flag,'Y', raw_cost,NULL)

Line 5972: ,fnd_global.conc_request_id

5968: ,other_rejection_code
5969: ,code_combination_id
5970: ,ccid_gen_status_code
5971: ,ccid_gen_rej_message
5972: ,fnd_global.conc_request_id
5973: ,borrowed_revenue
5974: ,tp_revenue_in
5975: ,tp_revenue_out
5976: ,revenue_adj