APPS.PA_BUDGET_UTILS dependencies on PA_BUDGET_LINES

Line 1550: FROM pa_budget_lines l,

1546: INTO raw_cost,
1547: burdened_cost,
1548: labor_qty,
1549: revenue_amount
1550: FROM pa_budget_lines l,
1551: pa_resource_assignments a,
1552: pa_tasks t,
1553: pa_budget_versions v
1554: WHERE v.project_id = x_project_id

Line 1653: from pa_budget_lines

1649: x_err_stage := 'delete budget lines <' || to_char(x_budget_version_id)
1650: || '>';
1651:
1652: for bl_rec in (select rowid
1653: from pa_budget_lines
1654: where resource_assignment_id in
1655: (select resource_assignment_id
1656: from pa_resource_assignments
1657: where budget_version_id = x_budget_version_id))

Line 1659: pa_budget_lines_v_pkg.delete_row(x_rowid => bl_rec.rowid);

1655: (select resource_assignment_id
1656: from pa_resource_assignments
1657: where budget_version_id = x_budget_version_id))
1658: loop
1659: pa_budget_lines_v_pkg.delete_row(x_rowid => bl_rec.rowid);
1660: -- Bug Fix: 4569365. Removed MRC code.
1661: -- x_mrc_flag => 'Y'); /* FPB2: Added x_mrc_flag for MRC changes */
1662:
1663: end loop;

Line 2143: l_budget_line_id pa_budget_lines.budget_line_id%TYPE; /* FPB2 */

2139: l_Return_Status VARCHAR2(1) :=NULL;
2140: l_Msg_Data VARCHAR2(2000) :=NULL;
2141: l_Msg_Count NUMBER := 0;
2142:
2143: l_budget_line_id pa_budget_lines.budget_line_id%TYPE; /* FPB2 */
2144:
2145:
2146:
2147: begin

Line 2262: -- insert into pa_budget_lines

2258: END IF;
2259: return;
2260: end ;
2261:
2262: -- insert into pa_budget_lines
2263: x_err_stage := 'create new budget line <'
2264: || to_char(x_resource_assignment_id) || '><'
2265: || to_char(x_start_date, 'DD-MON-YYYY')
2266: || '>';

Line 2333: SELECT pa_budget_lines_s.nextval

2329: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
2330: END IF;
2331:
2332: /* FPB2 */
2333: SELECT pa_budget_lines_s.nextval
2334: INTO l_budget_line_id
2335: FROM DUAL;
2336:
2337: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2342: insert into pa_budget_lines

2338: pa_debug.g_err_stage:= 'l_budget_line_id is - '||l_budget_line_id;
2339: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
2340: END IF;
2341:
2342: insert into pa_budget_lines
2343: (budget_line_id, /* FPB2 */
2344: budget_version_id, /* FPB2 */
2345: resource_assignment_id,
2346: start_date,

Line 2584: pa_budget_lines l

2580: SYSDATE,
2581: x_created_by,
2582: x_last_update_login
2583: from pa_resource_assignments a,
2584: pa_budget_lines l
2585: where a.budget_version_id = x_budget_version_id /*Bug 4198840: Perf:Included this join*/
2586: and a.budget_version_id = v.budget_version_id
2587: and a.resource_assignment_id = l.resource_assignment_id
2588: )

Line 3579: pa_budget_lines l ,

3575: SUM(NVL(l.RAW_COST,0)),
3576: SUM(NVL(l.BURDENED_COST,0)),
3577: SUM(NVL(l.REVENUE,0))
3578: from pa_tasks t,
3579: pa_budget_lines l ,
3580: pa_resource_assignments a
3581: where v_rollup_flag = 'T' -- Top Task Level
3582: and a.budget_version_id = x_budget_version_id
3583: and a.task_id = t.task_id

Line 3594: from pa_budget_lines l,

3590: select SUM(DECODE(a.TRACK_AS_LABOR_FLAG,'Y',NVL(l.QUANTITY,0),0)),
3591: SUM(NVL(l.RAW_COST,0)),
3592: SUM(NVL(l.BURDENED_COST,0)),
3593: SUM(NVL(l.REVENUE,0))
3594: from pa_budget_lines l,
3595: pa_resource_assignments a
3596: where v_rollup_flag = 'M' -- Middle Task Level
3597: and a.budget_version_id = x_budget_version_id
3598: and a.task_id in (select task_id

Line 3611: from pa_budget_lines l,

3607: select SUM(DECODE(a.TRACK_AS_LABOR_FLAG,'Y',NVL(l.QUANTITY,0),0)),
3608: SUM(NVL(l.RAW_COST,0)),
3609: SUM(NVL(l.BURDENED_COST,0)),
3610: SUM(NVL(l.REVENUE,0))
3611: from pa_budget_lines l,
3612: pa_resource_assignments a
3613: where v_rollup_flag = 'L' -- Lowest Task Level
3614: and a.budget_version_id = x_budget_version_id
3615: and a.task_id = x_task_id