4693: , PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST
4694: , l_cost_amount_types_tbl(j)
4695: , 1
4696: , sysdate
4697: , fnd_global.user_id
4698: , sysdate
4699: , fnd_global.user_id
4700: , fnd_global.login_id );
4701: ELSE
4695: , 1
4696: , sysdate
4697: , fnd_global.user_id
4698: , sysdate
4699: , fnd_global.user_id
4700: , fnd_global.login_id );
4701: ELSE
4702:
4703: IF l_debug_mode = 'Y' THEN
4696: , sysdate
4697: , fnd_global.user_id
4698: , sysdate
4699: , fnd_global.user_id
4700: , fnd_global.login_id );
4701: ELSE
4702:
4703: IF l_debug_mode = 'Y' THEN
4704: pa_debug.g_err_stage:= 'Not a cost plan type';
4731: , PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE
4732: , l_rev_amount_types_tbl(j)
4733: , 1
4734: , sysdate
4735: , fnd_global.user_id
4736: , sysdate
4737: , fnd_global.user_id
4738: , fnd_global.login_id );
4739: ELSE
4733: , 1
4734: , sysdate
4735: , fnd_global.user_id
4736: , sysdate
4737: , fnd_global.user_id
4738: , fnd_global.login_id );
4739: ELSE
4740:
4741: IF l_debug_mode = 'Y' THEN
4734: , sysdate
4735: , fnd_global.user_id
4736: , sysdate
4737: , fnd_global.user_id
4738: , fnd_global.login_id );
4739: ELSE
4740:
4741: IF l_debug_mode = 'Y' THEN
4742: pa_debug.g_err_stage:= 'Not a rev plan type';
4771: , PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL
4772: , l_all_amount_types_tbl(j)
4773: , 1
4774: , sysdate
4775: , fnd_global.user_id
4776: , sysdate
4777: , fnd_global.user_id
4778: , fnd_global.login_id );
4779:
4773: , 1
4774: , sysdate
4775: , fnd_global.user_id
4776: , sysdate
4777: , fnd_global.user_id
4778: , fnd_global.login_id );
4779:
4780: IF l_debug_mode = 'Y' THEN
4781: FOR j IN l_all_amount_types_tbl.FIRST..l_all_amount_types_tbl.LAST LOOP
4774: , sysdate
4775: , fnd_global.user_id
4776: , sysdate
4777: , fnd_global.user_id
4778: , fnd_global.login_id );
4779:
4780: IF l_debug_mode = 'Y' THEN
4781: FOR j IN l_all_amount_types_tbl.FIRST..l_all_amount_types_tbl.LAST LOOP
4782: pa_debug.g_err_stage:= 'Inserting all seed values ' || l_all_amount_types_tbl(j);
4921: ,option_type
4922: ,amount_type_code
4923: ,1
4924: ,sysdate
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
4923: ,1
4924: ,sysdate
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 ;
4924: ,sysdate
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:
5058: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST
5059: ,p_add_cost_amt_types_tbl(j)
5060: ,1
5061: ,sysdate
5062: ,fnd_global.user_id
5063: ,sysdate
5064: ,fnd_global.user_id
5065: ,fnd_global.user_id );
5066: END IF;
5060: ,1
5061: ,sysdate
5062: ,fnd_global.user_id
5063: ,sysdate
5064: ,fnd_global.user_id
5065: ,fnd_global.user_id );
5066: END IF;
5067:
5068: IF p_del_cost_amt_types_tbl.COUNT > 0 THEN
5061: ,sysdate
5062: ,fnd_global.user_id
5063: ,sysdate
5064: ,fnd_global.user_id
5065: ,fnd_global.user_id );
5066: END IF;
5067:
5068: IF p_del_cost_amt_types_tbl.COUNT > 0 THEN
5069:
5105: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE
5106: ,p_add_rev_amt_types_tbl(j)
5107: ,1
5108: ,sysdate
5109: ,fnd_global.user_id
5110: ,sysdate
5111: ,fnd_global.user_id
5112: ,fnd_global.user_id );
5113: END IF;
5107: ,1
5108: ,sysdate
5109: ,fnd_global.user_id
5110: ,sysdate
5111: ,fnd_global.user_id
5112: ,fnd_global.user_id );
5113: END IF;
5114:
5115: IF p_del_rev_amt_types_tbl.COUNT > 0 THEN
5108: ,sysdate
5109: ,fnd_global.user_id
5110: ,sysdate
5111: ,fnd_global.user_id
5112: ,fnd_global.user_id );
5113: END IF;
5114:
5115: IF p_del_rev_amt_types_tbl.COUNT > 0 THEN
5116: IF l_debug_mode = 'Y' THEN
5157: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL
5158: ,p_add_all_amt_types_tbl(j)
5159: ,1
5160: ,sysdate
5161: ,fnd_global.user_id
5162: ,sysdate
5163: ,fnd_global.user_id
5164: ,fnd_global.user_id );
5165:
5159: ,1
5160: ,sysdate
5161: ,fnd_global.user_id
5162: ,sysdate
5163: ,fnd_global.user_id
5164: ,fnd_global.user_id );
5165:
5166:
5167: END IF;
5160: ,sysdate
5161: ,fnd_global.user_id
5162: ,sysdate
5163: ,fnd_global.user_id
5164: ,fnd_global.user_id );
5165:
5166:
5167: END IF;
5168: