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

Line 239: FROM pa_budget_lines bl

235: l_stage := 'Get sum of quantity from from bl prior to etc start date';
236: --print_msg(l_stage);
237: SELECT sum(nvl(bl.quantity,0))
238: INTO v_bl_total_quantity
239: FROM pa_budget_lines bl
240: ,pa_fp_res_assignments_tmp rtmp
241: WHERE bl.budget_version_id = p_budget_version_id
242: AND bl.RESOURCE_ASSIGNMENT_ID = g_edist_RaId(i)
243: AND bl.TXN_CURRENCY_CODE = g_edist_Curcode(i)

Line 381: INSERT INTO PA_BUDGET_LINES

377:
378: IF g_bl_res_assignment_id_tab.COUNT > 0 THEN
379: l_stage := 'Bulk Insert of Budget Lines';
380: FORALL i IN g_bl_res_assignment_id_tab.FIRST .. g_bl_res_assignment_id_tab.LAST
381: INSERT INTO PA_BUDGET_LINES
382: (
383: BUDGET_LINE_ID
384: ,BUDGET_VERSION_ID
385: ,RESOURCE_ASSIGNMENT_ID

Line 516: /* This API bulk inserts lines into pa_fp_rollup_tmp from pa_budget_lines */

512: raise FND_API.G_EXC_UNEXPECTED_ERROR;
513:
514: END blkInsertFpLines;
515:
516: /* This API bulk inserts lines into pa_fp_rollup_tmp from pa_budget_lines */
517: PROCEDURE blkInsertBlFpLines(x_return_status OUT NOCOPY Varchar2) IS
518:
519: l_stage varchar2(1000);
520: BEGIN

Line 530: This code caches several attributes from pa_budget_lines table and will use them in the

526: /* Bug Fix 4332086
527: Whenever currency is overridden along with a change in quantity in the workplan flow
528: in Update Task Details page, the following piece of code gets executed.
529:
530: This code caches several attributes from pa_budget_lines table and will use them in the
531: later part of the flow, thus causing the above bug. When ever currency code is overwritten
532: we need to use the new currency's conversion attributes, but where as this code will use
533: old currency's conversion attributes.
534:

Line 665: FROM PA_BUDGET_LINES bl

661: ,bl.INIT_REVENUE
662: ,bl.PROJECT_INIT_RAW_COST
663: ,bl.PROJECT_INIT_BURDENED_COST
664: ,bl.PROJECT_INIT_REVENUE
665: FROM PA_BUDGET_LINES bl
666: WHERE bl.budget_line_id = g_rbl_budget_line_id_tab(i)
667:
668: End of Bug Fix 4332086.
669: */

Line 795: FROM PA_BUDGET_LINES bl

791: ,bl.INIT_REVENUE
792: ,bl.PROJECT_INIT_RAW_COST
793: ,bl.PROJECT_INIT_BURDENED_COST
794: ,bl.PROJECT_INIT_REVENUE
795: FROM PA_BUDGET_LINES bl
796: WHERE bl.budget_line_id = g_rbl_budget_line_id_tab(i)
797:
798: /*Perf Bug fix:4251959 AND bl.budget_version_id = g_rbl_budget_version_id_tab(i) */
799: ;

Line 817: p_resource_assignment_id IN pa_budget_lines.RESOURCE_ASSIGNMENT_ID%TYPE

813: END blkInsertBlFpLines;
814:
815: /* This API populates the plsql tables with budget lines for bulk insert */
816: PROCEDURE insert_budget_line(
817: p_resource_assignment_id IN pa_budget_lines.RESOURCE_ASSIGNMENT_ID%TYPE
818: ,p_start_date IN pa_budget_lines.START_DATE%TYPE
819: ,p_end_date IN pa_budget_lines.END_DATE%TYPE
820: ,p_period_name IN pa_budget_lines.PERIOD_NAME%TYPE
821: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE

Line 818: ,p_start_date IN pa_budget_lines.START_DATE%TYPE

814:
815: /* This API populates the plsql tables with budget lines for bulk insert */
816: PROCEDURE insert_budget_line(
817: p_resource_assignment_id IN pa_budget_lines.RESOURCE_ASSIGNMENT_ID%TYPE
818: ,p_start_date IN pa_budget_lines.START_DATE%TYPE
819: ,p_end_date IN pa_budget_lines.END_DATE%TYPE
820: ,p_period_name IN pa_budget_lines.PERIOD_NAME%TYPE
821: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
822: ,p_txn_curr_code_ovr IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE

Line 819: ,p_end_date IN pa_budget_lines.END_DATE%TYPE

815: /* This API populates the plsql tables with budget lines for bulk insert */
816: PROCEDURE insert_budget_line(
817: p_resource_assignment_id IN pa_budget_lines.RESOURCE_ASSIGNMENT_ID%TYPE
818: ,p_start_date IN pa_budget_lines.START_DATE%TYPE
819: ,p_end_date IN pa_budget_lines.END_DATE%TYPE
820: ,p_period_name IN pa_budget_lines.PERIOD_NAME%TYPE
821: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
822: ,p_txn_curr_code_ovr IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
823: ,x_budget_line_id OUT NOCOPY pa_budget_lines.BUDGET_LINE_ID%TYPE

Line 820: ,p_period_name IN pa_budget_lines.PERIOD_NAME%TYPE

816: PROCEDURE insert_budget_line(
817: p_resource_assignment_id IN pa_budget_lines.RESOURCE_ASSIGNMENT_ID%TYPE
818: ,p_start_date IN pa_budget_lines.START_DATE%TYPE
819: ,p_end_date IN pa_budget_lines.END_DATE%TYPE
820: ,p_period_name IN pa_budget_lines.PERIOD_NAME%TYPE
821: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
822: ,p_txn_curr_code_ovr IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
823: ,x_budget_line_id OUT NOCOPY pa_budget_lines.BUDGET_LINE_ID%TYPE
824: ,p_budget_version_id IN pa_budget_lines.BUDGET_VERSION_ID%TYPE

Line 821: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE

817: p_resource_assignment_id IN pa_budget_lines.RESOURCE_ASSIGNMENT_ID%TYPE
818: ,p_start_date IN pa_budget_lines.START_DATE%TYPE
819: ,p_end_date IN pa_budget_lines.END_DATE%TYPE
820: ,p_period_name IN pa_budget_lines.PERIOD_NAME%TYPE
821: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
822: ,p_txn_curr_code_ovr IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
823: ,x_budget_line_id OUT NOCOPY pa_budget_lines.BUDGET_LINE_ID%TYPE
824: ,p_budget_version_id IN pa_budget_lines.BUDGET_VERSION_ID%TYPE
825: ,p_proj_curr_cd IN pa_projects_all.project_currency_code%TYPE

Line 822: ,p_txn_curr_code_ovr IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE

818: ,p_start_date IN pa_budget_lines.START_DATE%TYPE
819: ,p_end_date IN pa_budget_lines.END_DATE%TYPE
820: ,p_period_name IN pa_budget_lines.PERIOD_NAME%TYPE
821: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
822: ,p_txn_curr_code_ovr IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
823: ,x_budget_line_id OUT NOCOPY pa_budget_lines.BUDGET_LINE_ID%TYPE
824: ,p_budget_version_id IN pa_budget_lines.BUDGET_VERSION_ID%TYPE
825: ,p_proj_curr_cd IN pa_projects_all.project_currency_code%TYPE
826: ,p_projfunc_curr_cd IN pa_projects_all.projfunc_currency_code%TYPE

Line 823: ,x_budget_line_id OUT NOCOPY pa_budget_lines.BUDGET_LINE_ID%TYPE

819: ,p_end_date IN pa_budget_lines.END_DATE%TYPE
820: ,p_period_name IN pa_budget_lines.PERIOD_NAME%TYPE
821: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
822: ,p_txn_curr_code_ovr IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
823: ,x_budget_line_id OUT NOCOPY pa_budget_lines.BUDGET_LINE_ID%TYPE
824: ,p_budget_version_id IN pa_budget_lines.BUDGET_VERSION_ID%TYPE
825: ,p_proj_curr_cd IN pa_projects_all.project_currency_code%TYPE
826: ,p_projfunc_curr_cd IN pa_projects_all.projfunc_currency_code%TYPE
827: ,x_return_status OUT NOCOPY VARCHAR2

Line 824: ,p_budget_version_id IN pa_budget_lines.BUDGET_VERSION_ID%TYPE

820: ,p_period_name IN pa_budget_lines.PERIOD_NAME%TYPE
821: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
822: ,p_txn_curr_code_ovr IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
823: ,x_budget_line_id OUT NOCOPY pa_budget_lines.BUDGET_LINE_ID%TYPE
824: ,p_budget_version_id IN pa_budget_lines.BUDGET_VERSION_ID%TYPE
825: ,p_proj_curr_cd IN pa_projects_all.project_currency_code%TYPE
826: ,p_projfunc_curr_cd IN pa_projects_all.projfunc_currency_code%TYPE
827: ,x_return_status OUT NOCOPY VARCHAR2
828: ,x_msg_count OUT NOCOPY NUMBER

Line 842: SELECT PA_BUDGET_LINES_S.NEXTVAL

838: x_msg_count := 0;
839: x_msg_data := NULL;
840:
841: -- get Budget Line ID
842: SELECT PA_BUDGET_LINES_S.NEXTVAL
843: INTO l_budget_line_id
844: FROM DUAL;
845:
846: x_budget_line_id := l_budget_line_id;

Line 2041: p_start_date IN pa_budget_lines.start_date%TYPE,

2037:
2038: END get_options;
2039:
2040: PROCEDURE get_periods (
2041: p_start_date IN pa_budget_lines.start_date%TYPE,
2042: p_end_date IN pa_budget_lines.end_date%TYPE,
2043: p_period_set_name IN gl_sets_of_books.
2044: period_set_name%TYPE,
2045: p_accounted_period_type IN gl_sets_of_books.

Line 2042: p_end_date IN pa_budget_lines.end_date%TYPE,

2038: END get_options;
2039:
2040: PROCEDURE get_periods (
2041: p_start_date IN pa_budget_lines.start_date%TYPE,
2042: p_end_date IN pa_budget_lines.end_date%TYPE,
2043: p_period_set_name IN gl_sets_of_books.
2044: period_set_name%TYPE,
2045: p_accounted_period_type IN gl_sets_of_books.
2046: accounted_period_type%TYPE,

Line 2273: l_last_budget_line_id pa_budget_lines.budget_line_id%TYPE;

2269: l_plan_end_date DATE;
2270: l_budget_line_time_phase_count INTEGER;
2271: l_fixed_date DATE;
2272: l_fixed_date_period_count INTEGER;
2273: l_last_budget_line_id pa_budget_lines.budget_line_id%TYPE;
2274: l_spread_curve_id pa_spread_curves_b.spread_curve_id%TYPE;
2275: v_budget_line_id pa_budget_lines.budget_line_id%TYPE;
2276:
2277: v_resource_assignment_id pa_budget_lines.resource_assignment_id%TYPE;

Line 2275: v_budget_line_id pa_budget_lines.budget_line_id%TYPE;

2271: l_fixed_date DATE;
2272: l_fixed_date_period_count INTEGER;
2273: l_last_budget_line_id pa_budget_lines.budget_line_id%TYPE;
2274: l_spread_curve_id pa_spread_curves_b.spread_curve_id%TYPE;
2275: v_budget_line_id pa_budget_lines.budget_line_id%TYPE;
2276:
2277: v_resource_assignment_id pa_budget_lines.resource_assignment_id%TYPE;
2278: v_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;
2279:

Line 2277: v_resource_assignment_id pa_budget_lines.resource_assignment_id%TYPE;

2273: l_last_budget_line_id pa_budget_lines.budget_line_id%TYPE;
2274: l_spread_curve_id pa_spread_curves_b.spread_curve_id%TYPE;
2275: v_budget_line_id pa_budget_lines.budget_line_id%TYPE;
2276:
2277: v_resource_assignment_id pa_budget_lines.resource_assignment_id%TYPE;
2278: v_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;
2279:
2280: v_total_quantity pa_budget_lines.quantity%TYPE;
2281: v_total_raw_cost pa_budget_lines.raw_cost%TYPE;

Line 2278: v_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;

2274: l_spread_curve_id pa_spread_curves_b.spread_curve_id%TYPE;
2275: v_budget_line_id pa_budget_lines.budget_line_id%TYPE;
2276:
2277: v_resource_assignment_id pa_budget_lines.resource_assignment_id%TYPE;
2278: v_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;
2279:
2280: v_total_quantity pa_budget_lines.quantity%TYPE;
2281: v_total_raw_cost pa_budget_lines.raw_cost%TYPE;
2282: v_total_burdened_cost pa_budget_lines.burdened_cost%TYPE;

Line 2280: v_total_quantity pa_budget_lines.quantity%TYPE;

2276:
2277: v_resource_assignment_id pa_budget_lines.resource_assignment_id%TYPE;
2278: v_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;
2279:
2280: v_total_quantity pa_budget_lines.quantity%TYPE;
2281: v_total_raw_cost pa_budget_lines.raw_cost%TYPE;
2282: v_total_burdened_cost pa_budget_lines.burdened_cost%TYPE;
2283: v_total_revenue pa_budget_lines.revenue%TYPE;
2284:

Line 2281: v_total_raw_cost pa_budget_lines.raw_cost%TYPE;

2277: v_resource_assignment_id pa_budget_lines.resource_assignment_id%TYPE;
2278: v_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;
2279:
2280: v_total_quantity pa_budget_lines.quantity%TYPE;
2281: v_total_raw_cost pa_budget_lines.raw_cost%TYPE;
2282: v_total_burdened_cost pa_budget_lines.burdened_cost%TYPE;
2283: v_total_revenue pa_budget_lines.revenue%TYPE;
2284:
2285: l_sum_txn_quantity pa_budget_lines.quantity%TYPE;

Line 2282: v_total_burdened_cost pa_budget_lines.burdened_cost%TYPE;

2278: v_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;
2279:
2280: v_total_quantity pa_budget_lines.quantity%TYPE;
2281: v_total_raw_cost pa_budget_lines.raw_cost%TYPE;
2282: v_total_burdened_cost pa_budget_lines.burdened_cost%TYPE;
2283: v_total_revenue pa_budget_lines.revenue%TYPE;
2284:
2285: l_sum_txn_quantity pa_budget_lines.quantity%TYPE;
2286: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

Line 2283: v_total_revenue pa_budget_lines.revenue%TYPE;

2279:
2280: v_total_quantity pa_budget_lines.quantity%TYPE;
2281: v_total_raw_cost pa_budget_lines.raw_cost%TYPE;
2282: v_total_burdened_cost pa_budget_lines.burdened_cost%TYPE;
2283: v_total_revenue pa_budget_lines.revenue%TYPE;
2284:
2285: l_sum_txn_quantity pa_budget_lines.quantity%TYPE;
2286: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
2287: l_avg_raw_cost_rate_override pa_budget_lines.txn_cost_rate_override%TYPE;

Line 2285: l_sum_txn_quantity pa_budget_lines.quantity%TYPE;

2281: v_total_raw_cost pa_budget_lines.raw_cost%TYPE;
2282: v_total_burdened_cost pa_budget_lines.burdened_cost%TYPE;
2283: v_total_revenue pa_budget_lines.revenue%TYPE;
2284:
2285: l_sum_txn_quantity pa_budget_lines.quantity%TYPE;
2286: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
2287: l_avg_raw_cost_rate_override pa_budget_lines.txn_cost_rate_override%TYPE;
2288: l_sum_txn_raw_cost pa_budget_lines.raw_cost%TYPE;
2289: l_avg_burden_cost_rate pa_budget_lines.burden_cost_rate%TYPE;

Line 2286: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

2282: v_total_burdened_cost pa_budget_lines.burdened_cost%TYPE;
2283: v_total_revenue pa_budget_lines.revenue%TYPE;
2284:
2285: l_sum_txn_quantity pa_budget_lines.quantity%TYPE;
2286: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
2287: l_avg_raw_cost_rate_override pa_budget_lines.txn_cost_rate_override%TYPE;
2288: l_sum_txn_raw_cost pa_budget_lines.raw_cost%TYPE;
2289: l_avg_burden_cost_rate pa_budget_lines.burden_cost_rate%TYPE;
2290: l_avg_burden_cost_rate_ovrid pa_budget_lines.

Line 2287: l_avg_raw_cost_rate_override pa_budget_lines.txn_cost_rate_override%TYPE;

2283: v_total_revenue pa_budget_lines.revenue%TYPE;
2284:
2285: l_sum_txn_quantity pa_budget_lines.quantity%TYPE;
2286: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
2287: l_avg_raw_cost_rate_override pa_budget_lines.txn_cost_rate_override%TYPE;
2288: l_sum_txn_raw_cost pa_budget_lines.raw_cost%TYPE;
2289: l_avg_burden_cost_rate pa_budget_lines.burden_cost_rate%TYPE;
2290: l_avg_burden_cost_rate_ovrid pa_budget_lines.
2291: burden_cost_rate_override%TYPE;

Line 2288: l_sum_txn_raw_cost pa_budget_lines.raw_cost%TYPE;

2284:
2285: l_sum_txn_quantity pa_budget_lines.quantity%TYPE;
2286: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
2287: l_avg_raw_cost_rate_override pa_budget_lines.txn_cost_rate_override%TYPE;
2288: l_sum_txn_raw_cost pa_budget_lines.raw_cost%TYPE;
2289: l_avg_burden_cost_rate pa_budget_lines.burden_cost_rate%TYPE;
2290: l_avg_burden_cost_rate_ovrid pa_budget_lines.
2291: burden_cost_rate_override%TYPE;
2292: l_sum_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;

Line 2289: l_avg_burden_cost_rate pa_budget_lines.burden_cost_rate%TYPE;

2285: l_sum_txn_quantity pa_budget_lines.quantity%TYPE;
2286: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
2287: l_avg_raw_cost_rate_override pa_budget_lines.txn_cost_rate_override%TYPE;
2288: l_sum_txn_raw_cost pa_budget_lines.raw_cost%TYPE;
2289: l_avg_burden_cost_rate pa_budget_lines.burden_cost_rate%TYPE;
2290: l_avg_burden_cost_rate_ovrid pa_budget_lines.
2291: burden_cost_rate_override%TYPE;
2292: l_sum_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;
2293: l_avg_bill_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

Line 2290: l_avg_burden_cost_rate_ovrid pa_budget_lines.

2286: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
2287: l_avg_raw_cost_rate_override pa_budget_lines.txn_cost_rate_override%TYPE;
2288: l_sum_txn_raw_cost pa_budget_lines.raw_cost%TYPE;
2289: l_avg_burden_cost_rate pa_budget_lines.burden_cost_rate%TYPE;
2290: l_avg_burden_cost_rate_ovrid pa_budget_lines.
2291: burden_cost_rate_override%TYPE;
2292: l_sum_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;
2293: l_avg_bill_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
2294: l_avg_bill_rate_override pa_budget_lines.txn_bill_rate_override%TYPE;

Line 2292: l_sum_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;

2288: l_sum_txn_raw_cost pa_budget_lines.raw_cost%TYPE;
2289: l_avg_burden_cost_rate pa_budget_lines.burden_cost_rate%TYPE;
2290: l_avg_burden_cost_rate_ovrid pa_budget_lines.
2291: burden_cost_rate_override%TYPE;
2292: l_sum_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;
2293: l_avg_bill_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
2294: l_avg_bill_rate_override pa_budget_lines.txn_bill_rate_override%TYPE;
2295: l_sum_txn_revenue pa_budget_lines.revenue%TYPE;
2296:

Line 2293: l_avg_bill_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

2289: l_avg_burden_cost_rate pa_budget_lines.burden_cost_rate%TYPE;
2290: l_avg_burden_cost_rate_ovrid pa_budget_lines.
2291: burden_cost_rate_override%TYPE;
2292: l_sum_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;
2293: l_avg_bill_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
2294: l_avg_bill_rate_override pa_budget_lines.txn_bill_rate_override%TYPE;
2295: l_sum_txn_revenue pa_budget_lines.revenue%TYPE;
2296:
2297: tmp_quantity NUMBER;

Line 2294: l_avg_bill_rate_override pa_budget_lines.txn_bill_rate_override%TYPE;

2290: l_avg_burden_cost_rate_ovrid pa_budget_lines.
2291: burden_cost_rate_override%TYPE;
2292: l_sum_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;
2293: l_avg_bill_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
2294: l_avg_bill_rate_override pa_budget_lines.txn_bill_rate_override%TYPE;
2295: l_sum_txn_revenue pa_budget_lines.revenue%TYPE;
2296:
2297: tmp_quantity NUMBER;
2298: tmp_txn_raw_cost NUMBER;

Line 2295: l_sum_txn_revenue pa_budget_lines.revenue%TYPE;

2291: burden_cost_rate_override%TYPE;
2292: l_sum_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;
2293: l_avg_bill_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
2294: l_avg_bill_rate_override pa_budget_lines.txn_bill_rate_override%TYPE;
2295: l_sum_txn_revenue pa_budget_lines.revenue%TYPE;
2296:
2297: tmp_quantity NUMBER;
2298: tmp_txn_raw_cost NUMBER;
2299: tmp_txn_burdened_cost NUMBER;

Line 2302: l_quantity pa_budget_lines.quantity%TYPE;

2298: tmp_txn_raw_cost NUMBER;
2299: tmp_txn_burdened_cost NUMBER;
2300: tmp_txn_revenue NUMBER;
2301:
2302: l_quantity pa_budget_lines.quantity%TYPE;
2303: l_txn_raw_cost pa_budget_lines.raw_cost%TYPE;
2304: l_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;
2305: l_txn_revenue pa_budget_lines.revenue%TYPE;
2306:

Line 2303: l_txn_raw_cost pa_budget_lines.raw_cost%TYPE;

2299: tmp_txn_burdened_cost NUMBER;
2300: tmp_txn_revenue NUMBER;
2301:
2302: l_quantity pa_budget_lines.quantity%TYPE;
2303: l_txn_raw_cost pa_budget_lines.raw_cost%TYPE;
2304: l_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;
2305: l_txn_revenue pa_budget_lines.revenue%TYPE;
2306:
2307: l_g_start_date DATE;

Line 2304: l_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;

2300: tmp_txn_revenue NUMBER;
2301:
2302: l_quantity pa_budget_lines.quantity%TYPE;
2303: l_txn_raw_cost pa_budget_lines.raw_cost%TYPE;
2304: l_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;
2305: l_txn_revenue pa_budget_lines.revenue%TYPE;
2306:
2307: l_g_start_date DATE;
2308: l_g_init_quantity pa_budget_lines.init_quantity%TYPE;

Line 2305: l_txn_revenue pa_budget_lines.revenue%TYPE;

2301:
2302: l_quantity pa_budget_lines.quantity%TYPE;
2303: l_txn_raw_cost pa_budget_lines.raw_cost%TYPE;
2304: l_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;
2305: l_txn_revenue pa_budget_lines.revenue%TYPE;
2306:
2307: l_g_start_date DATE;
2308: l_g_init_quantity pa_budget_lines.init_quantity%TYPE;
2309: l_g_txn_init_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;

Line 2308: l_g_init_quantity pa_budget_lines.init_quantity%TYPE;

2304: l_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;
2305: l_txn_revenue pa_budget_lines.revenue%TYPE;
2306:
2307: l_g_start_date DATE;
2308: l_g_init_quantity pa_budget_lines.init_quantity%TYPE;
2309: l_g_txn_init_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;
2310: l_g_txn_init_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;
2311: l_g_txn_init_revenue pa_budget_lines.txn_init_revenue%TYPE;
2312: l_g_sum_etc_quantity pa_budget_lines.init_quantity%TYPE;

Line 2309: l_g_txn_init_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;

2305: l_txn_revenue pa_budget_lines.revenue%TYPE;
2306:
2307: l_g_start_date DATE;
2308: l_g_init_quantity pa_budget_lines.init_quantity%TYPE;
2309: l_g_txn_init_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;
2310: l_g_txn_init_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;
2311: l_g_txn_init_revenue pa_budget_lines.txn_init_revenue%TYPE;
2312: l_g_sum_etc_quantity pa_budget_lines.init_quantity%TYPE;
2313: l_g_sum_txn_etc_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;

Line 2310: l_g_txn_init_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;

2306:
2307: l_g_start_date DATE;
2308: l_g_init_quantity pa_budget_lines.init_quantity%TYPE;
2309: l_g_txn_init_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;
2310: l_g_txn_init_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;
2311: l_g_txn_init_revenue pa_budget_lines.txn_init_revenue%TYPE;
2312: l_g_sum_etc_quantity pa_budget_lines.init_quantity%TYPE;
2313: l_g_sum_txn_etc_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;
2314: l_g_sum_txn_etc_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;

Line 2311: l_g_txn_init_revenue pa_budget_lines.txn_init_revenue%TYPE;

2307: l_g_start_date DATE;
2308: l_g_init_quantity pa_budget_lines.init_quantity%TYPE;
2309: l_g_txn_init_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;
2310: l_g_txn_init_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;
2311: l_g_txn_init_revenue pa_budget_lines.txn_init_revenue%TYPE;
2312: l_g_sum_etc_quantity pa_budget_lines.init_quantity%TYPE;
2313: l_g_sum_txn_etc_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;
2314: l_g_sum_txn_etc_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;
2315: l_g_sum_txn_etc_revenue pa_budget_lines.txn_init_revenue%TYPE;

Line 2312: l_g_sum_etc_quantity pa_budget_lines.init_quantity%TYPE;

2308: l_g_init_quantity pa_budget_lines.init_quantity%TYPE;
2309: l_g_txn_init_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;
2310: l_g_txn_init_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;
2311: l_g_txn_init_revenue pa_budget_lines.txn_init_revenue%TYPE;
2312: l_g_sum_etc_quantity pa_budget_lines.init_quantity%TYPE;
2313: l_g_sum_txn_etc_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;
2314: l_g_sum_txn_etc_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;
2315: l_g_sum_txn_etc_revenue pa_budget_lines.txn_init_revenue%TYPE;
2316: l_g_bl_init_count INTEGER;

Line 2313: l_g_sum_txn_etc_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;

2309: l_g_txn_init_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;
2310: l_g_txn_init_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;
2311: l_g_txn_init_revenue pa_budget_lines.txn_init_revenue%TYPE;
2312: l_g_sum_etc_quantity pa_budget_lines.init_quantity%TYPE;
2313: l_g_sum_txn_etc_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;
2314: l_g_sum_txn_etc_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;
2315: l_g_sum_txn_etc_revenue pa_budget_lines.txn_init_revenue%TYPE;
2316: l_g_bl_init_count INTEGER;
2317:

Line 2314: l_g_sum_txn_etc_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;

2310: l_g_txn_init_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;
2311: l_g_txn_init_revenue pa_budget_lines.txn_init_revenue%TYPE;
2312: l_g_sum_etc_quantity pa_budget_lines.init_quantity%TYPE;
2313: l_g_sum_txn_etc_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;
2314: l_g_sum_txn_etc_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;
2315: l_g_sum_txn_etc_revenue pa_budget_lines.txn_init_revenue%TYPE;
2316: l_g_bl_init_count INTEGER;
2317:
2318: l_g_bl_count INTEGER;

Line 2315: l_g_sum_txn_etc_revenue pa_budget_lines.txn_init_revenue%TYPE;

2311: l_g_txn_init_revenue pa_budget_lines.txn_init_revenue%TYPE;
2312: l_g_sum_etc_quantity pa_budget_lines.init_quantity%TYPE;
2313: l_g_sum_txn_etc_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;
2314: l_g_sum_txn_etc_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;
2315: l_g_sum_txn_etc_revenue pa_budget_lines.txn_init_revenue%TYPE;
2316: l_g_bl_init_count INTEGER;
2317:
2318: l_g_bl_count INTEGER;
2319: l_g_sum_txn_quantity pa_budget_lines.quantity%TYPE;

Line 2319: l_g_sum_txn_quantity pa_budget_lines.quantity%TYPE;

2315: l_g_sum_txn_etc_revenue pa_budget_lines.txn_init_revenue%TYPE;
2316: l_g_bl_init_count INTEGER;
2317:
2318: l_g_bl_count INTEGER;
2319: l_g_sum_txn_quantity pa_budget_lines.quantity%TYPE;
2320: l_g_sum_txn_raw_cost pa_budget_lines.txn_raw_cost%TYPE;
2321: l_g_sum_txn_burdened_cost pa_budget_lines.txn_burdened_cost%TYPE;
2322: l_g_sum_txn_revenue pa_budget_lines.txn_revenue%TYPE;
2323:

Line 2320: l_g_sum_txn_raw_cost pa_budget_lines.txn_raw_cost%TYPE;

2316: l_g_bl_init_count INTEGER;
2317:
2318: l_g_bl_count INTEGER;
2319: l_g_sum_txn_quantity pa_budget_lines.quantity%TYPE;
2320: l_g_sum_txn_raw_cost pa_budget_lines.txn_raw_cost%TYPE;
2321: l_g_sum_txn_burdened_cost pa_budget_lines.txn_burdened_cost%TYPE;
2322: l_g_sum_txn_revenue pa_budget_lines.txn_revenue%TYPE;
2323:
2324: l_txn_quantity_addl pa_fp_res_assignments_tmp.

Line 2321: l_g_sum_txn_burdened_cost pa_budget_lines.txn_burdened_cost%TYPE;

2317:
2318: l_g_bl_count INTEGER;
2319: l_g_sum_txn_quantity pa_budget_lines.quantity%TYPE;
2320: l_g_sum_txn_raw_cost pa_budget_lines.txn_raw_cost%TYPE;
2321: l_g_sum_txn_burdened_cost pa_budget_lines.txn_burdened_cost%TYPE;
2322: l_g_sum_txn_revenue pa_budget_lines.txn_revenue%TYPE;
2323:
2324: l_txn_quantity_addl pa_fp_res_assignments_tmp.
2325: TXN_PLAN_QUANTITY%TYPE;

Line 2322: l_g_sum_txn_revenue pa_budget_lines.txn_revenue%TYPE;

2318: l_g_bl_count INTEGER;
2319: l_g_sum_txn_quantity pa_budget_lines.quantity%TYPE;
2320: l_g_sum_txn_raw_cost pa_budget_lines.txn_raw_cost%TYPE;
2321: l_g_sum_txn_burdened_cost pa_budget_lines.txn_burdened_cost%TYPE;
2322: l_g_sum_txn_revenue pa_budget_lines.txn_revenue%TYPE;
2323:
2324: l_txn_quantity_addl pa_fp_res_assignments_tmp.
2325: TXN_PLAN_QUANTITY%TYPE;
2326: l_txn_raw_cost_addl pa_fp_res_assignments_tmp.

Line 2363: FROM PA_BUDGET_LINES

2359: TXN_INIT_REVENUE,
2360: TXN_CURRENCY_CODE,
2361: BUDGET_LINE_ID,
2362: BUDGET_VERSION_ID
2363: FROM PA_BUDGET_LINES
2364: WHERE RESOURCE_ASSIGNMENT_ID = v_resource_assignment_id
2365: AND TXN_CURRENCY_CODE = v_txn_currency_code
2366: AND START_DATE BETWEEN l_line_start_date AND l_line_end_date
2367: AND END_DATE BETWEEN l_line_start_date AND l_line_end_date

Line 2392: FROM PA_BUDGET_LINES

2388: TXN_INIT_REVENUE,
2389: TXN_CURRENCY_CODE,
2390: BUDGET_LINE_ID,
2391: BUDGET_VERSION_ID
2392: FROM PA_BUDGET_LINES
2393: WHERE RESOURCE_ASSIGNMENT_ID = p_resAsgnId
2394: AND TXN_CURRENCY_CODE = p_txn_cur_code
2395: AND START_DATE BETWEEN p_line_start_date AND p_line_end_date
2396: AND END_DATE BETWEEN p_line_start_date AND p_line_end_date

Line 2403: FROM PA_BUDGET_LINES

2399:
2400: /* This Cursor is used for Non-Time phase budgets */
2401: CURSOR budget_line_time_phase_csr IS
2402: SELECT BUDGET_LINE_ID
2403: FROM PA_BUDGET_LINES
2404: WHERE RESOURCE_ASSIGNMENT_ID = v_resource_assignment_id
2405: AND TXN_CURRENCY_CODE = v_txn_currency_code
2406: --AND START_DATE = l_plan_start_date bug 6339811
2407: --AND END_DATE = l_plan_end_date bug 6339811

Line 2518: FROM pa_budget_lines bl

2514: ,sum(bl.txn_revenue)
2515: ,min(bl.budget_line_id)
2516: ,decode(min(bl.budget_line_id),NULL,0,1) NumOfBudgetLines
2517: ,sum(NVL(bl.quantity,0)-NVL(bl.init_quantity,0)) Etc_Quantity
2518: FROM pa_budget_lines bl
2519: WHERE bl.resource_assignment_id = p_resAsgnId
2520: AND bl.txn_currency_code = p_txn_cur_code
2521: AND bl.START_DATE BETWEEN p_start_date AND p_end_date
2522: AND bl.END_DATE BETWEEN p_start_date AND p_end_date ;

Line 2863: -- Insert into PA_BUDGET_LINES,

2859: print_msg('l_budget_line_time_phase_count['||l_budget_line_time_phase_count||']');
2860:
2861: IF l_budget_line_time_phase_count = 0 THEN
2862: --print_msg('Inserting records into budget line for l_budget_line_time_phase_count = 0');
2863: -- Insert into PA_BUDGET_LINES,
2864: insert_budget_line(
2865: v_resource_assignment_id,
2866: resource_assignment_rec.PLANNING_START_DATE,
2867: resource_assignment_rec.PLANNING_END_DATE,

Line 3319: -- Insert into PA_BUDGET_LINES,

3315: v_spread_amounts(i).amount3 <> 0 OR
3316: v_spread_amounts(i).amount4 IS NOT NULL AND
3317: v_spread_amounts(i).amount4 <> 0 THEN
3318:
3319: -- Insert into PA_BUDGET_LINES,
3320:
3321: insert_budget_line(
3322: v_resource_assignment_id,
3323: v_spread_amounts(i).start_date,

Line 3457: --print_msg('inside loop For each record in PA_BUDGET_LINES');

3453: ,v_txn_currency_code
3454: ,l_line_start_date
3455: ,l_line_end_date ) LOOP
3456:
3457: --print_msg('inside loop For each record in PA_BUDGET_LINES');
3458: -- get Budget Line ID and amounts
3459: -- update amounts based on existing distribution
3460:
3461:

Line 3759: -- Insert into PA_BUDGET_LINES,

3755: l_stage := 1049;
3756: print_msg(l_stage||' after get fixed date period ');
3757: print_msg(' '||v_spread_amounts(i).start_date||'/'||v_spread_amounts(i).end_date);
3758:
3759: -- Insert into PA_BUDGET_LINES,
3760:
3761: insert_budget_line(
3762: v_resource_assignment_id,
3763: v_spread_amounts(i).start_date,