DBA Data[Home] [Help]

APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on FND_GLOBAL

Line 1855: ,last_updated_by = fnd_global.user_id

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

Line 1856: ,last_update_login = fnd_global.login_id

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

Line 2509: ,fnd_global.user_id

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

Line 2510: ,fnd_global.login_id

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

Line 2511: ,fnd_global.user_id

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

Line 2591: ,fnd_global.user_id

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

Line 2592: ,fnd_global.login_id

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

Line 2593: ,fnd_global.user_id

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

Line 3230: ,fnd_global.user_id

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

Line 3231: ,fnd_global.login_id

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

Line 3232: ,fnd_global.user_id

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

Line 3289: ,last_updated_by = fnd_global.user_id

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

Line 3290: ,last_update_login = fnd_global.login_id

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

Line 3677: ,fnd_global.user_id

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

Line 3678: ,fnd_global.login_id

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

Line 3679: ,fnd_global.user_id

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

Line 3734: ,last_updated_by = fnd_global.user_id

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

Line 3735: ,last_update_login = fnd_global.login_id

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

Line 3772: ,last_updated_by = fnd_global.user_id

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

Line 3773: ,last_update_login = fnd_global.login_id

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

Line 5187: ,fnd_global.user_id

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

Line 5189: ,fnd_global.user_id

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

Line 5190: ,fnd_global.login_id

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

Line 5457: ,fnd_global.user_id

5453: ,l_target_project_id
5454: ,pfrmt.target_task_id
5455: ,pfrmt.system_reference4 -- Bug 3615617 resource_list_member_id
5456: ,sysdate
5457: ,fnd_global.user_id
5458: ,sysdate
5459: ,fnd_global.user_id
5460: ,fnd_global.login_id
5461: ,pra.unit_of_measure

Line 5459: ,fnd_global.user_id

5455: ,pfrmt.system_reference4 -- Bug 3615617 resource_list_member_id
5456: ,sysdate
5457: ,fnd_global.user_id
5458: ,sysdate
5459: ,fnd_global.user_id
5460: ,fnd_global.login_id
5461: ,pra.unit_of_measure
5462: ,pra.track_as_labor_flag
5463: ,DECODE(l_adj_percentage,0,DECODE(l_revenue_flag,'Y',total_plan_revenue,NULL),NULL)

Line 5460: ,fnd_global.login_id

5456: ,sysdate
5457: ,fnd_global.user_id
5458: ,sysdate
5459: ,fnd_global.user_id
5460: ,fnd_global.login_id
5461: ,pra.unit_of_measure
5462: ,pra.track_as_labor_flag
5463: ,DECODE(l_adj_percentage,0,DECODE(l_revenue_flag,'Y',total_plan_revenue,NULL),NULL)
5464: ,DECODE(l_adj_percentage,0,DECODE(l_cost_flag,'Y',total_plan_raw_cost,NULL),NULL)

Line 5936: ,fnd_global.user_id

5932: ,p_target_plan_version_id /* FPB2 */
5933: ,pfrmt.target_res_assignment_id
5934: ,pbl.start_date
5935: ,sysdate
5936: ,fnd_global.user_id
5937: ,sysdate
5938: ,fnd_global.user_id
5939: ,fnd_global.login_id
5940: ,pbl.end_date

Line 5938: ,fnd_global.user_id

5934: ,pbl.start_date
5935: ,sysdate
5936: ,fnd_global.user_id
5937: ,sysdate
5938: ,fnd_global.user_id
5939: ,fnd_global.login_id
5940: ,pbl.end_date
5941: ,pbl.period_name
5942: ,pbl.quantity

Line 5939: ,fnd_global.login_id

5935: ,sysdate
5936: ,fnd_global.user_id
5937: ,sysdate
5938: ,fnd_global.user_id
5939: ,fnd_global.login_id
5940: ,pbl.end_date
5941: ,pbl.period_name
5942: ,pbl.quantity
5943: ,DECODE(l_cost_flag,'Y', raw_cost,NULL)

Line 5977: ,fnd_global.conc_request_id

5973: ,other_rejection_code
5974: ,code_combination_id
5975: ,ccid_gen_status_code
5976: ,ccid_gen_rej_message
5977: ,fnd_global.conc_request_id
5978: ,borrowed_revenue
5979: ,tp_revenue_in
5980: ,tp_revenue_out
5981: ,revenue_adj