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 4408: --Delete the existing amount types for the project/plan types from pa_fp_proj_xl_amt_types

4404: PA_DEBUG.Reset_Curr_Function;
4405: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4406: END IF;
4407:
4408: --Delete the existing amount types for the project/plan types from pa_fp_proj_xl_amt_types
4409: DELETE FROM PA_FP_PROJ_XL_AMT_TYPES
4410: WHERE project_id = p_project_id
4411: AND fin_plan_type_id = p_fin_plan_type_id;
4412: --getting the plan class code

Line 4409: DELETE FROM PA_FP_PROJ_XL_AMT_TYPES

4405: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4406: END IF;
4407:
4408: --Delete the existing amount types for the project/plan types from pa_fp_proj_xl_amt_types
4409: DELETE FROM PA_FP_PROJ_XL_AMT_TYPES
4410: WHERE project_id = p_project_id
4411: AND fin_plan_type_id = p_fin_plan_type_id;
4412: --getting the plan class code
4413:

Line 4633: INSERT INTO pa_fp_proj_xl_amt_types (

4629: pa_debug.g_err_stage:= 'Inserting cost seed values into pa_proj_fp_xl_amounts ';
4630: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
4631: END IF;
4632: FORALL j IN l_cost_amount_types_tbl.FIRST..l_cost_amount_types_tbl.LAST
4633: INSERT INTO pa_fp_proj_xl_amt_types (
4634: project_id
4635: ,fin_plan_type_id
4636: ,option_type
4637: ,amount_type_code

Line 4671: INSERT INTO pa_fp_proj_xl_amt_types (

4667: pa_debug.g_err_stage:= 'Inserting rev seed values into pa_proj_fp_xl_amounts ';
4668: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
4669: END IF;
4670: FORALL j IN l_rev_amount_types_tbl.FIRST..l_rev_amount_types_tbl.LAST
4671: INSERT INTO pa_fp_proj_xl_amt_types (
4672: project_id
4673: ,fin_plan_type_id
4674: ,option_type
4675: ,amount_type_code

Line 4711: INSERT INTO pa_fp_proj_xl_amt_types (

4707: END IF;
4708:
4709: FORALL j IN l_all_amount_types_tbl.FIRST..l_all_amount_types_tbl.LAST
4710:
4711: INSERT INTO pa_fp_proj_xl_amt_types (
4712: project_id
4713: ,fin_plan_type_id
4714: ,option_type
4715: ,amount_type_code

Line 4863: INSERT INTO PA_FP_PROJ_XL_AMT_TYPES(

4859: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4860:
4861: END IF;
4862:
4863: INSERT INTO PA_FP_PROJ_XL_AMT_TYPES(
4864: project_id
4865: ,fin_plan_type_id
4866: ,option_type
4867: ,amount_type_code

Line 4884: FROM PA_FP_PROJ_XL_AMT_TYPES WHERE

4880: ,fnd_global.user_id
4881: ,sysdate
4882: ,fnd_global.user_id
4883: ,fnd_global.user_id
4884: FROM PA_FP_PROJ_XL_AMT_TYPES WHERE
4885: project_id = p_source_project_id AND
4886: fin_plan_type_id = p_source_fin_plan_type_id ;
4887:
4888: PA_DEBUG.Reset_Curr_Function;

Line 4999: INSERT into pa_fp_proj_xl_amt_types (

4995: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
4996: END IF;
4997: FORALL j in p_add_cost_amt_types_tbl.FIRST..p_add_cost_amt_types_tbl.LAST
4998:
4999: INSERT into pa_fp_proj_xl_amt_types (
5000: project_id
5001: ,fin_plan_type_id
5002: ,option_type
5003: ,amount_type_code

Line 5031: DELETE FROM pa_fp_proj_xl_amt_types WHERE

5027: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
5028: END IF;
5029: FORALL j in p_del_cost_amt_types_tbl.FIRST..p_del_cost_amt_types_tbl.LAST
5030:
5031: DELETE FROM pa_fp_proj_xl_amt_types WHERE
5032: project_id = p_project_id AND
5033: fin_plan_type_id = p_fin_plan_type_id AND
5034: option_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST AND
5035: amount_type_code = p_del_cost_amt_types_tbl(j) ;

Line 5046: INSERT into pa_fp_proj_xl_amt_types (

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

Line 5077: DELETE FROM pa_fp_proj_xl_amt_types WHERE

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

Line 5098: INSERT into pa_fp_proj_xl_amt_types (

5094: END IF;
5095:
5096: FORALL j in p_add_all_amt_types_tbl.FIRST..p_add_all_amt_types_tbl.LAST
5097:
5098: INSERT into pa_fp_proj_xl_amt_types (
5099: project_id
5100: ,fin_plan_type_id
5101: ,option_type
5102: ,amount_type_code

Line 5131: DELETE FROM pa_fp_proj_xl_amt_types WHERE

5127: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
5128: END IF;
5129: FORALL j in p_del_all_amt_types_tbl.FIRST..p_del_all_amt_types_tbl.LAST
5130:
5131: DELETE FROM pa_fp_proj_xl_amt_types WHERE
5132: project_id = p_project_id AND
5133: fin_plan_type_id = p_fin_plan_type_id AND
5134: option_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL AND
5135: amount_type_code = p_del_all_amt_types_tbl(j) ;