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.3 2006/07/26 10:24:10 prachand noship $
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 1692: pa_debug.g_err_stage := 'Leaving PA_FP_MULTI_CURRENCY_PKG.conv_mc_bulk';

1688: --hr_utility.trace('x_projfunc_rejection_tab(i) := '||to_char(x_projfunc_rejection_tab(i)));
1689: END LOOP;
1690: l_stage := 8600;
1691: --hr_utility.trace(to_char(l_stage));
1692: pa_debug.g_err_stage := 'Leaving PA_FP_MULTI_CURRENCY_PKG.conv_mc_bulk';
1693: IF P_PA_DEBUG_MODE = 'Y' THEN
1694: pa_debug.write('conv_mc_bulk: ' || g_module_name,pa_debug.g_err_stage,3);
1695: END IF;
1696:

Line 1726: ( p_pkg_name => 'PA_FP_MULTI_CURRENCY_PKG'

1722: END IF;
1723:
1724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1725: fnd_msg_pub.add_exc_msg
1726: ( p_pkg_name => 'PA_FP_MULTI_CURRENCY_PKG'
1727: ,p_procedure_name => 'conv_mc_bulk' );
1728: pa_debug.g_err_stage := 'Stage : '||to_char(l_stage)||' '||substr(SQLERRM,1,240);
1729: IF P_PA_DEBUG_MODE = 'Y' THEN
1730: pa_debug.write('conv_mc_bulk: ' || g_module_name,pa_debug.g_err_stage,3);

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

1728: pa_debug.g_err_stage := 'Stage : '||to_char(l_stage)||' '||substr(SQLERRM,1,240);
1729: IF P_PA_DEBUG_MODE = 'Y' THEN
1730: pa_debug.write('conv_mc_bulk: ' || g_module_name,pa_debug.g_err_stage,3);
1731: END IF;
1732: --hr_utility.trace('PA_FP_MULTI_CURRENCY_PKG.conv_mc_bulk -- Stage : ' ||to_char(l_stage)||' '||substr(SQLERRM,1,240));
1733: /* bug 4227840: wrapping the setting of debug error stack call to
1734: * pa_debug under the debug enbaling check
1735: */
1736: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 1753: l_txn_row_id_tab pa_fp_multi_currency_pkg.rowid_type_tab;

1749: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1750: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1751: IS
1752:
1753: l_txn_row_id_tab pa_fp_multi_currency_pkg.rowid_type_tab;
1754: l_resource_assignment_id_tab pa_fp_multi_currency_pkg.number_type_tab;
1755: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1756: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1757: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 1754: l_resource_assignment_id_tab pa_fp_multi_currency_pkg.number_type_tab;

1750: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1751: IS
1752:
1753: l_txn_row_id_tab pa_fp_multi_currency_pkg.rowid_type_tab;
1754: l_resource_assignment_id_tab pa_fp_multi_currency_pkg.number_type_tab;
1755: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1756: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1757: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1758: l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1755: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;

1751: IS
1752:
1753: l_txn_row_id_tab pa_fp_multi_currency_pkg.rowid_type_tab;
1754: l_resource_assignment_id_tab pa_fp_multi_currency_pkg.number_type_tab;
1755: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1756: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1757: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1758: l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1759: l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1756: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;

1752:
1753: l_txn_row_id_tab pa_fp_multi_currency_pkg.rowid_type_tab;
1754: l_resource_assignment_id_tab pa_fp_multi_currency_pkg.number_type_tab;
1755: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1756: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1757: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1758: l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1759: l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1760: l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1757: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;

1753: l_txn_row_id_tab pa_fp_multi_currency_pkg.rowid_type_tab;
1754: l_resource_assignment_id_tab pa_fp_multi_currency_pkg.number_type_tab;
1755: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1756: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1757: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1758: l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1759: l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1760: l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1761: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 1758: l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

1754: l_resource_assignment_id_tab pa_fp_multi_currency_pkg.number_type_tab;
1755: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1756: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1757: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1758: l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1759: l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1760: l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1761: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1762: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 1759: l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

1755: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1756: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1757: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1758: l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1759: l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1760: l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1761: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1762: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1763: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1760: l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

1756: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1757: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1758: l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1759: l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1760: l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1761: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1762: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1763: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1764: l_projfunc_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 1761: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;

1757: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1758: l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1759: l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1760: l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1761: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1762: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1763: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1764: l_projfunc_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1765: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

Line 1762: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

1758: l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1759: l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1760: l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1761: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1762: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1763: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1764: l_projfunc_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1765: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1766: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 1763: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

1759: l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1760: l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1761: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1762: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1763: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1764: l_projfunc_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1765: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1766: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1767: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1764: l_projfunc_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;

1760: l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1761: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1762: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1763: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1764: l_projfunc_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1765: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1766: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1767: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1768: l_projfunc_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 1765: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

1761: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1762: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1763: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1764: l_projfunc_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1765: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1766: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1767: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1768: l_projfunc_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1769: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

Line 1766: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

1762: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1763: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1764: l_projfunc_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1765: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1766: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1767: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1768: l_projfunc_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1769: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1770: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1767: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

1763: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1764: l_projfunc_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1765: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1766: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1767: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1768: l_projfunc_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1769: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1770: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1771: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1768: l_projfunc_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;

1764: l_projfunc_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1765: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1766: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1767: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1768: l_projfunc_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1769: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1770: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1771: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1772: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1769: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

1765: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1766: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1767: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1768: l_projfunc_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1769: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1770: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1771: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1772: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1773: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;

Line 1770: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

1766: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1767: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1768: l_projfunc_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1769: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1770: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1771: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1772: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1773: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
1774: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 1771: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

1767: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1768: l_projfunc_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1769: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1770: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1771: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1772: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1773: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
1774: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1775: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 1772: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

1768: l_projfunc_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1769: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1770: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1771: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1772: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1773: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
1774: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1775: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1776: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1773: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;

1769: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1770: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1771: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1772: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1773: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
1774: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1775: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1776: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1777: l_proj_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 1774: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;

1770: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1771: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1772: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1773: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
1774: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1775: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1776: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1777: l_proj_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1778: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

Line 1775: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

1771: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1772: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1773: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
1774: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1775: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1776: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1777: l_proj_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1778: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1779: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 1776: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

1772: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1773: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
1774: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1775: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1776: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1777: l_proj_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1778: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1779: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1780: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1777: l_proj_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;

1773: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
1774: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1775: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1776: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1777: l_proj_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1778: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1779: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1780: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1781: l_proj_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 1778: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

1774: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
1775: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1776: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1777: l_proj_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1778: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1779: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1780: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1781: l_proj_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1782: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

Line 1779: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

1775: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1776: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1777: l_proj_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1778: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1779: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1780: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1781: l_proj_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1782: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1783: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1780: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

1776: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1777: l_proj_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1778: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1779: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1780: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1781: l_proj_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1782: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1783: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1784: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1781: l_proj_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;

1777: l_proj_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1778: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1779: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1780: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1781: l_proj_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1782: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1783: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1784: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1785: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1782: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

1778: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1779: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1780: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1781: l_proj_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1782: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1783: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1784: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1785: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1786: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;

Line 1783: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

1779: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
1780: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1781: l_proj_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1782: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1783: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1784: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1785: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1786: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
1787: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 1784: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

1780: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
1781: l_proj_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1782: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1783: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1784: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1785: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1786: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
1787: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
1788: l_status_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 1785: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

1781: l_proj_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
1782: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1783: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1784: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1785: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1786: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
1787: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
1788: l_status_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
1789:

Line 1786: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;

1782: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
1783: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1784: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1785: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1786: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
1787: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
1788: l_status_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
1789:
1790: /* Perf Bug: 3683132 */

Line 1787: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;

1783: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1784: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1785: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1786: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
1787: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
1788: l_status_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
1789:
1790: /* Perf Bug: 3683132 */
1791: l_fp_cur_projfunc_cost_rt_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1788: l_status_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;

1784: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1785: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1786: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
1787: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
1788: l_status_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
1789:
1790: /* Perf Bug: 3683132 */
1791: l_fp_cur_projfunc_cost_rt_tab pa_fp_multi_currency_pkg.number_type_tab;
1792: l_fp_cur_projfunc_rev_rt_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1791: l_fp_cur_projfunc_cost_rt_tab pa_fp_multi_currency_pkg.number_type_tab;

1787: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
1788: l_status_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
1789:
1790: /* Perf Bug: 3683132 */
1791: l_fp_cur_projfunc_cost_rt_tab pa_fp_multi_currency_pkg.number_type_tab;
1792: l_fp_cur_projfunc_rev_rt_tab pa_fp_multi_currency_pkg.number_type_tab;
1793: l_fp_cur_project_cost_rt_tab pa_fp_multi_currency_pkg.number_type_tab;
1794: l_fp_cur_project_rev_rt_tab pa_fp_multi_currency_pkg.number_type_tab;
1795:

Line 1792: l_fp_cur_projfunc_rev_rt_tab pa_fp_multi_currency_pkg.number_type_tab;

1788: l_status_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
1789:
1790: /* Perf Bug: 3683132 */
1791: l_fp_cur_projfunc_cost_rt_tab pa_fp_multi_currency_pkg.number_type_tab;
1792: l_fp_cur_projfunc_rev_rt_tab pa_fp_multi_currency_pkg.number_type_tab;
1793: l_fp_cur_project_cost_rt_tab pa_fp_multi_currency_pkg.number_type_tab;
1794: l_fp_cur_project_rev_rt_tab pa_fp_multi_currency_pkg.number_type_tab;
1795:
1796: /* Bug fix:4259098 */

Line 1793: l_fp_cur_project_cost_rt_tab pa_fp_multi_currency_pkg.number_type_tab;

1789:
1790: /* Perf Bug: 3683132 */
1791: l_fp_cur_projfunc_cost_rt_tab pa_fp_multi_currency_pkg.number_type_tab;
1792: l_fp_cur_projfunc_rev_rt_tab pa_fp_multi_currency_pkg.number_type_tab;
1793: l_fp_cur_project_cost_rt_tab pa_fp_multi_currency_pkg.number_type_tab;
1794: l_fp_cur_project_rev_rt_tab pa_fp_multi_currency_pkg.number_type_tab;
1795:
1796: /* Bug fix:4259098 */
1797: l_init_quantity_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1794: l_fp_cur_project_rev_rt_tab pa_fp_multi_currency_pkg.number_type_tab;

1790: /* Perf Bug: 3683132 */
1791: l_fp_cur_projfunc_cost_rt_tab pa_fp_multi_currency_pkg.number_type_tab;
1792: l_fp_cur_projfunc_rev_rt_tab pa_fp_multi_currency_pkg.number_type_tab;
1793: l_fp_cur_project_cost_rt_tab pa_fp_multi_currency_pkg.number_type_tab;
1794: l_fp_cur_project_rev_rt_tab pa_fp_multi_currency_pkg.number_type_tab;
1795:
1796: /* Bug fix:4259098 */
1797: l_init_quantity_tab pa_fp_multi_currency_pkg.number_type_tab;
1798: l_txn_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1797: l_init_quantity_tab pa_fp_multi_currency_pkg.number_type_tab;

1793: l_fp_cur_project_cost_rt_tab pa_fp_multi_currency_pkg.number_type_tab;
1794: l_fp_cur_project_rev_rt_tab pa_fp_multi_currency_pkg.number_type_tab;
1795:
1796: /* Bug fix:4259098 */
1797: l_init_quantity_tab pa_fp_multi_currency_pkg.number_type_tab;
1798: l_txn_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1799: l_txn_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1800: l_txn_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1801: l_pfc_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1798: l_txn_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

1794: l_fp_cur_project_rev_rt_tab pa_fp_multi_currency_pkg.number_type_tab;
1795:
1796: /* Bug fix:4259098 */
1797: l_init_quantity_tab pa_fp_multi_currency_pkg.number_type_tab;
1798: l_txn_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1799: l_txn_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1800: l_txn_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1801: l_pfc_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1802: l_pfc_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1799: l_txn_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

1795:
1796: /* Bug fix:4259098 */
1797: l_init_quantity_tab pa_fp_multi_currency_pkg.number_type_tab;
1798: l_txn_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1799: l_txn_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1800: l_txn_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1801: l_pfc_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1802: l_pfc_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1803: l_pfc_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1800: l_txn_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

1796: /* Bug fix:4259098 */
1797: l_init_quantity_tab pa_fp_multi_currency_pkg.number_type_tab;
1798: l_txn_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1799: l_txn_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1800: l_txn_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1801: l_pfc_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1802: l_pfc_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1803: l_pfc_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1804: l_proj_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1801: l_pfc_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

1797: l_init_quantity_tab pa_fp_multi_currency_pkg.number_type_tab;
1798: l_txn_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1799: l_txn_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1800: l_txn_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1801: l_pfc_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1802: l_pfc_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1803: l_pfc_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1804: l_proj_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1805: l_proj_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1802: l_pfc_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

1798: l_txn_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1799: l_txn_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1800: l_txn_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1801: l_pfc_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1802: l_pfc_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1803: l_pfc_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1804: l_proj_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1805: l_proj_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1806: l_proj_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 1803: l_pfc_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

1799: l_txn_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1800: l_txn_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1801: l_pfc_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1802: l_pfc_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1803: l_pfc_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1804: l_proj_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1805: l_proj_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1806: l_proj_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1807:

Line 1804: l_proj_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

1800: l_txn_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1801: l_pfc_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1802: l_pfc_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1803: l_pfc_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1804: l_proj_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1805: l_proj_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1806: l_proj_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1807:
1808: l_return_status VARCHAR2(240);

Line 1805: l_proj_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

1801: l_pfc_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1802: l_pfc_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1803: l_pfc_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1804: l_proj_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1805: l_proj_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1806: l_proj_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1807:
1808: l_return_status VARCHAR2(240);
1809: l_msg_count NUMBER;

Line 1806: l_proj_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

1802: l_pfc_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1803: l_pfc_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1804: l_proj_init_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1805: l_proj_init_burden_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
1806: l_proj_init_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
1807:
1808: l_return_status VARCHAR2(240);
1809: l_msg_count NUMBER;
1810: l_msg_data VARCHAR2(2000);

Line 2398: pa_fp_multi_currency_pkg.conv_mc_bulk (

2394: END LOOP;
2395: /* End of Perf Bug: 3683132 */
2396:
2397: --hr_utility.trace('Calling conv_mc_bulk...');
2398: pa_fp_multi_currency_pkg.conv_mc_bulk (
2399: p_resource_assignment_id_tab => l_resource_assignment_id_tab
2400: ,p_start_date_tab => l_start_date_tab
2401: ,p_end_date_tab => l_end_date_tab
2402: ,p_txn_currency_code_tab => l_txn_currency_code_tab

Line 2586: ( p_pkg_name => 'PA_FP_MULTI_CURRENCY_PKG'

2582: END IF;
2583: END IF;
2584:
2585: fnd_msg_pub.add_exc_msg
2586: ( p_pkg_name => 'PA_FP_MULTI_CURRENCY_PKG'
2587: ,p_procedure_name => 'convert_txn_currency' );
2588: pa_debug.g_err_stage := 'Stage : '||to_char(l_stage)||' '||substr(SQLERRM,1,240);
2589: IF P_PA_DEBUG_MODE = 'Y' THEN
2590: pa_debug.write('convert_txn_currency: ' || g_module_name,pa_debug.g_err_stage,3);

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

2588: pa_debug.g_err_stage := 'Stage : '||to_char(l_stage)||' '||substr(SQLERRM,1,240);
2589: IF P_PA_DEBUG_MODE = 'Y' THEN
2590: pa_debug.write('convert_txn_currency: ' || g_module_name,pa_debug.g_err_stage,3);
2591: END IF;
2592: --hr_utility.trace('PA_FP_MULTI_CURRENCY_PKG.convert_txn_currency -- Stage : ' ||to_char(l_stage)||' '||substr(SQLERRM,1,240));
2593: /* bug 4227840: wrapping the setting of debug error stack call to
2594: * pa_debug under the debug enbaling check
2595: */
2596: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2641: ( p_pkg_name => 'PA_FP_MULTI_CURRENCY_PKG'

2637: END IF;
2638:
2639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2640: fnd_msg_pub.add_exc_msg
2641: ( p_pkg_name => 'PA_FP_MULTI_CURRENCY_PKG'
2642: ,p_procedure_name => 'convert_txn_currency' );
2643: pa_debug.g_err_stage := 'Stage : '||to_char(l_stage)||' '||substr(SQLERRM,1,240);
2644: IF P_PA_DEBUG_MODE = 'Y' THEN
2645: pa_debug.write('convert_txn_currency: ' || g_module_name,pa_debug.g_err_stage,3);

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

2643: pa_debug.g_err_stage := 'Stage : '||to_char(l_stage)||' '||substr(SQLERRM,1,240);
2644: IF P_PA_DEBUG_MODE = 'Y' THEN
2645: pa_debug.write('convert_txn_currency: ' || g_module_name,pa_debug.g_err_stage,3);
2646: END IF;
2647: --hr_utility.trace('PA_FP_MULTI_CURRENCY_PKG.convert_txn_currency -- Stage : ' ||to_char(l_stage)||' '||substr(SQLERRM,1,240));
2648: /* bug 4227840: wrapping the setting of debug error stack call to
2649: * pa_debug under the debug enbaling check
2650: */
2651: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2693: l_txn_row_id_tab pa_fp_multi_currency_pkg.rowid_type_tab;

2689: l_msg_index_out NUMBER;
2690: l_debug_mode VARCHAR2(30);
2691:
2692: -- nested tables to hold amount and currency columns
2693: l_txn_row_id_tab pa_fp_multi_currency_pkg.rowid_type_tab;
2694: l_resource_assignment_id_tab pa_fp_multi_currency_pkg.number_type_tab;
2695: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
2696: l_quantity_tab pa_fp_multi_currency_pkg.number_type_tab;
2697:

Line 2694: l_resource_assignment_id_tab pa_fp_multi_currency_pkg.number_type_tab;

2690: l_debug_mode VARCHAR2(30);
2691:
2692: -- nested tables to hold amount and currency columns
2693: l_txn_row_id_tab pa_fp_multi_currency_pkg.rowid_type_tab;
2694: l_resource_assignment_id_tab pa_fp_multi_currency_pkg.number_type_tab;
2695: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
2696: l_quantity_tab pa_fp_multi_currency_pkg.number_type_tab;
2697:
2698: --Code changes for bug 4200168 starts here.

Line 2695: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;

2691:
2692: -- nested tables to hold amount and currency columns
2693: l_txn_row_id_tab pa_fp_multi_currency_pkg.rowid_type_tab;
2694: l_resource_assignment_id_tab pa_fp_multi_currency_pkg.number_type_tab;
2695: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
2696: l_quantity_tab pa_fp_multi_currency_pkg.number_type_tab;
2697:
2698: --Code changes for bug 4200168 starts here.
2699: --l_txn_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;

Line 2696: l_quantity_tab pa_fp_multi_currency_pkg.number_type_tab;

2692: -- nested tables to hold amount and currency columns
2693: l_txn_row_id_tab pa_fp_multi_currency_pkg.rowid_type_tab;
2694: l_resource_assignment_id_tab pa_fp_multi_currency_pkg.number_type_tab;
2695: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
2696: l_quantity_tab pa_fp_multi_currency_pkg.number_type_tab;
2697:
2698: --Code changes for bug 4200168 starts here.
2699: --l_txn_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;
2700: -- l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 2699: --l_txn_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;

2695: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
2696: l_quantity_tab pa_fp_multi_currency_pkg.number_type_tab;
2697:
2698: --Code changes for bug 4200168 starts here.
2699: --l_txn_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;
2700: -- l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2701: --l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2702: --l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
2703: l_txn_currency_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

Line 2700: -- l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

2696: l_quantity_tab pa_fp_multi_currency_pkg.number_type_tab;
2697:
2698: --Code changes for bug 4200168 starts here.
2699: --l_txn_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;
2700: -- l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2701: --l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2702: --l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
2703: l_txn_currency_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
2704: l_txn_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 2701: --l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

2697:
2698: --Code changes for bug 4200168 starts here.
2699: --l_txn_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;
2700: -- l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2701: --l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2702: --l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
2703: l_txn_currency_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
2704: l_txn_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2705: l_txn_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 2702: --l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

2698: --Code changes for bug 4200168 starts here.
2699: --l_txn_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;
2700: -- l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2701: --l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2702: --l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
2703: l_txn_currency_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
2704: l_txn_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2705: l_txn_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2706: l_txn_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 2708: /*l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;

2704: l_txn_raw_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2705: l_txn_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2706: l_txn_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2707:
2708: /*l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;
2709: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2710: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2711: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
2712: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;

Line 2709: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

2705: l_txn_burdened_cost_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2706: l_txn_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2707:
2708: /*l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;
2709: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2710: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2711: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
2712: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;
2713: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 2710: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

2706: l_txn_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2707:
2708: /*l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;
2709: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2710: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2711: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
2712: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;
2713: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2714: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 2711: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

2707:
2708: /*l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;
2709: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2710: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2711: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
2712: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;
2713: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2714: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2715: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;*/

Line 2712: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;

2708: /*l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;
2709: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2710: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2711: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
2712: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;
2713: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2714: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2715: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;*/
2716:

Line 2713: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

2709: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2710: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2711: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
2712: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;
2713: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2714: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2715: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;*/
2716:
2717: l_projfunc_currency_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

Line 2714: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

2710: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2711: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
2712: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;
2713: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2714: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2715: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;*/
2716:
2717: l_projfunc_currency_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
2718: l_proj_currency_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

Line 2715: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;*/

2711: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
2712: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char30_type_tab;
2713: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2714: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
2715: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;*/
2716:
2717: l_projfunc_currency_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
2718: l_proj_currency_code_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
2719:

Line 2789: p_function =>'PA_FP_MULTI_CURRENCY_PKG.Round_Budget_Line_Amounts'

2785: */
2786: IF l_debug_mode = 'Y' THEN
2787: -- set curr function
2788: pa_debug.set_curr_function(
2789: p_function =>'PA_FP_MULTI_CURRENCY_PKG.Round_Budget_Line_Amounts'
2790: ,p_debug_mode => l_debug_mode );
2791: END IF;
2792:
2793: -- check for business rules violations

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

2810:
2811: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2812: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
2813: p_token1 => 'PROCEDURENAME',
2814: p_value1 => 'PA_FP_MULTI_CURRENCY_PKG.Round_Budget_Line_Amounts',
2815: p_token2 => 'STAGE',
2816: p_value2 => 'p_budget_version_id '||p_budget_version_id ||' p_calling_context '||p_calling_context );
2817:
2818: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

2831:
2832: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2833: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
2834: p_token1 => 'PROCEDURENAME',
2835: p_value1 => 'PA_FP_MULTI_CURRENCY_PKG.Round_Budget_Line_Amounts',
2836: p_token2 => 'STAGE',
2837: p_value2 => 'p_bls_inserted_after_id '||p_bls_inserted_after_id);
2838:
2839:

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

3241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3242: x_msg_count := 1;
3243: x_msg_data := SQLERRM;
3244:
3245: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_MULTI_CURRENCY_PKG'
3246: ,p_procedure_name => 'Round_Budget_Line_Amounts');
3247:
3248: IF l_debug_mode = 'Y' THEN
3249: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

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

3585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3586: x_msg_count := 1;
3587: x_msg_data := SQLERRM;
3588:
3589: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_MULTI_CURRENCY_PKG'
3590: ,p_procedure_name => 'round_amounts');
3591:
3592: IF l_debug_mode = 'Y' THEN
3593: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 3607: END PA_FP_MULTI_CURRENCY_PKG;

3603: RAISE;
3604:
3605: END round_amounts;
3606:
3607: END PA_FP_MULTI_CURRENCY_PKG;