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_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 233: l_utl_hours pa_budget_lines.utilization_hours%TYPE;

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

Line 234: l_utl_capacity pa_budget_lines.capacity%TYPE;

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

Line 290: FROM pa_budget_lines bl

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

Line 3169: INSERT INTO pa_budget_lines

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

Line 3202: pa_budget_lines_s.nextval /* FPB2 */

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

Line 3271: FROM pa_budget_lines bl

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

Line 3616: INSERT INTO pa_budget_lines

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

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

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

Line 3717: FROM pa_budget_lines bl

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

Line 4692: FROM pa_budget_lines bl

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

Line 5809: INSERT INTO PA_BUDGET_LINES(

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

Line 6044: FROM PA_BUDGET_LINES pbl

6040: ,Decode(l_cost_flag,'Y',burden_cost_rate_override,null) --burden_cost_rate_override
6041: ,cost_ind_compiled_set_id
6042: ,Decode(l_adj_percentage,0,pc_cur_conv_rejection_code,null)
6043: ,Decode(l_adj_percentage,0,pfc_cur_conv_rejection_code,null)
6044: FROM PA_BUDGET_LINES pbl
6045: ,PA_FP_RA_MAP_TMP pfrmt
6046: ,pa_fp_bl_map_tmp bmt /* FPB2 */
6047: WHERE pbl.resource_assignment_id = pfrmt.source_res_assignment_id
6048: AND bmt.source_budget_line_id = pbl.budget_line_id /* FPB2 */