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

Line 38: l_tot_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

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;

Line 39: l_tot_quantity_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:

Line 40: l_tot_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

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;

Line 41: l_tot_brdn_cost_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:

Line 42: l_tot_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

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*/

Line 44: l_etc_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*/
47: l_pc_rate_quantity NUMBER;
48: l_pc_rate_raw_cost NUMBER;

Line 60: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

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;

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

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

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

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

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

Line 66: l_pfc_raw_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);
70:

Line 67: l_pfc_brdn_cost_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:
71: l_msg_count NUMBER;

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

Line 384: P_SRC_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,

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,

Line 385: P_TGT_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,

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,

Line 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,

Line 390: P_RES_LIST_MEMBER_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,
394: P_PLANNING_OPTIONS_FLAG IN VARCHAR2,

Line 391: P_ETC_SOURCE_CODE_TAB IN PA_PLSQL_DATATYPES.Char30TabTyp,

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,

Line 417: l_tot_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

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;

Line 418: l_tot_quantity_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:

Line 419: l_tot_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

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;

Line 420: l_tot_brdn_cost_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:

Line 421: l_tot_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

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*/

Line 423: l_etc_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*/
426: l_pc_rate_quantity NUMBER;
427: l_pc_rate_raw_cost NUMBER;

Line 439: l_txn_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

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;

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

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

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

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

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

Line 445: l_pfc_raw_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);
449:

Line 446: l_pfc_brdn_cost_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:
450: /*Added for Bulk insert at version level*/

Line 447: l_pfc_revenue_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*/
451: l_blk_src_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 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;

Line 452: l_blk_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

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;

Line 453: l_blk_tot_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

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;

Line 454: l_blk_etc_quantity_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;

Line 455: l_blk_etc_txn_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;

Line 456: l_blk_etc_txn_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;

Line 457: l_blk_etc_txn_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;

Line 458: l_blk_etc_pc_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;

Line 459: l_blk_etc_pc_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;

Line 460: l_blk_etc_pc_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:

Line 461: l_blk_etc_pfc_rcost_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:
465: continue_loop EXCEPTION;

Line 462: l_blk_etc_pfc_bcost_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;
466: l_count NUMBER := 0;

Line 463: l_blk_etc_pfc_revenue_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;
467: l_dummy NUMBER;