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_GEN_FCST_AMT_PUB5 dependencies on PA_PLSQL_DATATYPES

Line 47: l_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

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;

Line 48: l_act_quantity_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;

Line 49: l_act_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

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:

Line 50: l_act_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

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;

Line 51: l_act_revenue_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:

Line 54: l_etc_quantity_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:
56: /*For average rates*/
57: l_pc_rate_quantity NUMBER;
58: l_pc_rate_raw_cost NUMBER;

Line 70: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

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;

Line 71: l_txn_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;

Line 72: l_txn_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;

Line 73: l_pc_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;

Line 74: l_pc_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;

Line 75: l_pc_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);

Line 76: l_pfc_raw_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);
80:

Line 77: l_pfc_brdn_cost_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:
81: l_msg_count NUMBER;

Line 78: l_pfc_revenue_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;
82: l_msg_data VARCHAR2(2000);

Line 509: P_SRC_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,

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,

Line 510: P_TGT_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,

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,

Line 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_ETC_SOURCE_CODE_TAB IN PA_PLSQL_DATATYPES.Char30TabTyp,
517: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
518: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,

Line 515: P_RES_LIST_MEMBER_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_ETC_SOURCE_CODE_TAB IN PA_PLSQL_DATATYPES.Char30TabTyp,
517: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
518: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
519: P_PLANNING_OPTIONS_FLAG IN VARCHAR2,

Line 516: P_ETC_SOURCE_CODE_TAB IN PA_PLSQL_DATATYPES.Char30TabTyp,

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_ETC_SOURCE_CODE_TAB IN PA_PLSQL_DATATYPES.Char30TabTyp,
517: P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
518: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
519: P_PLANNING_OPTIONS_FLAG IN VARCHAR2,
520: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 550: l_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

546: lx_act_pc_brdn_cost NUMBER;
547: lx_act_pfc_raw_cost NUMBER;
548: lx_act_pfc_brdn_cost NUMBER;
549:
550: l_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
551: l_act_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
552: l_act_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
553: l_act_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
554: l_act_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 551: l_act_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;

547: lx_act_pfc_raw_cost NUMBER;
548: lx_act_pfc_brdn_cost NUMBER;
549:
550: l_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
551: l_act_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
552: l_act_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
553: l_act_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
554: l_act_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
555: l_target_version_type pa_budget_versions.version_type%type;

Line 552: l_act_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

548: lx_act_pfc_brdn_cost NUMBER;
549:
550: l_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
551: l_act_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
552: l_act_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
553: l_act_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
554: l_act_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
555: l_target_version_type pa_budget_versions.version_type%type;
556:

Line 553: l_act_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

549:
550: l_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
551: l_act_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
552: l_act_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
553: l_act_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
554: l_act_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
555: l_target_version_type pa_budget_versions.version_type%type;
556:
557: l_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 554: l_act_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

550: l_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
551: l_act_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
552: l_act_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
553: l_act_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
554: l_act_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
555: l_target_version_type pa_budget_versions.version_type%type;
556:
557: l_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
558:

Line 557: l_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;

553: l_act_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
554: l_act_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
555: l_target_version_type pa_budget_versions.version_type%type;
556:
557: l_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
558:
559: /*For average rates*/
560: l_pc_rate_quantity NUMBER;
561: l_pc_rate_raw_cost NUMBER;

Line 573: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

569: l_txn_rate_raw_cost NUMBER;
570: l_txn_rate_brdn_cost NUMBER;
571: l_txn_rate_revenue NUMBER;
572:
573: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
574: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
575: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
576: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
577: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 574: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

570: l_txn_rate_brdn_cost NUMBER;
571: l_txn_rate_revenue NUMBER;
572:
573: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
574: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
575: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
576: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
577: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
578: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 575: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

571: l_txn_rate_revenue NUMBER;
572:
573: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
574: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
575: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
576: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
577: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
578: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
579: l_pfc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 576: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

572:
573: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
574: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
575: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
576: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
577: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
578: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
579: l_pfc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
580: l_pfc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 577: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

573: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
574: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
575: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
576: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
577: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
578: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
579: l_pfc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
580: l_pfc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
581: l_pfc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 578: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

574: l_txn_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
575: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
576: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
577: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
578: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
579: l_pfc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
580: l_pfc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
581: l_pfc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
582: l_transaction_source_code VARCHAR2(30);

Line 579: l_pfc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

575: l_txn_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
576: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
577: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
578: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
579: l_pfc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
580: l_pfc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
581: l_pfc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
582: l_transaction_source_code VARCHAR2(30);
583:

Line 580: l_pfc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

576: l_pc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
577: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
578: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
579: l_pfc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
580: l_pfc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
581: l_pfc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
582: l_transaction_source_code VARCHAR2(30);
583:
584: /*Added for Bulk insert at version level*/

Line 581: l_pfc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

577: l_pc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
578: l_pc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
579: l_pfc_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
580: l_pfc_brdn_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
581: l_pfc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
582: l_transaction_source_code VARCHAR2(30);
583:
584: /*Added for Bulk insert at version level*/
585: l_blk_src_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 585: l_blk_src_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

581: l_pfc_revenue_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
582: l_transaction_source_code VARCHAR2(30);
583:
584: /*Added for Bulk insert at version level*/
585: l_blk_src_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
586: l_blk_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
587: l_blk_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
588: l_blk_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
589: l_blk_etc_txn_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 586: l_blk_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

582: l_transaction_source_code VARCHAR2(30);
583:
584: /*Added for Bulk insert at version level*/
585: l_blk_src_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
586: l_blk_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
587: l_blk_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
588: l_blk_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
589: l_blk_etc_txn_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
590: l_blk_etc_txn_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 587: l_blk_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

583:
584: /*Added for Bulk insert at version level*/
585: l_blk_src_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
586: l_blk_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
587: l_blk_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
588: l_blk_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
589: l_blk_etc_txn_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
590: l_blk_etc_txn_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
591: l_blk_etc_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 588: l_blk_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;

584: /*Added for Bulk insert at version level*/
585: l_blk_src_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
586: l_blk_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
587: l_blk_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
588: l_blk_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
589: l_blk_etc_txn_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
590: l_blk_etc_txn_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
591: l_blk_etc_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
592: l_blk_etc_pc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 589: l_blk_etc_txn_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;

585: l_blk_src_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
586: l_blk_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
587: l_blk_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
588: l_blk_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
589: l_blk_etc_txn_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
590: l_blk_etc_txn_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
591: l_blk_etc_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
592: l_blk_etc_pc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
593: l_blk_etc_pc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 590: l_blk_etc_txn_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;

586: l_blk_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
587: l_blk_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
588: l_blk_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
589: l_blk_etc_txn_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
590: l_blk_etc_txn_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
591: l_blk_etc_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
592: l_blk_etc_pc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
593: l_blk_etc_pc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
594: l_blk_etc_pc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 591: l_blk_etc_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

587: l_blk_act_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
588: l_blk_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
589: l_blk_etc_txn_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
590: l_blk_etc_txn_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
591: l_blk_etc_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
592: l_blk_etc_pc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
593: l_blk_etc_pc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
594: l_blk_etc_pc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
595: l_blk_etc_pfc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 592: l_blk_etc_pc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;

588: l_blk_etc_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
589: l_blk_etc_txn_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
590: l_blk_etc_txn_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
591: l_blk_etc_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
592: l_blk_etc_pc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
593: l_blk_etc_pc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
594: l_blk_etc_pc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
595: l_blk_etc_pfc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
596: l_blk_etc_pfc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 593: l_blk_etc_pc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;

589: l_blk_etc_txn_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
590: l_blk_etc_txn_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
591: l_blk_etc_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
592: l_blk_etc_pc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
593: l_blk_etc_pc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
594: l_blk_etc_pc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
595: l_blk_etc_pfc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
596: l_blk_etc_pfc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
597: l_blk_etc_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 594: l_blk_etc_pc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

590: l_blk_etc_txn_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
591: l_blk_etc_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
592: l_blk_etc_pc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
593: l_blk_etc_pc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
594: l_blk_etc_pc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
595: l_blk_etc_pfc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
596: l_blk_etc_pfc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
597: l_blk_etc_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
598:

Line 595: l_blk_etc_pfc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;

591: l_blk_etc_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
592: l_blk_etc_pc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
593: l_blk_etc_pc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
594: l_blk_etc_pc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
595: l_blk_etc_pfc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
596: l_blk_etc_pfc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
597: l_blk_etc_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
598:
599: continue_loop EXCEPTION;

Line 596: l_blk_etc_pfc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;

592: l_blk_etc_pc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
593: l_blk_etc_pc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
594: l_blk_etc_pc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
595: l_blk_etc_pfc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
596: l_blk_etc_pfc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
597: l_blk_etc_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
598:
599: continue_loop EXCEPTION;
600: l_count NUMBER := 0;

Line 597: l_blk_etc_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

593: l_blk_etc_pc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
594: l_blk_etc_pc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
595: l_blk_etc_pfc_rcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
596: l_blk_etc_pfc_bcost_tab PA_PLSQL_DATATYPES.NumTabTyp;
597: l_blk_etc_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
598:
599: continue_loop EXCEPTION;
600: l_count NUMBER := 0;
601: l_dummy NUMBER;

Line 603: l_remain_bdgt_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

599: continue_loop EXCEPTION;
600: l_count NUMBER := 0;
601: l_dummy NUMBER;
602:
603: l_remain_bdgt_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
604: l_remain_bdgt_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
605: l_remain_bdgt_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
606: l_remain_bdgt_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
607: l_remain_bdgt_etc_src_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 604: l_remain_bdgt_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

600: l_count NUMBER := 0;
601: l_dummy NUMBER;
602:
603: l_remain_bdgt_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
604: l_remain_bdgt_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
605: l_remain_bdgt_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
606: l_remain_bdgt_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
607: l_remain_bdgt_etc_src_tab PA_PLSQL_DATATYPES.Char30TabTyp;
608: l_cnt NUMBER := 0;

Line 605: l_remain_bdgt_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

601: l_dummy NUMBER;
602:
603: l_remain_bdgt_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
604: l_remain_bdgt_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
605: l_remain_bdgt_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
606: l_remain_bdgt_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
607: l_remain_bdgt_etc_src_tab PA_PLSQL_DATATYPES.Char30TabTyp;
608: l_cnt NUMBER := 0;
609:

Line 606: l_remain_bdgt_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

602:
603: l_remain_bdgt_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
604: l_remain_bdgt_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
605: l_remain_bdgt_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
606: l_remain_bdgt_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
607: l_remain_bdgt_etc_src_tab PA_PLSQL_DATATYPES.Char30TabTyp;
608: l_cnt NUMBER := 0;
609:
610: l_msg_count NUMBER;

Line 607: l_remain_bdgt_etc_src_tab PA_PLSQL_DATATYPES.Char30TabTyp;

603: l_remain_bdgt_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
604: l_remain_bdgt_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
605: l_remain_bdgt_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
606: l_remain_bdgt_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
607: l_remain_bdgt_etc_src_tab PA_PLSQL_DATATYPES.Char30TabTyp;
608: l_cnt NUMBER := 0;
609:
610: l_msg_count NUMBER;
611: l_msg_data VARCHAR2(2000);