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.

[Home] [Help]

APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on PA_BUDGET_LINES

Line 9: -- budget_line_id into pa_budget_lines

5: -- Package name : PA_FP_ORG_FCST_GEN_PUB
6: -- Purpose :
7: -- History :
8: -- 27-SEP-2002 sdebroy FPB2: Changes made due to addition of
9: -- budget_line_id into pa_budget_lines
10: -- table .
11: -- 26-NOV-02 ssarma FPB4: Added txn_currency_code to
12: -- all inserts into budget_lines.
13: -- The value will be that of PFC.

Line 234: l_utl_hours pa_budget_lines.utilization_hours%TYPE;

230: l_own_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
231: l_proj_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
232: l_resource_list_member_id pa_resource_assignments.resource_list_member_id%TYPE;
233: l_prv_forecast_element_id pa_org_fcst_elements.forecast_element_id%TYPE;
234: l_utl_hours pa_budget_lines.utilization_hours%TYPE;
235: l_utl_capacity pa_budget_lines.capacity%TYPE;
236: l_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE;
237: l_act_period_type gl_periods.period_type%TYPE;
238:

Line 235: l_utl_capacity pa_budget_lines.capacity%TYPE;

231: l_proj_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
232: l_resource_list_member_id pa_resource_assignments.resource_list_member_id%TYPE;
233: l_prv_forecast_element_id pa_org_fcst_elements.forecast_element_id%TYPE;
234: l_utl_hours pa_budget_lines.utilization_hours%TYPE;
235: l_utl_capacity pa_budget_lines.capacity%TYPE;
236: l_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE;
237: l_act_period_type gl_periods.period_type%TYPE;
238:
239:

Line 291: FROM pa_budget_lines bl

287: ,nvl(sum(bl.utilization_percent),0)
288: ,nvl(sum(bl.utilization_hours),0)
289: ,nvl(sum(bl.capacity),0)
290: ,nvl(sum(bl.head_count),0)
291: FROM pa_budget_lines bl
292: ,pa_resource_assignments ra
293: WHERE bl.resource_assignment_id = ra.resource_assignment_id
294: AND bl.budget_version_id = ra.budget_version_id
295: AND ra.budget_version_id = l_budget_version_id

Line 3170: INSERT INTO pa_budget_lines

3166:
3167: /* Bulk insert into Budget Lines for Own Numbers Phase I */
3168: IF l_bl_res_asg_id_tab.count > 0 THEN
3169: FORALL i in l_bl_res_asg_id_tab.first..l_bl_res_asg_id_tab.last
3170: INSERT INTO pa_budget_lines
3171: ( budget_line_id /* FPB2 */
3172: ,budget_version_id /* FPB2 */
3173: ,txn_currency_code /* FPB4 */
3174: ,resource_assignment_id

Line 3203: pa_budget_lines_s.nextval /* FPB2 */

3199: ,last_update_login
3200: ,last_updated_by
3201: ,last_update_date
3202: ) VALUES (
3203: pa_budget_lines_s.nextval /* FPB2 */
3204: ,l_bl_budget_version_id_tab(i) /* FPB2 */
3205: ,l_org_projfunc_currency_code /* FPB4 */
3206: ,l_bl_res_asg_id_tab(i)
3207: ,l_bl_period_name_tab(i)

Line 3272: FROM pa_budget_lines bl

3268: ,budget_lines_rec(1).utilization_percent
3269: ,budget_lines_rec(1).utilization_hours
3270: ,budget_lines_rec(1).capacity
3271: ,budget_lines_rec(1).head_count
3272: FROM pa_budget_lines bl
3273: WHERE bl.resource_assignment_id = l_own_resource_assignment_id;
3274:
3275: l_stage := 9200;
3276: -- hr_utility.trace(to_char(l_stage));

Line 3617: INSERT INTO pa_budget_lines

3613: IF P_PA_DEBUG_MODE = 'Y' THEN
3614: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
3615: END IF;
3616: FORALL i in l_bl_res_asg_id_tab.first..l_bl_res_asg_id_tab.last
3617: INSERT INTO pa_budget_lines
3618: ( budget_line_id /* FPB2 budget_line_id */
3619: ,budget_version_id /* FPB2 */
3620: ,txn_currency_code /* FPB4 */
3621: ,resource_assignment_id

Line 3650: pa_budget_lines_s.nextval /* FPB2: budget_line_id */

3646: ,last_update_login
3647: ,last_updated_by
3648: ,last_update_date
3649: ) VALUES (
3650: pa_budget_lines_s.nextval /* FPB2: budget_line_id */
3651: ,l_bl_budget_version_id_tab(i) /* FPB2: budget_version_id */
3652: ,l_org_projfunc_currency_code /* FPB4 */
3653: ,l_bl_res_asg_id_tab(i)
3654: ,l_bl_period_name_tab(i)

Line 3718: FROM pa_budget_lines bl

3714: ,budget_lines_rec(1).utilization_percent
3715: ,budget_lines_rec(1).utilization_hours
3716: ,budget_lines_rec(1).capacity
3717: ,budget_lines_rec(1).head_count
3718: FROM pa_budget_lines bl
3719: WHERE bl.resource_assignment_id = l_proj_resource_assignment_id;
3720:
3721: l_stage := 10500;
3722: -- hr_utility.trace(to_char(l_stage));

Line 4693: FROM pa_budget_lines bl

4689: END IF;
4690:
4691: SELECT min(bl.start_date)
4692: INTO l_start_Date
4693: FROM pa_budget_lines bl
4694: WHERE bl.budget_version_id = p_source_plan_version_id;
4695:
4696: END IF; /* Mininum Task start date is null */
4697:

Line 5814: INSERT INTO PA_BUDGET_LINES(

5810: --PA_FP_MULTI_CURRENCY_PKG.Round_Budget_Line_Amounts which is called after this INSERT. Note that this has to be done only
5811: --when adjustment% is not null since the amounts in the source will be altered only when the user enters some adj %
5812: --Bug 4188225. PC/PFC buckets will be copied unconditionally (Removed the condition that checks for l_adj_percentage
5813: --being greater than 0 in order to copy)
5814: INSERT INTO PA_BUDGET_LINES(
5815: budget_line_id /* FPB2 */
5816: ,budget_version_id /* FPB2 */
5817: ,resource_assignment_id
5818: ,start_date

Line 6049: FROM PA_BUDGET_LINES pbl

6045: ,Decode(l_cost_flag,'Y',burden_cost_rate_override,null) --burden_cost_rate_override
6046: ,cost_ind_compiled_set_id
6047: ,Decode(l_adj_percentage,0,pc_cur_conv_rejection_code,null)
6048: ,Decode(l_adj_percentage,0,pfc_cur_conv_rejection_code,null)
6049: FROM PA_BUDGET_LINES pbl
6050: ,PA_FP_RA_MAP_TMP pfrmt
6051: ,pa_fp_bl_map_tmp bmt /* FPB2 */
6052: WHERE pbl.resource_assignment_id = pfrmt.source_res_assignment_id
6053: AND bmt.source_budget_line_id = pbl.budget_line_id /* FPB2 */