34: l_pfc_currency_code pa_projects_all.project_currency_code%type;
35: l_rev_gen_method VARCHAR2(3);
36:
37: l_target_version_type pa_budget_versions.version_type%type;
38: l_tot_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
39: l_tot_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
40: l_tot_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
41: l_tot_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
42: l_tot_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
35: l_rev_gen_method VARCHAR2(3);
36:
37: l_target_version_type pa_budget_versions.version_type%type;
38: l_tot_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
39: l_tot_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
40: l_tot_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
41: l_tot_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
42: l_tot_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
43:
36:
37: l_target_version_type pa_budget_versions.version_type%type;
38: l_tot_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
39: l_tot_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
40: l_tot_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
41: l_tot_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
42: l_tot_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
43:
44: l_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
37: l_target_version_type pa_budget_versions.version_type%type;
38: l_tot_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
39: l_tot_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
40: l_tot_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
41: l_tot_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
42: l_tot_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
43:
44: l_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
45:
38: l_tot_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
39: l_tot_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
40: l_tot_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
41: l_tot_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
42: l_tot_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
43:
44: l_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
45:
46: /*For average rates*/
40: l_tot_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
41: l_tot_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
42: l_tot_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
43:
44: l_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
45:
46: /*For average rates*/
47: l_pc_rate_quantity NUMBER;
48: l_pc_rate_raw_cost NUMBER;
56: l_txn_rate_raw_cost NUMBER;
57: l_txn_rate_brdn_cost NUMBER;
58: l_txn_rate_revenue NUMBER;
59:
60: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
61: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
62: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
63: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
64: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
57: l_txn_rate_brdn_cost NUMBER;
58: l_txn_rate_revenue NUMBER;
59:
60: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
61: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
62: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
63: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
64: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
65: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
58: l_txn_rate_revenue NUMBER;
59:
60: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
61: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
62: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
63: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
64: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
65: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
66: l_pfc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
59:
60: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
61: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
62: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
63: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
64: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
65: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
66: l_pfc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
67: l_pfc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
60: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
61: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
62: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
63: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
64: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
65: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
66: l_pfc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
67: l_pfc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
68: l_pfc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
61: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
62: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
63: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
64: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
65: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
66: l_pfc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
67: l_pfc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
68: l_pfc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
69: l_transaction_source_code VARCHAR2(30);
62: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
63: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
64: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
65: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
66: l_pfc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
67: l_pfc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
68: l_pfc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
69: l_transaction_source_code VARCHAR2(30);
70:
63: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
64: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
65: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
66: l_pfc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
67: l_pfc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
68: l_pfc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
69: l_transaction_source_code VARCHAR2(30);
70:
71: l_msg_count NUMBER;
64: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
65: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
66: l_pfc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
67: l_pfc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
68: l_pfc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
69: l_transaction_source_code VARCHAR2(30);
70:
71: l_msg_count NUMBER;
72: l_msg_data VARCHAR2(2000);
380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
381: END GET_ETC_BDGT_COMPLETE_AMTS;
382:
383: PROCEDURE GET_ETC_BDGT_COMPLETE_AMTS_BLK (
384: P_SRC_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
385: P_TGT_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
386: P_FP_COLS_SRC_REC_FP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
387: P_FP_COLS_SRC_REC_WP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
388: P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
381: END GET_ETC_BDGT_COMPLETE_AMTS;
382:
383: PROCEDURE GET_ETC_BDGT_COMPLETE_AMTS_BLK (
384: P_SRC_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
385: P_TGT_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
386: P_FP_COLS_SRC_REC_FP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
387: P_FP_COLS_SRC_REC_WP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
388: P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
389: P_TASK_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
385: P_TGT_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
386: P_FP_COLS_SRC_REC_FP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
387: P_FP_COLS_SRC_REC_WP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
388: P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
389: P_TASK_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
390: P_RES_LIST_MEMBER_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
391: P_ETC_SOURCE_CODE_TAB IN PA_PLSQL_DATATYPES.Char30TabTyp,
392: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
393: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
386: P_FP_COLS_SRC_REC_FP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
387: P_FP_COLS_SRC_REC_WP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
388: P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
389: P_TASK_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
390: P_RES_LIST_MEMBER_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
391: P_ETC_SOURCE_CODE_TAB IN PA_PLSQL_DATATYPES.Char30TabTyp,
392: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
393: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
394: P_PLANNING_OPTIONS_FLAG IN VARCHAR2,
387: P_FP_COLS_SRC_REC_WP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
388: P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
389: P_TASK_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
390: P_RES_LIST_MEMBER_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
391: P_ETC_SOURCE_CODE_TAB IN PA_PLSQL_DATATYPES.Char30TabTyp,
392: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
393: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
394: P_PLANNING_OPTIONS_FLAG IN VARCHAR2,
395: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
413: l_rev_gen_method VARCHAR2(3);
414:
415: l_target_version_type pa_budget_versions.version_type%type;
416: l_source_version_type pa_budget_versions.version_type%type; /* Added for IPM */
417: l_tot_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
418: l_tot_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
419: l_tot_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
420: l_tot_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
421: l_tot_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
414:
415: l_target_version_type pa_budget_versions.version_type%type;
416: l_source_version_type pa_budget_versions.version_type%type; /* Added for IPM */
417: l_tot_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
418: l_tot_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
419: l_tot_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
420: l_tot_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
421: l_tot_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
422:
415: l_target_version_type pa_budget_versions.version_type%type;
416: l_source_version_type pa_budget_versions.version_type%type; /* Added for IPM */
417: l_tot_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
418: l_tot_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
419: l_tot_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
420: l_tot_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
421: l_tot_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
422:
423: l_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
416: l_source_version_type pa_budget_versions.version_type%type; /* Added for IPM */
417: l_tot_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
418: l_tot_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
419: l_tot_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
420: l_tot_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
421: l_tot_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
422:
423: l_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
424:
417: l_tot_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
418: l_tot_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
419: l_tot_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
420: l_tot_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
421: l_tot_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
422:
423: l_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
424:
425: /*For average rates*/
419: l_tot_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
420: l_tot_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
421: l_tot_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
422:
423: l_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
424:
425: /*For average rates*/
426: l_pc_rate_quantity NUMBER;
427: l_pc_rate_raw_cost NUMBER;
435: l_txn_rate_raw_cost NUMBER;
436: l_txn_rate_brdn_cost NUMBER;
437: l_txn_rate_revenue NUMBER;
438:
439: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
440: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
441: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
442: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
443: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
436: l_txn_rate_brdn_cost NUMBER;
437: l_txn_rate_revenue NUMBER;
438:
439: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
440: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
441: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
442: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
443: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
444: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
437: l_txn_rate_revenue NUMBER;
438:
439: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
440: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
441: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
442: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
443: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
444: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
445: l_pfc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
438:
439: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
440: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
441: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
442: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
443: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
444: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
445: l_pfc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
446: l_pfc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
439: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
440: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
441: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
442: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
443: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
444: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
445: l_pfc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
446: l_pfc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
447: l_pfc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
440: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
441: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
442: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
443: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
444: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
445: l_pfc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
446: l_pfc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
447: l_pfc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
448: l_transaction_source_code VARCHAR2(30);
441: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
442: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
443: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
444: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
445: l_pfc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
446: l_pfc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
447: l_pfc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
448: l_transaction_source_code VARCHAR2(30);
449:
442: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
443: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
444: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
445: l_pfc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
446: l_pfc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
447: l_pfc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
448: l_transaction_source_code VARCHAR2(30);
449:
450: /*Added for Bulk insert at version level*/
443: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
444: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
445: l_pfc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
446: l_pfc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
447: l_pfc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
448: l_transaction_source_code VARCHAR2(30);
449:
450: /*Added for Bulk insert at version level*/
451: l_blk_src_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
447: l_pfc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
448: l_transaction_source_code VARCHAR2(30);
449:
450: /*Added for Bulk insert at version level*/
451: l_blk_src_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
452: l_blk_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
453: l_blk_tot_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
454: l_blk_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
455: l_blk_etc_txn_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
448: l_transaction_source_code VARCHAR2(30);
449:
450: /*Added for Bulk insert at version level*/
451: l_blk_src_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
452: l_blk_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
453: l_blk_tot_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
454: l_blk_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
455: l_blk_etc_txn_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
456: l_blk_etc_txn_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
449:
450: /*Added for Bulk insert at version level*/
451: l_blk_src_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
452: l_blk_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
453: l_blk_tot_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
454: l_blk_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
455: l_blk_etc_txn_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
456: l_blk_etc_txn_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
457: l_blk_etc_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
450: /*Added for Bulk insert at version level*/
451: l_blk_src_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
452: l_blk_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
453: l_blk_tot_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
454: l_blk_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
455: l_blk_etc_txn_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
456: l_blk_etc_txn_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
457: l_blk_etc_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
458: l_blk_etc_pc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
451: l_blk_src_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
452: l_blk_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
453: l_blk_tot_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
454: l_blk_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
455: l_blk_etc_txn_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
456: l_blk_etc_txn_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
457: l_blk_etc_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
458: l_blk_etc_pc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
459: l_blk_etc_pc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
452: l_blk_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
453: l_blk_tot_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
454: l_blk_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
455: l_blk_etc_txn_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
456: l_blk_etc_txn_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
457: l_blk_etc_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
458: l_blk_etc_pc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
459: l_blk_etc_pc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
460: l_blk_etc_pc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
453: l_blk_tot_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
454: l_blk_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
455: l_blk_etc_txn_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
456: l_blk_etc_txn_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
457: l_blk_etc_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
458: l_blk_etc_pc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
459: l_blk_etc_pc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
460: l_blk_etc_pc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
461: l_blk_etc_pfc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
454: l_blk_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
455: l_blk_etc_txn_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
456: l_blk_etc_txn_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
457: l_blk_etc_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
458: l_blk_etc_pc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
459: l_blk_etc_pc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
460: l_blk_etc_pc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
461: l_blk_etc_pfc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
462: l_blk_etc_pfc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
455: l_blk_etc_txn_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
456: l_blk_etc_txn_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
457: l_blk_etc_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
458: l_blk_etc_pc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
459: l_blk_etc_pc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
460: l_blk_etc_pc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
461: l_blk_etc_pfc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
462: l_blk_etc_pfc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
463: l_blk_etc_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
456: l_blk_etc_txn_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
457: l_blk_etc_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
458: l_blk_etc_pc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
459: l_blk_etc_pc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
460: l_blk_etc_pc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
461: l_blk_etc_pfc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
462: l_blk_etc_pfc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
463: l_blk_etc_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
464:
457: l_blk_etc_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
458: l_blk_etc_pc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
459: l_blk_etc_pc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
460: l_blk_etc_pc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
461: l_blk_etc_pfc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
462: l_blk_etc_pfc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
463: l_blk_etc_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
464:
465: continue_loop EXCEPTION;
458: l_blk_etc_pc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
459: l_blk_etc_pc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
460: l_blk_etc_pc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
461: l_blk_etc_pfc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
462: l_blk_etc_pfc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
463: l_blk_etc_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
464:
465: continue_loop EXCEPTION;
466: l_count NUMBER := 0;
459: l_blk_etc_pc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
460: l_blk_etc_pc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
461: l_blk_etc_pfc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
462: l_blk_etc_pfc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
463: l_blk_etc_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
464:
465: continue_loop EXCEPTION;
466: l_count NUMBER := 0;
467: l_dummy NUMBER;