DBA Data[Home] [Help]

APPS.PA_FP_CONTROL_ITEMS_IMPACT_PKG dependencies on PA_FP_CONSTANTS_PKG

Line 324: ( p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY OR

320: END IF;
321: END IF;
322:
323: IF l_no_of_app_plan_types = 1 AND
324: ( p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY OR
325: p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY OR
326: p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME ) AND
327: (p_button_pressed_from_page = 'REVENUE_EDIT' OR
328: p_button_pressed_from_page = 'ALL_EDIT' OR

Line 325: p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY OR

321: END IF;
322:
323: IF l_no_of_app_plan_types = 1 AND
324: ( p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY OR
325: p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY OR
326: p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME ) AND
327: (p_button_pressed_from_page = 'REVENUE_EDIT' OR
328: p_button_pressed_from_page = 'ALL_EDIT' OR
329: p_button_pressed_from_page = 'COST_EDIT' OR

Line 326: p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME ) AND

322:
323: IF l_no_of_app_plan_types = 1 AND
324: ( p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY OR
325: p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY OR
326: p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME ) AND
327: (p_button_pressed_from_page = 'REVENUE_EDIT' OR
328: p_button_pressed_from_page = 'ALL_EDIT' OR
329: p_button_pressed_from_page = 'COST_EDIT' OR
330: NVL(p_agreement_id,0) <> NVL(est_amt_rec.agreement_id,0) OR

Line 338: IF p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY THEN

334: NVL(l_est_equip_qty,0) <> NVL(est_amt_rec.est_equipment_quantity,0) OR
335: NVL(p_est_proj_revenue,0) <> NVL(est_amt_rec.est_project_revenue,0))THEN
336:
337:
338: IF p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY THEN
339: l_fin_plan_type_id := p_fin_plan_type_id_cost;
340: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST;
341: ELSIF p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY THEN
342: l_fin_plan_type_id := p_fin_plan_type_id_rev;

Line 340: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST;

336:
337:
338: IF p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY THEN
339: l_fin_plan_type_id := p_fin_plan_type_id_cost;
340: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST;
341: ELSIF p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY THEN
342: l_fin_plan_type_id := p_fin_plan_type_id_rev;
343: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE;
344: ELSIF p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN

Line 341: ELSIF p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY THEN

337:
338: IF p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY THEN
339: l_fin_plan_type_id := p_fin_plan_type_id_cost;
340: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST;
341: ELSIF p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY THEN
342: l_fin_plan_type_id := p_fin_plan_type_id_rev;
343: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE;
344: ELSIF p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN
345: l_fin_plan_type_id := p_fin_plan_type_id_all;

Line 343: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE;

339: l_fin_plan_type_id := p_fin_plan_type_id_cost;
340: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST;
341: ELSIF p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY THEN
342: l_fin_plan_type_id := p_fin_plan_type_id_rev;
343: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE;
344: ELSIF p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN
345: l_fin_plan_type_id := p_fin_plan_type_id_all;
346: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL;
347: END IF;

Line 344: ELSIF p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN

340: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST;
341: ELSIF p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY THEN
342: l_fin_plan_type_id := p_fin_plan_type_id_rev;
343: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE;
344: ELSIF p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN
345: l_fin_plan_type_id := p_fin_plan_type_id_all;
346: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL;
347: END IF;
348: /* ELSIF p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP THEN

Line 346: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL;

342: l_fin_plan_type_id := p_fin_plan_type_id_rev;
343: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE;
344: ELSIF p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN
345: l_fin_plan_type_id := p_fin_plan_type_id_all;
346: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL;
347: END IF;
348: /* ELSIF p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP THEN
349: l_fin_plan_type_id := p_fin_plan_type_id_all;
350: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL; */

Line 348: /* ELSIF p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP THEN

344: ELSIF p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN
345: l_fin_plan_type_id := p_fin_plan_type_id_all;
346: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL;
347: END IF;
348: /* ELSIF p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP THEN
349: l_fin_plan_type_id := p_fin_plan_type_id_all;
350: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL; */
351:
352: IF l_element_type IN (PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL) AND

Line 350: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL; */

346: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL;
347: END IF;
348: /* ELSIF p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP THEN
349: l_fin_plan_type_id := p_fin_plan_type_id_all;
350: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL; */
351:
352: IF l_element_type IN (PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL) AND
353: p_agreement_id IS NULL THEN
354:

Line 352: IF l_element_type IN (PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL) AND

348: /* ELSIF p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP THEN
349: l_fin_plan_type_id := p_fin_plan_type_id_all;
350: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL; */
351:
352: IF l_element_type IN (PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL) AND
353: p_agreement_id IS NULL THEN
354:
355: Pa_Fp_Control_Items_Utils.IsValidAgreement(
356: p_project_id => p_project_id,

Line 422: p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP THEN

418: END IF;
419: RETURN;
420: END IF;
421: ELSIF l_no_of_app_plan_types = 2 OR
422: p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP THEN
423:
424: /* Calling the create api with the proper version type */
425: IF p_button_pressed_from_page = 'COST_EDIT' OR
426: NVL(p_est_proj_raw_cost,0) <> NVL(est_amt_rec.est_project_raw_cost,0) OR

Line 436: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST;

432: l_fin_plan_type_id := p_fin_plan_type_id_cost;
433: ELSE
434: l_fin_plan_type_id := p_fin_plan_type_id_all;
435: END IF;
436: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST;
437:
438: Maintain_Plan_Version(
439: p_project_id => p_project_id,
440: p_ci_id => p_ci_id,

Line 490: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE;

486: ELSE
487: l_fin_plan_type_id := p_fin_plan_type_id_all;
488: END IF;
489:
490: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE;
491:
492: IF p_agreement_id IS NULL THEN
493:
494: Pa_Fp_Control_Items_Utils.IsValidAgreement(