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.

[Home] [Help]

APPS.PA_FP_CALC_PLAN_PKG dependencies on PA_FP_RES_ASSIGNMENTS_TMP

Line 30: g_line_start_date pa_fp_res_assignments_tmp.line_start_date%TYPE;

26: g_rollup_required_flag VARCHAR2(1) := 'Y';
27: g_wp_version_flag pa_budget_versions.wp_version_flag%TYPE;
28: g_proj_structure_ver_id NUMBER;
29: g_ra_bl_txn_currency_code pa_budget_lines.txn_currency_code%TYPE := NULL;
30: g_line_start_date pa_fp_res_assignments_tmp.line_start_date%TYPE;
31: g_line_end_date pa_fp_res_assignments_tmp.line_end_date%TYPE;
32: g_source_context pa_fp_res_assignments_tmp.source_context%TYPE;
33: g_clientExtn_api_call_flag VARCHAR2(1) := 'Y' ;
34: g_session_time VARCHAR2(30);

Line 31: g_line_end_date pa_fp_res_assignments_tmp.line_end_date%TYPE;

27: g_wp_version_flag pa_budget_versions.wp_version_flag%TYPE;
28: g_proj_structure_ver_id NUMBER;
29: g_ra_bl_txn_currency_code pa_budget_lines.txn_currency_code%TYPE := NULL;
30: g_line_start_date pa_fp_res_assignments_tmp.line_start_date%TYPE;
31: g_line_end_date pa_fp_res_assignments_tmp.line_end_date%TYPE;
32: g_source_context pa_fp_res_assignments_tmp.source_context%TYPE;
33: g_clientExtn_api_call_flag VARCHAR2(1) := 'Y' ;
34: g_session_time VARCHAR2(30);
35: g_owner_name Varchar2(100);

Line 32: g_source_context pa_fp_res_assignments_tmp.source_context%TYPE;

28: g_proj_structure_ver_id NUMBER;
29: g_ra_bl_txn_currency_code pa_budget_lines.txn_currency_code%TYPE := NULL;
30: g_line_start_date pa_fp_res_assignments_tmp.line_start_date%TYPE;
31: g_line_end_date pa_fp_res_assignments_tmp.line_end_date%TYPE;
32: g_source_context pa_fp_res_assignments_tmp.source_context%TYPE;
33: g_clientExtn_api_call_flag VARCHAR2(1) := 'Y' ;
34: g_session_time VARCHAR2(30);
35: g_owner_name Varchar2(100);
36: g_Plan_Class_Type VARCHAR2(100);

Line 1550: DELETE FROM pa_fp_res_assignments_tmp;

1546: l_unexpected_exception Exception;
1547: BEGIN
1548:
1549: --INITIALIZATION--
1550: DELETE FROM pa_fp_res_assignments_tmp;
1551: DELETE FROM pa_fp_rollup_tmp;
1552: DELETE FROM pa_fp_spread_calc_tmp;
1553: DELETE FROM pa_resource_asgn_curr_tmp;
1554:

Line 2241: ,p_source_context IN pa_fp_res_assignments_tmp.source_context%TYPE

2237: PROCEDURE Update_PCPFC_rounding_diff(
2238: p_project_id IN pa_budget_versions.project_id%type
2239: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
2240: ,p_calling_module IN VARCHAR2 DEFAULT NULL
2241: ,p_source_context IN pa_fp_res_assignments_tmp.source_context%TYPE
2242: ,p_wp_cost_enabled_flag IN varchar2
2243: ,p_budget_version_type IN varchar2
2244: ,x_return_status OUT NOCOPY VARCHAR2
2245: ,x_msg_count OUT NOCOPY NUMBER

Line 2560: ,p_source_context IN pa_fp_res_assignments_tmp.source_context%TYPE

2556: PROCEDURE Update_rounding_diff(
2557: p_project_id IN pa_budget_versions.project_id%type
2558: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
2559: ,p_calling_module IN VARCHAR2 DEFAULT NULL
2560: ,p_source_context IN pa_fp_res_assignments_tmp.source_context%TYPE
2561: ,p_wp_cost_enabled_flag IN varchar2
2562: ,p_budget_version_type IN varchar2
2563: ,x_return_status OUT NOCOPY VARCHAR2
2564: ,x_msg_count OUT NOCOPY NUMBER

Line 2809: ,p_source_context IN pa_fp_res_assignments_tmp.source_context%TYPE

2805: ,p_revenue_adj_pct IN NUMBER
2806: ,p_spread_required_flag IN VARCHAR2
2807: ,p_wp_cost_changed_flag IN VARCHAR2
2808: ,p_time_phase_changed_flag IN VARCHAR2
2809: ,p_source_context IN pa_fp_res_assignments_tmp.source_context%TYPE
2810: ,p_resource_assignment_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
2811: ,p_delete_budget_lines_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2812: ,p_spread_amts_flag_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()
2813: ,p_txn_currency_code_tab IN SYSTEM.pa_varchar2_15_tbl_type DEFAULT SYSTEM.pa_varchar2_15_tbl_type()

Line 5651: ,p_cost_override_rate IN pa_fp_res_assignments_tmp.rw_cost_rate_override%TYPE

5647: ,p_item_date IN pa_budget_lines.start_date%TYPE
5648: ,p_non_labor_resource IN pa_resource_assignments.non_labor_resource%TYPE
5649: ,p_expenditure_org_id IN pa_resource_assignments.rate_expenditure_org_id%TYPE
5650: ,p_nlr_organization_id IN pa_resource_assignments.organization_id%TYPE
5651: ,p_cost_override_rate IN pa_fp_res_assignments_tmp.rw_cost_rate_override%TYPE
5652: ,p_revenue_override_rate IN pa_fp_res_assignments_tmp.bill_rate_override%TYPE
5653: ,p_raw_cost IN pa_fp_res_assignments_tmp.txn_raw_cost%TYPE
5654: ,p_burden_cost IN pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE
5655: ,p_raw_revenue IN pa_fp_res_assignments_tmp.txn_revenue%TYPE

Line 5652: ,p_revenue_override_rate IN pa_fp_res_assignments_tmp.bill_rate_override%TYPE

5648: ,p_non_labor_resource IN pa_resource_assignments.non_labor_resource%TYPE
5649: ,p_expenditure_org_id IN pa_resource_assignments.rate_expenditure_org_id%TYPE
5650: ,p_nlr_organization_id IN pa_resource_assignments.organization_id%TYPE
5651: ,p_cost_override_rate IN pa_fp_res_assignments_tmp.rw_cost_rate_override%TYPE
5652: ,p_revenue_override_rate IN pa_fp_res_assignments_tmp.bill_rate_override%TYPE
5653: ,p_raw_cost IN pa_fp_res_assignments_tmp.txn_raw_cost%TYPE
5654: ,p_burden_cost IN pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE
5655: ,p_raw_revenue IN pa_fp_res_assignments_tmp.txn_revenue%TYPE
5656: ,p_override_currency_code IN pa_fp_res_assignments_tmp.txn_currency_code%TYPE

Line 5653: ,p_raw_cost IN pa_fp_res_assignments_tmp.txn_raw_cost%TYPE

5649: ,p_expenditure_org_id IN pa_resource_assignments.rate_expenditure_org_id%TYPE
5650: ,p_nlr_organization_id IN pa_resource_assignments.organization_id%TYPE
5651: ,p_cost_override_rate IN pa_fp_res_assignments_tmp.rw_cost_rate_override%TYPE
5652: ,p_revenue_override_rate IN pa_fp_res_assignments_tmp.bill_rate_override%TYPE
5653: ,p_raw_cost IN pa_fp_res_assignments_tmp.txn_raw_cost%TYPE
5654: ,p_burden_cost IN pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE
5655: ,p_raw_revenue IN pa_fp_res_assignments_tmp.txn_revenue%TYPE
5656: ,p_override_currency_code IN pa_fp_res_assignments_tmp.txn_currency_code%TYPE
5657: ,x_return_status OUT NOCOPY VARCHAR2

Line 5654: ,p_burden_cost IN pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE

5650: ,p_nlr_organization_id IN pa_resource_assignments.organization_id%TYPE
5651: ,p_cost_override_rate IN pa_fp_res_assignments_tmp.rw_cost_rate_override%TYPE
5652: ,p_revenue_override_rate IN pa_fp_res_assignments_tmp.bill_rate_override%TYPE
5653: ,p_raw_cost IN pa_fp_res_assignments_tmp.txn_raw_cost%TYPE
5654: ,p_burden_cost IN pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE
5655: ,p_raw_revenue IN pa_fp_res_assignments_tmp.txn_revenue%TYPE
5656: ,p_override_currency_code IN pa_fp_res_assignments_tmp.txn_currency_code%TYPE
5657: ,x_return_status OUT NOCOPY VARCHAR2
5658: ,x_msg_count OUT NOCOPY NUMBER

Line 5655: ,p_raw_revenue IN pa_fp_res_assignments_tmp.txn_revenue%TYPE

5651: ,p_cost_override_rate IN pa_fp_res_assignments_tmp.rw_cost_rate_override%TYPE
5652: ,p_revenue_override_rate IN pa_fp_res_assignments_tmp.bill_rate_override%TYPE
5653: ,p_raw_cost IN pa_fp_res_assignments_tmp.txn_raw_cost%TYPE
5654: ,p_burden_cost IN pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE
5655: ,p_raw_revenue IN pa_fp_res_assignments_tmp.txn_revenue%TYPE
5656: ,p_override_currency_code IN pa_fp_res_assignments_tmp.txn_currency_code%TYPE
5657: ,x_return_status OUT NOCOPY VARCHAR2
5658: ,x_msg_count OUT NOCOPY NUMBER
5659: ,x_msg_data OUT NOCOPY VARCHAR2

Line 5656: ,p_override_currency_code IN pa_fp_res_assignments_tmp.txn_currency_code%TYPE

5652: ,p_revenue_override_rate IN pa_fp_res_assignments_tmp.bill_rate_override%TYPE
5653: ,p_raw_cost IN pa_fp_res_assignments_tmp.txn_raw_cost%TYPE
5654: ,p_burden_cost IN pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE
5655: ,p_raw_revenue IN pa_fp_res_assignments_tmp.txn_revenue%TYPE
5656: ,p_override_currency_code IN pa_fp_res_assignments_tmp.txn_currency_code%TYPE
5657: ,x_return_status OUT NOCOPY VARCHAR2
5658: ,x_msg_count OUT NOCOPY NUMBER
5659: ,x_msg_data OUT NOCOPY VARCHAR2
5660: ) IS

Line 7129: INSERT INTO PA_FP_RES_ASSIGNMENTS_TMP

7125: print_msg('Inserting records into fp_res_assignment_tmp table count['||g_sprd_raId_tab.COUNT||']fst['||g_sprd_raId_tab.first||']Lst['||g_sprd_raId_tab.last||']');
7126: End If;
7127:
7128: FORALL i IN g_sprd_raId_tab.FIRST .. g_sprd_raId_tab.LAST
7129: INSERT INTO PA_FP_RES_ASSIGNMENTS_TMP
7130: (BUDGET_VERSION_ID
7131: ,PROJECT_ID
7132: ,TASK_ID
7133: ,RESOURCE_LIST_MEMBER_ID

Line 7867: ,p_source_context IN pa_fp_res_assignments_tmp.source_context%TYPE

7863: ,p_bill_rate_adj_pct IN NUMBER := NULL
7864: ,p_raw_cost_adj_pct IN NUMBER := NULL
7865: ,p_burden_cost_adj_pct IN NUMBER := NULL
7866: ,p_revenue_adj_pct IN NUMBER := NULL
7867: ,p_source_context IN pa_fp_res_assignments_tmp.source_context%TYPE
7868: ,p_calling_module IN VARCHAR2 DEFAULT 'UPDATE_PLAN_TRANSACTION'
7869: ,p_activity_code IN VARCHAR2 DEFAULT 'CALCULATE'
7870: ,p_resource_assignment_tab IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
7871: ,p_delete_budget_lines_tab IN SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type()

Line 8011: l_txn_raw_cost_total pa_fp_res_assignments_tmp.txn_raw_cost%TYPE;

8007: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
8008: -- end of pa_resource_assignemts local variables--
8009:
8010: --bug#14398131 :: added the following 3 variables l_txn_raw_cost_total, l_txn_burdened_cost_total and l_txn_revenue_total
8011: l_txn_raw_cost_total pa_fp_res_assignments_tmp.txn_raw_cost%TYPE;
8012: l_txn_burdened_cost_total pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE;
8013: l_txn_raw_cost_total_bl pa_fp_res_assignments_tmp.txn_raw_cost%TYPE;
8014: l_txn_burdened_cost_total_bl pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE;
8015:

Line 8012: l_txn_burdened_cost_total pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE;

8008: -- end of pa_resource_assignemts local variables--
8009:
8010: --bug#14398131 :: added the following 3 variables l_txn_raw_cost_total, l_txn_burdened_cost_total and l_txn_revenue_total
8011: l_txn_raw_cost_total pa_fp_res_assignments_tmp.txn_raw_cost%TYPE;
8012: l_txn_burdened_cost_total pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE;
8013: l_txn_raw_cost_total_bl pa_fp_res_assignments_tmp.txn_raw_cost%TYPE;
8014: l_txn_burdened_cost_total_bl pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE;
8015:
8016: l_txn_currency_code pa_fp_res_assignments_tmp.txn_currency_code%TYPE;

Line 8013: l_txn_raw_cost_total_bl pa_fp_res_assignments_tmp.txn_raw_cost%TYPE;

8009:
8010: --bug#14398131 :: added the following 3 variables l_txn_raw_cost_total, l_txn_burdened_cost_total and l_txn_revenue_total
8011: l_txn_raw_cost_total pa_fp_res_assignments_tmp.txn_raw_cost%TYPE;
8012: l_txn_burdened_cost_total pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE;
8013: l_txn_raw_cost_total_bl pa_fp_res_assignments_tmp.txn_raw_cost%TYPE;
8014: l_txn_burdened_cost_total_bl pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE;
8015:
8016: l_txn_currency_code pa_fp_res_assignments_tmp.txn_currency_code%TYPE;
8017: l_txn_revenue pa_fp_res_assignments_tmp.txn_revenue%TYPE;

Line 8014: l_txn_burdened_cost_total_bl pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE;

8010: --bug#14398131 :: added the following 3 variables l_txn_raw_cost_total, l_txn_burdened_cost_total and l_txn_revenue_total
8011: l_txn_raw_cost_total pa_fp_res_assignments_tmp.txn_raw_cost%TYPE;
8012: l_txn_burdened_cost_total pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE;
8013: l_txn_raw_cost_total_bl pa_fp_res_assignments_tmp.txn_raw_cost%TYPE;
8014: l_txn_burdened_cost_total_bl pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE;
8015:
8016: l_txn_currency_code pa_fp_res_assignments_tmp.txn_currency_code%TYPE;
8017: l_txn_revenue pa_fp_res_assignments_tmp.txn_revenue%TYPE;
8018: l_txn_revenue_addl pa_fp_res_assignments_tmp.txn_revenue_addl%TYPE;

Line 8016: l_txn_currency_code pa_fp_res_assignments_tmp.txn_currency_code%TYPE;

8012: l_txn_burdened_cost_total pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE;
8013: l_txn_raw_cost_total_bl pa_fp_res_assignments_tmp.txn_raw_cost%TYPE;
8014: l_txn_burdened_cost_total_bl pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE;
8015:
8016: l_txn_currency_code pa_fp_res_assignments_tmp.txn_currency_code%TYPE;
8017: l_txn_revenue pa_fp_res_assignments_tmp.txn_revenue%TYPE;
8018: l_txn_revenue_addl pa_fp_res_assignments_tmp.txn_revenue_addl%TYPE;
8019: l_txn_raw_cost pa_fp_res_assignments_tmp.txn_raw_cost%TYPE;
8020: l_txn_raw_cost_addl pa_fp_res_assignments_tmp.txn_raw_cost_addl%TYPE;

Line 8017: l_txn_revenue pa_fp_res_assignments_tmp.txn_revenue%TYPE;

8013: l_txn_raw_cost_total_bl pa_fp_res_assignments_tmp.txn_raw_cost%TYPE;
8014: l_txn_burdened_cost_total_bl pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE;
8015:
8016: l_txn_currency_code pa_fp_res_assignments_tmp.txn_currency_code%TYPE;
8017: l_txn_revenue pa_fp_res_assignments_tmp.txn_revenue%TYPE;
8018: l_txn_revenue_addl pa_fp_res_assignments_tmp.txn_revenue_addl%TYPE;
8019: l_txn_raw_cost pa_fp_res_assignments_tmp.txn_raw_cost%TYPE;
8020: l_txn_raw_cost_addl pa_fp_res_assignments_tmp.txn_raw_cost_addl%TYPE;
8021: l_txn_burdened_cost pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE;

Line 8018: l_txn_revenue_addl pa_fp_res_assignments_tmp.txn_revenue_addl%TYPE;

8014: l_txn_burdened_cost_total_bl pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE;
8015:
8016: l_txn_currency_code pa_fp_res_assignments_tmp.txn_currency_code%TYPE;
8017: l_txn_revenue pa_fp_res_assignments_tmp.txn_revenue%TYPE;
8018: l_txn_revenue_addl pa_fp_res_assignments_tmp.txn_revenue_addl%TYPE;
8019: l_txn_raw_cost pa_fp_res_assignments_tmp.txn_raw_cost%TYPE;
8020: l_txn_raw_cost_addl pa_fp_res_assignments_tmp.txn_raw_cost_addl%TYPE;
8021: l_txn_burdened_cost pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE;
8022: l_txn_burdened_cost_addl pa_fp_res_assignments_tmp.txn_burdened_cost_addl%TYPE;

Line 8019: l_txn_raw_cost pa_fp_res_assignments_tmp.txn_raw_cost%TYPE;

8015:
8016: l_txn_currency_code pa_fp_res_assignments_tmp.txn_currency_code%TYPE;
8017: l_txn_revenue pa_fp_res_assignments_tmp.txn_revenue%TYPE;
8018: l_txn_revenue_addl pa_fp_res_assignments_tmp.txn_revenue_addl%TYPE;
8019: l_txn_raw_cost pa_fp_res_assignments_tmp.txn_raw_cost%TYPE;
8020: l_txn_raw_cost_addl pa_fp_res_assignments_tmp.txn_raw_cost_addl%TYPE;
8021: l_txn_burdened_cost pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE;
8022: l_txn_burdened_cost_addl pa_fp_res_assignments_tmp.txn_burdened_cost_addl%TYPE;
8023: l_txn_plan_quantity pa_fp_res_assignments_tmp.txn_plan_quantity%TYPE;

Line 8020: l_txn_raw_cost_addl pa_fp_res_assignments_tmp.txn_raw_cost_addl%TYPE;

8016: l_txn_currency_code pa_fp_res_assignments_tmp.txn_currency_code%TYPE;
8017: l_txn_revenue pa_fp_res_assignments_tmp.txn_revenue%TYPE;
8018: l_txn_revenue_addl pa_fp_res_assignments_tmp.txn_revenue_addl%TYPE;
8019: l_txn_raw_cost pa_fp_res_assignments_tmp.txn_raw_cost%TYPE;
8020: l_txn_raw_cost_addl pa_fp_res_assignments_tmp.txn_raw_cost_addl%TYPE;
8021: l_txn_burdened_cost pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE;
8022: l_txn_burdened_cost_addl pa_fp_res_assignments_tmp.txn_burdened_cost_addl%TYPE;
8023: l_txn_plan_quantity pa_fp_res_assignments_tmp.txn_plan_quantity%TYPE;
8024: l_txn_plan_quantity_addl pa_fp_res_assignments_tmp.txn_plan_quantity_addl%TYPE;

Line 8021: l_txn_burdened_cost pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE;

8017: l_txn_revenue pa_fp_res_assignments_tmp.txn_revenue%TYPE;
8018: l_txn_revenue_addl pa_fp_res_assignments_tmp.txn_revenue_addl%TYPE;
8019: l_txn_raw_cost pa_fp_res_assignments_tmp.txn_raw_cost%TYPE;
8020: l_txn_raw_cost_addl pa_fp_res_assignments_tmp.txn_raw_cost_addl%TYPE;
8021: l_txn_burdened_cost pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE;
8022: l_txn_burdened_cost_addl pa_fp_res_assignments_tmp.txn_burdened_cost_addl%TYPE;
8023: l_txn_plan_quantity pa_fp_res_assignments_tmp.txn_plan_quantity%TYPE;
8024: l_txn_plan_quantity_addl pa_fp_res_assignments_tmp.txn_plan_quantity_addl%TYPE;
8025: l_txn_currency_code_override pa_fp_res_assignments_tmp.txn_currency_code_override%TYPE;

Line 8022: l_txn_burdened_cost_addl pa_fp_res_assignments_tmp.txn_burdened_cost_addl%TYPE;

8018: l_txn_revenue_addl pa_fp_res_assignments_tmp.txn_revenue_addl%TYPE;
8019: l_txn_raw_cost pa_fp_res_assignments_tmp.txn_raw_cost%TYPE;
8020: l_txn_raw_cost_addl pa_fp_res_assignments_tmp.txn_raw_cost_addl%TYPE;
8021: l_txn_burdened_cost pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE;
8022: l_txn_burdened_cost_addl pa_fp_res_assignments_tmp.txn_burdened_cost_addl%TYPE;
8023: l_txn_plan_quantity pa_fp_res_assignments_tmp.txn_plan_quantity%TYPE;
8024: l_txn_plan_quantity_addl pa_fp_res_assignments_tmp.txn_plan_quantity_addl%TYPE;
8025: l_txn_currency_code_override pa_fp_res_assignments_tmp.txn_currency_code_override%TYPE;
8026: l_txn_init_revenue pa_fp_res_assignments_tmp.txn_init_revenue%TYPE;

Line 8023: l_txn_plan_quantity pa_fp_res_assignments_tmp.txn_plan_quantity%TYPE;

8019: l_txn_raw_cost pa_fp_res_assignments_tmp.txn_raw_cost%TYPE;
8020: l_txn_raw_cost_addl pa_fp_res_assignments_tmp.txn_raw_cost_addl%TYPE;
8021: l_txn_burdened_cost pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE;
8022: l_txn_burdened_cost_addl pa_fp_res_assignments_tmp.txn_burdened_cost_addl%TYPE;
8023: l_txn_plan_quantity pa_fp_res_assignments_tmp.txn_plan_quantity%TYPE;
8024: l_txn_plan_quantity_addl pa_fp_res_assignments_tmp.txn_plan_quantity_addl%TYPE;
8025: l_txn_currency_code_override pa_fp_res_assignments_tmp.txn_currency_code_override%TYPE;
8026: l_txn_init_revenue pa_fp_res_assignments_tmp.txn_init_revenue%TYPE;
8027: l_txn_init_revenue_addl pa_fp_res_assignments_tmp.txn_init_revenue_addl%TYPE;

Line 8024: l_txn_plan_quantity_addl pa_fp_res_assignments_tmp.txn_plan_quantity_addl%TYPE;

8020: l_txn_raw_cost_addl pa_fp_res_assignments_tmp.txn_raw_cost_addl%TYPE;
8021: l_txn_burdened_cost pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE;
8022: l_txn_burdened_cost_addl pa_fp_res_assignments_tmp.txn_burdened_cost_addl%TYPE;
8023: l_txn_plan_quantity pa_fp_res_assignments_tmp.txn_plan_quantity%TYPE;
8024: l_txn_plan_quantity_addl pa_fp_res_assignments_tmp.txn_plan_quantity_addl%TYPE;
8025: l_txn_currency_code_override pa_fp_res_assignments_tmp.txn_currency_code_override%TYPE;
8026: l_txn_init_revenue pa_fp_res_assignments_tmp.txn_init_revenue%TYPE;
8027: l_txn_init_revenue_addl pa_fp_res_assignments_tmp.txn_init_revenue_addl%TYPE;
8028: l_txn_init_raw_cost pa_fp_res_assignments_tmp.txn_init_raw_cost%TYPE;

Line 8025: l_txn_currency_code_override pa_fp_res_assignments_tmp.txn_currency_code_override%TYPE;

8021: l_txn_burdened_cost pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE;
8022: l_txn_burdened_cost_addl pa_fp_res_assignments_tmp.txn_burdened_cost_addl%TYPE;
8023: l_txn_plan_quantity pa_fp_res_assignments_tmp.txn_plan_quantity%TYPE;
8024: l_txn_plan_quantity_addl pa_fp_res_assignments_tmp.txn_plan_quantity_addl%TYPE;
8025: l_txn_currency_code_override pa_fp_res_assignments_tmp.txn_currency_code_override%TYPE;
8026: l_txn_init_revenue pa_fp_res_assignments_tmp.txn_init_revenue%TYPE;
8027: l_txn_init_revenue_addl pa_fp_res_assignments_tmp.txn_init_revenue_addl%TYPE;
8028: l_txn_init_raw_cost pa_fp_res_assignments_tmp.txn_init_raw_cost%TYPE;
8029: l_txn_init_raw_cost_addl pa_fp_res_assignments_tmp.txn_init_raw_cost_addl%TYPE;

Line 8026: l_txn_init_revenue pa_fp_res_assignments_tmp.txn_init_revenue%TYPE;

8022: l_txn_burdened_cost_addl pa_fp_res_assignments_tmp.txn_burdened_cost_addl%TYPE;
8023: l_txn_plan_quantity pa_fp_res_assignments_tmp.txn_plan_quantity%TYPE;
8024: l_txn_plan_quantity_addl pa_fp_res_assignments_tmp.txn_plan_quantity_addl%TYPE;
8025: l_txn_currency_code_override pa_fp_res_assignments_tmp.txn_currency_code_override%TYPE;
8026: l_txn_init_revenue pa_fp_res_assignments_tmp.txn_init_revenue%TYPE;
8027: l_txn_init_revenue_addl pa_fp_res_assignments_tmp.txn_init_revenue_addl%TYPE;
8028: l_txn_init_raw_cost pa_fp_res_assignments_tmp.txn_init_raw_cost%TYPE;
8029: l_txn_init_raw_cost_addl pa_fp_res_assignments_tmp.txn_init_raw_cost_addl%TYPE;
8030: l_txn_init_burdened_cost pa_fp_res_assignments_tmp.txn_init_burdened_cost%TYPE;

Line 8027: l_txn_init_revenue_addl pa_fp_res_assignments_tmp.txn_init_revenue_addl%TYPE;

8023: l_txn_plan_quantity pa_fp_res_assignments_tmp.txn_plan_quantity%TYPE;
8024: l_txn_plan_quantity_addl pa_fp_res_assignments_tmp.txn_plan_quantity_addl%TYPE;
8025: l_txn_currency_code_override pa_fp_res_assignments_tmp.txn_currency_code_override%TYPE;
8026: l_txn_init_revenue pa_fp_res_assignments_tmp.txn_init_revenue%TYPE;
8027: l_txn_init_revenue_addl pa_fp_res_assignments_tmp.txn_init_revenue_addl%TYPE;
8028: l_txn_init_raw_cost pa_fp_res_assignments_tmp.txn_init_raw_cost%TYPE;
8029: l_txn_init_raw_cost_addl pa_fp_res_assignments_tmp.txn_init_raw_cost_addl%TYPE;
8030: l_txn_init_burdened_cost pa_fp_res_assignments_tmp.txn_init_burdened_cost%TYPE;
8031: l_txn_init_burdened_cost_addl pa_fp_res_assignments_tmp.txn_init_burdened_cost_addl%TYPE;

Line 8028: l_txn_init_raw_cost pa_fp_res_assignments_tmp.txn_init_raw_cost%TYPE;

8024: l_txn_plan_quantity_addl pa_fp_res_assignments_tmp.txn_plan_quantity_addl%TYPE;
8025: l_txn_currency_code_override pa_fp_res_assignments_tmp.txn_currency_code_override%TYPE;
8026: l_txn_init_revenue pa_fp_res_assignments_tmp.txn_init_revenue%TYPE;
8027: l_txn_init_revenue_addl pa_fp_res_assignments_tmp.txn_init_revenue_addl%TYPE;
8028: l_txn_init_raw_cost pa_fp_res_assignments_tmp.txn_init_raw_cost%TYPE;
8029: l_txn_init_raw_cost_addl pa_fp_res_assignments_tmp.txn_init_raw_cost_addl%TYPE;
8030: l_txn_init_burdened_cost pa_fp_res_assignments_tmp.txn_init_burdened_cost%TYPE;
8031: l_txn_init_burdened_cost_addl pa_fp_res_assignments_tmp.txn_init_burdened_cost_addl%TYPE;
8032: l_init_quantity pa_fp_res_assignments_tmp.init_quantity%TYPE;

Line 8029: l_txn_init_raw_cost_addl pa_fp_res_assignments_tmp.txn_init_raw_cost_addl%TYPE;

8025: l_txn_currency_code_override pa_fp_res_assignments_tmp.txn_currency_code_override%TYPE;
8026: l_txn_init_revenue pa_fp_res_assignments_tmp.txn_init_revenue%TYPE;
8027: l_txn_init_revenue_addl pa_fp_res_assignments_tmp.txn_init_revenue_addl%TYPE;
8028: l_txn_init_raw_cost pa_fp_res_assignments_tmp.txn_init_raw_cost%TYPE;
8029: l_txn_init_raw_cost_addl pa_fp_res_assignments_tmp.txn_init_raw_cost_addl%TYPE;
8030: l_txn_init_burdened_cost pa_fp_res_assignments_tmp.txn_init_burdened_cost%TYPE;
8031: l_txn_init_burdened_cost_addl pa_fp_res_assignments_tmp.txn_init_burdened_cost_addl%TYPE;
8032: l_init_quantity pa_fp_res_assignments_tmp.init_quantity%TYPE;
8033: l_init_quantity_addl pa_fp_res_assignments_tmp.init_quantity_addl%TYPE;

Line 8030: l_txn_init_burdened_cost pa_fp_res_assignments_tmp.txn_init_burdened_cost%TYPE;

8026: l_txn_init_revenue pa_fp_res_assignments_tmp.txn_init_revenue%TYPE;
8027: l_txn_init_revenue_addl pa_fp_res_assignments_tmp.txn_init_revenue_addl%TYPE;
8028: l_txn_init_raw_cost pa_fp_res_assignments_tmp.txn_init_raw_cost%TYPE;
8029: l_txn_init_raw_cost_addl pa_fp_res_assignments_tmp.txn_init_raw_cost_addl%TYPE;
8030: l_txn_init_burdened_cost pa_fp_res_assignments_tmp.txn_init_burdened_cost%TYPE;
8031: l_txn_init_burdened_cost_addl pa_fp_res_assignments_tmp.txn_init_burdened_cost_addl%TYPE;
8032: l_init_quantity pa_fp_res_assignments_tmp.init_quantity%TYPE;
8033: l_init_quantity_addl pa_fp_res_assignments_tmp.init_quantity_addl%TYPE;
8034: l_spread_amounts_flag pa_fp_res_assignments_tmp.spread_amounts_flag%TYPE;

Line 8031: l_txn_init_burdened_cost_addl pa_fp_res_assignments_tmp.txn_init_burdened_cost_addl%TYPE;

8027: l_txn_init_revenue_addl pa_fp_res_assignments_tmp.txn_init_revenue_addl%TYPE;
8028: l_txn_init_raw_cost pa_fp_res_assignments_tmp.txn_init_raw_cost%TYPE;
8029: l_txn_init_raw_cost_addl pa_fp_res_assignments_tmp.txn_init_raw_cost_addl%TYPE;
8030: l_txn_init_burdened_cost pa_fp_res_assignments_tmp.txn_init_burdened_cost%TYPE;
8031: l_txn_init_burdened_cost_addl pa_fp_res_assignments_tmp.txn_init_burdened_cost_addl%TYPE;
8032: l_init_quantity pa_fp_res_assignments_tmp.init_quantity%TYPE;
8033: l_init_quantity_addl pa_fp_res_assignments_tmp.init_quantity_addl%TYPE;
8034: l_spread_amounts_flag pa_fp_res_assignments_tmp.spread_amounts_flag%TYPE;
8035: l_raw_cost_rate pa_fp_res_assignments_tmp.raw_cost_rate%TYPE;

Line 8032: l_init_quantity pa_fp_res_assignments_tmp.init_quantity%TYPE;

8028: l_txn_init_raw_cost pa_fp_res_assignments_tmp.txn_init_raw_cost%TYPE;
8029: l_txn_init_raw_cost_addl pa_fp_res_assignments_tmp.txn_init_raw_cost_addl%TYPE;
8030: l_txn_init_burdened_cost pa_fp_res_assignments_tmp.txn_init_burdened_cost%TYPE;
8031: l_txn_init_burdened_cost_addl pa_fp_res_assignments_tmp.txn_init_burdened_cost_addl%TYPE;
8032: l_init_quantity pa_fp_res_assignments_tmp.init_quantity%TYPE;
8033: l_init_quantity_addl pa_fp_res_assignments_tmp.init_quantity_addl%TYPE;
8034: l_spread_amounts_flag pa_fp_res_assignments_tmp.spread_amounts_flag%TYPE;
8035: l_raw_cost_rate pa_fp_res_assignments_tmp.raw_cost_rate%TYPE;
8036: l_rw_cost_rate_override pa_fp_res_assignments_tmp.rw_cost_rate_override%TYPE;

Line 8033: l_init_quantity_addl pa_fp_res_assignments_tmp.init_quantity_addl%TYPE;

8029: l_txn_init_raw_cost_addl pa_fp_res_assignments_tmp.txn_init_raw_cost_addl%TYPE;
8030: l_txn_init_burdened_cost pa_fp_res_assignments_tmp.txn_init_burdened_cost%TYPE;
8031: l_txn_init_burdened_cost_addl pa_fp_res_assignments_tmp.txn_init_burdened_cost_addl%TYPE;
8032: l_init_quantity pa_fp_res_assignments_tmp.init_quantity%TYPE;
8033: l_init_quantity_addl pa_fp_res_assignments_tmp.init_quantity_addl%TYPE;
8034: l_spread_amounts_flag pa_fp_res_assignments_tmp.spread_amounts_flag%TYPE;
8035: l_raw_cost_rate pa_fp_res_assignments_tmp.raw_cost_rate%TYPE;
8036: l_rw_cost_rate_override pa_fp_res_assignments_tmp.rw_cost_rate_override%TYPE;
8037: l_burden_cost_rate pa_fp_res_assignments_tmp.burden_cost_rate%TYPE;

Line 8034: l_spread_amounts_flag pa_fp_res_assignments_tmp.spread_amounts_flag%TYPE;

8030: l_txn_init_burdened_cost pa_fp_res_assignments_tmp.txn_init_burdened_cost%TYPE;
8031: l_txn_init_burdened_cost_addl pa_fp_res_assignments_tmp.txn_init_burdened_cost_addl%TYPE;
8032: l_init_quantity pa_fp_res_assignments_tmp.init_quantity%TYPE;
8033: l_init_quantity_addl pa_fp_res_assignments_tmp.init_quantity_addl%TYPE;
8034: l_spread_amounts_flag pa_fp_res_assignments_tmp.spread_amounts_flag%TYPE;
8035: l_raw_cost_rate pa_fp_res_assignments_tmp.raw_cost_rate%TYPE;
8036: l_rw_cost_rate_override pa_fp_res_assignments_tmp.rw_cost_rate_override%TYPE;
8037: l_burden_cost_rate pa_fp_res_assignments_tmp.burden_cost_rate%TYPE;
8038: l_burden_cost_rate_override pa_fp_res_assignments_tmp.burden_cost_rate_override%TYPE;

Line 8035: l_raw_cost_rate pa_fp_res_assignments_tmp.raw_cost_rate%TYPE;

8031: l_txn_init_burdened_cost_addl pa_fp_res_assignments_tmp.txn_init_burdened_cost_addl%TYPE;
8032: l_init_quantity pa_fp_res_assignments_tmp.init_quantity%TYPE;
8033: l_init_quantity_addl pa_fp_res_assignments_tmp.init_quantity_addl%TYPE;
8034: l_spread_amounts_flag pa_fp_res_assignments_tmp.spread_amounts_flag%TYPE;
8035: l_raw_cost_rate pa_fp_res_assignments_tmp.raw_cost_rate%TYPE;
8036: l_rw_cost_rate_override pa_fp_res_assignments_tmp.rw_cost_rate_override%TYPE;
8037: l_burden_cost_rate pa_fp_res_assignments_tmp.burden_cost_rate%TYPE;
8038: l_burden_cost_rate_override pa_fp_res_assignments_tmp.burden_cost_rate_override%TYPE;
8039: l_bill_rate pa_fp_res_assignments_tmp.bill_rate%TYPE;

Line 8036: l_rw_cost_rate_override pa_fp_res_assignments_tmp.rw_cost_rate_override%TYPE;

8032: l_init_quantity pa_fp_res_assignments_tmp.init_quantity%TYPE;
8033: l_init_quantity_addl pa_fp_res_assignments_tmp.init_quantity_addl%TYPE;
8034: l_spread_amounts_flag pa_fp_res_assignments_tmp.spread_amounts_flag%TYPE;
8035: l_raw_cost_rate pa_fp_res_assignments_tmp.raw_cost_rate%TYPE;
8036: l_rw_cost_rate_override pa_fp_res_assignments_tmp.rw_cost_rate_override%TYPE;
8037: l_burden_cost_rate pa_fp_res_assignments_tmp.burden_cost_rate%TYPE;
8038: l_burden_cost_rate_override pa_fp_res_assignments_tmp.burden_cost_rate_override%TYPE;
8039: l_bill_rate pa_fp_res_assignments_tmp.bill_rate%TYPE;
8040: l_bill_rate_override pa_fp_res_assignments_tmp.bill_rate_override%TYPE;

Line 8037: l_burden_cost_rate pa_fp_res_assignments_tmp.burden_cost_rate%TYPE;

8033: l_init_quantity_addl pa_fp_res_assignments_tmp.init_quantity_addl%TYPE;
8034: l_spread_amounts_flag pa_fp_res_assignments_tmp.spread_amounts_flag%TYPE;
8035: l_raw_cost_rate pa_fp_res_assignments_tmp.raw_cost_rate%TYPE;
8036: l_rw_cost_rate_override pa_fp_res_assignments_tmp.rw_cost_rate_override%TYPE;
8037: l_burden_cost_rate pa_fp_res_assignments_tmp.burden_cost_rate%TYPE;
8038: l_burden_cost_rate_override pa_fp_res_assignments_tmp.burden_cost_rate_override%TYPE;
8039: l_bill_rate pa_fp_res_assignments_tmp.bill_rate%TYPE;
8040: l_bill_rate_override pa_fp_res_assignments_tmp.bill_rate_override%TYPE;
8041: l_org_id pa_projects_all.org_id%TYPE;

Line 8038: l_burden_cost_rate_override pa_fp_res_assignments_tmp.burden_cost_rate_override%TYPE;

8034: l_spread_amounts_flag pa_fp_res_assignments_tmp.spread_amounts_flag%TYPE;
8035: l_raw_cost_rate pa_fp_res_assignments_tmp.raw_cost_rate%TYPE;
8036: l_rw_cost_rate_override pa_fp_res_assignments_tmp.rw_cost_rate_override%TYPE;
8037: l_burden_cost_rate pa_fp_res_assignments_tmp.burden_cost_rate%TYPE;
8038: l_burden_cost_rate_override pa_fp_res_assignments_tmp.burden_cost_rate_override%TYPE;
8039: l_bill_rate pa_fp_res_assignments_tmp.bill_rate%TYPE;
8040: l_bill_rate_override pa_fp_res_assignments_tmp.bill_rate_override%TYPE;
8041: l_org_id pa_projects_all.org_id%TYPE;
8042:

Line 8039: l_bill_rate pa_fp_res_assignments_tmp.bill_rate%TYPE;

8035: l_raw_cost_rate pa_fp_res_assignments_tmp.raw_cost_rate%TYPE;
8036: l_rw_cost_rate_override pa_fp_res_assignments_tmp.rw_cost_rate_override%TYPE;
8037: l_burden_cost_rate pa_fp_res_assignments_tmp.burden_cost_rate%TYPE;
8038: l_burden_cost_rate_override pa_fp_res_assignments_tmp.burden_cost_rate_override%TYPE;
8039: l_bill_rate pa_fp_res_assignments_tmp.bill_rate%TYPE;
8040: l_bill_rate_override pa_fp_res_assignments_tmp.bill_rate_override%TYPE;
8041: l_org_id pa_projects_all.org_id%TYPE;
8042:
8043: l_cost_rt_miss_num_flag VARCHAR2(1) := NULL;

Line 8040: l_bill_rate_override pa_fp_res_assignments_tmp.bill_rate_override%TYPE;

8036: l_rw_cost_rate_override pa_fp_res_assignments_tmp.rw_cost_rate_override%TYPE;
8037: l_burden_cost_rate pa_fp_res_assignments_tmp.burden_cost_rate%TYPE;
8038: l_burden_cost_rate_override pa_fp_res_assignments_tmp.burden_cost_rate_override%TYPE;
8039: l_bill_rate pa_fp_res_assignments_tmp.bill_rate%TYPE;
8040: l_bill_rate_override pa_fp_res_assignments_tmp.bill_rate_override%TYPE;
8041: l_org_id pa_projects_all.org_id%TYPE;
8042:
8043: l_cost_rt_miss_num_flag VARCHAR2(1) := NULL;
8044: l_burd_rt_miss_num_flag VARCHAR2(1) := NULL;

Line 10073: -- Populate global temporary table pa_fp_res_assignments_tmp with values assigned to

10069: If P_PA_DEBUG_MODE = 'Y' Then
10070: print_msg(to_char(l_stage)||' Spread Required populte the resAss tmp');
10071: End If;
10072: /*
10073: -- Populate global temporary table pa_fp_res_assignments_tmp with values assigned to
10074: -- the local variables. The spread api queries this table for values
10075: */
10076: BEGIN
10077: /* THIS LOGIC HAS BEEN SHIFTED TO THE SPREAD API

Line 10142: print_msg(to_char(l_stage)||' ERROR Inserting into pa_fp_res_assignments_tmp');

10138: g_sprd_neg_Burd_Changflag_tab(NVL(g_sprd_neg_Burd_Changflag_tab.last,0)+1) :=l_neg_Burd_Changflag_tab(i);
10139: g_sprd_neg_rev_Changflag_tab(NVL(g_sprd_neg_rev_Changflag_tab.last,0)+1) := l_neg_rev_Changflag_tab(i);
10140: EXCEPTION
10141: WHEN OTHERS THEN
10142: print_msg(to_char(l_stage)||' ***ERROR*** Inserting into pa_fp_res_assignments_tmp');
10143: pa_debug.g_err_stage := to_char(l_stage)||': ***ERROR*** Inserting into pa_fp_res_assignments_tmp';
10144: RAISE;
10145: END;
10146: /* Bug fix:4295967 */

Line 10143: pa_debug.g_err_stage := to_char(l_stage)||': ERROR Inserting into pa_fp_res_assignments_tmp';

10139: g_sprd_neg_rev_Changflag_tab(NVL(g_sprd_neg_rev_Changflag_tab.last,0)+1) := l_neg_rev_Changflag_tab(i);
10140: EXCEPTION
10141: WHEN OTHERS THEN
10142: print_msg(to_char(l_stage)||' ***ERROR*** Inserting into pa_fp_res_assignments_tmp');
10143: pa_debug.g_err_stage := to_char(l_stage)||': ***ERROR*** Inserting into pa_fp_res_assignments_tmp';
10144: RAISE;
10145: END;
10146: /* Bug fix:4295967 */
10147: ELSIF (NVL(p_apply_progress_flag,'N') = 'Y'