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_WEBADI_PKG dependencies on PA_BUDGET_LINES

Line 7: pa_budget_lines.BUDGET_LINE_ID%TYPE INDEX BY BINARY_INTEGER ;

3:
4: /* PL/SQL table type declaration */
5:
6: TYPE l_budget_line_id_tbl_typ IS TABLE OF
7: pa_budget_lines.BUDGET_LINE_ID%TYPE INDEX BY BINARY_INTEGER ;
8: TYPE l_budget_version_id_tbl_typ IS TABLE OF
9: pa_budget_lines.BUDGET_VERSION_ID%TYPE INDEX BY BINARY_INTEGER ;
10: TYPE l_project_id_tbl_typ IS TABLE OF
11: pa_resource_assignments.PROJECT_ID%TYPE INDEX BY BINARY_INTEGER ;

Line 9: pa_budget_lines.BUDGET_VERSION_ID%TYPE INDEX BY BINARY_INTEGER ;

5:
6: TYPE l_budget_line_id_tbl_typ IS TABLE OF
7: pa_budget_lines.BUDGET_LINE_ID%TYPE INDEX BY BINARY_INTEGER ;
8: TYPE l_budget_version_id_tbl_typ IS TABLE OF
9: pa_budget_lines.BUDGET_VERSION_ID%TYPE INDEX BY BINARY_INTEGER ;
10: TYPE l_project_id_tbl_typ IS TABLE OF
11: pa_resource_assignments.PROJECT_ID%TYPE INDEX BY BINARY_INTEGER ;
12: TYPE l_res_assignment_id_tbl_typ IS TABLE OF
13: pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE INDEX BY BINARY_INTEGER ;

Line 29: pa_budget_lines.START_DATE%TYPE INDEX BY BINARY_INTEGER ;

25: pa_resource_list_members.ALIAS%TYPE INDEX BY BINARY_INTEGER ;
26: TYPE l_task_number_tbl_typ IS TABLE OF
27: pa_tasks.TASK_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
28: TYPE l_start_date_tbl_typ IS TABLE OF
29: pa_budget_lines.START_DATE%TYPE INDEX BY BINARY_INTEGER ;
30: TYPE l_end_date_tbl_typ IS TABLE OF
31: pa_budget_lines.END_DATE%TYPE INDEX BY BINARY_INTEGER ;
32: TYPE l_amount_tbl_typ IS TABLE OF NUMBER INDEX BY BINARY_INTEGER ;
33: TYPE l_burdened_cost_tbl_typ IS TABLE OF

Line 31: pa_budget_lines.END_DATE%TYPE INDEX BY BINARY_INTEGER ;

27: pa_tasks.TASK_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
28: TYPE l_start_date_tbl_typ IS TABLE OF
29: pa_budget_lines.START_DATE%TYPE INDEX BY BINARY_INTEGER ;
30: TYPE l_end_date_tbl_typ IS TABLE OF
31: pa_budget_lines.END_DATE%TYPE INDEX BY BINARY_INTEGER ;
32: TYPE l_amount_tbl_typ IS TABLE OF NUMBER INDEX BY BINARY_INTEGER ;
33: TYPE l_burdened_cost_tbl_typ IS TABLE OF
34: pa_budget_lines.BURDENED_COST%TYPE INDEX BY BINARY_INTEGER ;
35: TYPE l_revenue_tbl_typ IS TABLE OF

Line 34: pa_budget_lines.BURDENED_COST%TYPE INDEX BY BINARY_INTEGER ;

30: TYPE l_end_date_tbl_typ IS TABLE OF
31: pa_budget_lines.END_DATE%TYPE INDEX BY BINARY_INTEGER ;
32: TYPE l_amount_tbl_typ IS TABLE OF NUMBER INDEX BY BINARY_INTEGER ;
33: TYPE l_burdened_cost_tbl_typ IS TABLE OF
34: pa_budget_lines.BURDENED_COST%TYPE INDEX BY BINARY_INTEGER ;
35: TYPE l_revenue_tbl_typ IS TABLE OF
36: pa_budget_lines.REVENUE%TYPE INDEX BY BINARY_INTEGER ;
37: TYPE l_quantity_tbl_typ IS TABLE OF
38: pa_budget_lines.QUANTITY%TYPE INDEX BY BINARY_INTEGER ;

Line 36: pa_budget_lines.REVENUE%TYPE INDEX BY BINARY_INTEGER ;

32: TYPE l_amount_tbl_typ IS TABLE OF NUMBER INDEX BY BINARY_INTEGER ;
33: TYPE l_burdened_cost_tbl_typ IS TABLE OF
34: pa_budget_lines.BURDENED_COST%TYPE INDEX BY BINARY_INTEGER ;
35: TYPE l_revenue_tbl_typ IS TABLE OF
36: pa_budget_lines.REVENUE%TYPE INDEX BY BINARY_INTEGER ;
37: TYPE l_quantity_tbl_typ IS TABLE OF
38: pa_budget_lines.QUANTITY%TYPE INDEX BY BINARY_INTEGER ;
39: TYPE l_txn_currency_code_tbl_typ IS TABLE OF
40: pa_budget_lines.TXN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER ;

Line 38: pa_budget_lines.QUANTITY%TYPE INDEX BY BINARY_INTEGER ;

34: pa_budget_lines.BURDENED_COST%TYPE INDEX BY BINARY_INTEGER ;
35: TYPE l_revenue_tbl_typ IS TABLE OF
36: pa_budget_lines.REVENUE%TYPE INDEX BY BINARY_INTEGER ;
37: TYPE l_quantity_tbl_typ IS TABLE OF
38: pa_budget_lines.QUANTITY%TYPE INDEX BY BINARY_INTEGER ;
39: TYPE l_txn_currency_code_tbl_typ IS TABLE OF
40: pa_budget_lines.TXN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER ;
41: TYPE l_delete_flag_tbl_typ IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER ;
42: TYPE l_unit_of_measure_tbl_typ IS TABLE OF

Line 40: pa_budget_lines.TXN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER ;

36: pa_budget_lines.REVENUE%TYPE INDEX BY BINARY_INTEGER ;
37: TYPE l_quantity_tbl_typ IS TABLE OF
38: pa_budget_lines.QUANTITY%TYPE INDEX BY BINARY_INTEGER ;
39: TYPE l_txn_currency_code_tbl_typ IS TABLE OF
40: pa_budget_lines.TXN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER ;
41: TYPE l_delete_flag_tbl_typ IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER ;
42: TYPE l_unit_of_measure_tbl_typ IS TABLE OF
43: pa_resource_assignments.UNIT_OF_MEASURE%TYPE INDEX BY BINARY_INTEGER ;
44: TYPE l_description_tbl_typ IS TABLE OF

Line 45: pa_budget_lines.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;

41: TYPE l_delete_flag_tbl_typ IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER ;
42: TYPE l_unit_of_measure_tbl_typ IS TABLE OF
43: pa_resource_assignments.UNIT_OF_MEASURE%TYPE INDEX BY BINARY_INTEGER ;
44: TYPE l_description_tbl_typ IS TABLE OF
45: pa_budget_lines.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
46: TYPE l_change_reason_code_tbl_typ IS TABLE OF
47: pa_budget_lines.PERIOD_NAME%TYPE INDEX BY BINARY_INTEGER ;
48: TYPE l_meaning_tbl_typ IS TABLE OF
49: pa_lookups.meaning%TYPE INDEX BY BINARY_INTEGER ;

Line 47: pa_budget_lines.PERIOD_NAME%TYPE INDEX BY BINARY_INTEGER ;

43: pa_resource_assignments.UNIT_OF_MEASURE%TYPE INDEX BY BINARY_INTEGER ;
44: TYPE l_description_tbl_typ IS TABLE OF
45: pa_budget_lines.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER ;
46: TYPE l_change_reason_code_tbl_typ IS TABLE OF
47: pa_budget_lines.PERIOD_NAME%TYPE INDEX BY BINARY_INTEGER ;
48: TYPE l_meaning_tbl_typ IS TABLE OF
49: pa_lookups.meaning%TYPE INDEX BY BINARY_INTEGER ;
50:
51: TYPE l_pf_cost_rate_type_tbl_typ IS TABLE OF

Line 52: pa_budget_lines.PROJFUNC_COST_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER ;

48: TYPE l_meaning_tbl_typ IS TABLE OF
49: pa_lookups.meaning%TYPE INDEX BY BINARY_INTEGER ;
50:
51: TYPE l_pf_cost_rate_type_tbl_typ IS TABLE OF
52: pa_budget_lines.PROJFUNC_COST_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
53: TYPE l_pf_cost_rt_dt_type_tbl_typ IS TABLE OF
54: pa_budget_lines.PROJFUNC_COST_RATE_DATE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
55: TYPE l_pf_cost_exc_rate_tbl_typ IS TABLE OF
56: pa_budget_lines.PROJFUNC_COST_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER ;

Line 54: pa_budget_lines.PROJFUNC_COST_RATE_DATE_TYPE%TYPE INDEX BY BINARY_INTEGER ;

50:
51: TYPE l_pf_cost_rate_type_tbl_typ IS TABLE OF
52: pa_budget_lines.PROJFUNC_COST_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
53: TYPE l_pf_cost_rt_dt_type_tbl_typ IS TABLE OF
54: pa_budget_lines.PROJFUNC_COST_RATE_DATE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
55: TYPE l_pf_cost_exc_rate_tbl_typ IS TABLE OF
56: pa_budget_lines.PROJFUNC_COST_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER ;
57: TYPE l_pf_cost_rate_date_tbl_typ IS TABLE OF
58: pa_budget_lines.PROJFUNC_COST_RATE_DATE%TYPE INDEX BY BINARY_INTEGER ;

Line 56: pa_budget_lines.PROJFUNC_COST_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER ;

52: pa_budget_lines.PROJFUNC_COST_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
53: TYPE l_pf_cost_rt_dt_type_tbl_typ IS TABLE OF
54: pa_budget_lines.PROJFUNC_COST_RATE_DATE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
55: TYPE l_pf_cost_exc_rate_tbl_typ IS TABLE OF
56: pa_budget_lines.PROJFUNC_COST_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER ;
57: TYPE l_pf_cost_rate_date_tbl_typ IS TABLE OF
58: pa_budget_lines.PROJFUNC_COST_RATE_DATE%TYPE INDEX BY BINARY_INTEGER ;
59:
60: TYPE l_proj_cost_rate_type_tbl_typ IS TABLE OF

Line 58: pa_budget_lines.PROJFUNC_COST_RATE_DATE%TYPE INDEX BY BINARY_INTEGER ;

54: pa_budget_lines.PROJFUNC_COST_RATE_DATE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
55: TYPE l_pf_cost_exc_rate_tbl_typ IS TABLE OF
56: pa_budget_lines.PROJFUNC_COST_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER ;
57: TYPE l_pf_cost_rate_date_tbl_typ IS TABLE OF
58: pa_budget_lines.PROJFUNC_COST_RATE_DATE%TYPE INDEX BY BINARY_INTEGER ;
59:
60: TYPE l_proj_cost_rate_type_tbl_typ IS TABLE OF
61: pa_budget_lines.PROJECT_COST_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
62: TYPE l_proj_cost_rt_dt_type_tbl_typ IS TABLE OF

Line 61: pa_budget_lines.PROJECT_COST_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER ;

57: TYPE l_pf_cost_rate_date_tbl_typ IS TABLE OF
58: pa_budget_lines.PROJFUNC_COST_RATE_DATE%TYPE INDEX BY BINARY_INTEGER ;
59:
60: TYPE l_proj_cost_rate_type_tbl_typ IS TABLE OF
61: pa_budget_lines.PROJECT_COST_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
62: TYPE l_proj_cost_rt_dt_type_tbl_typ IS TABLE OF
63: pa_budget_lines.PROJECT_COST_RATE_DATE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
64: TYPE l_proj_cost_exc_rate_tbl_typ IS TABLE OF
65: pa_budget_lines.PROJECT_COST_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER ;

Line 63: pa_budget_lines.PROJECT_COST_RATE_DATE_TYPE%TYPE INDEX BY BINARY_INTEGER ;

59:
60: TYPE l_proj_cost_rate_type_tbl_typ IS TABLE OF
61: pa_budget_lines.PROJECT_COST_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
62: TYPE l_proj_cost_rt_dt_type_tbl_typ IS TABLE OF
63: pa_budget_lines.PROJECT_COST_RATE_DATE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
64: TYPE l_proj_cost_exc_rate_tbl_typ IS TABLE OF
65: pa_budget_lines.PROJECT_COST_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER ;
66: TYPE l_proj_cost_rate_date_tbl_typ IS TABLE OF
67: pa_budget_lines.PROJECT_COST_RATE_DATE%TYPE INDEX BY BINARY_INTEGER ;

Line 65: pa_budget_lines.PROJECT_COST_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER ;

61: pa_budget_lines.PROJECT_COST_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
62: TYPE l_proj_cost_rt_dt_type_tbl_typ IS TABLE OF
63: pa_budget_lines.PROJECT_COST_RATE_DATE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
64: TYPE l_proj_cost_exc_rate_tbl_typ IS TABLE OF
65: pa_budget_lines.PROJECT_COST_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER ;
66: TYPE l_proj_cost_rate_date_tbl_typ IS TABLE OF
67: pa_budget_lines.PROJECT_COST_RATE_DATE%TYPE INDEX BY BINARY_INTEGER ;
68:
69: TYPE l_pf_rev_rate_type_tbl_typ IS TABLE OF

Line 67: pa_budget_lines.PROJECT_COST_RATE_DATE%TYPE INDEX BY BINARY_INTEGER ;

63: pa_budget_lines.PROJECT_COST_RATE_DATE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
64: TYPE l_proj_cost_exc_rate_tbl_typ IS TABLE OF
65: pa_budget_lines.PROJECT_COST_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER ;
66: TYPE l_proj_cost_rate_date_tbl_typ IS TABLE OF
67: pa_budget_lines.PROJECT_COST_RATE_DATE%TYPE INDEX BY BINARY_INTEGER ;
68:
69: TYPE l_pf_rev_rate_type_tbl_typ IS TABLE OF
70: pa_budget_lines.PROJFUNC_REV_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
71: TYPE l_pf_rev_rt_dt_type_tbl_typ IS TABLE OF

Line 70: pa_budget_lines.PROJFUNC_REV_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER ;

66: TYPE l_proj_cost_rate_date_tbl_typ IS TABLE OF
67: pa_budget_lines.PROJECT_COST_RATE_DATE%TYPE INDEX BY BINARY_INTEGER ;
68:
69: TYPE l_pf_rev_rate_type_tbl_typ IS TABLE OF
70: pa_budget_lines.PROJFUNC_REV_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
71: TYPE l_pf_rev_rt_dt_type_tbl_typ IS TABLE OF
72: pa_budget_lines.PROJFUNC_REV_RATE_DATE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
73: TYPE l_pf_rev_exc_rate_tbl_typ IS TABLE OF
74: pa_budget_lines.PROJFUNC_REV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER ;

Line 72: pa_budget_lines.PROJFUNC_REV_RATE_DATE_TYPE%TYPE INDEX BY BINARY_INTEGER ;

68:
69: TYPE l_pf_rev_rate_type_tbl_typ IS TABLE OF
70: pa_budget_lines.PROJFUNC_REV_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
71: TYPE l_pf_rev_rt_dt_type_tbl_typ IS TABLE OF
72: pa_budget_lines.PROJFUNC_REV_RATE_DATE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
73: TYPE l_pf_rev_exc_rate_tbl_typ IS TABLE OF
74: pa_budget_lines.PROJFUNC_REV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER ;
75: TYPE l_pf_rev_rate_date_tbl_typ IS TABLE OF
76: pa_budget_lines.PROJFUNC_REV_RATE_DATE%TYPE INDEX BY BINARY_INTEGER ;

Line 74: pa_budget_lines.PROJFUNC_REV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER ;

70: pa_budget_lines.PROJFUNC_REV_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
71: TYPE l_pf_rev_rt_dt_type_tbl_typ IS TABLE OF
72: pa_budget_lines.PROJFUNC_REV_RATE_DATE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
73: TYPE l_pf_rev_exc_rate_tbl_typ IS TABLE OF
74: pa_budget_lines.PROJFUNC_REV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER ;
75: TYPE l_pf_rev_rate_date_tbl_typ IS TABLE OF
76: pa_budget_lines.PROJFUNC_REV_RATE_DATE%TYPE INDEX BY BINARY_INTEGER ;
77:
78: TYPE l_proj_rev_rate_type_tbl_typ IS TABLE OF

Line 76: pa_budget_lines.PROJFUNC_REV_RATE_DATE%TYPE INDEX BY BINARY_INTEGER ;

72: pa_budget_lines.PROJFUNC_REV_RATE_DATE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
73: TYPE l_pf_rev_exc_rate_tbl_typ IS TABLE OF
74: pa_budget_lines.PROJFUNC_REV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER ;
75: TYPE l_pf_rev_rate_date_tbl_typ IS TABLE OF
76: pa_budget_lines.PROJFUNC_REV_RATE_DATE%TYPE INDEX BY BINARY_INTEGER ;
77:
78: TYPE l_proj_rev_rate_type_tbl_typ IS TABLE OF
79: pa_budget_lines.PROJECT_REV_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
80: TYPE l_proj_rev_rt_dt_type_tbl_typ IS TABLE OF

Line 79: pa_budget_lines.PROJECT_REV_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER ;

75: TYPE l_pf_rev_rate_date_tbl_typ IS TABLE OF
76: pa_budget_lines.PROJFUNC_REV_RATE_DATE%TYPE INDEX BY BINARY_INTEGER ;
77:
78: TYPE l_proj_rev_rate_type_tbl_typ IS TABLE OF
79: pa_budget_lines.PROJECT_REV_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
80: TYPE l_proj_rev_rt_dt_type_tbl_typ IS TABLE OF
81: pa_budget_lines.PROJECT_REV_RATE_DATE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
82: TYPE l_proj_rev_exc_rate_tbl_typ IS TABLE OF
83: pa_budget_lines.PROJECT_REV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER ;

Line 81: pa_budget_lines.PROJECT_REV_RATE_DATE_TYPE%TYPE INDEX BY BINARY_INTEGER ;

77:
78: TYPE l_proj_rev_rate_type_tbl_typ IS TABLE OF
79: pa_budget_lines.PROJECT_REV_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
80: TYPE l_proj_rev_rt_dt_type_tbl_typ IS TABLE OF
81: pa_budget_lines.PROJECT_REV_RATE_DATE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
82: TYPE l_proj_rev_exc_rate_tbl_typ IS TABLE OF
83: pa_budget_lines.PROJECT_REV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER ;
84: TYPE l_proj_rev_rate_date_tbl_typ IS TABLE OF
85: pa_budget_lines.PROJECT_REV_RATE_DATE%TYPE INDEX BY BINARY_INTEGER ;

Line 83: pa_budget_lines.PROJECT_REV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER ;

79: pa_budget_lines.PROJECT_REV_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
80: TYPE l_proj_rev_rt_dt_type_tbl_typ IS TABLE OF
81: pa_budget_lines.PROJECT_REV_RATE_DATE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
82: TYPE l_proj_rev_exc_rate_tbl_typ IS TABLE OF
83: pa_budget_lines.PROJECT_REV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER ;
84: TYPE l_proj_rev_rate_date_tbl_typ IS TABLE OF
85: pa_budget_lines.PROJECT_REV_RATE_DATE%TYPE INDEX BY BINARY_INTEGER ;
86:
87: TYPE l_proj_currency_code_tbl_typ IS TABLE OF

Line 85: pa_budget_lines.PROJECT_REV_RATE_DATE%TYPE INDEX BY BINARY_INTEGER ;

81: pa_budget_lines.PROJECT_REV_RATE_DATE_TYPE%TYPE INDEX BY BINARY_INTEGER ;
82: TYPE l_proj_rev_exc_rate_tbl_typ IS TABLE OF
83: pa_budget_lines.PROJECT_REV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER ;
84: TYPE l_proj_rev_rate_date_tbl_typ IS TABLE OF
85: pa_budget_lines.PROJECT_REV_RATE_DATE%TYPE INDEX BY BINARY_INTEGER ;
86:
87: TYPE l_proj_currency_code_tbl_typ IS TABLE OF
88: pa_budget_lines.PROJECT_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER ;
89: TYPE l_pf_currency_code_tbl_typ IS TABLE OF

Line 88: pa_budget_lines.PROJECT_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER ;

84: TYPE l_proj_rev_rate_date_tbl_typ IS TABLE OF
85: pa_budget_lines.PROJECT_REV_RATE_DATE%TYPE INDEX BY BINARY_INTEGER ;
86:
87: TYPE l_proj_currency_code_tbl_typ IS TABLE OF
88: pa_budget_lines.PROJECT_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER ;
89: TYPE l_pf_currency_code_tbl_typ IS TABLE OF
90: pa_budget_lines.PROJFUNC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER ;
91:
92:

Line 90: pa_budget_lines.PROJFUNC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER ;

86:
87: TYPE l_proj_currency_code_tbl_typ IS TABLE OF
88: pa_budget_lines.PROJECT_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER ;
89: TYPE l_pf_currency_code_tbl_typ IS TABLE OF
90: pa_budget_lines.PROJFUNC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER ;
91:
92:
93: TYPE l_attribute_category_tbl_typ IS TABLE OF
94: pa_budget_lines.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER ;

Line 94: pa_budget_lines.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER ;

90: pa_budget_lines.PROJFUNC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER ;
91:
92:
93: TYPE l_attribute_category_tbl_typ IS TABLE OF
94: pa_budget_lines.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER ;
95: TYPE l_attribute_tbl_typ IS TABLE OF
96: pa_budget_lines.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER ;
97:
98: TYPE l_error_flag_tbl_typ IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER ;

Line 96: pa_budget_lines.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER ;

92:
93: TYPE l_attribute_category_tbl_typ IS TABLE OF
94: pa_budget_lines.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER ;
95: TYPE l_attribute_tbl_typ IS TABLE OF
96: pa_budget_lines.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER ;
97:
98: TYPE l_error_flag_tbl_typ IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER ;
99: TYPE l_val_error_code_tbl_typ IS TABLE OF
100: pa_lookups.LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER ;

Line 103: pa_budget_lines.PERIOD_NAME%TYPE INDEX BY BINARY_INTEGER ;

99: TYPE l_val_error_code_tbl_typ IS TABLE OF
100: pa_lookups.LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER ;
101:
102: TYPE l_period_name_tbl_typ IS TABLE OF
103: pa_budget_lines.PERIOD_NAME%TYPE INDEX BY BINARY_INTEGER ;
104: TYPE l_bucketing_pd_code_tbl_typ IS TABLE OF
105: pa_budget_lines.BUCKETING_PERIOD_CODE%TYPE INDEX BY BINARY_INTEGER ;
106: TYPE l_pm_product_code_tbl_typ IS TABLE OF
107: pa_budget_lines.PM_PRODUCT_CODE%TYPE INDEX BY BINARY_INTEGER ;

Line 105: pa_budget_lines.BUCKETING_PERIOD_CODE%TYPE INDEX BY BINARY_INTEGER ;

101:
102: TYPE l_period_name_tbl_typ IS TABLE OF
103: pa_budget_lines.PERIOD_NAME%TYPE INDEX BY BINARY_INTEGER ;
104: TYPE l_bucketing_pd_code_tbl_typ IS TABLE OF
105: pa_budget_lines.BUCKETING_PERIOD_CODE%TYPE INDEX BY BINARY_INTEGER ;
106: TYPE l_pm_product_code_tbl_typ IS TABLE OF
107: pa_budget_lines.PM_PRODUCT_CODE%TYPE INDEX BY BINARY_INTEGER ;
108:
109: TYPE l_raw_cost_source_tbl_typ IS TABLE OF

Line 107: pa_budget_lines.PM_PRODUCT_CODE%TYPE INDEX BY BINARY_INTEGER ;

103: pa_budget_lines.PERIOD_NAME%TYPE INDEX BY BINARY_INTEGER ;
104: TYPE l_bucketing_pd_code_tbl_typ IS TABLE OF
105: pa_budget_lines.BUCKETING_PERIOD_CODE%TYPE INDEX BY BINARY_INTEGER ;
106: TYPE l_pm_product_code_tbl_typ IS TABLE OF
107: pa_budget_lines.PM_PRODUCT_CODE%TYPE INDEX BY BINARY_INTEGER ;
108:
109: TYPE l_raw_cost_source_tbl_typ IS TABLE OF
110: pa_budget_lines.RAW_COST_SOURCE%TYPE INDEX BY BINARY_INTEGER ;
111: TYPE l_burdened_cost_source_tbl_typ IS TABLE OF

Line 110: pa_budget_lines.RAW_COST_SOURCE%TYPE INDEX BY BINARY_INTEGER ;

106: TYPE l_pm_product_code_tbl_typ IS TABLE OF
107: pa_budget_lines.PM_PRODUCT_CODE%TYPE INDEX BY BINARY_INTEGER ;
108:
109: TYPE l_raw_cost_source_tbl_typ IS TABLE OF
110: pa_budget_lines.RAW_COST_SOURCE%TYPE INDEX BY BINARY_INTEGER ;
111: TYPE l_burdened_cost_source_tbl_typ IS TABLE OF
112: pa_budget_lines.BURDENED_COST_SOURCE%TYPE INDEX BY BINARY_INTEGER ;
113: TYPE l_quantity_source_tbl_typ IS TABLE OF
114: pa_budget_lines.QUANTITY%TYPE INDEX BY BINARY_INTEGER ;

Line 112: pa_budget_lines.BURDENED_COST_SOURCE%TYPE INDEX BY BINARY_INTEGER ;

108:
109: TYPE l_raw_cost_source_tbl_typ IS TABLE OF
110: pa_budget_lines.RAW_COST_SOURCE%TYPE INDEX BY BINARY_INTEGER ;
111: TYPE l_burdened_cost_source_tbl_typ IS TABLE OF
112: pa_budget_lines.BURDENED_COST_SOURCE%TYPE INDEX BY BINARY_INTEGER ;
113: TYPE l_quantity_source_tbl_typ IS TABLE OF
114: pa_budget_lines.QUANTITY%TYPE INDEX BY BINARY_INTEGER ;
115: TYPE l_revenue_source_tbl_typ IS TABLE OF
116: pa_budget_lines.QUANTITY%TYPE INDEX BY BINARY_INTEGER ;

Line 114: pa_budget_lines.QUANTITY%TYPE INDEX BY BINARY_INTEGER ;

110: pa_budget_lines.RAW_COST_SOURCE%TYPE INDEX BY BINARY_INTEGER ;
111: TYPE l_burdened_cost_source_tbl_typ IS TABLE OF
112: pa_budget_lines.BURDENED_COST_SOURCE%TYPE INDEX BY BINARY_INTEGER ;
113: TYPE l_quantity_source_tbl_typ IS TABLE OF
114: pa_budget_lines.QUANTITY%TYPE INDEX BY BINARY_INTEGER ;
115: TYPE l_revenue_source_tbl_typ IS TABLE OF
116: pa_budget_lines.QUANTITY%TYPE INDEX BY BINARY_INTEGER ;
117:
118: /* Bug 4431269: Added the record type gloabl variable.

Line 116: pa_budget_lines.QUANTITY%TYPE INDEX BY BINARY_INTEGER ;

112: pa_budget_lines.BURDENED_COST_SOURCE%TYPE INDEX BY BINARY_INTEGER ;
113: TYPE l_quantity_source_tbl_typ IS TABLE OF
114: pa_budget_lines.QUANTITY%TYPE INDEX BY BINARY_INTEGER ;
115: TYPE l_revenue_source_tbl_typ IS TABLE OF
116: pa_budget_lines.QUANTITY%TYPE INDEX BY BINARY_INTEGER ;
117:
118: /* Bug 4431269: Added the record type gloabl variable.
119: * Using the global variable for the calling reference makes
120: * code changes and the subsequent impact very less as this variable would be only populated

Line 137: txn_currency pa_budget_lines.txn_currency_code%TYPE,

133: TYPE G_FP_WA_GLOBAL_VAR_REC IS RECORD
134: (
135: task_id pa_resource_assignments.task_id%TYPE,
136: rlm_id pa_resource_assignments.resource_list_member_id%TYPE,
137: txn_currency pa_budget_lines.txn_currency_code%TYPE,
138: error_code pa_fp_webadi_upload_inf.val_error_code%TYPE
139: );
140:
141: TYPE G_FP_WEBADI_GLOBAL IS TABLE OF G_FP_WA_GLOBAL_VAR_REC;