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_TXN_CURRENCIES_PUB dependencies on PA_PROJ_FP_OPTIONS

Line 10: pa_proj_fp_options table.

6:
7: /*===========================================================================
8: This api copies pa_fp_txn_currencies from one proj option to another.
9: If p_target_fp_preference_code isn't passed then it's vale is fetched from
10: pa_proj_fp_options table.
11:
12: 3/30/2004 Raja FP M Phase II Dev changes
13: Post FP M txn currencies can be added irrespective of MC flag status
14: Changed the code such that if source option is available all the currencies

Line 46: l_source_fp_option_id pa_proj_fp_options.proj_fp_options_id%TYPE;

42:
43: /* End of Variables to be used for debugging purpose */
44:
45: l_source_project_id pa_projects_all.project_id%TYPE;
46: l_source_fp_option_id pa_proj_fp_options.proj_fp_options_id%TYPE;
47:
48: l_srce_cost_default_curr_code pa_fp_txn_currencies.txn_currency_code%TYPE;
49: l_srce_rev_default_curr_code pa_fp_txn_currencies.txn_currency_code%TYPE;
50: l_srce_all_default_curr_code pa_fp_txn_currencies.txn_currency_code%TYPE;

Line 61: FROM pa_proj_fp_options

57: ,NVL(p_target_fp_preference_code,fin_plan_preference_code) fin_plan_preference_code
58: ,nvl(p_approved_rev_plan_type_flag,nvl(approved_rev_plan_type_flag,'N')) approved_rev_plan_type_flag--For Bug 2998696
59: -- ,plan_in_multi_curr_flag Bug:- 2706430
60: /* commented out as we should be using the passed value always */
61: FROM pa_proj_fp_options
62: WHERE proj_fp_options_id = p_target_fp_option_id;
63:
64: target_fp_options_rec target_fp_options_cur%ROWTYPE;
65:

Line 142: -- from pa_proj_fp_options

138: pa_debug.write('Copy_Fp_Txn_Currencies: ' || l_module_name,pa_debug.g_err_stage,3);
139: END IF;
140:
141: -- Fetch project id,plan type id,plan version id and preference code of target
142: -- from pa_proj_fp_options
143:
144: IF P_PA_DEBUG_MODE = 'Y' THEN
145: pa_debug.g_err_stage:='Opening target_fp_options_cur';
146: pa_debug.write('Copy_Fp_Txn_Currencies: ' || l_module_name,pa_debug.g_err_stage,3);

Line 184: l_source_fp_option_id := PA_PROJ_FP_OPTIONS_PUB.GET_PARENT_FP_OPTION_ID(p_target_fp_option_id);

180: END IF;
181:
182: IF p_source_fp_option_id IS NULL THEN
183:
184: l_source_fp_option_id := PA_PROJ_FP_OPTIONS_PUB.GET_PARENT_FP_OPTION_ID(p_target_fp_option_id);
185:
186: ELSE
187:
188: l_source_fp_option_id := p_source_fp_option_id;

Line 237: FROM pa_proj_fp_options

233: END IF;
234:
235: SELECT project_id
236: INTO l_source_project_id
237: FROM pa_proj_fp_options
238: WHERE proj_fp_options_id = l_source_fp_option_id;
239:
240: /* #2632410: Modified the below logic to insert only Project Functional Records
241: when the l_only_projfunc_curr_flg returned by Insert_Only_Projfunc_Curr is TRUE. */

Line 867: FROM pa_proj_fp_options

863:
864: CURSOR version_details_cur IS
865: SELECT proj_fp_options_id,
866: fin_plan_type_id
867: FROM pa_proj_fp_options
868: WHERE fin_plan_version_id = p_fin_plan_version_id
869: AND project_id = p_project_id;
870:
871: version_details_rec version_details_cur%ROWTYPE;

Line 1096: FUNCTION Insert_Only_Projfunc_Curr( p_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE

1092: Bug 3668370 Raja FP M changes Even for AR versions there can be multiple txn currencies
1093: So, changed the api to always return false so that all the currencies from
1094: parent record are added
1095: ===============================================================================================*/
1096: FUNCTION Insert_Only_Projfunc_Curr( p_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE
1097: ,p_approved_rev_plan_type_flag pa_proj_fp_options.approved_rev_plan_type_flag%TYPE)--for bug 2998696
1098: RETURN BOOLEAN
1099: IS
1100:

Line 1097: ,p_approved_rev_plan_type_flag pa_proj_fp_options.approved_rev_plan_type_flag%TYPE)--for bug 2998696

1093: So, changed the api to always return false so that all the currencies from
1094: parent record are added
1095: ===============================================================================================*/
1096: FUNCTION Insert_Only_Projfunc_Curr( p_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE
1097: ,p_approved_rev_plan_type_flag pa_proj_fp_options.approved_rev_plan_type_flag%TYPE)--for bug 2998696
1098: RETURN BOOLEAN
1099: IS
1100:
1101: l_planning_level pa_proj_fp_options.fin_plan_option_level_code%TYPE;

Line 1101: l_planning_level pa_proj_fp_options.fin_plan_option_level_code%TYPE;

1097: ,p_approved_rev_plan_type_flag pa_proj_fp_options.approved_rev_plan_type_flag%TYPE)--for bug 2998696
1098: RETURN BOOLEAN
1099: IS
1100:
1101: l_planning_level pa_proj_fp_options.fin_plan_option_level_code%TYPE;
1102: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
1103: l_approved_rev_plan_type_flag pa_proj_fp_options.approved_rev_plan_type_flag%TYPE;
1104: l_insert_only_proj_func_curr BOOLEAN;
1105:

Line 1102: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

1098: RETURN BOOLEAN
1099: IS
1100:
1101: l_planning_level pa_proj_fp_options.fin_plan_option_level_code%TYPE;
1102: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
1103: l_approved_rev_plan_type_flag pa_proj_fp_options.approved_rev_plan_type_flag%TYPE;
1104: l_insert_only_proj_func_curr BOOLEAN;
1105:
1106: BEGIN

Line 1103: l_approved_rev_plan_type_flag pa_proj_fp_options.approved_rev_plan_type_flag%TYPE;

1099: IS
1100:
1101: l_planning_level pa_proj_fp_options.fin_plan_option_level_code%TYPE;
1102: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
1103: l_approved_rev_plan_type_flag pa_proj_fp_options.approved_rev_plan_type_flag%TYPE;
1104: l_insert_only_proj_func_curr BOOLEAN;
1105:
1106: BEGIN
1107:

Line 1129: FROM pa_proj_fp_options

1125: ,nvl(p_approved_rev_plan_type_flag,nvl(approved_rev_plan_type_flag,'N'))--Bug 2998696
1126: INTO l_planning_level
1127: ,l_fp_preference_code
1128: ,l_approved_rev_plan_type_flag
1129: FROM pa_proj_fp_options
1130: WHERE proj_fp_options_id = p_proj_fp_options_id;
1131:
1132: IF P_PA_DEBUG_MODE = 'Y' THEN
1133: pa_debug.g_err_stage:='Approved Revenue Flag is Y';