43: lx_act_pc_brdn_cost NUMBER;
44: lx_act_pfc_raw_cost NUMBER;
45: lx_act_pfc_brdn_cost NUMBER;
46:
47: l_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
48: l_act_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
49: l_act_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
50: l_act_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
51: l_act_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
44: lx_act_pfc_raw_cost NUMBER;
45: lx_act_pfc_brdn_cost NUMBER;
46:
47: l_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
48: l_act_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
49: l_act_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
50: l_act_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
51: l_act_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
52: l_target_version_type pa_budget_versions.version_type%type;
45: lx_act_pfc_brdn_cost NUMBER;
46:
47: l_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
48: l_act_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
49: l_act_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
50: l_act_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
51: l_act_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
52: l_target_version_type pa_budget_versions.version_type%type;
53:
46:
47: l_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
48: l_act_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
49: l_act_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
50: l_act_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
51: l_act_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
52: l_target_version_type pa_budget_versions.version_type%type;
53:
54: l_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
47: l_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
48: l_act_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
49: l_act_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
50: l_act_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
51: l_act_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
52: l_target_version_type pa_budget_versions.version_type%type;
53:
54: l_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
55:
50: l_act_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
51: l_act_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
52: l_target_version_type pa_budget_versions.version_type%type;
53:
54: l_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
55:
56: /*For average rates*/
57: l_pc_rate_quantity NUMBER;
58: l_pc_rate_raw_cost NUMBER;
66: l_txn_rate_raw_cost NUMBER;
67: l_txn_rate_brdn_cost NUMBER;
68: l_txn_rate_revenue NUMBER;
69:
70: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
71: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
72: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
73: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
74: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
67: l_txn_rate_brdn_cost NUMBER;
68: l_txn_rate_revenue NUMBER;
69:
70: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
71: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
72: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
73: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
74: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
75: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
68: l_txn_rate_revenue NUMBER;
69:
70: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
71: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
72: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
73: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
74: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
75: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
76: l_pfc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
69:
70: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
71: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
72: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
73: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
74: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
75: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
76: l_pfc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
77: l_pfc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
70: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
71: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
72: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
73: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
74: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
75: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
76: l_pfc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
77: l_pfc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
78: l_pfc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
71: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
72: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
73: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
74: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
75: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
76: l_pfc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
77: l_pfc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
78: l_pfc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
79: l_transaction_source_code VARCHAR2(30);
72: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
73: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
74: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
75: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
76: l_pfc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
77: l_pfc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
78: l_pfc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
79: l_transaction_source_code VARCHAR2(30);
80:
73: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
74: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
75: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
76: l_pfc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
77: l_pfc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
78: l_pfc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
79: l_transaction_source_code VARCHAR2(30);
80:
81: l_msg_count NUMBER;
74: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
75: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
76: l_pfc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
77: l_pfc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
78: l_pfc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
79: l_transaction_source_code VARCHAR2(30);
80:
81: l_msg_count NUMBER;
82: l_msg_data VARCHAR2(2000);
505: END GET_ETC_EARNED_VALUE_AMTS;
506:
507:
508: PROCEDURE GET_ETC_EARNED_VALUE_AMTS_BLK (
509: P_SRC_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
510: P_TGT_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
511: P_FP_COLS_SRC_REC_FP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
512: P_FP_COLS_SRC_REC_WP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
513: P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
506:
507:
508: PROCEDURE GET_ETC_EARNED_VALUE_AMTS_BLK (
509: P_SRC_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
510: P_TGT_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
511: P_FP_COLS_SRC_REC_FP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
512: P_FP_COLS_SRC_REC_WP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
513: P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
514: P_TASK_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
510: P_TGT_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
511: P_FP_COLS_SRC_REC_FP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
512: P_FP_COLS_SRC_REC_WP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
513: P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
514: P_TASK_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
515: P_RES_LIST_MEMBER_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
516: P_CBS_ELEMENT_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp, --bug#16791711
517: P_ETC_SOURCE_CODE_TAB IN PA_PLSQL_DATATYPES.Char30TabTyp,
518: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
511: P_FP_COLS_SRC_REC_FP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
512: P_FP_COLS_SRC_REC_WP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
513: P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
514: P_TASK_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
515: P_RES_LIST_MEMBER_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
516: P_CBS_ELEMENT_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp, --bug#16791711
517: P_ETC_SOURCE_CODE_TAB IN PA_PLSQL_DATATYPES.Char30TabTyp,
518: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
519: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
512: P_FP_COLS_SRC_REC_WP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
513: P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
514: P_TASK_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
515: P_RES_LIST_MEMBER_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
516: P_CBS_ELEMENT_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp, --bug#16791711
517: P_ETC_SOURCE_CODE_TAB IN PA_PLSQL_DATATYPES.Char30TabTyp,
518: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
519: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
520: P_PLANNING_OPTIONS_FLAG IN VARCHAR2,
513: P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
514: P_TASK_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
515: P_RES_LIST_MEMBER_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
516: P_CBS_ELEMENT_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp, --bug#16791711
517: P_ETC_SOURCE_CODE_TAB IN PA_PLSQL_DATATYPES.Char30TabTyp,
518: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
519: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
520: P_PLANNING_OPTIONS_FLAG IN VARCHAR2,
521: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
547: lx_act_pc_brdn_cost NUMBER;
548: lx_act_pfc_raw_cost NUMBER;
549: lx_act_pfc_brdn_cost NUMBER;
550:
551: l_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
552: l_act_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
553: l_act_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
554: l_act_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
555: l_act_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
548: lx_act_pfc_raw_cost NUMBER;
549: lx_act_pfc_brdn_cost NUMBER;
550:
551: l_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
552: l_act_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
553: l_act_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
554: l_act_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
555: l_act_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
556: l_target_version_type pa_budget_versions.version_type%type;
549: lx_act_pfc_brdn_cost NUMBER;
550:
551: l_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
552: l_act_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
553: l_act_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
554: l_act_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
555: l_act_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
556: l_target_version_type pa_budget_versions.version_type%type;
557:
550:
551: l_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
552: l_act_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
553: l_act_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
554: l_act_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
555: l_act_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
556: l_target_version_type pa_budget_versions.version_type%type;
557:
558: l_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
551: l_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
552: l_act_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
553: l_act_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
554: l_act_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
555: l_act_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
556: l_target_version_type pa_budget_versions.version_type%type;
557:
558: l_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
559:
554: l_act_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
555: l_act_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
556: l_target_version_type pa_budget_versions.version_type%type;
557:
558: l_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
559:
560: /*For average rates*/
561: l_pc_rate_quantity NUMBER;
562: l_pc_rate_raw_cost NUMBER;
570: l_txn_rate_raw_cost NUMBER;
571: l_txn_rate_brdn_cost NUMBER;
572: l_txn_rate_revenue NUMBER;
573:
574: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
575: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
576: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
577: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
578: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
571: l_txn_rate_brdn_cost NUMBER;
572: l_txn_rate_revenue NUMBER;
573:
574: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
575: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
576: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
577: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
578: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
579: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
572: l_txn_rate_revenue NUMBER;
573:
574: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
575: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
576: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
577: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
578: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
579: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
580: l_pfc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
573:
574: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
575: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
576: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
577: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
578: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
579: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
580: l_pfc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
581: l_pfc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
574: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
575: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
576: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
577: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
578: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
579: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
580: l_pfc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
581: l_pfc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
582: l_pfc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
575: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
576: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
577: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
578: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
579: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
580: l_pfc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
581: l_pfc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
582: l_pfc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
583: l_transaction_source_code VARCHAR2(30);
576: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
577: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
578: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
579: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
580: l_pfc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
581: l_pfc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
582: l_pfc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
583: l_transaction_source_code VARCHAR2(30);
584:
577: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
578: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
579: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
580: l_pfc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
581: l_pfc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
582: l_pfc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
583: l_transaction_source_code VARCHAR2(30);
584:
585: /*Added for Bulk insert at version level*/
578: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
579: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
580: l_pfc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
581: l_pfc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
582: l_pfc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
583: l_transaction_source_code VARCHAR2(30);
584:
585: /*Added for Bulk insert at version level*/
586: l_blk_src_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
582: l_pfc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
583: l_transaction_source_code VARCHAR2(30);
584:
585: /*Added for Bulk insert at version level*/
586: l_blk_src_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
587: l_blk_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
588: l_blk_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
589: l_blk_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
590: l_blk_etc_txn_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
583: l_transaction_source_code VARCHAR2(30);
584:
585: /*Added for Bulk insert at version level*/
586: l_blk_src_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
587: l_blk_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
588: l_blk_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
589: l_blk_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
590: l_blk_etc_txn_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
591: l_blk_etc_txn_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
584:
585: /*Added for Bulk insert at version level*/
586: l_blk_src_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
587: l_blk_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
588: l_blk_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
589: l_blk_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
590: l_blk_etc_txn_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
591: l_blk_etc_txn_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
592: l_blk_etc_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
585: /*Added for Bulk insert at version level*/
586: l_blk_src_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
587: l_blk_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
588: l_blk_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
589: l_blk_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
590: l_blk_etc_txn_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
591: l_blk_etc_txn_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
592: l_blk_etc_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
593: l_blk_etc_pc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
586: l_blk_src_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
587: l_blk_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
588: l_blk_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
589: l_blk_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
590: l_blk_etc_txn_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
591: l_blk_etc_txn_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
592: l_blk_etc_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
593: l_blk_etc_pc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
594: l_blk_etc_pc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
587: l_blk_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
588: l_blk_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
589: l_blk_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
590: l_blk_etc_txn_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
591: l_blk_etc_txn_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
592: l_blk_etc_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
593: l_blk_etc_pc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
594: l_blk_etc_pc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
595: l_blk_etc_pc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
588: l_blk_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
589: l_blk_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
590: l_blk_etc_txn_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
591: l_blk_etc_txn_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
592: l_blk_etc_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
593: l_blk_etc_pc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
594: l_blk_etc_pc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
595: l_blk_etc_pc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
596: l_blk_etc_pfc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
589: l_blk_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
590: l_blk_etc_txn_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
591: l_blk_etc_txn_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
592: l_blk_etc_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
593: l_blk_etc_pc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
594: l_blk_etc_pc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
595: l_blk_etc_pc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
596: l_blk_etc_pfc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
597: l_blk_etc_pfc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
590: l_blk_etc_txn_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
591: l_blk_etc_txn_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
592: l_blk_etc_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
593: l_blk_etc_pc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
594: l_blk_etc_pc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
595: l_blk_etc_pc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
596: l_blk_etc_pfc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
597: l_blk_etc_pfc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
598: l_blk_etc_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
591: l_blk_etc_txn_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
592: l_blk_etc_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
593: l_blk_etc_pc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
594: l_blk_etc_pc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
595: l_blk_etc_pc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
596: l_blk_etc_pfc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
597: l_blk_etc_pfc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
598: l_blk_etc_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
599:
592: l_blk_etc_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
593: l_blk_etc_pc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
594: l_blk_etc_pc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
595: l_blk_etc_pc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
596: l_blk_etc_pfc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
597: l_blk_etc_pfc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
598: l_blk_etc_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
599:
600: continue_loop EXCEPTION;
593: l_blk_etc_pc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
594: l_blk_etc_pc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
595: l_blk_etc_pc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
596: l_blk_etc_pfc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
597: l_blk_etc_pfc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
598: l_blk_etc_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
599:
600: continue_loop EXCEPTION;
601: l_count NUMBER := 0;
594: l_blk_etc_pc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
595: l_blk_etc_pc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
596: l_blk_etc_pfc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
597: l_blk_etc_pfc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
598: l_blk_etc_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
599:
600: continue_loop EXCEPTION;
601: l_count NUMBER := 0;
602: l_dummy NUMBER;
600: continue_loop EXCEPTION;
601: l_count NUMBER := 0;
602: l_dummy NUMBER;
603:
604: l_remain_bdgt_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
605: l_remain_bdgt_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
606: l_remain_bdgt_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
607: l_remain_bdgt_cbs_id_tab PA_PLSQL_DATATYPES.IdTabTyp; --bug#16791711
608: l_remain_bdgt_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
601: l_count NUMBER := 0;
602: l_dummy NUMBER;
603:
604: l_remain_bdgt_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
605: l_remain_bdgt_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
606: l_remain_bdgt_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
607: l_remain_bdgt_cbs_id_tab PA_PLSQL_DATATYPES.IdTabTyp; --bug#16791711
608: l_remain_bdgt_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
609: l_remain_bdgt_etc_src_tab PA_PLSQL_DATATYPES.Char30TabTyp;
602: l_dummy NUMBER;
603:
604: l_remain_bdgt_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
605: l_remain_bdgt_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
606: l_remain_bdgt_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
607: l_remain_bdgt_cbs_id_tab PA_PLSQL_DATATYPES.IdTabTyp; --bug#16791711
608: l_remain_bdgt_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
609: l_remain_bdgt_etc_src_tab PA_PLSQL_DATATYPES.Char30TabTyp;
610: l_cnt NUMBER := 0;
603:
604: l_remain_bdgt_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
605: l_remain_bdgt_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
606: l_remain_bdgt_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
607: l_remain_bdgt_cbs_id_tab PA_PLSQL_DATATYPES.IdTabTyp; --bug#16791711
608: l_remain_bdgt_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
609: l_remain_bdgt_etc_src_tab PA_PLSQL_DATATYPES.Char30TabTyp;
610: l_cnt NUMBER := 0;
611:
604: l_remain_bdgt_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
605: l_remain_bdgt_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
606: l_remain_bdgt_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
607: l_remain_bdgt_cbs_id_tab PA_PLSQL_DATATYPES.IdTabTyp; --bug#16791711
608: l_remain_bdgt_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
609: l_remain_bdgt_etc_src_tab PA_PLSQL_DATATYPES.Char30TabTyp;
610: l_cnt NUMBER := 0;
611:
612: l_msg_count NUMBER;
605: l_remain_bdgt_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
606: l_remain_bdgt_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
607: l_remain_bdgt_cbs_id_tab PA_PLSQL_DATATYPES.IdTabTyp; --bug#16791711
608: l_remain_bdgt_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
609: l_remain_bdgt_etc_src_tab PA_PLSQL_DATATYPES.Char30TabTyp;
610: l_cnt NUMBER := 0;
611:
612: l_msg_count NUMBER;
613: l_msg_data VARCHAR2(2000);