DBA Data[Home] [Help]

APPS.PA_FP_ROLLUP_PKG dependencies on FND_GLOBAL

Line 720: ,last_updated_by = FND_GLOBAL.user_id -- Added for bug 3394907

716: ,total_project_revenue = l_proj_revenue
717: ,labor_quantity = l_labor_quantity
718: ,equipment_quantity = l_equip_quantity
719: ,last_update_date = SYSDATE -- Added for bug 3394907
720: ,last_updated_by = FND_GLOBAL.user_id -- Added for bug 3394907
721: ,last_update_login = FND_GLOBAL.login_id -- Added for bug 3394907
722: WHERE budget_version_id = p_budget_version_id;
723:
724: -- End, Bug 3441943, 18-FEB-2004: New Vars for people (labor) and equipment quantities ------------

Line 721: ,last_update_login = FND_GLOBAL.login_id -- Added for bug 3394907

717: ,labor_quantity = l_labor_quantity
718: ,equipment_quantity = l_equip_quantity
719: ,last_update_date = SYSDATE -- Added for bug 3394907
720: ,last_updated_by = FND_GLOBAL.user_id -- Added for bug 3394907
721: ,last_update_login = FND_GLOBAL.login_id -- Added for bug 3394907
722: WHERE budget_version_id = p_budget_version_id;
723:
724: -- End, Bug 3441943, 18-FEB-2004: New Vars for people (labor) and equipment quantities ------------
725:

Line 1964: ,fnd_global.user_id

1960: ,p_projfunc_raw_cost_tbl(i)
1961: ,p_projfunc_burd_cost_tbl(i)
1962: ,p_projfunc_revenue_tbl(i)
1963: ,sysdate
1964: ,fnd_global.user_id
1965: ,sysdate
1966: ,fnd_global.user_id
1967: ,fnd_global.login_id
1968: ,p_unit_of_measure_tbl(i)

Line 1966: ,fnd_global.user_id

1962: ,p_projfunc_revenue_tbl(i)
1963: ,sysdate
1964: ,fnd_global.user_id
1965: ,sysdate
1966: ,fnd_global.user_id
1967: ,fnd_global.login_id
1968: ,p_unit_of_measure_tbl(i)
1969: ,p_track_as_labor_flag_tbl(i)
1970: ,-1

Line 1967: ,fnd_global.login_id

1963: ,sysdate
1964: ,fnd_global.user_id
1965: ,sysdate
1966: ,fnd_global.user_id
1967: ,fnd_global.login_id
1968: ,p_unit_of_measure_tbl(i)
1969: ,p_track_as_labor_flag_tbl(i)
1970: ,-1
1971: ,PA_FP_CONSTANTS_PKG.G_ROLLED_UP) ;

Line 2371: ,fnd_global.user_id

2367: ,sum(nvl(period_amount50,0)) period_amount50
2368: ,sum(nvl(period_amount51,0)) period_amount51
2369: ,sum(nvl(period_amount52,0)) period_amount52
2370: ,sysdate
2371: ,fnd_global.user_id
2372: ,sysdate
2373: ,fnd_global.user_id
2374: ,fnd_global.login_id
2375: FROM pa_fp_ra_map_tmp tmp,

Line 2373: ,fnd_global.user_id

2369: ,sum(nvl(period_amount52,0)) period_amount52
2370: ,sysdate
2371: ,fnd_global.user_id
2372: ,sysdate
2373: ,fnd_global.user_id
2374: ,fnd_global.login_id
2375: FROM pa_fp_ra_map_tmp tmp,
2376: pa_proj_periods_denorm ppd
2377: WHERE tmp.resource_assignment_id = ppd.resource_assignment_id

Line 2374: ,fnd_global.login_id

2370: ,sysdate
2371: ,fnd_global.user_id
2372: ,sysdate
2373: ,fnd_global.user_id
2374: ,fnd_global.login_id
2375: FROM pa_fp_ra_map_tmp tmp,
2376: pa_proj_periods_denorm ppd
2377: WHERE tmp.resource_assignment_id = ppd.resource_assignment_id
2378: AND ppd.budget_version_id = p_budget_version_id -- performance bug 2802862

Line 2823: ,fnd_global.user_id

2819: ,l_project_id
2820: ,l_task_id_tbl(i)
2821: ,l_res_list_mem_id_tbl(i)
2822: ,sysdate
2823: ,fnd_global.user_id
2824: ,sysdate
2825: ,fnd_global.user_id
2826: ,fnd_global.login_id
2827: ,l_unit_of_measure_tbl(i)

Line 2825: ,fnd_global.user_id

2821: ,l_res_list_mem_id_tbl(i)
2822: ,sysdate
2823: ,fnd_global.user_id
2824: ,sysdate
2825: ,fnd_global.user_id
2826: ,fnd_global.login_id
2827: ,l_unit_of_measure_tbl(i)
2828: ,l_track_as_labor_flag_tbl(i)
2829: ,-1

Line 2826: ,fnd_global.login_id

2822: ,sysdate
2823: ,fnd_global.user_id
2824: ,sysdate
2825: ,fnd_global.user_id
2826: ,fnd_global.login_id
2827: ,l_unit_of_measure_tbl(i)
2828: ,l_track_as_labor_flag_tbl(i)
2829: ,-1
2830: ,PA_FP_CONSTANTS_PKG.G_ROLLED_UP)

Line 2962: ,fnd_global.user_id

2958: ,l_project_id
2959: ,l_task_id_tbl(i)
2960: ,0 -- res_list_mem_id is 0 for tasks
2961: ,sysdate
2962: ,fnd_global.user_id
2963: ,sysdate
2964: ,fnd_global.user_id
2965: ,fnd_global.login_id
2966: ,PA_FP_CONSTANTS_PKG.G_UNIT_OF_MEASURE_HOURS -- Modified for #2697999

Line 2964: ,fnd_global.user_id

2960: ,0 -- res_list_mem_id is 0 for tasks
2961: ,sysdate
2962: ,fnd_global.user_id
2963: ,sysdate
2964: ,fnd_global.user_id
2965: ,fnd_global.login_id
2966: ,PA_FP_CONSTANTS_PKG.G_UNIT_OF_MEASURE_HOURS -- Modified for #2697999
2967: ,'Y' -- Modified for #2697999
2968: ,-1

Line 2965: ,fnd_global.login_id

2961: ,sysdate
2962: ,fnd_global.user_id
2963: ,sysdate
2964: ,fnd_global.user_id
2965: ,fnd_global.login_id
2966: ,PA_FP_CONSTANTS_PKG.G_UNIT_OF_MEASURE_HOURS -- Modified for #2697999
2967: ,'Y' -- Modified for #2697999
2968: ,-1
2969: ,PA_FP_CONSTANTS_PKG.G_ROLLED_UP)

Line 3136: ,fnd_global.user_id

3132: ,l_project_id
3133: ,l_task_id_tbl(i)
3134: ,0 -- res_list_mem_id is 0 for tasks
3135: ,sysdate
3136: ,fnd_global.user_id
3137: ,sysdate
3138: ,fnd_global.user_id
3139: ,fnd_global.login_id
3140: ,PA_FP_CONSTANTS_PKG.G_UNIT_OF_MEASURE_HOURS -- Modified for #2697999

Line 3138: ,fnd_global.user_id

3134: ,0 -- res_list_mem_id is 0 for tasks
3135: ,sysdate
3136: ,fnd_global.user_id
3137: ,sysdate
3138: ,fnd_global.user_id
3139: ,fnd_global.login_id
3140: ,PA_FP_CONSTANTS_PKG.G_UNIT_OF_MEASURE_HOURS -- Modified for #2697999
3141: ,'Y' -- Modified for #2697999
3142: ,-1

Line 3139: ,fnd_global.login_id

3135: ,sysdate
3136: ,fnd_global.user_id
3137: ,sysdate
3138: ,fnd_global.user_id
3139: ,fnd_global.login_id
3140: ,PA_FP_CONSTANTS_PKG.G_UNIT_OF_MEASURE_HOURS -- Modified for #2697999
3141: ,'Y' -- Modified for #2697999
3142: ,-1
3143: ,PA_FP_CONSTANTS_PKG.G_ROLLED_UP)

Line 3263: ,fnd_global.user_id

3259: ,l_project_id
3260: ,0
3261: ,0 -- res_list_mem_id is 0 for tasks
3262: ,sysdate
3263: ,fnd_global.user_id
3264: ,sysdate
3265: ,fnd_global.user_id
3266: ,fnd_global.login_id
3267: ,PA_FP_CONSTANTS_PKG.G_UNIT_OF_MEASURE_HOURS -- Modified for #2697999

Line 3265: ,fnd_global.user_id

3261: ,0 -- res_list_mem_id is 0 for tasks
3262: ,sysdate
3263: ,fnd_global.user_id
3264: ,sysdate
3265: ,fnd_global.user_id
3266: ,fnd_global.login_id
3267: ,PA_FP_CONSTANTS_PKG.G_UNIT_OF_MEASURE_HOURS -- Modified for #2697999
3268: ,'Y' -- Modified for #2697999
3269: ,-1

Line 3266: ,fnd_global.login_id

3262: ,sysdate
3263: ,fnd_global.user_id
3264: ,sysdate
3265: ,fnd_global.user_id
3266: ,fnd_global.login_id
3267: ,PA_FP_CONSTANTS_PKG.G_UNIT_OF_MEASURE_HOURS -- Modified for #2697999
3268: ,'Y' -- Modified for #2697999
3269: ,-1
3270: ,PA_FP_CONSTANTS_PKG.G_ROLLED_UP)

Line 3882: ,fnd_global.user_id

3878: ,l_amount_subtype_id_tbl(i)
3879: ,l_currency_type_tbl(i)
3880: ,l_currency_code_tbl(i)
3881: ,sysdate
3882: ,fnd_global.user_id
3883: ,sysdate
3884: ,fnd_global.user_id
3885: ,fnd_global.login_id);
3886:

Line 3884: ,fnd_global.user_id

3880: ,l_currency_code_tbl(i)
3881: ,sysdate
3882: ,fnd_global.user_id
3883: ,sysdate
3884: ,fnd_global.user_id
3885: ,fnd_global.login_id);
3886:
3887: pa_debug.g_err_stage := 'Inserted ' || sql%rowcount || ' records into denorm table';
3888: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 3885: ,fnd_global.login_id);

3881: ,sysdate
3882: ,fnd_global.user_id
3883: ,sysdate
3884: ,fnd_global.user_id
3885: ,fnd_global.login_id);
3886:
3887: pa_debug.g_err_stage := 'Inserted ' || sql%rowcount || ' records into denorm table';
3888: IF P_PA_DEBUG_MODE = 'Y' THEN
3889: pa_debug.write('INSERT_MISSING_PARENT_DENORM: ' || l_module_name,pa_debug.g_err_stage,3);