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_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:
95: l_gen_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
96: l_chk_duplicate_flag VARCHAR2(1) := 'N';

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:
95: l_gen_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
96: l_chk_duplicate_flag VARCHAR2(1) := 'N';
97:

Line 95: l_gen_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

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:
95: l_gen_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
96: l_chk_duplicate_flag VARCHAR2(1) := 'N';
97:
98: l_resource_class_id PA_RESOURCE_CLASSES_B.RESOURCE_CLASS_ID%TYPE;
99:

Line 110: l_TXN_SOURCE_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;

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

Line 111: l_TXN_SOURCE_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 112: l_PERSON_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;

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

Line 113: l_JOB_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;

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

Line 114: l_ORGANIZATION_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;

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

Line 115: l_VENDOR_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;

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

Line 116: l_EXPENDITURE_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 117: l_EVENT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 118: l_NON_LABOR_RESOURCE_tab PA_PLSQL_DATATYPES.Char20TabTyp;

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

Line 119: l_EXPENDITURE_CATEGORY_tab PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 120: l_REVENUE_CATEGORY_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 121: l_NLR_ORGANIZATION_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;

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

Line 122: l_EVENT_CLASSIFICATION_tab PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 123: l_SYS_LINK_FUNCTION_tab PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 124: l_PROJECT_ROLE_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;

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

Line 125: l_RESOURCE_CLASS_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 126: l_MFC_COST_TYPE_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;

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

Line 127: l_RESOURCE_CLASS_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;

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

Line 128: l_FC_RES_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 129: l_INVENTORY_ITEM_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;

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

Line 130: l_ITEM_CATEGORY_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;

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

Line 131: l_PERSON_TYPE_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 132: l_BOM_RESOURCE_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;

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

Line 133: l_NAMED_ROLE_tab PA_PLSQL_DATATYPES.Char80TabTyp;

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

Line 134: l_INCURRED_BY_RES_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;

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

Line 135: l_RATE_BASED_FLAG_tab PA_PLSQL_DATATYPES.Char1TabTyp;

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

Line 136: l_TXN_TASK_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;

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

Line 137: l_TXN_WBS_ELEMENT_VER_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;

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

Line 138: l_TXN_RBS_ELEMENT_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;

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

Line 139: l_TXN_PLAN_START_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;

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

Line 140: l_TXN_PLAN_END_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;

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

Line 142: l_map_txn_source_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

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

Line 143: l_map_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

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

Line 144: l_map_rbs_element_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

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

Line 145: l_map_txn_accum_header_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

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

Line 186: l_index_tab PA_PLSQL_DATATYPES.IdTabTyp;

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

Line 189: l_cal_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

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

Line 190: l_cal_tgt_rate_based_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;

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

Line 191: l_cal_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 192: l_cal_line_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

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

Line 193: l_cal_line_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

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

Line 195: l_cal_cmt_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;

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

Line 196: l_cal_cmt_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

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

Line 197: l_cal_cmt_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

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

Line 199: l_cal_base_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;

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

Line 200: l_cal_base_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

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

Line 201: l_cal_base_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

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

Line 231: l_budget_line_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

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

Line 274: l_rej_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

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

Line 275: l_cost_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 276: l_burden_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 277: l_pc_cur_conv_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 278: l_pfc_cur_conv_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

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

Line 290: l_sr_src_ra_id_tab PA_PLSQL_DATATYPES.NumTabTyp;

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

Line 291: l_sr_tgt_ra_id_tab PA_PLSQL_DATATYPES.NumTabTyp;

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

Line 292: l_sr_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

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