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_BUDGET_CORE1 dependencies on PA_BUDGET_LINES

Line 17: -- the FP model. Instead, the pa_budget_lines_v_pkg.insert_row

13:
14: --Notes
15: --
16: -- For Copy_Actual, no modifications were made for
17: -- the FP model. Instead, the pa_budget_lines_v_pkg.insert_row
18: -- procedures, which is called often by Copy_Actual, was
19: -- modified to address new FP specs for budget lines.
20: --
21:

Line 312: from pa_budget_lines l

308: -- pa_mrc_finplan.g_calling_module := PA_MRC_FINPLAN.G_COPY_ACTUALS; /* FPB2: MRC */
309:
310: for bl_rec in (
311: select rowid
312: from pa_budget_lines l
313: where l.resource_assignment_id in
314: (select a.resource_assignment_id
315: from pa_resource_assignments a
316: where a.budget_version_id = x_version_id)

Line 320: pa_budget_lines_v_pkg.delete_row(X_Rowid => bl_rec.rowid);

316: where a.budget_version_id = x_version_id)
317: and l.start_date between x_start_period_start_date and
318: x_end_period_end_date) loop
319:
320: pa_budget_lines_v_pkg.delete_row(X_Rowid => bl_rec.rowid);
321: -- Bug Fix: 4569365. Removed MRC code.
322: -- ,X_mrc_flag => 'Y'); /* FPB2: Added x_mrc_flag for MRC changes */
323: end loop;
324:

Line 526: from pa_budget_lines pbl

522: x_new_burdened_cost,
523: x_new_revenue,
524: x_new_assignment_id,
525: x_new_row_id
526: from pa_budget_lines pbl
527: where pbl.resource_assignment_id in (
528: select distinct pbl1.resource_assignment_id
529: from pa_budget_lines pbl1,
530: pa_resource_assignments pra,

Line 529: from pa_budget_lines pbl1,

525: x_new_row_id
526: from pa_budget_lines pbl
527: where pbl.resource_assignment_id in (
528: select distinct pbl1.resource_assignment_id
529: from pa_budget_lines pbl1,
530: pa_resource_assignments pra,
531: pa_resource_list_members p1,
532: pa_resource_list_members p2
533: where pra.resource_list_member_id = p2.resource_list_member_id

Line 568: pa_budget_lines_v_pkg.update_Row(X_Rowid => x_new_row_id,

564: X_Burdened_Cost => TmpActTab(j).burdened_cost,
565: X_Revenue => TmpActTab(j).revenue
566: );
567:
568: pa_budget_lines_v_pkg.update_Row(X_Rowid => x_new_row_id,
569: X_Resource_Assignment_Id => x_new_assignment_id,
570: X_Budget_Version_Id => x_version_id,
571: X_Project_Id => x_project_id,
572: X_Task_Id => 0,

Line 638: pa_budget_lines_v_pkg.insert_row (

634: X_Revenue => TmpActTab(j).revenue
635: );
636: /* Ends added for 6509313 */
637:
638: pa_budget_lines_v_pkg.insert_row (
639: X_Rowid => x_rowid,
640: X_Resource_Assignment_Id => x_resource_assignment_id,
641: X_Budget_Version_Id => x_version_id,
642: X_Project_Id => x_project_id,

Line 797: Changed the following call to the procedure pa_budget_lines_v_pkg.insert_row

793:
794: -- ***** Bug # 2021295 - BEGIN *****
795:
796: PAXBUEBU:COPY ACTUALS DOES NOT PICK UP ACTUAL REVENUE FOR WORK/EVENT BUDGET
797: Changed the following call to the procedure pa_budget_lines_v_pkg.insert_row
798: from "Positional Parameter Passing" to "Named Parameter Passing".
799:
800:
801: pa_budget_lines_v_pkg.insert_row (

Line 801: pa_budget_lines_v_pkg.insert_row (

797: Changed the following call to the procedure pa_budget_lines_v_pkg.insert_row
798: from "Positional Parameter Passing" to "Named Parameter Passing".
799:
800:
801: pa_budget_lines_v_pkg.insert_row (
802: X_Rowid => x_rowid,
803: X_Resource_Assignment_Id => x_resource_assignment_id,
804: X_Budget_Version_Id => x_version_id,
805: X_Project_Id => x_project_id,

Line 1118: from pa_budget_lines pbl

1114: x_new_burdened_cost,
1115: x_new_revenue,
1116: x_new_assignment_id,
1117: x_new_row_id
1118: from pa_budget_lines pbl
1119: where pbl.resource_assignment_id in (
1120: select distinct pbl1.resource_assignment_id
1121: from pa_budget_lines pbl1,
1122: pa_resource_assignments pra,

Line 1121: from pa_budget_lines pbl1,

1117: x_new_row_id
1118: from pa_budget_lines pbl
1119: where pbl.resource_assignment_id in (
1120: select distinct pbl1.resource_assignment_id
1121: from pa_budget_lines pbl1,
1122: pa_resource_assignments pra,
1123: pa_resource_list_members p1,
1124: pa_resource_list_members p2
1125: where pra.resource_list_member_id = p2.resource_list_member_id

Line 1161: pa_budget_lines_v_pkg.update_Row(X_Rowid => x_new_row_id,

1157: X_Burdened_Cost => TmpActTab(j).burdened_cost,
1158: X_Revenue => TmpActTab(j).revenue
1159: );
1160:
1161: pa_budget_lines_v_pkg.update_Row(X_Rowid => x_new_row_id,
1162: X_Resource_Assignment_Id => x_new_assignment_id,
1163: X_Budget_Version_Id => x_version_id,
1164: X_Project_Id => x_project_id,
1165: X_Task_Id => 0,

Line 1231: pa_budget_lines_v_pkg.insert_row (

1227: X_Revenue => TmpActTab(j).revenue
1228: );
1229: /* Ends added for 6509313 */
1230:
1231: pa_budget_lines_v_pkg.insert_row (
1232: X_Rowid => x_rowid,
1233: X_Resource_Assignment_Id => x_resource_assignment_id,
1234: X_Budget_Version_Id => x_version_id,
1235: X_Project_Id => x_project_id,

Line 1386: Changed the following call to the procedure pa_budget_lines_v_pkg.insert_row

1382:
1383: -- ***** Bug # 2021295 - BEGIN *****
1384:
1385: PAXBUEBU:COPY ACTUALS DOES NOT PICK UP ACTUAL REVENUE FOR WORK/EVENT BUDGET
1386: Changed the following call to the procedure pa_budget_lines_v_pkg.insert_row
1387: from "Positional Parameter Passing" to "Named Parameter Passing".
1388:
1389:
1390: pa_budget_lines_v_pkg.insert_row (

Line 1390: pa_budget_lines_v_pkg.insert_row (

1386: Changed the following call to the procedure pa_budget_lines_v_pkg.insert_row
1387: from "Positional Parameter Passing" to "Named Parameter Passing".
1388:
1389:
1390: pa_budget_lines_v_pkg.insert_row (
1391: X_Rowid => x_rowid,
1392: X_Resource_Assignment_Id => x_resource_assignment_id,
1393: X_Budget_Version_Id => x_version_id,
1394: X_Project_Id => x_project_id,

Line 1678: from pa_budget_lines pbl

1674: x_new_burdened_cost,
1675: x_new_revenue,
1676: x_new_assignment_id,
1677: x_new_row_id
1678: from pa_budget_lines pbl
1679: where pbl.resource_assignment_id in (
1680: select distinct pbl1.resource_assignment_id
1681: from pa_budget_lines pbl1,
1682: pa_resource_assignments pra,

Line 1681: from pa_budget_lines pbl1,

1677: x_new_row_id
1678: from pa_budget_lines pbl
1679: where pbl.resource_assignment_id in (
1680: select distinct pbl1.resource_assignment_id
1681: from pa_budget_lines pbl1,
1682: pa_resource_assignments pra,
1683: pa_resource_list_members p1,
1684: pa_resource_list_members p2
1685: where pra.resource_list_member_id = p2.resource_list_member_id

Line 1721: pa_budget_lines_v_pkg.update_Row(X_Rowid => x_new_row_id,

1717: X_Burdened_Cost => TmpActTab(j).burdened_cost,
1718: X_Revenue => TmpActTab(j).revenue
1719: );
1720:
1721: pa_budget_lines_v_pkg.update_Row(X_Rowid => x_new_row_id,
1722: X_Resource_Assignment_Id => x_new_assignment_id,
1723: X_Budget_Version_Id => x_version_id,
1724: X_Project_Id => x_project_id,
1725: X_Task_Id => TmpActTab(j).task_id,

Line 1790: pa_budget_lines_v_pkg.insert_row (

1786: X_Revenue => TmpActTab(j).revenue
1787: );
1788: /* Ends added for 6509313 */
1789:
1790: pa_budget_lines_v_pkg.insert_row (
1791: X_Rowid => x_rowid,
1792: X_Resource_Assignment_Id => x_resource_assignment_id,
1793: X_Budget_Version_Id => x_version_id,
1794: X_Project_Id => x_project_id,

Line 2130: from pa_budget_lines pbl

2126: x_new_burdened_cost,
2127: x_new_revenue,
2128: x_new_assignment_id,
2129: x_new_row_id
2130: from pa_budget_lines pbl
2131: where pbl.resource_assignment_id in (
2132: select distinct pbl1.resource_assignment_id
2133: from pa_budget_lines pbl1,
2134: pa_resource_assignments pra,

Line 2133: from pa_budget_lines pbl1,

2129: x_new_row_id
2130: from pa_budget_lines pbl
2131: where pbl.resource_assignment_id in (
2132: select distinct pbl1.resource_assignment_id
2133: from pa_budget_lines pbl1,
2134: pa_resource_assignments pra,
2135: pa_resource_list_members p1,
2136: pa_resource_list_members p2
2137: where pra.resource_list_member_id = p2.resource_list_member_id

Line 2175: pa_budget_lines_v_pkg.update_Row(X_Rowid => x_new_row_id,

2171: X_Burdened_Cost => TmpActTab(j).burdened_cost,
2172: X_Revenue => TmpActTab(j).revenue
2173: );
2174:
2175: pa_budget_lines_v_pkg.update_Row(X_Rowid => x_new_row_id,
2176: X_Resource_Assignment_Id => x_new_assignment_id,
2177: X_Budget_Version_Id => x_version_id,
2178: X_Project_Id => x_project_id,
2179: X_Task_Id => TmpActTab(j).task_id,

Line 2245: pa_budget_lines_v_pkg.insert_row (

2241: X_Revenue => TmpActTab(j).revenue
2242: );
2243: /* Ends added for 6509313 */
2244:
2245: pa_budget_lines_v_pkg.insert_row (
2246: X_Rowid => x_rowid,
2247: X_Resource_Assignment_Id => x_resource_assignment_id,
2248: X_Budget_Version_Id => x_version_id,
2249: X_Project_Id => x_project_id,

Line 2393: Changed the following call to the procedure pa_budget_lines_v_pkg.insert_row

2389:
2390: -- ***** Bug # 2021295 - BEGIN *****
2391:
2392: PAXBUEBU:COPY ACTUALS DOES NOT PICK UP ACTUAL REVENUE FOR WORK/EVENT BUDGET
2393: Changed the following call to the procedure pa_budget_lines_v_pkg.insert_row
2394: from "Positional Parameter Passing" to "Named Parameter Passing".
2395:
2396:
2397: pa_budget_lines_v_pkg.insert_row (

Line 2397: pa_budget_lines_v_pkg.insert_row (

2393: Changed the following call to the procedure pa_budget_lines_v_pkg.insert_row
2394: from "Positional Parameter Passing" to "Named Parameter Passing".
2395:
2396:
2397: pa_budget_lines_v_pkg.insert_row (
2398: X_Rowid => x_rowid,
2399: X_Resource_Assignment_Id => x_resource_assignment_id,
2400: X_Budget_Version_Id => x_version_id,
2401: X_Project_Id => x_project_id,

Line 2560: Changed the following call to the procedure pa_budget_lines_v_pkg.insert_row

2556:
2557: -- ***** Bug # 2021295 - BEGIN *****
2558:
2559: PAXBUEBU:COPY ACTUALS DOES NOT PICK UP ACTUAL REVENUE FOR WORK/EVENT BUDGET
2560: Changed the following call to the procedure pa_budget_lines_v_pkg.insert_row
2561: from "Positional Parameter Passing" to "Named Parameter Passing".
2562:
2563:
2564: pa_budget_lines_v_pkg.insert_row (

Line 2564: pa_budget_lines_v_pkg.insert_row (

2560: Changed the following call to the procedure pa_budget_lines_v_pkg.insert_row
2561: from "Positional Parameter Passing" to "Named Parameter Passing".
2562:
2563:
2564: pa_budget_lines_v_pkg.insert_row (
2565: X_Rowid => x_rowid,
2566: X_Resource_Assignment_Id => x_resource_assignment_id,
2567: X_Budget_Version_Id => x_version_id,
2568: X_Project_Id => x_project_id,

Line 2869: from pa_budget_lines pbl

2865: x_new_burdened_cost,
2866: x_new_revenue,
2867: x_new_assignment_id,
2868: x_new_row_id
2869: from pa_budget_lines pbl
2870: where pbl.resource_assignment_id in (
2871: select distinct pbl1.resource_assignment_id
2872: from pa_budget_lines pbl1,
2873: pa_resource_assignments pra,

Line 2872: from pa_budget_lines pbl1,

2868: x_new_row_id
2869: from pa_budget_lines pbl
2870: where pbl.resource_assignment_id in (
2871: select distinct pbl1.resource_assignment_id
2872: from pa_budget_lines pbl1,
2873: pa_resource_assignments pra,
2874: pa_resource_list_members p1,
2875: pa_resource_list_members p2
2876: where pra.resource_list_member_id = p2.resource_list_member_id

Line 2912: pa_budget_lines_v_pkg.update_Row(X_Rowid => x_new_row_id,

2908: X_Burdened_Cost => TmpActTab(j).burdened_cost,
2909: X_Revenue => TmpActTab(j).revenue
2910: );
2911:
2912: pa_budget_lines_v_pkg.update_Row(X_Rowid => x_new_row_id,
2913: X_Resource_Assignment_Id => x_new_assignment_id,
2914: X_Budget_Version_Id => x_version_id,
2915: X_Project_Id => x_project_id,
2916: X_Task_Id => TmpActTab(j).task_id,

Line 2982: pa_budget_lines_v_pkg.insert_row (

2978: X_Revenue => TmpActTab(j).revenue
2979: );
2980: /* Ends added for 6509313 */
2981:
2982: pa_budget_lines_v_pkg.insert_row (
2983: X_Rowid => x_rowid,
2984: X_Resource_Assignment_Id => x_resource_assignment_id,
2985: X_Budget_Version_Id => x_version_id,
2986: X_Project_Id => x_project_id,

Line 3328: from pa_budget_lines pbl

3324: x_new_burdened_cost,
3325: x_new_revenue,
3326: x_new_assignment_id,
3327: x_new_row_id
3328: from pa_budget_lines pbl
3329: where pbl.resource_assignment_id in (
3330: select distinct pbl1.resource_assignment_id
3331: from pa_budget_lines pbl1,
3332: pa_resource_assignments pra,

Line 3331: from pa_budget_lines pbl1,

3327: x_new_row_id
3328: from pa_budget_lines pbl
3329: where pbl.resource_assignment_id in (
3330: select distinct pbl1.resource_assignment_id
3331: from pa_budget_lines pbl1,
3332: pa_resource_assignments pra,
3333: pa_resource_list_members p1,
3334: pa_resource_list_members p2
3335: where pra.resource_list_member_id = p2.resource_list_member_id

Line 3373: pa_budget_lines_v_pkg.update_Row(X_Rowid => x_new_row_id,

3369: X_Revenue => TmpActTab(j).revenue
3370: );
3371:
3372:
3373: pa_budget_lines_v_pkg.update_Row(X_Rowid => x_new_row_id,
3374: X_Resource_Assignment_Id => x_new_assignment_id,
3375: X_Budget_Version_Id => x_version_id,
3376: X_Project_Id => x_project_id,
3377: X_Task_Id => TmpActTab(j).task_id,

Line 3444: pa_budget_lines_v_pkg.insert_row (

3440: X_Revenue => TmpActTab(j).revenue
3441: );
3442: /* Ends added for 6509313 */
3443:
3444: pa_budget_lines_v_pkg.insert_row (
3445: X_Rowid => x_rowid,
3446: X_Resource_Assignment_Id => x_resource_assignment_id,
3447: X_Budget_Version_Id => x_version_id,
3448: X_Project_Id => x_project_id,

Line 3588: Changed the following call to the procedure pa_budget_lines_v_pkg.insert_row

3584:
3585: -- ***** Bug # 2021295 - BEGIN *****
3586:
3587: PAXBUEBU:COPY ACTUALS DOES NOT PICK UP ACTUAL REVENUE FOR WORK/EVENT BUDGET
3588: Changed the following call to the procedure pa_budget_lines_v_pkg.insert_row
3589: from "Positional Parameter Passing" to "Named Parameter Passing".
3590:
3591:
3592: pa_budget_lines_v_pkg.insert_row (

Line 3592: pa_budget_lines_v_pkg.insert_row (

3588: Changed the following call to the procedure pa_budget_lines_v_pkg.insert_row
3589: from "Positional Parameter Passing" to "Named Parameter Passing".
3590:
3591:
3592: pa_budget_lines_v_pkg.insert_row (
3593: X_Rowid => x_rowid,
3594: X_Resource_Assignment_Id => x_resource_assignment_id,
3595: X_Budget_Version_Id => x_version_id,
3596: X_Project_Id => x_project_id,

Line 3754: Changed the following call to the procedure pa_budget_lines_v_pkg.insert_row

3750:
3751: -- ***** Bug # 2021295 - BEGIN *****
3752:
3753: PAXBUEBU:COPY ACTUALS DOES NOT PICK UP ACTUAL REVENUE FOR WORK/EVENT BUDGET
3754: Changed the following call to the procedure pa_budget_lines_v_pkg.insert_row
3755: from "Positional Parameter Passing" to "Named Parameter Passing".
3756:
3757:
3758: pa_budget_lines_v_pkg.insert_row (

Line 3758: pa_budget_lines_v_pkg.insert_row (

3754: Changed the following call to the procedure pa_budget_lines_v_pkg.insert_row
3755: from "Positional Parameter Passing" to "Named Parameter Passing".
3756:
3757:
3758: pa_budget_lines_v_pkg.insert_row (
3759: X_Rowid => x_rowid,
3760: X_Resource_Assignment_Id => x_resource_assignment_id,
3761: X_Budget_Version_Id => x_version_id,
3762: X_Project_Id => x_project_id,

Line 3878: from pa_budget_lines pbl,

3874: x_task_id number
3875: )
3876: is
3877: select pbl.resource_assignment_id resource_assignment_id
3878: from pa_budget_lines pbl,
3879: pa_resource_assignments pra
3880: where pra.resource_list_member_id = l_parent_id
3881: and pbl.resource_assignment_id = pra.resource_assignment_id
3882: and pra.budget_version_id = x_budget_version_id

Line 4050: insert into pa_budget_lines

4046:
4047: x_err_stage := 'copy budget lines <' ||to_char(x_src_version_id)
4048: || '>' ;
4049:
4050: insert into pa_budget_lines
4051: (budget_line_id, /* FPB2 during changes for MRC */
4052: budget_version_id, /* FPB2 */
4053: resource_assignment_id,
4054: start_date,

Line 4143: from pa_budget_lines l,

4139: l.CCID_Gen_Rej_Message,
4140: l.projfunc_currency_code,
4141: l.project_currency_code,
4142: l.txn_currency_code
4143: from pa_budget_lines l,
4144: pa_resource_assignments sa,
4145: pa_resource_assignments da,
4146: pa_fp_bl_map_tmp bmt /* FPB2 */
4147: where l.resource_assignment_id = sa.resource_assignment_id