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 2142: l_budget_line_id pa_budget_lines.budget_line_id%TYPE; /* FPB2 */

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

Line 2258: -- insert into pa_budget_lines

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

Line 2329: SELECT pa_budget_lines_s.nextval

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

Line 2338: insert into pa_budget_lines

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

Line 2580: pa_budget_lines l

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

Line 3575: pa_budget_lines l ,

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

Line 3590: from pa_budget_lines l,

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

Line 3607: from pa_budget_lines l,

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