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 2771: p_start_date IN pa_budget_lines.start_date%TYPE,

2767:
2768: END get_options;
2769:
2770: PROCEDURE get_periods (
2771: p_start_date IN pa_budget_lines.start_date%TYPE,
2772: p_end_date IN pa_budget_lines.end_date%TYPE,
2773: p_period_set_name IN gl_sets_of_books.
2774: period_set_name%TYPE,
2775: p_accounted_period_type IN gl_sets_of_books.

Line 2772: p_end_date IN pa_budget_lines.end_date%TYPE,

2768: END get_options;
2769:
2770: PROCEDURE get_periods (
2771: p_start_date IN pa_budget_lines.start_date%TYPE,
2772: p_end_date IN pa_budget_lines.end_date%TYPE,
2773: p_period_set_name IN gl_sets_of_books.
2774: period_set_name%TYPE,
2775: p_accounted_period_type IN gl_sets_of_books.
2776: accounted_period_type%TYPE,

Line 3003: l_last_budget_line_id pa_budget_lines.budget_line_id%TYPE;

2999: l_plan_end_date DATE;
3000: l_budget_line_time_phase_count INTEGER;
3001: l_fixed_date DATE;
3002: l_fixed_date_period_count INTEGER;
3003: l_last_budget_line_id pa_budget_lines.budget_line_id%TYPE;
3004: l_spread_curve_id pa_spread_curves_b.spread_curve_id%TYPE;
3005: v_budget_line_id pa_budget_lines.budget_line_id%TYPE;
3006:
3007: v_resource_assignment_id pa_budget_lines.resource_assignment_id%TYPE;

Line 3005: v_budget_line_id pa_budget_lines.budget_line_id%TYPE;

3001: l_fixed_date DATE;
3002: l_fixed_date_period_count INTEGER;
3003: l_last_budget_line_id pa_budget_lines.budget_line_id%TYPE;
3004: l_spread_curve_id pa_spread_curves_b.spread_curve_id%TYPE;
3005: v_budget_line_id pa_budget_lines.budget_line_id%TYPE;
3006:
3007: v_resource_assignment_id pa_budget_lines.resource_assignment_id%TYPE;
3008: v_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;
3009:

Line 3007: v_resource_assignment_id pa_budget_lines.resource_assignment_id%TYPE;

3003: l_last_budget_line_id pa_budget_lines.budget_line_id%TYPE;
3004: l_spread_curve_id pa_spread_curves_b.spread_curve_id%TYPE;
3005: v_budget_line_id pa_budget_lines.budget_line_id%TYPE;
3006:
3007: v_resource_assignment_id pa_budget_lines.resource_assignment_id%TYPE;
3008: v_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;
3009:
3010: v_total_quantity pa_budget_lines.quantity%TYPE;
3011: v_total_raw_cost pa_budget_lines.raw_cost%TYPE;

Line 3008: v_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;

3004: l_spread_curve_id pa_spread_curves_b.spread_curve_id%TYPE;
3005: v_budget_line_id pa_budget_lines.budget_line_id%TYPE;
3006:
3007: v_resource_assignment_id pa_budget_lines.resource_assignment_id%TYPE;
3008: v_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;
3009:
3010: v_total_quantity pa_budget_lines.quantity%TYPE;
3011: v_total_raw_cost pa_budget_lines.raw_cost%TYPE;
3012: v_total_burdened_cost pa_budget_lines.burdened_cost%TYPE;

Line 3010: v_total_quantity pa_budget_lines.quantity%TYPE;

3006:
3007: v_resource_assignment_id pa_budget_lines.resource_assignment_id%TYPE;
3008: v_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;
3009:
3010: v_total_quantity pa_budget_lines.quantity%TYPE;
3011: v_total_raw_cost pa_budget_lines.raw_cost%TYPE;
3012: v_total_burdened_cost pa_budget_lines.burdened_cost%TYPE;
3013: v_total_revenue pa_budget_lines.revenue%TYPE;
3014:

Line 3011: v_total_raw_cost pa_budget_lines.raw_cost%TYPE;

3007: v_resource_assignment_id pa_budget_lines.resource_assignment_id%TYPE;
3008: v_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;
3009:
3010: v_total_quantity pa_budget_lines.quantity%TYPE;
3011: v_total_raw_cost pa_budget_lines.raw_cost%TYPE;
3012: v_total_burdened_cost pa_budget_lines.burdened_cost%TYPE;
3013: v_total_revenue pa_budget_lines.revenue%TYPE;
3014:
3015: l_sum_txn_quantity pa_budget_lines.quantity%TYPE;

Line 3012: v_total_burdened_cost pa_budget_lines.burdened_cost%TYPE;

3008: v_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;
3009:
3010: v_total_quantity pa_budget_lines.quantity%TYPE;
3011: v_total_raw_cost pa_budget_lines.raw_cost%TYPE;
3012: v_total_burdened_cost pa_budget_lines.burdened_cost%TYPE;
3013: v_total_revenue pa_budget_lines.revenue%TYPE;
3014:
3015: l_sum_txn_quantity pa_budget_lines.quantity%TYPE;
3016: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

Line 3013: v_total_revenue pa_budget_lines.revenue%TYPE;

3009:
3010: v_total_quantity pa_budget_lines.quantity%TYPE;
3011: v_total_raw_cost pa_budget_lines.raw_cost%TYPE;
3012: v_total_burdened_cost pa_budget_lines.burdened_cost%TYPE;
3013: v_total_revenue pa_budget_lines.revenue%TYPE;
3014:
3015: l_sum_txn_quantity pa_budget_lines.quantity%TYPE;
3016: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
3017: l_avg_raw_cost_rate_override pa_budget_lines.txn_cost_rate_override%TYPE;

Line 3015: l_sum_txn_quantity pa_budget_lines.quantity%TYPE;

3011: v_total_raw_cost pa_budget_lines.raw_cost%TYPE;
3012: v_total_burdened_cost pa_budget_lines.burdened_cost%TYPE;
3013: v_total_revenue pa_budget_lines.revenue%TYPE;
3014:
3015: l_sum_txn_quantity pa_budget_lines.quantity%TYPE;
3016: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
3017: l_avg_raw_cost_rate_override pa_budget_lines.txn_cost_rate_override%TYPE;
3018: l_sum_txn_raw_cost pa_budget_lines.raw_cost%TYPE;
3019: l_avg_burden_cost_rate pa_budget_lines.burden_cost_rate%TYPE;

Line 3016: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

3012: v_total_burdened_cost pa_budget_lines.burdened_cost%TYPE;
3013: v_total_revenue pa_budget_lines.revenue%TYPE;
3014:
3015: l_sum_txn_quantity pa_budget_lines.quantity%TYPE;
3016: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
3017: l_avg_raw_cost_rate_override pa_budget_lines.txn_cost_rate_override%TYPE;
3018: l_sum_txn_raw_cost pa_budget_lines.raw_cost%TYPE;
3019: l_avg_burden_cost_rate pa_budget_lines.burden_cost_rate%TYPE;
3020: l_avg_burden_cost_rate_ovrid pa_budget_lines.

Line 3017: l_avg_raw_cost_rate_override pa_budget_lines.txn_cost_rate_override%TYPE;

3013: v_total_revenue pa_budget_lines.revenue%TYPE;
3014:
3015: l_sum_txn_quantity pa_budget_lines.quantity%TYPE;
3016: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
3017: l_avg_raw_cost_rate_override pa_budget_lines.txn_cost_rate_override%TYPE;
3018: l_sum_txn_raw_cost pa_budget_lines.raw_cost%TYPE;
3019: l_avg_burden_cost_rate pa_budget_lines.burden_cost_rate%TYPE;
3020: l_avg_burden_cost_rate_ovrid pa_budget_lines.
3021: burden_cost_rate_override%TYPE;

Line 3018: l_sum_txn_raw_cost pa_budget_lines.raw_cost%TYPE;

3014:
3015: l_sum_txn_quantity pa_budget_lines.quantity%TYPE;
3016: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
3017: l_avg_raw_cost_rate_override pa_budget_lines.txn_cost_rate_override%TYPE;
3018: l_sum_txn_raw_cost pa_budget_lines.raw_cost%TYPE;
3019: l_avg_burden_cost_rate pa_budget_lines.burden_cost_rate%TYPE;
3020: l_avg_burden_cost_rate_ovrid pa_budget_lines.
3021: burden_cost_rate_override%TYPE;
3022: l_sum_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;

Line 3019: l_avg_burden_cost_rate pa_budget_lines.burden_cost_rate%TYPE;

3015: l_sum_txn_quantity pa_budget_lines.quantity%TYPE;
3016: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
3017: l_avg_raw_cost_rate_override pa_budget_lines.txn_cost_rate_override%TYPE;
3018: l_sum_txn_raw_cost pa_budget_lines.raw_cost%TYPE;
3019: l_avg_burden_cost_rate pa_budget_lines.burden_cost_rate%TYPE;
3020: l_avg_burden_cost_rate_ovrid pa_budget_lines.
3021: burden_cost_rate_override%TYPE;
3022: l_sum_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;
3023: l_avg_bill_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

Line 3020: l_avg_burden_cost_rate_ovrid pa_budget_lines.

3016: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
3017: l_avg_raw_cost_rate_override pa_budget_lines.txn_cost_rate_override%TYPE;
3018: l_sum_txn_raw_cost pa_budget_lines.raw_cost%TYPE;
3019: l_avg_burden_cost_rate pa_budget_lines.burden_cost_rate%TYPE;
3020: l_avg_burden_cost_rate_ovrid pa_budget_lines.
3021: burden_cost_rate_override%TYPE;
3022: l_sum_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;
3023: l_avg_bill_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
3024: l_avg_bill_rate_override pa_budget_lines.txn_bill_rate_override%TYPE;

Line 3022: l_sum_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;

3018: l_sum_txn_raw_cost pa_budget_lines.raw_cost%TYPE;
3019: l_avg_burden_cost_rate pa_budget_lines.burden_cost_rate%TYPE;
3020: l_avg_burden_cost_rate_ovrid pa_budget_lines.
3021: burden_cost_rate_override%TYPE;
3022: l_sum_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;
3023: l_avg_bill_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
3024: l_avg_bill_rate_override pa_budget_lines.txn_bill_rate_override%TYPE;
3025: l_sum_txn_revenue pa_budget_lines.revenue%TYPE;
3026:

Line 3023: l_avg_bill_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

3019: l_avg_burden_cost_rate pa_budget_lines.burden_cost_rate%TYPE;
3020: l_avg_burden_cost_rate_ovrid pa_budget_lines.
3021: burden_cost_rate_override%TYPE;
3022: l_sum_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;
3023: l_avg_bill_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
3024: l_avg_bill_rate_override pa_budget_lines.txn_bill_rate_override%TYPE;
3025: l_sum_txn_revenue pa_budget_lines.revenue%TYPE;
3026:
3027: tmp_quantity NUMBER;

Line 3024: l_avg_bill_rate_override pa_budget_lines.txn_bill_rate_override%TYPE;

3020: l_avg_burden_cost_rate_ovrid pa_budget_lines.
3021: burden_cost_rate_override%TYPE;
3022: l_sum_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;
3023: l_avg_bill_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
3024: l_avg_bill_rate_override pa_budget_lines.txn_bill_rate_override%TYPE;
3025: l_sum_txn_revenue pa_budget_lines.revenue%TYPE;
3026:
3027: tmp_quantity NUMBER;
3028: tmp_txn_raw_cost NUMBER;

Line 3025: l_sum_txn_revenue pa_budget_lines.revenue%TYPE;

3021: burden_cost_rate_override%TYPE;
3022: l_sum_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;
3023: l_avg_bill_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
3024: l_avg_bill_rate_override pa_budget_lines.txn_bill_rate_override%TYPE;
3025: l_sum_txn_revenue pa_budget_lines.revenue%TYPE;
3026:
3027: tmp_quantity NUMBER;
3028: tmp_txn_raw_cost NUMBER;
3029: tmp_txn_burdened_cost NUMBER;

Line 3032: l_quantity pa_budget_lines.quantity%TYPE;

3028: tmp_txn_raw_cost NUMBER;
3029: tmp_txn_burdened_cost NUMBER;
3030: tmp_txn_revenue NUMBER;
3031:
3032: l_quantity pa_budget_lines.quantity%TYPE;
3033: l_txn_raw_cost pa_budget_lines.raw_cost%TYPE;
3034: l_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;
3035: l_txn_revenue pa_budget_lines.revenue%TYPE;
3036:

Line 3033: l_txn_raw_cost pa_budget_lines.raw_cost%TYPE;

3029: tmp_txn_burdened_cost NUMBER;
3030: tmp_txn_revenue NUMBER;
3031:
3032: l_quantity pa_budget_lines.quantity%TYPE;
3033: l_txn_raw_cost pa_budget_lines.raw_cost%TYPE;
3034: l_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;
3035: l_txn_revenue pa_budget_lines.revenue%TYPE;
3036:
3037: l_g_start_date DATE;

Line 3034: l_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;

3030: tmp_txn_revenue NUMBER;
3031:
3032: l_quantity pa_budget_lines.quantity%TYPE;
3033: l_txn_raw_cost pa_budget_lines.raw_cost%TYPE;
3034: l_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;
3035: l_txn_revenue pa_budget_lines.revenue%TYPE;
3036:
3037: l_g_start_date DATE;
3038: l_g_init_quantity pa_budget_lines.init_quantity%TYPE;

Line 3035: l_txn_revenue pa_budget_lines.revenue%TYPE;

3031:
3032: l_quantity pa_budget_lines.quantity%TYPE;
3033: l_txn_raw_cost pa_budget_lines.raw_cost%TYPE;
3034: l_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;
3035: l_txn_revenue pa_budget_lines.revenue%TYPE;
3036:
3037: l_g_start_date DATE;
3038: l_g_init_quantity pa_budget_lines.init_quantity%TYPE;
3039: l_g_txn_init_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;

Line 3038: l_g_init_quantity pa_budget_lines.init_quantity%TYPE;

3034: l_txn_burdened_cost pa_budget_lines.burdened_cost%TYPE;
3035: l_txn_revenue pa_budget_lines.revenue%TYPE;
3036:
3037: l_g_start_date DATE;
3038: l_g_init_quantity pa_budget_lines.init_quantity%TYPE;
3039: l_g_txn_init_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;
3040: l_g_txn_init_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;
3041: l_g_txn_init_revenue pa_budget_lines.txn_init_revenue%TYPE;
3042: l_g_sum_etc_quantity pa_budget_lines.init_quantity%TYPE;

Line 3039: l_g_txn_init_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;

3035: l_txn_revenue pa_budget_lines.revenue%TYPE;
3036:
3037: l_g_start_date DATE;
3038: l_g_init_quantity pa_budget_lines.init_quantity%TYPE;
3039: l_g_txn_init_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;
3040: l_g_txn_init_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;
3041: l_g_txn_init_revenue pa_budget_lines.txn_init_revenue%TYPE;
3042: l_g_sum_etc_quantity pa_budget_lines.init_quantity%TYPE;
3043: l_g_sum_txn_etc_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;

Line 3040: l_g_txn_init_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;

3036:
3037: l_g_start_date DATE;
3038: l_g_init_quantity pa_budget_lines.init_quantity%TYPE;
3039: l_g_txn_init_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;
3040: l_g_txn_init_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;
3041: l_g_txn_init_revenue pa_budget_lines.txn_init_revenue%TYPE;
3042: l_g_sum_etc_quantity pa_budget_lines.init_quantity%TYPE;
3043: l_g_sum_txn_etc_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;
3044: l_g_sum_txn_etc_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;

Line 3041: l_g_txn_init_revenue pa_budget_lines.txn_init_revenue%TYPE;

3037: l_g_start_date DATE;
3038: l_g_init_quantity pa_budget_lines.init_quantity%TYPE;
3039: l_g_txn_init_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;
3040: l_g_txn_init_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;
3041: l_g_txn_init_revenue pa_budget_lines.txn_init_revenue%TYPE;
3042: l_g_sum_etc_quantity pa_budget_lines.init_quantity%TYPE;
3043: l_g_sum_txn_etc_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;
3044: l_g_sum_txn_etc_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;
3045: l_g_sum_txn_etc_revenue pa_budget_lines.txn_init_revenue%TYPE;

Line 3042: l_g_sum_etc_quantity pa_budget_lines.init_quantity%TYPE;

3038: l_g_init_quantity pa_budget_lines.init_quantity%TYPE;
3039: l_g_txn_init_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;
3040: l_g_txn_init_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;
3041: l_g_txn_init_revenue pa_budget_lines.txn_init_revenue%TYPE;
3042: l_g_sum_etc_quantity pa_budget_lines.init_quantity%TYPE;
3043: l_g_sum_txn_etc_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;
3044: l_g_sum_txn_etc_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;
3045: l_g_sum_txn_etc_revenue pa_budget_lines.txn_init_revenue%TYPE;
3046: l_g_bl_init_count INTEGER;

Line 3043: l_g_sum_txn_etc_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;

3039: l_g_txn_init_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;
3040: l_g_txn_init_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;
3041: l_g_txn_init_revenue pa_budget_lines.txn_init_revenue%TYPE;
3042: l_g_sum_etc_quantity pa_budget_lines.init_quantity%TYPE;
3043: l_g_sum_txn_etc_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;
3044: l_g_sum_txn_etc_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;
3045: l_g_sum_txn_etc_revenue pa_budget_lines.txn_init_revenue%TYPE;
3046: l_g_bl_init_count INTEGER;
3047:

Line 3044: l_g_sum_txn_etc_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;

3040: l_g_txn_init_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;
3041: l_g_txn_init_revenue pa_budget_lines.txn_init_revenue%TYPE;
3042: l_g_sum_etc_quantity pa_budget_lines.init_quantity%TYPE;
3043: l_g_sum_txn_etc_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;
3044: l_g_sum_txn_etc_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;
3045: l_g_sum_txn_etc_revenue pa_budget_lines.txn_init_revenue%TYPE;
3046: l_g_bl_init_count INTEGER;
3047:
3048: l_g_bl_count INTEGER;

Line 3045: l_g_sum_txn_etc_revenue pa_budget_lines.txn_init_revenue%TYPE;

3041: l_g_txn_init_revenue pa_budget_lines.txn_init_revenue%TYPE;
3042: l_g_sum_etc_quantity pa_budget_lines.init_quantity%TYPE;
3043: l_g_sum_txn_etc_raw_cost pa_budget_lines.txn_init_raw_cost%TYPE;
3044: l_g_sum_txn_etc_burdened_cost pa_budget_lines.txn_init_burdened_cost%TYPE;
3045: l_g_sum_txn_etc_revenue pa_budget_lines.txn_init_revenue%TYPE;
3046: l_g_bl_init_count INTEGER;
3047:
3048: l_g_bl_count INTEGER;
3049: l_g_sum_txn_quantity pa_budget_lines.quantity%TYPE;

Line 3049: l_g_sum_txn_quantity pa_budget_lines.quantity%TYPE;

3045: l_g_sum_txn_etc_revenue pa_budget_lines.txn_init_revenue%TYPE;
3046: l_g_bl_init_count INTEGER;
3047:
3048: l_g_bl_count INTEGER;
3049: l_g_sum_txn_quantity pa_budget_lines.quantity%TYPE;
3050: l_g_sum_txn_raw_cost pa_budget_lines.txn_raw_cost%TYPE;
3051: l_g_sum_txn_burdened_cost pa_budget_lines.txn_burdened_cost%TYPE;
3052: l_g_sum_txn_revenue pa_budget_lines.txn_revenue%TYPE;
3053:

Line 3050: l_g_sum_txn_raw_cost pa_budget_lines.txn_raw_cost%TYPE;

3046: l_g_bl_init_count INTEGER;
3047:
3048: l_g_bl_count INTEGER;
3049: l_g_sum_txn_quantity pa_budget_lines.quantity%TYPE;
3050: l_g_sum_txn_raw_cost pa_budget_lines.txn_raw_cost%TYPE;
3051: l_g_sum_txn_burdened_cost pa_budget_lines.txn_burdened_cost%TYPE;
3052: l_g_sum_txn_revenue pa_budget_lines.txn_revenue%TYPE;
3053:
3054: l_txn_quantity_addl pa_fp_res_assignments_tmp.

Line 3051: l_g_sum_txn_burdened_cost pa_budget_lines.txn_burdened_cost%TYPE;

3047:
3048: l_g_bl_count INTEGER;
3049: l_g_sum_txn_quantity pa_budget_lines.quantity%TYPE;
3050: l_g_sum_txn_raw_cost pa_budget_lines.txn_raw_cost%TYPE;
3051: l_g_sum_txn_burdened_cost pa_budget_lines.txn_burdened_cost%TYPE;
3052: l_g_sum_txn_revenue pa_budget_lines.txn_revenue%TYPE;
3053:
3054: l_txn_quantity_addl pa_fp_res_assignments_tmp.
3055: TXN_PLAN_QUANTITY%TYPE;

Line 3052: l_g_sum_txn_revenue pa_budget_lines.txn_revenue%TYPE;

3048: l_g_bl_count INTEGER;
3049: l_g_sum_txn_quantity pa_budget_lines.quantity%TYPE;
3050: l_g_sum_txn_raw_cost pa_budget_lines.txn_raw_cost%TYPE;
3051: l_g_sum_txn_burdened_cost pa_budget_lines.txn_burdened_cost%TYPE;
3052: l_g_sum_txn_revenue pa_budget_lines.txn_revenue%TYPE;
3053:
3054: l_txn_quantity_addl pa_fp_res_assignments_tmp.
3055: TXN_PLAN_QUANTITY%TYPE;
3056: l_txn_raw_cost_addl pa_fp_res_assignments_tmp.

Line 3093: FROM PA_BUDGET_LINES

3089: TXN_INIT_REVENUE,
3090: TXN_CURRENCY_CODE,
3091: BUDGET_LINE_ID,
3092: BUDGET_VERSION_ID
3093: FROM PA_BUDGET_LINES
3094: WHERE RESOURCE_ASSIGNMENT_ID = v_resource_assignment_id
3095: AND TXN_CURRENCY_CODE = v_txn_currency_code
3096: AND START_DATE BETWEEN l_line_start_date AND l_line_end_date
3097: AND END_DATE BETWEEN l_line_start_date AND l_line_end_date

Line 3122: FROM PA_BUDGET_LINES

3118: TXN_INIT_REVENUE,
3119: TXN_CURRENCY_CODE,
3120: BUDGET_LINE_ID,
3121: BUDGET_VERSION_ID
3122: FROM PA_BUDGET_LINES
3123: WHERE RESOURCE_ASSIGNMENT_ID = p_resAsgnId
3124: AND TXN_CURRENCY_CODE = p_txn_cur_code
3125: AND START_DATE BETWEEN p_line_start_date AND p_line_end_date
3126: AND END_DATE BETWEEN p_line_start_date AND p_line_end_date

Line 3133: FROM PA_BUDGET_LINES

3129:
3130: /* This Cursor is used for Non-Time phase budgets */
3131: CURSOR budget_line_time_phase_csr IS
3132: SELECT BUDGET_LINE_ID
3133: FROM PA_BUDGET_LINES
3134: WHERE RESOURCE_ASSIGNMENT_ID = v_resource_assignment_id
3135: AND TXN_CURRENCY_CODE = v_txn_currency_code
3136: --AND START_DATE = l_plan_start_date bug 6339811
3137: --AND END_DATE = l_plan_end_date bug 6339811

Line 3248: FROM pa_budget_lines bl

3244: ,sum(bl.txn_revenue)
3245: ,min(bl.budget_line_id)
3246: ,decode(min(bl.budget_line_id),NULL,0,1) NumOfBudgetLines
3247: ,sum(NVL(bl.quantity,0)-NVL(bl.init_quantity,0)) Etc_Quantity
3248: FROM pa_budget_lines bl
3249: WHERE bl.resource_assignment_id = p_resAsgnId
3250: AND bl.txn_currency_code = p_txn_cur_code
3251: AND bl.START_DATE BETWEEN p_start_date AND p_end_date
3252: AND bl.END_DATE BETWEEN p_start_date AND p_end_date ;

Line 3593: -- Insert into PA_BUDGET_LINES,

3589: print_msg('l_budget_line_time_phase_count['||l_budget_line_time_phase_count||']');
3590:
3591: IF l_budget_line_time_phase_count = 0 THEN
3592: --print_msg('Inserting records into budget line for l_budget_line_time_phase_count = 0');
3593: -- Insert into PA_BUDGET_LINES,
3594: insert_budget_line(
3595: v_resource_assignment_id,
3596: resource_assignment_rec.PLANNING_START_DATE,
3597: resource_assignment_rec.PLANNING_END_DATE,

Line 4083: -- Insert into PA_BUDGET_LINES,

4079: v_spread_amounts(i).amount3 <> 0 OR
4080: v_spread_amounts(i).amount4 IS NOT NULL AND
4081: v_spread_amounts(i).amount4 <> 0 THEN
4082:
4083: -- Insert into PA_BUDGET_LINES,
4084:
4085: insert_budget_line(
4086: v_resource_assignment_id,
4087: v_spread_amounts(i).start_date,

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

4217: ,v_txn_currency_code
4218: ,l_line_start_date
4219: ,l_line_end_date ) LOOP
4220:
4221: --print_msg('inside loop For each record in PA_BUDGET_LINES');
4222: -- get Budget Line ID and amounts
4223: -- update amounts based on existing distribution
4224:
4225:

Line 4523: -- Insert into PA_BUDGET_LINES,

4519: l_stage := 1049;
4520: print_msg(l_stage||' after get fixed date period ');
4521: print_msg(' '||v_spread_amounts(i).start_date||'/'||v_spread_amounts(i).end_date);
4522:
4523: -- Insert into PA_BUDGET_LINES,
4524:
4525: insert_budget_line(
4526: v_resource_assignment_id,
4527: v_spread_amounts(i).start_date,