APPS.PA_FP_GEN_COMMITMENT_AMOUNTS dependencies on PA_PLSQL_DATATYPES

Line 10: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

6: PROCEDURE GEN_COMMITMENT_AMOUNTS
7: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
8: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
9: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
10: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
11: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
12: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
13: X_MSG_COUNT OUT NOCOPY NUMBER,
14: X_MSG_DATA OUT NOCOPY VARCHAR2) IS

Line 11: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

7: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
8: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
9: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
10: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
11: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
12: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
13: X_MSG_COUNT OUT NOCOPY NUMBER,
14: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
15:

Line 46: l_res_asg_id PA_PLSQL_DATATYPES.IdTabTyp;

42: AND NVL(CT.generation_error_flag,'N') = 'N'
43: AND P.RESOURCE_ASSIGNMENT_ID = TMP.TXN_RESOURCE_ASSIGNMENT_ID
44: AND P.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID;
45:
46: l_res_asg_id PA_PLSQL_DATATYPES.IdTabTyp;
47: l_currency_code PA_PLSQL_DATATYPES.Char15TabTyp;
48: l_tphase PA_PLSQL_DATATYPES.Char30TabTyp;
49: l_exp_itm_date PA_PLSQL_DATATYPES.DateTabTyp;
50: l_commstart_date PA_PLSQL_DATATYPES.DateTabTyp;

Line 47: l_currency_code PA_PLSQL_DATATYPES.Char15TabTyp;

43: AND P.RESOURCE_ASSIGNMENT_ID = TMP.TXN_RESOURCE_ASSIGNMENT_ID
44: AND P.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID;
45:
46: l_res_asg_id PA_PLSQL_DATATYPES.IdTabTyp;
47: l_currency_code PA_PLSQL_DATATYPES.Char15TabTyp;
48: l_tphase PA_PLSQL_DATATYPES.Char30TabTyp;
49: l_exp_itm_date PA_PLSQL_DATATYPES.DateTabTyp;
50: l_commstart_date PA_PLSQL_DATATYPES.DateTabTyp;
51: l_commend_date PA_PLSQL_DATATYPES.DateTabTyp;

Line 48: l_tphase PA_PLSQL_DATATYPES.Char30TabTyp;

44: AND P.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID;
45:
46: l_res_asg_id PA_PLSQL_DATATYPES.IdTabTyp;
47: l_currency_code PA_PLSQL_DATATYPES.Char15TabTyp;
48: l_tphase PA_PLSQL_DATATYPES.Char30TabTyp;
49: l_exp_itm_date PA_PLSQL_DATATYPES.DateTabTyp;
50: l_commstart_date PA_PLSQL_DATATYPES.DateTabTyp;
51: l_commend_date PA_PLSQL_DATATYPES.DateTabTyp;
52: l_raw_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;

Line 49: l_exp_itm_date PA_PLSQL_DATATYPES.DateTabTyp;

45:
46: l_res_asg_id PA_PLSQL_DATATYPES.IdTabTyp;
47: l_currency_code PA_PLSQL_DATATYPES.Char15TabTyp;
48: l_tphase PA_PLSQL_DATATYPES.Char30TabTyp;
49: l_exp_itm_date PA_PLSQL_DATATYPES.DateTabTyp;
50: l_commstart_date PA_PLSQL_DATATYPES.DateTabTyp;
51: l_commend_date PA_PLSQL_DATATYPES.DateTabTyp;
52: l_raw_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
53: l_burdened_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;

Line 50: l_commstart_date PA_PLSQL_DATATYPES.DateTabTyp;

46: l_res_asg_id PA_PLSQL_DATATYPES.IdTabTyp;
47: l_currency_code PA_PLSQL_DATATYPES.Char15TabTyp;
48: l_tphase PA_PLSQL_DATATYPES.Char30TabTyp;
49: l_exp_itm_date PA_PLSQL_DATATYPES.DateTabTyp;
50: l_commstart_date PA_PLSQL_DATATYPES.DateTabTyp;
51: l_commend_date PA_PLSQL_DATATYPES.DateTabTyp;
52: l_raw_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
53: l_burdened_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
54: l_proj_raw_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;

Line 51: l_commend_date PA_PLSQL_DATATYPES.DateTabTyp;

47: l_currency_code PA_PLSQL_DATATYPES.Char15TabTyp;
48: l_tphase PA_PLSQL_DATATYPES.Char30TabTyp;
49: l_exp_itm_date PA_PLSQL_DATATYPES.DateTabTyp;
50: l_commstart_date PA_PLSQL_DATATYPES.DateTabTyp;
51: l_commend_date PA_PLSQL_DATATYPES.DateTabTyp;
52: l_raw_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
53: l_burdened_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
54: l_proj_raw_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
55: l_proj_burdened_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;

Line 52: l_raw_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;

48: l_tphase PA_PLSQL_DATATYPES.Char30TabTyp;
49: l_exp_itm_date PA_PLSQL_DATATYPES.DateTabTyp;
50: l_commstart_date PA_PLSQL_DATATYPES.DateTabTyp;
51: l_commend_date PA_PLSQL_DATATYPES.DateTabTyp;
52: l_raw_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
53: l_burdened_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
54: l_proj_raw_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
55: l_proj_burdened_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
56: l_projfunc_raw_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;

Line 53: l_burdened_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;

49: l_exp_itm_date PA_PLSQL_DATATYPES.DateTabTyp;
50: l_commstart_date PA_PLSQL_DATATYPES.DateTabTyp;
51: l_commend_date PA_PLSQL_DATATYPES.DateTabTyp;
52: l_raw_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
53: l_burdened_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
54: l_proj_raw_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
55: l_proj_burdened_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
56: l_projfunc_raw_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
57: l_projfunc_burdened_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;

Line 54: l_proj_raw_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;

50: l_commstart_date PA_PLSQL_DATATYPES.DateTabTyp;
51: l_commend_date PA_PLSQL_DATATYPES.DateTabTyp;
52: l_raw_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
53: l_burdened_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
54: l_proj_raw_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
55: l_proj_burdened_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
56: l_projfunc_raw_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
57: l_projfunc_burdened_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
58: l_quantity_sum_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 55: l_proj_burdened_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;

51: l_commend_date PA_PLSQL_DATATYPES.DateTabTyp;
52: l_raw_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
53: l_burdened_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
54: l_proj_raw_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
55: l_proj_burdened_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
56: l_projfunc_raw_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
57: l_projfunc_burdened_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
58: l_quantity_sum_tab PA_PLSQL_DATATYPES.NumTabTyp;
59: l_DELETED_RES_ASG_ID_TAB PA_PLSQL_DATATYPES.IdTabTyp;

Line 56: l_projfunc_raw_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;

52: l_raw_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
53: l_burdened_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
54: l_proj_raw_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
55: l_proj_burdened_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
56: l_projfunc_raw_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
57: l_projfunc_burdened_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
58: l_quantity_sum_tab PA_PLSQL_DATATYPES.NumTabTyp;
59: l_DELETED_RES_ASG_ID_TAB PA_PLSQL_DATATYPES.IdTabTyp;
60: l_bl_raw_cost_sum_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 57: l_projfunc_burdened_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;

53: l_burdened_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
54: l_proj_raw_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
55: l_proj_burdened_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
56: l_projfunc_raw_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
57: l_projfunc_burdened_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
58: l_quantity_sum_tab PA_PLSQL_DATATYPES.NumTabTyp;
59: l_DELETED_RES_ASG_ID_TAB PA_PLSQL_DATATYPES.IdTabTyp;
60: l_bl_raw_cost_sum_tab PA_PLSQL_DATATYPES.NumTabTyp;
61: l_bl_burden_cost_sum_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 58: l_quantity_sum_tab PA_PLSQL_DATATYPES.NumTabTyp;

54: l_proj_raw_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
55: l_proj_burdened_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
56: l_projfunc_raw_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
57: l_projfunc_burdened_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
58: l_quantity_sum_tab PA_PLSQL_DATATYPES.NumTabTyp;
59: l_DELETED_RES_ASG_ID_TAB PA_PLSQL_DATATYPES.IdTabTyp;
60: l_bl_raw_cost_sum_tab PA_PLSQL_DATATYPES.NumTabTyp;
61: l_bl_burden_cost_sum_tab PA_PLSQL_DATATYPES.NumTabTyp;
62: l_bl_quantity_sum_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 59: l_DELETED_RES_ASG_ID_TAB PA_PLSQL_DATATYPES.IdTabTyp;

55: l_proj_burdened_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
56: l_projfunc_raw_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
57: l_projfunc_burdened_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
58: l_quantity_sum_tab PA_PLSQL_DATATYPES.NumTabTyp;
59: l_DELETED_RES_ASG_ID_TAB PA_PLSQL_DATATYPES.IdTabTyp;
60: l_bl_raw_cost_sum_tab PA_PLSQL_DATATYPES.NumTabTyp;
61: l_bl_burden_cost_sum_tab PA_PLSQL_DATATYPES.NumTabTyp;
62: l_bl_quantity_sum_tab PA_PLSQL_DATATYPES.NumTabTyp;
63:

Line 60: l_bl_raw_cost_sum_tab PA_PLSQL_DATATYPES.NumTabTyp;

56: l_projfunc_raw_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
57: l_projfunc_burdened_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
58: l_quantity_sum_tab PA_PLSQL_DATATYPES.NumTabTyp;
59: l_DELETED_RES_ASG_ID_TAB PA_PLSQL_DATATYPES.IdTabTyp;
60: l_bl_raw_cost_sum_tab PA_PLSQL_DATATYPES.NumTabTyp;
61: l_bl_burden_cost_sum_tab PA_PLSQL_DATATYPES.NumTabTyp;
62: l_bl_quantity_sum_tab PA_PLSQL_DATATYPES.NumTabTyp;
63:
64: l_qty_tmp NUMBER:= 0;

Line 61: l_bl_burden_cost_sum_tab PA_PLSQL_DATATYPES.NumTabTyp;

57: l_projfunc_burdened_cost_sum PA_PLSQL_DATATYPES.NumTabTyp;
58: l_quantity_sum_tab PA_PLSQL_DATATYPES.NumTabTyp;
59: l_DELETED_RES_ASG_ID_TAB PA_PLSQL_DATATYPES.IdTabTyp;
60: l_bl_raw_cost_sum_tab PA_PLSQL_DATATYPES.NumTabTyp;
61: l_bl_burden_cost_sum_tab PA_PLSQL_DATATYPES.NumTabTyp;
62: l_bl_quantity_sum_tab PA_PLSQL_DATATYPES.NumTabTyp;
63:
64: l_qty_tmp NUMBER:= 0;
65: l_txn_raw_cost_tmp NUMBER:= 0;

Line 62: l_bl_quantity_sum_tab PA_PLSQL_DATATYPES.NumTabTyp;

58: l_quantity_sum_tab PA_PLSQL_DATATYPES.NumTabTyp;
59: l_DELETED_RES_ASG_ID_TAB PA_PLSQL_DATATYPES.IdTabTyp;
60: l_bl_raw_cost_sum_tab PA_PLSQL_DATATYPES.NumTabTyp;
61: l_bl_burden_cost_sum_tab PA_PLSQL_DATATYPES.NumTabTyp;
62: l_bl_quantity_sum_tab PA_PLSQL_DATATYPES.NumTabTyp;
63:
64: l_qty_tmp NUMBER:= 0;
65: l_txn_raw_cost_tmp NUMBER:= 0;
66: l_upd_count NUMBER:= 0;

Line 92: l_res_assgn_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

88: l_msg_data VARCHAR2(2000);
89: l_data VARCHAR2(2000);
90: l_msg_index_out NUMBER:=0;
91: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
92: l_res_assgn_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
93: l_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
94: l_cbs_element_id_tab PA_PLSQL_DATATYPES.IdTabTyp;--bug#16827157
95:
96: l_gen_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 93: l_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

89: l_data VARCHAR2(2000);
90: l_msg_index_out NUMBER:=0;
91: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
92: l_res_assgn_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
93: l_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
94: l_cbs_element_id_tab PA_PLSQL_DATATYPES.IdTabTyp;--bug#16827157
95:
96: l_gen_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
97: l_chk_duplicate_flag VARCHAR2(1) := 'N';

Line 94: l_cbs_element_id_tab PA_PLSQL_DATATYPES.IdTabTyp;--bug#16827157

90: l_msg_index_out NUMBER:=0;
91: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
92: l_res_assgn_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
93: l_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
94: l_cbs_element_id_tab PA_PLSQL_DATATYPES.IdTabTyp;--bug#16827157
95:
96: l_gen_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
97: l_chk_duplicate_flag VARCHAR2(1) := 'N';
98:

Line 96: l_gen_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

92: l_res_assgn_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
93: l_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
94: l_cbs_element_id_tab PA_PLSQL_DATATYPES.IdTabTyp;--bug#16827157
95:
96: l_gen_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
97: l_chk_duplicate_flag VARCHAR2(1) := 'N';
98:
99: l_resource_class_id PA_RESOURCE_CLASSES_B.RESOURCE_CLASS_ID%TYPE;
100:

Line 111: l_TXN_SOURCE_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;

107:
108: l_count1 NUMBER;
109:
110: --Local pl/sql table to call Map_Rlmi_Rbs api
111: l_TXN_SOURCE_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
112: l_TXN_SOURCE_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
113: l_PERSON_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
114: l_JOB_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
115: l_ORGANIZATION_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 112: l_TXN_SOURCE_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

108: l_count1 NUMBER;
109:
110: --Local pl/sql table to call Map_Rlmi_Rbs api
111: l_TXN_SOURCE_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
112: l_TXN_SOURCE_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
113: l_PERSON_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
114: l_JOB_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
115: l_ORGANIZATION_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
116: l_VENDOR_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 113: l_PERSON_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;

109:
110: --Local pl/sql table to call Map_Rlmi_Rbs api
111: l_TXN_SOURCE_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
112: l_TXN_SOURCE_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
113: l_PERSON_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
114: l_JOB_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
115: l_ORGANIZATION_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
116: l_VENDOR_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
117: l_EXPENDITURE_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 114: l_JOB_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;

110: --Local pl/sql table to call Map_Rlmi_Rbs api
111: l_TXN_SOURCE_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
112: l_TXN_SOURCE_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
113: l_PERSON_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
114: l_JOB_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
115: l_ORGANIZATION_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
116: l_VENDOR_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
117: l_EXPENDITURE_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
118: l_EVENT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 115: l_ORGANIZATION_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;

111: l_TXN_SOURCE_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
112: l_TXN_SOURCE_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
113: l_PERSON_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
114: l_JOB_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
115: l_ORGANIZATION_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
116: l_VENDOR_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
117: l_EXPENDITURE_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
118: l_EVENT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
119: l_NON_LABOR_RESOURCE_tab PA_PLSQL_DATATYPES.Char20TabTyp;

Line 116: l_VENDOR_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;

112: l_TXN_SOURCE_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
113: l_PERSON_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
114: l_JOB_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
115: l_ORGANIZATION_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
116: l_VENDOR_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
117: l_EXPENDITURE_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
118: l_EVENT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
119: l_NON_LABOR_RESOURCE_tab PA_PLSQL_DATATYPES.Char20TabTyp;
120: l_EXPENDITURE_CATEGORY_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 117: l_EXPENDITURE_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

113: l_PERSON_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
114: l_JOB_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
115: l_ORGANIZATION_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
116: l_VENDOR_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
117: l_EXPENDITURE_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
118: l_EVENT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
119: l_NON_LABOR_RESOURCE_tab PA_PLSQL_DATATYPES.Char20TabTyp;
120: l_EXPENDITURE_CATEGORY_tab PA_PLSQL_DATATYPES.Char30TabTyp;
121: l_REVENUE_CATEGORY_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 118: l_EVENT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

114: l_JOB_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
115: l_ORGANIZATION_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
116: l_VENDOR_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
117: l_EXPENDITURE_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
118: l_EVENT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
119: l_NON_LABOR_RESOURCE_tab PA_PLSQL_DATATYPES.Char20TabTyp;
120: l_EXPENDITURE_CATEGORY_tab PA_PLSQL_DATATYPES.Char30TabTyp;
121: l_REVENUE_CATEGORY_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
122: l_NLR_ORGANIZATION_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 119: l_NON_LABOR_RESOURCE_tab PA_PLSQL_DATATYPES.Char20TabTyp;

115: l_ORGANIZATION_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
116: l_VENDOR_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
117: l_EXPENDITURE_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
118: l_EVENT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
119: l_NON_LABOR_RESOURCE_tab PA_PLSQL_DATATYPES.Char20TabTyp;
120: l_EXPENDITURE_CATEGORY_tab PA_PLSQL_DATATYPES.Char30TabTyp;
121: l_REVENUE_CATEGORY_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
122: l_NLR_ORGANIZATION_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
123: l_EVENT_CLASSIFICATION_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 120: l_EXPENDITURE_CATEGORY_tab PA_PLSQL_DATATYPES.Char30TabTyp;

116: l_VENDOR_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
117: l_EXPENDITURE_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
118: l_EVENT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
119: l_NON_LABOR_RESOURCE_tab PA_PLSQL_DATATYPES.Char20TabTyp;
120: l_EXPENDITURE_CATEGORY_tab PA_PLSQL_DATATYPES.Char30TabTyp;
121: l_REVENUE_CATEGORY_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
122: l_NLR_ORGANIZATION_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
123: l_EVENT_CLASSIFICATION_tab PA_PLSQL_DATATYPES.Char30TabTyp;
124: l_SYS_LINK_FUNCTION_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 121: l_REVENUE_CATEGORY_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

117: l_EXPENDITURE_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
118: l_EVENT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
119: l_NON_LABOR_RESOURCE_tab PA_PLSQL_DATATYPES.Char20TabTyp;
120: l_EXPENDITURE_CATEGORY_tab PA_PLSQL_DATATYPES.Char30TabTyp;
121: l_REVENUE_CATEGORY_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
122: l_NLR_ORGANIZATION_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
123: l_EVENT_CLASSIFICATION_tab PA_PLSQL_DATATYPES.Char30TabTyp;
124: l_SYS_LINK_FUNCTION_tab PA_PLSQL_DATATYPES.Char30TabTyp;
125: l_PROJECT_ROLE_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 122: l_NLR_ORGANIZATION_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;

118: l_EVENT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
119: l_NON_LABOR_RESOURCE_tab PA_PLSQL_DATATYPES.Char20TabTyp;
120: l_EXPENDITURE_CATEGORY_tab PA_PLSQL_DATATYPES.Char30TabTyp;
121: l_REVENUE_CATEGORY_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
122: l_NLR_ORGANIZATION_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
123: l_EVENT_CLASSIFICATION_tab PA_PLSQL_DATATYPES.Char30TabTyp;
124: l_SYS_LINK_FUNCTION_tab PA_PLSQL_DATATYPES.Char30TabTyp;
125: l_PROJECT_ROLE_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
126: l_RESOURCE_CLASS_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 123: l_EVENT_CLASSIFICATION_tab PA_PLSQL_DATATYPES.Char30TabTyp;

119: l_NON_LABOR_RESOURCE_tab PA_PLSQL_DATATYPES.Char20TabTyp;
120: l_EXPENDITURE_CATEGORY_tab PA_PLSQL_DATATYPES.Char30TabTyp;
121: l_REVENUE_CATEGORY_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
122: l_NLR_ORGANIZATION_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
123: l_EVENT_CLASSIFICATION_tab PA_PLSQL_DATATYPES.Char30TabTyp;
124: l_SYS_LINK_FUNCTION_tab PA_PLSQL_DATATYPES.Char30TabTyp;
125: l_PROJECT_ROLE_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
126: l_RESOURCE_CLASS_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
127: l_MFC_COST_TYPE_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;

Line 124: l_SYS_LINK_FUNCTION_tab PA_PLSQL_DATATYPES.Char30TabTyp;

120: l_EXPENDITURE_CATEGORY_tab PA_PLSQL_DATATYPES.Char30TabTyp;
121: l_REVENUE_CATEGORY_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
122: l_NLR_ORGANIZATION_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
123: l_EVENT_CLASSIFICATION_tab PA_PLSQL_DATATYPES.Char30TabTyp;
124: l_SYS_LINK_FUNCTION_tab PA_PLSQL_DATATYPES.Char30TabTyp;
125: l_PROJECT_ROLE_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
126: l_RESOURCE_CLASS_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
127: l_MFC_COST_TYPE_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
128: l_RESOURCE_CLASS_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;

Line 125: l_PROJECT_ROLE_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;

121: l_REVENUE_CATEGORY_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
122: l_NLR_ORGANIZATION_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
123: l_EVENT_CLASSIFICATION_tab PA_PLSQL_DATATYPES.Char30TabTyp;
124: l_SYS_LINK_FUNCTION_tab PA_PLSQL_DATATYPES.Char30TabTyp;
125: l_PROJECT_ROLE_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
126: l_RESOURCE_CLASS_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
127: l_MFC_COST_TYPE_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
128: l_RESOURCE_CLASS_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
129: l_FC_RES_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 126: l_RESOURCE_CLASS_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

122: l_NLR_ORGANIZATION_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
123: l_EVENT_CLASSIFICATION_tab PA_PLSQL_DATATYPES.Char30TabTyp;
124: l_SYS_LINK_FUNCTION_tab PA_PLSQL_DATATYPES.Char30TabTyp;
125: l_PROJECT_ROLE_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
126: l_RESOURCE_CLASS_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
127: l_MFC_COST_TYPE_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
128: l_RESOURCE_CLASS_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
129: l_FC_RES_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
130: l_INVENTORY_ITEM_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;

Line 127: l_MFC_COST_TYPE_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;

123: l_EVENT_CLASSIFICATION_tab PA_PLSQL_DATATYPES.Char30TabTyp;
124: l_SYS_LINK_FUNCTION_tab PA_PLSQL_DATATYPES.Char30TabTyp;
125: l_PROJECT_ROLE_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
126: l_RESOURCE_CLASS_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
127: l_MFC_COST_TYPE_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
128: l_RESOURCE_CLASS_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
129: l_FC_RES_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
130: l_INVENTORY_ITEM_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
131: l_ITEM_CATEGORY_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;

Line 128: l_RESOURCE_CLASS_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;

124: l_SYS_LINK_FUNCTION_tab PA_PLSQL_DATATYPES.Char30TabTyp;
125: l_PROJECT_ROLE_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
126: l_RESOURCE_CLASS_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
127: l_MFC_COST_TYPE_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
128: l_RESOURCE_CLASS_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
129: l_FC_RES_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
130: l_INVENTORY_ITEM_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
131: l_ITEM_CATEGORY_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
132: l_PERSON_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 129: l_FC_RES_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

125: l_PROJECT_ROLE_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
126: l_RESOURCE_CLASS_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
127: l_MFC_COST_TYPE_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
128: l_RESOURCE_CLASS_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
129: l_FC_RES_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
130: l_INVENTORY_ITEM_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
131: l_ITEM_CATEGORY_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
132: l_PERSON_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
133: l_BOM_RESOURCE_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;

Line 130: l_INVENTORY_ITEM_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;

126: l_RESOURCE_CLASS_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
127: l_MFC_COST_TYPE_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
128: l_RESOURCE_CLASS_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
129: l_FC_RES_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
130: l_INVENTORY_ITEM_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
131: l_ITEM_CATEGORY_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
132: l_PERSON_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
133: l_BOM_RESOURCE_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
134: l_NAMED_ROLE_tab PA_PLSQL_DATATYPES.Char80TabTyp;

Line 131: l_ITEM_CATEGORY_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;

127: l_MFC_COST_TYPE_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
128: l_RESOURCE_CLASS_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
129: l_FC_RES_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
130: l_INVENTORY_ITEM_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
131: l_ITEM_CATEGORY_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
132: l_PERSON_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
133: l_BOM_RESOURCE_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
134: l_NAMED_ROLE_tab PA_PLSQL_DATATYPES.Char80TabTyp;
135: l_INCURRED_BY_RES_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;

Line 132: l_PERSON_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

128: l_RESOURCE_CLASS_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
129: l_FC_RES_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
130: l_INVENTORY_ITEM_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
131: l_ITEM_CATEGORY_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
132: l_PERSON_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
133: l_BOM_RESOURCE_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
134: l_NAMED_ROLE_tab PA_PLSQL_DATATYPES.Char80TabTyp;
135: l_INCURRED_BY_RES_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
136: l_RATE_BASED_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;

Line 133: l_BOM_RESOURCE_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;

129: l_FC_RES_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
130: l_INVENTORY_ITEM_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
131: l_ITEM_CATEGORY_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
132: l_PERSON_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
133: l_BOM_RESOURCE_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
134: l_NAMED_ROLE_tab PA_PLSQL_DATATYPES.Char80TabTyp;
135: l_INCURRED_BY_RES_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
136: l_RATE_BASED_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
137: l_TXN_TASK_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 134: l_NAMED_ROLE_tab PA_PLSQL_DATATYPES.Char80TabTyp;

130: l_INVENTORY_ITEM_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
131: l_ITEM_CATEGORY_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
132: l_PERSON_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
133: l_BOM_RESOURCE_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
134: l_NAMED_ROLE_tab PA_PLSQL_DATATYPES.Char80TabTyp;
135: l_INCURRED_BY_RES_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
136: l_RATE_BASED_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
137: l_TXN_TASK_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
138: l_TXN_WBS_ELEMENT_VER_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 135: l_INCURRED_BY_RES_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;

131: l_ITEM_CATEGORY_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
132: l_PERSON_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
133: l_BOM_RESOURCE_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
134: l_NAMED_ROLE_tab PA_PLSQL_DATATYPES.Char80TabTyp;
135: l_INCURRED_BY_RES_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
136: l_RATE_BASED_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
137: l_TXN_TASK_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
138: l_TXN_WBS_ELEMENT_VER_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
139: l_TXN_RBS_ELEMENT_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 136: l_RATE_BASED_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;

132: l_PERSON_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
133: l_BOM_RESOURCE_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
134: l_NAMED_ROLE_tab PA_PLSQL_DATATYPES.Char80TabTyp;
135: l_INCURRED_BY_RES_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
136: l_RATE_BASED_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
137: l_TXN_TASK_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
138: l_TXN_WBS_ELEMENT_VER_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
139: l_TXN_RBS_ELEMENT_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
140: l_TXN_PLAN_START_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;

Line 137: l_TXN_TASK_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;

133: l_BOM_RESOURCE_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
134: l_NAMED_ROLE_tab PA_PLSQL_DATATYPES.Char80TabTyp;
135: l_INCURRED_BY_RES_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
136: l_RATE_BASED_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
137: l_TXN_TASK_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
138: l_TXN_WBS_ELEMENT_VER_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
139: l_TXN_RBS_ELEMENT_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
140: l_TXN_PLAN_START_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
141: l_TXN_PLAN_END_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;

Line 138: l_TXN_WBS_ELEMENT_VER_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;

134: l_NAMED_ROLE_tab PA_PLSQL_DATATYPES.Char80TabTyp;
135: l_INCURRED_BY_RES_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
136: l_RATE_BASED_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
137: l_TXN_TASK_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
138: l_TXN_WBS_ELEMENT_VER_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
139: l_TXN_RBS_ELEMENT_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
140: l_TXN_PLAN_START_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
141: l_TXN_PLAN_END_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
142: --out param from PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS

Line 139: l_TXN_RBS_ELEMENT_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;

135: l_INCURRED_BY_RES_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
136: l_RATE_BASED_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
137: l_TXN_TASK_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
138: l_TXN_WBS_ELEMENT_VER_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
139: l_TXN_RBS_ELEMENT_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
140: l_TXN_PLAN_START_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
141: l_TXN_PLAN_END_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
142: --out param from PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS
143: l_map_txn_source_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 140: l_TXN_PLAN_START_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;

136: l_RATE_BASED_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;
137: l_TXN_TASK_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
138: l_TXN_WBS_ELEMENT_VER_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
139: l_TXN_RBS_ELEMENT_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
140: l_TXN_PLAN_START_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
141: l_TXN_PLAN_END_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
142: --out param from PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS
143: l_map_txn_source_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
144: l_map_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 141: l_TXN_PLAN_END_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;

137: l_TXN_TASK_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
138: l_TXN_WBS_ELEMENT_VER_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
139: l_TXN_RBS_ELEMENT_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
140: l_TXN_PLAN_START_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
141: l_TXN_PLAN_END_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
142: --out param from PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS
143: l_map_txn_source_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
144: l_map_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
145: l_map_rbs_element_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 143: l_map_txn_source_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

139: l_TXN_RBS_ELEMENT_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;
140: l_TXN_PLAN_START_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
141: l_TXN_PLAN_END_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
142: --out param from PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS
143: l_map_txn_source_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
144: l_map_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
145: l_map_rbs_element_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
146: l_map_txn_accum_header_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
147:

Line 144: l_map_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

140: l_TXN_PLAN_START_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
141: l_TXN_PLAN_END_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
142: --out param from PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS
143: l_map_txn_source_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
144: l_map_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
145: l_map_rbs_element_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
146: l_map_txn_accum_header_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
147:
148: -- Bug 4251148: When the Target is a Forecast version with Cost and Revenue

Line 145: l_map_rbs_element_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

141: l_TXN_PLAN_END_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
142: --out param from PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS
143: l_map_txn_source_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
144: l_map_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
145: l_map_rbs_element_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
146: l_map_txn_accum_header_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
147:
148: -- Bug 4251148: When the Target is a Forecast version with Cost and Revenue
149: -- planned together and accrual method is Work, we will call the Calculate

Line 146: l_map_txn_accum_header_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

142: --out param from PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS
143: l_map_txn_source_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
144: l_map_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
145: l_map_rbs_element_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
146: l_map_txn_accum_header_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
147:
148: -- Bug 4251148: When the Target is a Forecast version with Cost and Revenue
149: -- planned together and accrual method is Work, we will call the Calculate
150: -- API to compute revenue amounts.

Line 187: l_index_tab PA_PLSQL_DATATYPES.IdTabTyp;

183: l_index NUMBER;
184: bl_index NUMBER;
185:
186: kk NUMBER; -- an index variable during aggregation logic
187: l_index_tab PA_PLSQL_DATATYPES.IdTabTyp;
188:
189: -- temporary pl/sql tables to hold pre-aggregated amounts
190: l_cal_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
191: l_cal_tgt_rate_based_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;

Line 190: l_cal_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

186: kk NUMBER; -- an index variable during aggregation logic
187: l_index_tab PA_PLSQL_DATATYPES.IdTabTyp;
188:
189: -- temporary pl/sql tables to hold pre-aggregated amounts
190: l_cal_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
191: l_cal_tgt_rate_based_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
192: l_cal_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
193: l_cal_line_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
194: l_cal_line_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

Line 191: l_cal_tgt_rate_based_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;

187: l_index_tab PA_PLSQL_DATATYPES.IdTabTyp;
188:
189: -- temporary pl/sql tables to hold pre-aggregated amounts
190: l_cal_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
191: l_cal_tgt_rate_based_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
192: l_cal_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
193: l_cal_line_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
194: l_cal_line_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
195:

Line 192: l_cal_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

188:
189: -- temporary pl/sql tables to hold pre-aggregated amounts
190: l_cal_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
191: l_cal_tgt_rate_based_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
192: l_cal_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
193: l_cal_line_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
194: l_cal_line_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
195:
196: l_cal_cmt_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 193: l_cal_line_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

189: -- temporary pl/sql tables to hold pre-aggregated amounts
190: l_cal_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
191: l_cal_tgt_rate_based_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
192: l_cal_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
193: l_cal_line_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
194: l_cal_line_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
195:
196: l_cal_cmt_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
197: l_cal_cmt_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 194: l_cal_line_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

190: l_cal_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
191: l_cal_tgt_rate_based_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
192: l_cal_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
193: l_cal_line_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
194: l_cal_line_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
195:
196: l_cal_cmt_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
197: l_cal_cmt_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
198: l_cal_cmt_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 196: l_cal_cmt_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;

192: l_cal_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
193: l_cal_line_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
194: l_cal_line_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
195:
196: l_cal_cmt_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
197: l_cal_cmt_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
198: l_cal_cmt_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
199:
200: l_cal_base_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 197: l_cal_cmt_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

193: l_cal_line_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
194: l_cal_line_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
195:
196: l_cal_cmt_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
197: l_cal_cmt_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
198: l_cal_cmt_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
199:
200: l_cal_base_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
201: l_cal_base_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 198: l_cal_cmt_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

194: l_cal_line_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
195:
196: l_cal_cmt_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
197: l_cal_cmt_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
198: l_cal_cmt_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
199:
200: l_cal_base_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
201: l_cal_base_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
202: l_cal_base_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 200: l_cal_base_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;

196: l_cal_cmt_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
197: l_cal_cmt_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
198: l_cal_cmt_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
199:
200: l_cal_base_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
201: l_cal_base_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
202: l_cal_base_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
203:
204: -- budget line amounts for update records

Line 201: l_cal_base_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

197: l_cal_cmt_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
198: l_cal_cmt_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
199:
200: l_cal_base_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
201: l_cal_base_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
202: l_cal_base_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
203:
204: -- budget line amounts for update records
205: l_bl_quantity PA_BUDGET_LINES.QUANTITY%TYPE;

Line 202: l_cal_base_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

198: l_cal_cmt_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
199:
200: l_cal_base_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
201: l_cal_base_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
202: l_cal_base_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
203:
204: -- budget line amounts for update records
205: l_bl_quantity PA_BUDGET_LINES.QUANTITY%TYPE;
206: l_bl_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;

Line 232: l_budget_line_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

228:
229: l_budget_line_id PA_BUDGET_LINES.BUDGET_LINE_ID%TYPE;
230: -- stores ids of existing budget lines that need to be deleted
231: -- before Calculate API is called so that a difference is detected.
232: l_budget_line_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
233:
234: /* String constants for valid Calling Context values */
235: lc_BudgetGeneration CONSTANT VARCHAR2(30) := 'BUDGET_GENERATION';
236: lc_ForecastGeneration CONSTANT VARCHAR2(30) := 'FORECAST_GENERATION';

Line 275: l_rej_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

271: continue_loop EXCEPTION;
272: l_dummy NUMBER;
273:
274: -- Bug 4549862: Variables to process rejection codes
275: l_rej_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
276: l_cost_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
277: l_burden_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
278: l_pc_cur_conv_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
279: l_pfc_cur_conv_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 276: l_cost_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

272: l_dummy NUMBER;
273:
274: -- Bug 4549862: Variables to process rejection codes
275: l_rej_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
276: l_cost_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
277: l_burden_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
278: l_pc_cur_conv_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
279: l_pfc_cur_conv_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
280:

Line 277: l_burden_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

273:
274: -- Bug 4549862: Variables to process rejection codes
275: l_rej_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
276: l_cost_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
277: l_burden_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
278: l_pc_cur_conv_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
279: l_pfc_cur_conv_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
280:
281: l_project_name PA_PROJECTS_ALL.NAME%TYPE;

Line 278: l_pc_cur_conv_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

274: -- Bug 4549862: Variables to process rejection codes
275: l_rej_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
276: l_cost_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
277: l_burden_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
278: l_pc_cur_conv_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
279: l_pfc_cur_conv_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
280:
281: l_project_name PA_PROJECTS_ALL.NAME%TYPE;
282: l_task_number PA_TASKS.TASK_NUMBER%TYPE;

Line 279: l_pfc_cur_conv_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

275: l_rej_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
276: l_cost_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
277: l_burden_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
278: l_pc_cur_conv_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
279: l_pfc_cur_conv_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
280:
281: l_project_name PA_PROJECTS_ALL.NAME%TYPE;
282: l_task_number PA_TASKS.TASK_NUMBER%TYPE;
283: l_resource_name PA_RESOURCE_LIST_MEMBERS.ALIAS%TYPE;

Line 291: l_sr_src_ra_id_tab PA_PLSQL_DATATYPES.NumTabTyp;

287: l_fp_cols_rec_src_finplan PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
288: l_fp_planning_options_flag VARCHAR2(1);
289:
290: -- pl/sql tables to store parameters for POPULATE_GEN_RATE API
291: l_sr_src_ra_id_tab PA_PLSQL_DATATYPES.NumTabTyp;
292: l_sr_tgt_ra_id_tab PA_PLSQL_DATATYPES.NumTabTyp;
293: l_sr_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
294:
295: BEGIN

Line 292: l_sr_tgt_ra_id_tab PA_PLSQL_DATATYPES.NumTabTyp;

288: l_fp_planning_options_flag VARCHAR2(1);
289:
290: -- pl/sql tables to store parameters for POPULATE_GEN_RATE API
291: l_sr_src_ra_id_tab PA_PLSQL_DATATYPES.NumTabTyp;
292: l_sr_tgt_ra_id_tab PA_PLSQL_DATATYPES.NumTabTyp;
293: l_sr_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
294:
295: BEGIN
296: -- hr_utility.trace_on(null,'mftest');

Line 293: l_sr_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

289:
290: -- pl/sql tables to store parameters for POPULATE_GEN_RATE API
291: l_sr_src_ra_id_tab PA_PLSQL_DATATYPES.NumTabTyp;
292: l_sr_tgt_ra_id_tab PA_PLSQL_DATATYPES.NumTabTyp;
293: l_sr_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
294:
295: BEGIN
296: -- hr_utility.trace_on(null,'mftest');
297: /* hr_utility.trace('---BEGIN---'); */