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_MULTI_CURRENCY_PKG dependencies on PA_FP_MULTI_CURRENCY_PKG

Line 1: PACKAGE BODY PA_FP_MULTI_CURRENCY_PKG AS

1: PACKAGE BODY PA_FP_MULTI_CURRENCY_PKG AS
2: --$Header: PAFPMCPB.pls 120.4.12020000.2 2013/03/28 12:24:37 tvala ship $
3: /* Perf Bug: 3683132 */
4: g_cache_fp_plan_version_id Number;
5: g_cache_fp_txn_cur_code Varchar2(100);

Line 12: g_module_name VARCHAR2(100) := 'pa.plsql.PA_FP_MULTI_CURRENCY_PKG';

8: g_fp_projfunc_cost_exchng_rt Number;
9: g_fp_projfunc_rev_exchng_rt Number;
10: g_fp_project_cost_exchng_rt Number;
11: g_fp_project_rev_exchng_rt Number;
12: g_module_name VARCHAR2(100) := 'pa.plsql.PA_FP_MULTI_CURRENCY_PKG';
13:
14: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
15:
16: /* Perf Bug: 3683132 */

Line 98: pa_fp_multi_currency_pkg.number_type_tab

94: END get_fp_cur_details;
95:
96:
97: PROCEDURE conv_mc_bulk ( p_resource_assignment_id_tab IN
98: pa_fp_multi_currency_pkg.number_type_tab
99: ,p_start_date_tab IN
100: pa_fp_multi_currency_pkg.date_type_tab
101: ,p_end_date_tab IN
102: pa_fp_multi_currency_pkg.date_type_tab

Line 100: pa_fp_multi_currency_pkg.date_type_tab

96:
97: PROCEDURE conv_mc_bulk ( p_resource_assignment_id_tab IN
98: pa_fp_multi_currency_pkg.number_type_tab
99: ,p_start_date_tab IN
100: pa_fp_multi_currency_pkg.date_type_tab
101: ,p_end_date_tab IN
102: pa_fp_multi_currency_pkg.date_type_tab
103: ,p_txn_currency_code_tab IN
104: pa_fp_multi_currency_pkg.char240_type_tab

Line 102: pa_fp_multi_currency_pkg.date_type_tab

98: pa_fp_multi_currency_pkg.number_type_tab
99: ,p_start_date_tab IN
100: pa_fp_multi_currency_pkg.date_type_tab
101: ,p_end_date_tab IN
102: pa_fp_multi_currency_pkg.date_type_tab
103: ,p_txn_currency_code_tab IN
104: pa_fp_multi_currency_pkg.char240_type_tab
105: ,p_txn_raw_cost_tab IN
106: pa_fp_multi_currency_pkg.number_type_tab

Line 104: pa_fp_multi_currency_pkg.char240_type_tab

100: pa_fp_multi_currency_pkg.date_type_tab
101: ,p_end_date_tab IN
102: pa_fp_multi_currency_pkg.date_type_tab
103: ,p_txn_currency_code_tab IN
104: pa_fp_multi_currency_pkg.char240_type_tab
105: ,p_txn_raw_cost_tab IN
106: pa_fp_multi_currency_pkg.number_type_tab
107: ,p_txn_burdened_cost_tab IN
108: pa_fp_multi_currency_pkg.number_type_tab

Line 106: pa_fp_multi_currency_pkg.number_type_tab

102: pa_fp_multi_currency_pkg.date_type_tab
103: ,p_txn_currency_code_tab IN
104: pa_fp_multi_currency_pkg.char240_type_tab
105: ,p_txn_raw_cost_tab IN
106: pa_fp_multi_currency_pkg.number_type_tab
107: ,p_txn_burdened_cost_tab IN
108: pa_fp_multi_currency_pkg.number_type_tab
109: ,p_txn_revenue_tab IN
110: pa_fp_multi_currency_pkg.number_type_tab

Line 108: pa_fp_multi_currency_pkg.number_type_tab

104: pa_fp_multi_currency_pkg.char240_type_tab
105: ,p_txn_raw_cost_tab IN
106: pa_fp_multi_currency_pkg.number_type_tab
107: ,p_txn_burdened_cost_tab IN
108: pa_fp_multi_currency_pkg.number_type_tab
109: ,p_txn_revenue_tab IN
110: pa_fp_multi_currency_pkg.number_type_tab
111: ,p_projfunc_currency_code_tab IN
112: pa_fp_multi_currency_pkg.char240_type_tab

Line 110: pa_fp_multi_currency_pkg.number_type_tab

106: pa_fp_multi_currency_pkg.number_type_tab
107: ,p_txn_burdened_cost_tab IN
108: pa_fp_multi_currency_pkg.number_type_tab
109: ,p_txn_revenue_tab IN
110: pa_fp_multi_currency_pkg.number_type_tab
111: ,p_projfunc_currency_code_tab IN
112: pa_fp_multi_currency_pkg.char240_type_tab
113: ,p_projfunc_cost_rate_type_tab IN
114: pa_fp_multi_currency_pkg.char240_type_tab

Line 112: pa_fp_multi_currency_pkg.char240_type_tab

108: pa_fp_multi_currency_pkg.number_type_tab
109: ,p_txn_revenue_tab IN
110: pa_fp_multi_currency_pkg.number_type_tab
111: ,p_projfunc_currency_code_tab IN
112: pa_fp_multi_currency_pkg.char240_type_tab
113: ,p_projfunc_cost_rate_type_tab IN
114: pa_fp_multi_currency_pkg.char240_type_tab
115: ,p_projfunc_cost_rate_tab IN OUT NOCOPY
116: pa_fp_multi_currency_pkg.number_type_tab

Line 114: pa_fp_multi_currency_pkg.char240_type_tab

110: pa_fp_multi_currency_pkg.number_type_tab
111: ,p_projfunc_currency_code_tab IN
112: pa_fp_multi_currency_pkg.char240_type_tab
113: ,p_projfunc_cost_rate_type_tab IN
114: pa_fp_multi_currency_pkg.char240_type_tab
115: ,p_projfunc_cost_rate_tab IN OUT NOCOPY
116: pa_fp_multi_currency_pkg.number_type_tab
117: ,p_projfunc_cost_rate_date_tab IN
118: pa_fp_multi_currency_pkg.date_type_tab

Line 116: pa_fp_multi_currency_pkg.number_type_tab

112: pa_fp_multi_currency_pkg.char240_type_tab
113: ,p_projfunc_cost_rate_type_tab IN
114: pa_fp_multi_currency_pkg.char240_type_tab
115: ,p_projfunc_cost_rate_tab IN OUT NOCOPY
116: pa_fp_multi_currency_pkg.number_type_tab
117: ,p_projfunc_cost_rate_date_tab IN
118: pa_fp_multi_currency_pkg.date_type_tab
119: ,p_projfunc_rev_rate_type_tab IN
120: pa_fp_multi_currency_pkg.char240_type_tab

Line 118: pa_fp_multi_currency_pkg.date_type_tab

114: pa_fp_multi_currency_pkg.char240_type_tab
115: ,p_projfunc_cost_rate_tab IN OUT NOCOPY
116: pa_fp_multi_currency_pkg.number_type_tab
117: ,p_projfunc_cost_rate_date_tab IN
118: pa_fp_multi_currency_pkg.date_type_tab
119: ,p_projfunc_rev_rate_type_tab IN
120: pa_fp_multi_currency_pkg.char240_type_tab
121: ,p_projfunc_rev_rate_tab IN OUT NOCOPY
122: pa_fp_multi_currency_pkg.number_type_tab

Line 120: pa_fp_multi_currency_pkg.char240_type_tab

116: pa_fp_multi_currency_pkg.number_type_tab
117: ,p_projfunc_cost_rate_date_tab IN
118: pa_fp_multi_currency_pkg.date_type_tab
119: ,p_projfunc_rev_rate_type_tab IN
120: pa_fp_multi_currency_pkg.char240_type_tab
121: ,p_projfunc_rev_rate_tab IN OUT NOCOPY
122: pa_fp_multi_currency_pkg.number_type_tab
123: ,p_projfunc_rev_rate_date_tab IN
124: pa_fp_multi_currency_pkg.date_type_tab

Line 122: pa_fp_multi_currency_pkg.number_type_tab

118: pa_fp_multi_currency_pkg.date_type_tab
119: ,p_projfunc_rev_rate_type_tab IN
120: pa_fp_multi_currency_pkg.char240_type_tab
121: ,p_projfunc_rev_rate_tab IN OUT NOCOPY
122: pa_fp_multi_currency_pkg.number_type_tab
123: ,p_projfunc_rev_rate_date_tab IN
124: pa_fp_multi_currency_pkg.date_type_tab
125: ,x_projfunc_raw_cost_tab OUT NOCOPY
126: pa_fp_multi_currency_pkg.number_type_tab

Line 124: pa_fp_multi_currency_pkg.date_type_tab

120: pa_fp_multi_currency_pkg.char240_type_tab
121: ,p_projfunc_rev_rate_tab IN OUT NOCOPY
122: pa_fp_multi_currency_pkg.number_type_tab
123: ,p_projfunc_rev_rate_date_tab IN
124: pa_fp_multi_currency_pkg.date_type_tab
125: ,x_projfunc_raw_cost_tab OUT NOCOPY
126: pa_fp_multi_currency_pkg.number_type_tab
127: ,x_projfunc_burdened_cost_tab OUT NOCOPY
128: pa_fp_multi_currency_pkg.number_type_tab

Line 126: pa_fp_multi_currency_pkg.number_type_tab

122: pa_fp_multi_currency_pkg.number_type_tab
123: ,p_projfunc_rev_rate_date_tab IN
124: pa_fp_multi_currency_pkg.date_type_tab
125: ,x_projfunc_raw_cost_tab OUT NOCOPY
126: pa_fp_multi_currency_pkg.number_type_tab
127: ,x_projfunc_burdened_cost_tab OUT NOCOPY
128: pa_fp_multi_currency_pkg.number_type_tab
129: ,x_projfunc_revenue_tab OUT NOCOPY
130: pa_fp_multi_currency_pkg.number_type_tab

Line 128: pa_fp_multi_currency_pkg.number_type_tab

124: pa_fp_multi_currency_pkg.date_type_tab
125: ,x_projfunc_raw_cost_tab OUT NOCOPY
126: pa_fp_multi_currency_pkg.number_type_tab
127: ,x_projfunc_burdened_cost_tab OUT NOCOPY
128: pa_fp_multi_currency_pkg.number_type_tab
129: ,x_projfunc_revenue_tab OUT NOCOPY
130: pa_fp_multi_currency_pkg.number_type_tab
131: ,x_projfunc_rejection_tab OUT NOCOPY
132: pa_fp_multi_currency_pkg.char30_type_tab

Line 130: pa_fp_multi_currency_pkg.number_type_tab

126: pa_fp_multi_currency_pkg.number_type_tab
127: ,x_projfunc_burdened_cost_tab OUT NOCOPY
128: pa_fp_multi_currency_pkg.number_type_tab
129: ,x_projfunc_revenue_tab OUT NOCOPY
130: pa_fp_multi_currency_pkg.number_type_tab
131: ,x_projfunc_rejection_tab OUT NOCOPY
132: pa_fp_multi_currency_pkg.char30_type_tab
133: ,p_proj_currency_code_tab IN
134: pa_fp_multi_currency_pkg.char240_type_tab

Line 132: pa_fp_multi_currency_pkg.char30_type_tab

128: pa_fp_multi_currency_pkg.number_type_tab
129: ,x_projfunc_revenue_tab OUT NOCOPY
130: pa_fp_multi_currency_pkg.number_type_tab
131: ,x_projfunc_rejection_tab OUT NOCOPY
132: pa_fp_multi_currency_pkg.char30_type_tab
133: ,p_proj_currency_code_tab IN
134: pa_fp_multi_currency_pkg.char240_type_tab
135: ,p_proj_cost_rate_type_tab IN
136: pa_fp_multi_currency_pkg.char240_type_tab

Line 134: pa_fp_multi_currency_pkg.char240_type_tab

130: pa_fp_multi_currency_pkg.number_type_tab
131: ,x_projfunc_rejection_tab OUT NOCOPY
132: pa_fp_multi_currency_pkg.char30_type_tab
133: ,p_proj_currency_code_tab IN
134: pa_fp_multi_currency_pkg.char240_type_tab
135: ,p_proj_cost_rate_type_tab IN
136: pa_fp_multi_currency_pkg.char240_type_tab
137: ,p_proj_cost_rate_tab IN OUT NOCOPY
138: pa_fp_multi_currency_pkg.number_type_tab

Line 136: pa_fp_multi_currency_pkg.char240_type_tab

132: pa_fp_multi_currency_pkg.char30_type_tab
133: ,p_proj_currency_code_tab IN
134: pa_fp_multi_currency_pkg.char240_type_tab
135: ,p_proj_cost_rate_type_tab IN
136: pa_fp_multi_currency_pkg.char240_type_tab
137: ,p_proj_cost_rate_tab IN OUT NOCOPY
138: pa_fp_multi_currency_pkg.number_type_tab
139: ,p_proj_cost_rate_date_tab IN
140: pa_fp_multi_currency_pkg.date_type_tab

Line 138: pa_fp_multi_currency_pkg.number_type_tab

134: pa_fp_multi_currency_pkg.char240_type_tab
135: ,p_proj_cost_rate_type_tab IN
136: pa_fp_multi_currency_pkg.char240_type_tab
137: ,p_proj_cost_rate_tab IN OUT NOCOPY
138: pa_fp_multi_currency_pkg.number_type_tab
139: ,p_proj_cost_rate_date_tab IN
140: pa_fp_multi_currency_pkg.date_type_tab
141: ,p_proj_rev_rate_type_tab IN
142: pa_fp_multi_currency_pkg.char240_type_tab

Line 140: pa_fp_multi_currency_pkg.date_type_tab

136: pa_fp_multi_currency_pkg.char240_type_tab
137: ,p_proj_cost_rate_tab IN OUT NOCOPY
138: pa_fp_multi_currency_pkg.number_type_tab
139: ,p_proj_cost_rate_date_tab IN
140: pa_fp_multi_currency_pkg.date_type_tab
141: ,p_proj_rev_rate_type_tab IN
142: pa_fp_multi_currency_pkg.char240_type_tab
143: ,p_proj_rev_rate_tab IN OUT NOCOPY
144: pa_fp_multi_currency_pkg.number_type_tab

Line 142: pa_fp_multi_currency_pkg.char240_type_tab

138: pa_fp_multi_currency_pkg.number_type_tab
139: ,p_proj_cost_rate_date_tab IN
140: pa_fp_multi_currency_pkg.date_type_tab
141: ,p_proj_rev_rate_type_tab IN
142: pa_fp_multi_currency_pkg.char240_type_tab
143: ,p_proj_rev_rate_tab IN OUT NOCOPY
144: pa_fp_multi_currency_pkg.number_type_tab
145: ,p_proj_rev_rate_date_tab IN
146: pa_fp_multi_currency_pkg.date_type_tab

Line 144: pa_fp_multi_currency_pkg.number_type_tab

140: pa_fp_multi_currency_pkg.date_type_tab
141: ,p_proj_rev_rate_type_tab IN
142: pa_fp_multi_currency_pkg.char240_type_tab
143: ,p_proj_rev_rate_tab IN OUT NOCOPY
144: pa_fp_multi_currency_pkg.number_type_tab
145: ,p_proj_rev_rate_date_tab IN
146: pa_fp_multi_currency_pkg.date_type_tab
147: ,x_proj_raw_cost_tab OUT NOCOPY
148: pa_fp_multi_currency_pkg.number_type_tab

Line 146: pa_fp_multi_currency_pkg.date_type_tab

142: pa_fp_multi_currency_pkg.char240_type_tab
143: ,p_proj_rev_rate_tab IN OUT NOCOPY
144: pa_fp_multi_currency_pkg.number_type_tab
145: ,p_proj_rev_rate_date_tab IN
146: pa_fp_multi_currency_pkg.date_type_tab
147: ,x_proj_raw_cost_tab OUT NOCOPY
148: pa_fp_multi_currency_pkg.number_type_tab
149: ,x_proj_burdened_cost_tab OUT NOCOPY
150: pa_fp_multi_currency_pkg.number_type_tab

Line 148: pa_fp_multi_currency_pkg.number_type_tab

144: pa_fp_multi_currency_pkg.number_type_tab
145: ,p_proj_rev_rate_date_tab IN
146: pa_fp_multi_currency_pkg.date_type_tab
147: ,x_proj_raw_cost_tab OUT NOCOPY
148: pa_fp_multi_currency_pkg.number_type_tab
149: ,x_proj_burdened_cost_tab OUT NOCOPY
150: pa_fp_multi_currency_pkg.number_type_tab
151: ,x_proj_revenue_tab OUT NOCOPY
152: pa_fp_multi_currency_pkg.number_type_tab

Line 150: pa_fp_multi_currency_pkg.number_type_tab

146: pa_fp_multi_currency_pkg.date_type_tab
147: ,x_proj_raw_cost_tab OUT NOCOPY
148: pa_fp_multi_currency_pkg.number_type_tab
149: ,x_proj_burdened_cost_tab OUT NOCOPY
150: pa_fp_multi_currency_pkg.number_type_tab
151: ,x_proj_revenue_tab OUT NOCOPY
152: pa_fp_multi_currency_pkg.number_type_tab
153: ,x_proj_rejection_tab OUT NOCOPY
154: pa_fp_multi_currency_pkg.char30_type_tab

Line 152: pa_fp_multi_currency_pkg.number_type_tab

148: pa_fp_multi_currency_pkg.number_type_tab
149: ,x_proj_burdened_cost_tab OUT NOCOPY
150: pa_fp_multi_currency_pkg.number_type_tab
151: ,x_proj_revenue_tab OUT NOCOPY
152: pa_fp_multi_currency_pkg.number_type_tab
153: ,x_proj_rejection_tab OUT NOCOPY
154: pa_fp_multi_currency_pkg.char30_type_tab
155: ,p_user_validate_flag_tab IN
156: pa_fp_multi_currency_pkg.char240_type_tab

Line 154: pa_fp_multi_currency_pkg.char30_type_tab

150: pa_fp_multi_currency_pkg.number_type_tab
151: ,x_proj_revenue_tab OUT NOCOPY
152: pa_fp_multi_currency_pkg.number_type_tab
153: ,x_proj_rejection_tab OUT NOCOPY
154: pa_fp_multi_currency_pkg.char30_type_tab
155: ,p_user_validate_flag_tab IN
156: pa_fp_multi_currency_pkg.char240_type_tab
157: ,p_calling_module IN
158: VARCHAR2 DEFAULT 'UPDATE_PLAN_TRANSACTION' -- Added for bug#5395732

Line 156: pa_fp_multi_currency_pkg.char240_type_tab

152: pa_fp_multi_currency_pkg.number_type_tab
153: ,x_proj_rejection_tab OUT NOCOPY
154: pa_fp_multi_currency_pkg.char30_type_tab
155: ,p_user_validate_flag_tab IN
156: pa_fp_multi_currency_pkg.char240_type_tab
157: ,p_calling_module IN
158: VARCHAR2 DEFAULT 'UPDATE_PLAN_TRANSACTION' -- Added for bug#5395732
159: ,x_return_status OUT NOCOPY --File.Sql.39 bug 4440895
160: VARCHAR2

Line 185: CachedRowTab pa_fp_multi_currency_pkg.cached_row_tab;

181:
182: l_allow_user_rate_type VARCHAR2(1);
183: l_call_closest_flag varchar2(1) := 'F'; -- Added for Bug#5395732
184:
185: CachedRowTab pa_fp_multi_currency_pkg.cached_row_tab;
186:
187: /** Bug fix: 4199085 . No need to use this curosr as we are not adding the error msg to stack
188: CURSOR get_line_info (p_resource_assignment_id IN NUMBER) IS
189: SELECT ppa.name project_name

Line 209: pa_debug.init_err_stack('PA_FP_MULTI_CURRENCY_PKG.conv_mc_bulk');

205:
206: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
207: --l_debug_mode := NVL(l_debug_mode,'Y');
208: IF P_PA_DEBUG_MODE = 'Y' THEN
209: pa_debug.init_err_stack('PA_FP_MULTI_CURRENCY_PKG.conv_mc_bulk');
210: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
211: END IF;
212:
213: pa_debug.g_err_stage := 'Entered PA_FP_MULTI_CURRENCY_PKG.conv_mc_bulk';

Line 213: pa_debug.g_err_stage := 'Entered PA_FP_MULTI_CURRENCY_PKG.conv_mc_bulk';

209: pa_debug.init_err_stack('PA_FP_MULTI_CURRENCY_PKG.conv_mc_bulk');
210: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
211: END IF;
212:
213: pa_debug.g_err_stage := 'Entered PA_FP_MULTI_CURRENCY_PKG.conv_mc_bulk';
214: IF P_PA_DEBUG_MODE = 'Y' THEN
215: pa_debug.write('conv_mc_bulk: ' || g_module_name,pa_debug.g_err_stage,3);
216: END IF;
217:

Line 1725: pa_debug.g_err_stage := 'Leaving PA_FP_MULTI_CURRENCY_PKG.conv_mc_bulk';

1721: --hr_utility.trace('x_projfunc_rejection_tab(i) := '||to_char(x_projfunc_rejection_tab(i)));
1722: END LOOP;
1723: l_stage := 8600;
1724: --hr_utility.trace(to_char(l_stage));
1725: pa_debug.g_err_stage := 'Leaving PA_FP_MULTI_CURRENCY_PKG.conv_mc_bulk';
1726: IF P_PA_DEBUG_MODE = 'Y' THEN
1727: pa_debug.write('conv_mc_bulk: ' || g_module_name,pa_debug.g_err_stage,3);
1728: END IF;
1729:

Line 1759: ( p_pkg_name => 'PA_FP_MULTI_CURRENCY_PKG'

1755: END IF;
1756:
1757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1758: fnd_msg_pub.add_exc_msg
1759: ( p_pkg_name => 'PA_FP_MULTI_CURRENCY_PKG'
1760: ,p_procedure_name => 'conv_mc_bulk' );
1761: pa_debug.g_err_stage := 'Stage : '||to_char(l_stage)||' '||substr(SQLERRM,1,240);
1762: IF P_PA_DEBUG_MODE = 'Y' THEN
1763: pa_debug.write('conv_mc_bulk: ' || g_module_name,pa_debug.g_err_stage,3);

Line 1765: --hr_utility.trace('PA_FP_MULTI_CURRENCY_PKG.conv_mc_bulk -- Stage : ' ||to_char(l_stage)||' '||substr(SQLERRM,1,240));

1761: pa_debug.g_err_stage := 'Stage : '||to_char(l_stage)||' '||substr(SQLERRM,1,240);
1762: IF P_PA_DEBUG_MODE = 'Y' THEN
1763: pa_debug.write('conv_mc_bulk: ' || g_module_name,pa_debug.g_err_stage,3);
1764: END IF;
1765: --hr_utility.trace('PA_FP_MULTI_CURRENCY_PKG.conv_mc_bulk -- Stage : ' ||to_char(l_stage)||' '||substr(SQLERRM,1,240));
1766: /* bug 4227840: wrapping the setting of debug error stack call to
1767: * pa_debug under the debug enbaling check
1768: */
1769: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 1786: l_txn_row_id_tab pa_fp_multi_currency_pkg.rowid_type_tab;

1782: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1783: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1784: IS
1785:
1786: l_txn_row_id_tab pa_fp_multi_currency_pkg.rowid_type_tab;
1787: l_resource_assignment_id_tab pa_fp_multi_currency_pkg.number_type_tab;
1788: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1789: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1790: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 1787: l_resource_assignment_id_tab pa_fp_multi_currency_pkg.number_type_tab;

1783: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1784: IS
1785:
1786: l_txn_row_id_tab pa_fp_multi_currency_pkg.rowid_type_tab;
1787: l_resource_assignment_id_tab pa_fp_multi_currency_pkg.number_type_tab;
1788: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1789: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1790: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1791: l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1788: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;

1784: IS
1785:
1786: l_txn_row_id_tab pa_fp_multi_currency_pkg.rowid_type_tab;
1787: l_resource_assignment_id_tab pa_fp_multi_currency_pkg.number_type_tab;
1788: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1789: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1790: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1791: l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1792: l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1789: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;

1785:
1786: l_txn_row_id_tab pa_fp_multi_currency_pkg.rowid_type_tab;
1787: l_resource_assignment_id_tab pa_fp_multi_currency_pkg.number_type_tab;
1788: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1789: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1790: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1791: l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1792: l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1793: l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1790: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;

1786: l_txn_row_id_tab pa_fp_multi_currency_pkg.rowid_type_tab;
1787: l_resource_assignment_id_tab pa_fp_multi_currency_pkg.number_type_tab;
1788: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1789: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1790: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1791: l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1792: l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1793: l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1794: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 1791: l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

1787: l_resource_assignment_id_tab pa_fp_multi_currency_pkg.number_type_tab;
1788: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1789: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1790: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1791: l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1792: l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1793: l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1794: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1795: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 1792: l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

1788: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1789: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1790: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1791: l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1792: l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1793: l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1794: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1795: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1796: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1793: l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

1789: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1790: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1791: l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1792: l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1793: l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1794: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1795: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1796: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1797: l_projfunc_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 1794: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;

1790: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1791: l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1792: l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1793: l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1794: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1795: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1796: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1797: l_projfunc_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1798: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

Line 1795: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

1791: l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1792: l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1793: l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1794: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1795: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1796: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1797: l_projfunc_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1798: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1799: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 1796: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

1792: l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1793: l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1794: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1795: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1796: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1797: l_projfunc_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1798: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1799: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1800: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1797: l_projfunc_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;

1793: l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1794: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1795: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1796: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1797: l_projfunc_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1798: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1799: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1800: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1801: l_projfunc_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 1798: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

1794: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1795: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1796: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1797: l_projfunc_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1798: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1799: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1800: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1801: l_projfunc_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1802: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

Line 1799: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

1795: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1796: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1797: l_projfunc_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1798: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1799: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1800: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1801: l_projfunc_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1802: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1803: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1800: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

1796: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1797: l_projfunc_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1798: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1799: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1800: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1801: l_projfunc_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1802: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1803: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1804: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1801: l_projfunc_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;

1797: l_projfunc_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1798: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1799: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1800: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1801: l_projfunc_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1802: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1803: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1804: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1805: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1802: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

1798: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1799: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1800: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1801: l_projfunc_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1802: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1803: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1804: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1805: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1806: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;

Line 1803: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

1799: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1800: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1801: l_projfunc_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1802: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1803: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1804: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1805: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1806: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
1807: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 1804: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

1800: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1801: l_projfunc_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1802: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1803: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1804: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1805: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1806: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
1807: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1808: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 1805: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

1801: l_projfunc_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1802: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1803: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1804: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1805: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1806: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
1807: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1808: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1809: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1806: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;

1802: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1803: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1804: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1805: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1806: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
1807: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1808: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1809: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1810: l_proj_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 1807: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;

1803: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1804: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1805: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1806: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
1807: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1808: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1809: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1810: l_proj_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1811: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

Line 1808: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

1804: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1805: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1806: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
1807: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1808: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1809: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1810: l_proj_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1811: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1812: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 1809: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

1805: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1806: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
1807: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1808: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1809: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1810: l_proj_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1811: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1812: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1813: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1810: l_proj_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;

1806: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
1807: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1808: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1809: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1810: l_proj_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1811: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1812: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1813: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1814: l_proj_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 1811: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

1807: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1808: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1809: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1810: l_proj_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1811: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1812: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1813: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1814: l_proj_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1815: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

Line 1812: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

1808: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1809: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1810: l_proj_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1811: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1812: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1813: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1814: l_proj_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1815: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1816: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1813: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

1809: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1810: l_proj_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1811: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1812: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1813: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1814: l_proj_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1815: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1816: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1817: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1814: l_proj_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;

1810: l_proj_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1811: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1812: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1813: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1814: l_proj_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1815: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1816: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1817: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1818: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1815: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

1811: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1812: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1813: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1814: l_proj_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1815: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1816: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1817: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1818: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1819: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;

Line 1816: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

1812: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1813: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1814: l_proj_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1815: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1816: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1817: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1818: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1819: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
1820: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 1817: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

1813: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1814: l_proj_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1815: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1816: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1817: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1818: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1819: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
1820: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
1821: l_status_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 1818: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

1814: l_proj_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1815: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1816: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1817: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1818: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1819: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
1820: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
1821: l_status_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
1822:

Line 1819: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;

1815: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1816: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1817: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1818: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1819: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
1820: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
1821: l_status_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
1822:
1823: /* Perf Bug: 3683132 */

Line 1820: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;

1816: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1817: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1818: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1819: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
1820: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
1821: l_status_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
1822:
1823: /* Perf Bug: 3683132 */
1824: l_fp_cur_projfunc_cost_rt_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1821: l_status_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;

1817: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1818: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1819: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
1820: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
1821: l_status_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
1822:
1823: /* Perf Bug: 3683132 */
1824: l_fp_cur_projfunc_cost_rt_tab pa_fp_multi_currency_pkg.number_type_tab;
1825: l_fp_cur_projfunc_rev_rt_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1824: l_fp_cur_projfunc_cost_rt_tab pa_fp_multi_currency_pkg.number_type_tab;

1820: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
1821: l_status_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
1822:
1823: /* Perf Bug: 3683132 */
1824: l_fp_cur_projfunc_cost_rt_tab pa_fp_multi_currency_pkg.number_type_tab;
1825: l_fp_cur_projfunc_rev_rt_tab pa_fp_multi_currency_pkg.number_type_tab;
1826: l_fp_cur_project_cost_rt_tab pa_fp_multi_currency_pkg.number_type_tab;
1827: l_fp_cur_project_rev_rt_tab pa_fp_multi_currency_pkg.number_type_tab;
1828:

Line 1825: l_fp_cur_projfunc_rev_rt_tab pa_fp_multi_currency_pkg.number_type_tab;

1821: l_status_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
1822:
1823: /* Perf Bug: 3683132 */
1824: l_fp_cur_projfunc_cost_rt_tab pa_fp_multi_currency_pkg.number_type_tab;
1825: l_fp_cur_projfunc_rev_rt_tab pa_fp_multi_currency_pkg.number_type_tab;
1826: l_fp_cur_project_cost_rt_tab pa_fp_multi_currency_pkg.number_type_tab;
1827: l_fp_cur_project_rev_rt_tab pa_fp_multi_currency_pkg.number_type_tab;
1828:
1829: /* Bug fix:4259098 */

Line 1826: l_fp_cur_project_cost_rt_tab pa_fp_multi_currency_pkg.number_type_tab;

1822:
1823: /* Perf Bug: 3683132 */
1824: l_fp_cur_projfunc_cost_rt_tab pa_fp_multi_currency_pkg.number_type_tab;
1825: l_fp_cur_projfunc_rev_rt_tab pa_fp_multi_currency_pkg.number_type_tab;
1826: l_fp_cur_project_cost_rt_tab pa_fp_multi_currency_pkg.number_type_tab;
1827: l_fp_cur_project_rev_rt_tab pa_fp_multi_currency_pkg.number_type_tab;
1828:
1829: /* Bug fix:4259098 */
1830: l_init_quantity_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1827: l_fp_cur_project_rev_rt_tab pa_fp_multi_currency_pkg.number_type_tab;

1823: /* Perf Bug: 3683132 */
1824: l_fp_cur_projfunc_cost_rt_tab pa_fp_multi_currency_pkg.number_type_tab;
1825: l_fp_cur_projfunc_rev_rt_tab pa_fp_multi_currency_pkg.number_type_tab;
1826: l_fp_cur_project_cost_rt_tab pa_fp_multi_currency_pkg.number_type_tab;
1827: l_fp_cur_project_rev_rt_tab pa_fp_multi_currency_pkg.number_type_tab;
1828:
1829: /* Bug fix:4259098 */
1830: l_init_quantity_tab pa_fp_multi_currency_pkg.number_type_tab;
1831: l_txn_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1830: l_init_quantity_tab pa_fp_multi_currency_pkg.number_type_tab;

1826: l_fp_cur_project_cost_rt_tab pa_fp_multi_currency_pkg.number_type_tab;
1827: l_fp_cur_project_rev_rt_tab pa_fp_multi_currency_pkg.number_type_tab;
1828:
1829: /* Bug fix:4259098 */
1830: l_init_quantity_tab pa_fp_multi_currency_pkg.number_type_tab;
1831: l_txn_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1832: l_txn_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1833: l_txn_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1834: l_pfc_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1831: l_txn_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

1827: l_fp_cur_project_rev_rt_tab pa_fp_multi_currency_pkg.number_type_tab;
1828:
1829: /* Bug fix:4259098 */
1830: l_init_quantity_tab pa_fp_multi_currency_pkg.number_type_tab;
1831: l_txn_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1832: l_txn_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1833: l_txn_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1834: l_pfc_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1835: l_pfc_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1832: l_txn_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

1828:
1829: /* Bug fix:4259098 */
1830: l_init_quantity_tab pa_fp_multi_currency_pkg.number_type_tab;
1831: l_txn_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1832: l_txn_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1833: l_txn_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1834: l_pfc_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1835: l_pfc_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1836: l_pfc_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1833: l_txn_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

1829: /* Bug fix:4259098 */
1830: l_init_quantity_tab pa_fp_multi_currency_pkg.number_type_tab;
1831: l_txn_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1832: l_txn_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1833: l_txn_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1834: l_pfc_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1835: l_pfc_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1836: l_pfc_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1837: l_proj_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1834: l_pfc_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

1830: l_init_quantity_tab pa_fp_multi_currency_pkg.number_type_tab;
1831: l_txn_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1832: l_txn_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1833: l_txn_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1834: l_pfc_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1835: l_pfc_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1836: l_pfc_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1837: l_proj_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1838: l_proj_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1835: l_pfc_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

1831: l_txn_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1832: l_txn_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1833: l_txn_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1834: l_pfc_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1835: l_pfc_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1836: l_pfc_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1837: l_proj_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1838: l_proj_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1839: l_proj_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1836: l_pfc_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

1832: l_txn_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1833: l_txn_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1834: l_pfc_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1835: l_pfc_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1836: l_pfc_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1837: l_proj_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1838: l_proj_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1839: l_proj_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1840:

Line 1837: l_proj_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

1833: l_txn_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1834: l_pfc_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1835: l_pfc_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1836: l_pfc_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1837: l_proj_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1838: l_proj_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1839: l_proj_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1840:
1841: l_return_status VARCHAR2(240);

Line 1838: l_proj_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

1834: l_pfc_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1835: l_pfc_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1836: l_pfc_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1837: l_proj_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1838: l_proj_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1839: l_proj_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1840:
1841: l_return_status VARCHAR2(240);
1842: l_msg_count NUMBER;

Line 1839: l_proj_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

1835: l_pfc_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1836: l_pfc_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1837: l_proj_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1838: l_proj_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1839: l_proj_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1840:
1841: l_return_status VARCHAR2(240);
1842: l_msg_count NUMBER;
1843: l_msg_data VARCHAR2(2000);

Line 2431: pa_fp_multi_currency_pkg.conv_mc_bulk (

2427: END LOOP;
2428: /* End of Perf Bug: 3683132 */
2429:
2430: --hr_utility.trace('Calling conv_mc_bulk...');
2431: pa_fp_multi_currency_pkg.conv_mc_bulk (
2432: p_resource_assignment_id_tab => l_resource_assignment_id_tab
2433: ,p_start_date_tab => l_start_date_tab
2434: ,p_end_date_tab => l_end_date_tab
2435: ,p_txn_currency_code_tab => l_txn_currency_code_tab

Line 2619: ( p_pkg_name => 'PA_FP_MULTI_CURRENCY_PKG'

2615: END IF;
2616: END IF;
2617:
2618: fnd_msg_pub.add_exc_msg
2619: ( p_pkg_name => 'PA_FP_MULTI_CURRENCY_PKG'
2620: ,p_procedure_name => 'convert_txn_currency' );
2621: pa_debug.g_err_stage := 'Stage : '||to_char(l_stage)||' '||substr(SQLERRM,1,240);
2622: IF P_PA_DEBUG_MODE = 'Y' THEN
2623: pa_debug.write('convert_txn_currency: ' || g_module_name,pa_debug.g_err_stage,3);

Line 2625: --hr_utility.trace('PA_FP_MULTI_CURRENCY_PKG.convert_txn_currency -- Stage : ' ||to_char(l_stage)||' '||substr(SQLERRM,1,240));

2621: pa_debug.g_err_stage := 'Stage : '||to_char(l_stage)||' '||substr(SQLERRM,1,240);
2622: IF P_PA_DEBUG_MODE = 'Y' THEN
2623: pa_debug.write('convert_txn_currency: ' || g_module_name,pa_debug.g_err_stage,3);
2624: END IF;
2625: --hr_utility.trace('PA_FP_MULTI_CURRENCY_PKG.convert_txn_currency -- Stage : ' ||to_char(l_stage)||' '||substr(SQLERRM,1,240));
2626: /* bug 4227840: wrapping the setting of debug error stack call to
2627: * pa_debug under the debug enbaling check
2628: */
2629: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2674: ( p_pkg_name => 'PA_FP_MULTI_CURRENCY_PKG'

2670: END IF;
2671:
2672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2673: fnd_msg_pub.add_exc_msg
2674: ( p_pkg_name => 'PA_FP_MULTI_CURRENCY_PKG'
2675: ,p_procedure_name => 'convert_txn_currency' );
2676: pa_debug.g_err_stage := 'Stage : '||to_char(l_stage)||' '||substr(SQLERRM,1,240);
2677: IF P_PA_DEBUG_MODE = 'Y' THEN
2678: pa_debug.write('convert_txn_currency: ' || g_module_name,pa_debug.g_err_stage,3);

Line 2680: --hr_utility.trace('PA_FP_MULTI_CURRENCY_PKG.convert_txn_currency -- Stage : ' ||to_char(l_stage)||' '||substr(SQLERRM,1,240));

2676: pa_debug.g_err_stage := 'Stage : '||to_char(l_stage)||' '||substr(SQLERRM,1,240);
2677: IF P_PA_DEBUG_MODE = 'Y' THEN
2678: pa_debug.write('convert_txn_currency: ' || g_module_name,pa_debug.g_err_stage,3);
2679: END IF;
2680: --hr_utility.trace('PA_FP_MULTI_CURRENCY_PKG.convert_txn_currency -- Stage : ' ||to_char(l_stage)||' '||substr(SQLERRM,1,240));
2681: /* bug 4227840: wrapping the setting of debug error stack call to
2682: * pa_debug under the debug enbaling check
2683: */
2684: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2726: l_txn_row_id_tab pa_fp_multi_currency_pkg.rowid_type_tab;

2722: l_msg_index_out NUMBER;
2723: l_debug_mode VARCHAR2(30);
2724:
2725: -- nested tables to hold amount and currency columns
2726: l_txn_row_id_tab pa_fp_multi_currency_pkg.rowid_type_tab;
2727: l_resource_assignment_id_tab pa_fp_multi_currency_pkg.number_type_tab;
2728: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
2729: l_quantity_tab pa_fp_multi_currency_pkg.number_type_tab;
2730:

Line 2727: l_resource_assignment_id_tab pa_fp_multi_currency_pkg.number_type_tab;

2723: l_debug_mode VARCHAR2(30);
2724:
2725: -- nested tables to hold amount and currency columns
2726: l_txn_row_id_tab pa_fp_multi_currency_pkg.rowid_type_tab;
2727: l_resource_assignment_id_tab pa_fp_multi_currency_pkg.number_type_tab;
2728: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
2729: l_quantity_tab pa_fp_multi_currency_pkg.number_type_tab;
2730:
2731: --Code changes for bug 4200168 starts here.

Line 2728: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;

2724:
2725: -- nested tables to hold amount and currency columns
2726: l_txn_row_id_tab pa_fp_multi_currency_pkg.rowid_type_tab;
2727: l_resource_assignment_id_tab pa_fp_multi_currency_pkg.number_type_tab;
2728: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
2729: l_quantity_tab pa_fp_multi_currency_pkg.number_type_tab;
2730:
2731: --Code changes for bug 4200168 starts here.
2732: --l_txn_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;

Line 2729: l_quantity_tab pa_fp_multi_currency_pkg.number_type_tab;

2725: -- nested tables to hold amount and currency columns
2726: l_txn_row_id_tab pa_fp_multi_currency_pkg.rowid_type_tab;
2727: l_resource_assignment_id_tab pa_fp_multi_currency_pkg.number_type_tab;
2728: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
2729: l_quantity_tab pa_fp_multi_currency_pkg.number_type_tab;
2730:
2731: --Code changes for bug 4200168 starts here.
2732: --l_txn_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;
2733: -- l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 2732: --l_txn_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;

2728: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
2729: l_quantity_tab pa_fp_multi_currency_pkg.number_type_tab;
2730:
2731: --Code changes for bug 4200168 starts here.
2732: --l_txn_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;
2733: -- l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2734: --l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2735: --l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
2736: l_txn_currency_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

Line 2733: -- l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

2729: l_quantity_tab pa_fp_multi_currency_pkg.number_type_tab;
2730:
2731: --Code changes for bug 4200168 starts here.
2732: --l_txn_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;
2733: -- l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2734: --l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2735: --l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
2736: l_txn_currency_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
2737: l_txn_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 2734: --l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

2730:
2731: --Code changes for bug 4200168 starts here.
2732: --l_txn_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;
2733: -- l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2734: --l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2735: --l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
2736: l_txn_currency_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
2737: l_txn_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2738: l_txn_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 2735: --l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

2731: --Code changes for bug 4200168 starts here.
2732: --l_txn_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;
2733: -- l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2734: --l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2735: --l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
2736: l_txn_currency_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
2737: l_txn_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2738: l_txn_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2739: l_txn_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 2741: /*l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;

2737: l_txn_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2738: l_txn_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2739: l_txn_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2740:
2741: /*l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;
2742: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2743: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2744: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
2745: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;

Line 2742: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

2738: l_txn_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2739: l_txn_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2740:
2741: /*l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;
2742: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2743: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2744: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
2745: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;
2746: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 2743: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

2739: l_txn_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2740:
2741: /*l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;
2742: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2743: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2744: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
2745: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;
2746: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2747: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 2744: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

2740:
2741: /*l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;
2742: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2743: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2744: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
2745: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;
2746: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2747: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2748: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;*/

Line 2745: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;

2741: /*l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;
2742: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2743: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2744: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
2745: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;
2746: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2747: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2748: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;*/
2749:

Line 2746: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

2742: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2743: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2744: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
2745: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;
2746: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2747: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2748: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;*/
2749:
2750: l_projfunc_currency_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

Line 2747: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

2743: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2744: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
2745: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;
2746: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2747: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2748: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;*/
2749:
2750: l_projfunc_currency_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
2751: l_proj_currency_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

Line 2748: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;*/

2744: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
2745: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;
2746: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2747: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2748: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;*/
2749:
2750: l_projfunc_currency_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
2751: l_proj_currency_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
2752:

Line 2822: p_function =>'PA_FP_MULTI_CURRENCY_PKG.Round_Budget_Line_Amounts'

2818: */
2819: IF l_debug_mode = 'Y' THEN
2820: -- set curr function
2821: pa_debug.set_curr_function(
2822: p_function =>'PA_FP_MULTI_CURRENCY_PKG.Round_Budget_Line_Amounts'
2823: ,p_debug_mode => l_debug_mode );
2824: END IF;
2825:
2826: -- check for business rules violations

Line 2847: p_value1 => 'PA_FP_MULTI_CURRENCY_PKG.Round_Budget_Line_Amounts',

2843:
2844: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2845: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
2846: p_token1 => 'PROCEDURENAME',
2847: p_value1 => 'PA_FP_MULTI_CURRENCY_PKG.Round_Budget_Line_Amounts',
2848: p_token2 => 'STAGE',
2849: p_value2 => 'p_budget_version_id '||p_budget_version_id ||' p_calling_context '||p_calling_context );
2850:
2851: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

Line 2868: p_value1 => 'PA_FP_MULTI_CURRENCY_PKG.Round_Budget_Line_Amounts',

2864:
2865: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2866: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
2867: p_token1 => 'PROCEDURENAME',
2868: p_value1 => 'PA_FP_MULTI_CURRENCY_PKG.Round_Budget_Line_Amounts',
2869: p_token2 => 'STAGE',
2870: p_value2 => 'p_bls_inserted_after_id '||p_bls_inserted_after_id);
2871:
2872:

Line 3278: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_MULTI_CURRENCY_PKG'

3274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3275: x_msg_count := 1;
3276: x_msg_data := SQLERRM;
3277:
3278: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_MULTI_CURRENCY_PKG'
3279: ,p_procedure_name => 'Round_Budget_Line_Amounts');
3280:
3281: IF l_debug_mode = 'Y' THEN
3282: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 3622: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_MULTI_CURRENCY_PKG'

3618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3619: x_msg_count := 1;
3620: x_msg_data := SQLERRM;
3621:
3622: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_MULTI_CURRENCY_PKG'
3623: ,p_procedure_name => 'round_amounts');
3624:
3625: IF l_debug_mode = 'Y' THEN
3626: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 3640: END PA_FP_MULTI_CURRENCY_PKG;

3636: RAISE;
3637:
3638: END round_amounts;
3639:
3640: END PA_FP_MULTI_CURRENCY_PKG;