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_PROJ_FP_OPTIONS_PUB dependencies on PA_FP_PROJ_XL_AMT_TYPES

Line 4453: --Delete the existing amount types for the project/plan types from pa_fp_proj_xl_amt_types

4449: PA_DEBUG.Reset_Curr_Function;
4450: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4451: END IF;
4452:
4453: --Delete the existing amount types for the project/plan types from pa_fp_proj_xl_amt_types
4454: DELETE FROM PA_FP_PROJ_XL_AMT_TYPES
4455: WHERE project_id = p_project_id
4456: AND fin_plan_type_id = p_fin_plan_type_id;
4457: --getting the plan class code

Line 4454: DELETE FROM PA_FP_PROJ_XL_AMT_TYPES

4450: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4451: END IF;
4452:
4453: --Delete the existing amount types for the project/plan types from pa_fp_proj_xl_amt_types
4454: DELETE FROM PA_FP_PROJ_XL_AMT_TYPES
4455: WHERE project_id = p_project_id
4456: AND fin_plan_type_id = p_fin_plan_type_id;
4457: --getting the plan class code
4458:

Line 4678: INSERT INTO pa_fp_proj_xl_amt_types (

4674: pa_debug.g_err_stage:= 'Inserting cost seed values into pa_proj_fp_xl_amounts ';
4675: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
4676: END IF;
4677: FORALL j IN l_cost_amount_types_tbl.FIRST..l_cost_amount_types_tbl.LAST
4678: INSERT INTO pa_fp_proj_xl_amt_types (
4679: project_id
4680: ,fin_plan_type_id
4681: ,option_type
4682: ,amount_type_code

Line 4716: INSERT INTO pa_fp_proj_xl_amt_types (

4712: pa_debug.g_err_stage:= 'Inserting rev seed values into pa_proj_fp_xl_amounts ';
4713: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
4714: END IF;
4715: FORALL j IN l_rev_amount_types_tbl.FIRST..l_rev_amount_types_tbl.LAST
4716: INSERT INTO pa_fp_proj_xl_amt_types (
4717: project_id
4718: ,fin_plan_type_id
4719: ,option_type
4720: ,amount_type_code

Line 4756: INSERT INTO pa_fp_proj_xl_amt_types (

4752: END IF;
4753:
4754: FORALL j IN l_all_amount_types_tbl.FIRST..l_all_amount_types_tbl.LAST
4755:
4756: INSERT INTO pa_fp_proj_xl_amt_types (
4757: project_id
4758: ,fin_plan_type_id
4759: ,option_type
4760: ,amount_type_code

Line 4908: INSERT INTO PA_FP_PROJ_XL_AMT_TYPES(

4904: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4905:
4906: END IF;
4907:
4908: INSERT INTO PA_FP_PROJ_XL_AMT_TYPES(
4909: project_id
4910: ,fin_plan_type_id
4911: ,option_type
4912: ,amount_type_code

Line 4929: FROM PA_FP_PROJ_XL_AMT_TYPES WHERE

4925: ,fnd_global.user_id
4926: ,sysdate
4927: ,fnd_global.user_id
4928: ,fnd_global.user_id
4929: FROM PA_FP_PROJ_XL_AMT_TYPES WHERE
4930: project_id = p_source_project_id AND
4931: fin_plan_type_id = p_source_fin_plan_type_id ;
4932:
4933: PA_DEBUG.Reset_Curr_Function;

Line 5044: INSERT into pa_fp_proj_xl_amt_types (

5040: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
5041: END IF;
5042: FORALL j in p_add_cost_amt_types_tbl.FIRST..p_add_cost_amt_types_tbl.LAST
5043:
5044: INSERT into pa_fp_proj_xl_amt_types (
5045: project_id
5046: ,fin_plan_type_id
5047: ,option_type
5048: ,amount_type_code

Line 5076: DELETE FROM pa_fp_proj_xl_amt_types WHERE

5072: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
5073: END IF;
5074: FORALL j in p_del_cost_amt_types_tbl.FIRST..p_del_cost_amt_types_tbl.LAST
5075:
5076: DELETE FROM pa_fp_proj_xl_amt_types WHERE
5077: project_id = p_project_id AND
5078: fin_plan_type_id = p_fin_plan_type_id AND
5079: option_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST AND
5080: amount_type_code = p_del_cost_amt_types_tbl(j) ;

Line 5091: INSERT into pa_fp_proj_xl_amt_types (

5087: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
5088: END IF;
5089: FORALL j in p_add_rev_amt_types_tbl.FIRST..p_add_rev_amt_types_tbl.LAST
5090:
5091: INSERT into pa_fp_proj_xl_amt_types (
5092: project_id
5093: ,fin_plan_type_id
5094: ,option_type
5095: ,amount_type_code

Line 5122: DELETE FROM pa_fp_proj_xl_amt_types WHERE

5118: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
5119: END IF;
5120: FORALL j in p_del_rev_amt_types_tbl.FIRST..p_del_rev_amt_types_tbl.LAST
5121:
5122: DELETE FROM pa_fp_proj_xl_amt_types WHERE
5123: project_id = p_project_id AND
5124: fin_plan_type_id = p_fin_plan_type_id AND
5125: option_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE AND
5126: amount_type_code = p_del_rev_amt_types_tbl(j) ;

Line 5143: INSERT into pa_fp_proj_xl_amt_types (

5139: END IF;
5140:
5141: FORALL j in p_add_all_amt_types_tbl.FIRST..p_add_all_amt_types_tbl.LAST
5142:
5143: INSERT into pa_fp_proj_xl_amt_types (
5144: project_id
5145: ,fin_plan_type_id
5146: ,option_type
5147: ,amount_type_code

Line 5176: DELETE FROM pa_fp_proj_xl_amt_types WHERE

5172: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
5173: END IF;
5174: FORALL j in p_del_all_amt_types_tbl.FIRST..p_del_all_amt_types_tbl.LAST
5175:
5176: DELETE FROM pa_fp_proj_xl_amt_types WHERE
5177: project_id = p_project_id AND
5178: fin_plan_type_id = p_fin_plan_type_id AND
5179: option_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL AND
5180: amount_type_code = p_del_all_amt_types_tbl(j) ;