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_CONTROL_ITEMS_IMPACT_PKG dependencies on PA_FP_CONSTANTS_PKG

Line 328: ( p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY OR

324: END IF;
325: END IF;
326:
327: IF l_no_of_app_plan_types = 1 AND
328: ( p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY OR
329: p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY OR
330: p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME ) AND
331: (p_button_pressed_from_page = 'REVENUE_EDIT' OR
332: p_button_pressed_from_page = 'ALL_EDIT' OR

Line 329: p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY OR

325: END IF;
326:
327: IF l_no_of_app_plan_types = 1 AND
328: ( p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY OR
329: p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY OR
330: p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME ) AND
331: (p_button_pressed_from_page = 'REVENUE_EDIT' OR
332: p_button_pressed_from_page = 'ALL_EDIT' OR
333: p_button_pressed_from_page = 'COST_EDIT' OR

Line 330: p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME ) AND

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

Line 342: IF p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY THEN

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

Line 344: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST;

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

Line 345: ELSIF p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY THEN

341:
342: IF p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY THEN
343: l_fin_plan_type_id := p_fin_plan_type_id_cost;
344: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST;
345: ELSIF p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY THEN
346: l_fin_plan_type_id := p_fin_plan_type_id_rev;
347: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE;
348: ELSIF p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN
349: l_fin_plan_type_id := p_fin_plan_type_id_all;

Line 347: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE;

343: l_fin_plan_type_id := p_fin_plan_type_id_cost;
344: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST;
345: ELSIF p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY THEN
346: l_fin_plan_type_id := p_fin_plan_type_id_rev;
347: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE;
348: ELSIF p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME 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: END IF;

Line 348: ELSIF p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN

344: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST;
345: ELSIF p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY THEN
346: l_fin_plan_type_id := p_fin_plan_type_id_rev;
347: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE;
348: ELSIF p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME 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: END IF;
352: /* ELSIF p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP THEN

Line 350: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL;

346: l_fin_plan_type_id := p_fin_plan_type_id_rev;
347: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE;
348: ELSIF p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME 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: END IF;
352: /* ELSIF p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP THEN
353: l_fin_plan_type_id := p_fin_plan_type_id_all;
354: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL; */

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

348: ELSIF p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME 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: END IF;
352: /* ELSIF p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP THEN
353: l_fin_plan_type_id := p_fin_plan_type_id_all;
354: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL; */
355:
356: IF l_element_type IN (PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL) AND

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

350: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL;
351: END IF;
352: /* ELSIF p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP THEN
353: l_fin_plan_type_id := p_fin_plan_type_id_all;
354: l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL; */
355:
356: IF l_element_type IN (PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL) AND
357: p_agreement_id IS NULL THEN
358:

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

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

Line 426: p_fp_pref_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP THEN

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

Line 441: --l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST;

437: ELSE
438: l_fin_plan_type_id := p_fin_plan_type_id_all;
439: END IF;
440: --Bug 5845142. CI Cost impacts can be of type ALL too
441: --l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST;
442: SELECT DECODE(fin_plan_preference_code,
443: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL,
444: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST)
445: INTO l_element_type

Line 443: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL,

439: END IF;
440: --Bug 5845142. CI Cost impacts can be of type ALL too
441: --l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST;
442: SELECT DECODE(fin_plan_preference_code,
443: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL,
444: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST)
445: INTO l_element_type
446: FROM pa_proj_fp_options
447: WHERE project_id=p_project_id

Line 444: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST)

440: --Bug 5845142. CI Cost impacts can be of type ALL too
441: --l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST;
442: SELECT DECODE(fin_plan_preference_code,
443: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL,
444: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST)
445: INTO l_element_type
446: FROM pa_proj_fp_options
447: WHERE project_id=p_project_id
448: AND fin_plan_type_id=l_fin_plan_type_id

Line 505: --l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE;

501: END IF;
502:
503:
504: /* bug 7584903 impacts can be of type ALL too */
505: --l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE;
506:
507: SELECT DECODE(fin_plan_preference_code,
508: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL,
509: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE)

Line 508: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL,

504: /* bug 7584903 impacts can be of type ALL too */
505: --l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE;
506:
507: SELECT DECODE(fin_plan_preference_code,
508: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL,
509: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE)
510: INTO l_element_type
511: FROM pa_proj_fp_options
512: WHERE project_id=p_project_id

Line 509: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE)

505: --l_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE;
506:
507: SELECT DECODE(fin_plan_preference_code,
508: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL,
509: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE)
510: INTO l_element_type
511: FROM pa_proj_fp_options
512: WHERE project_id=p_project_id
513: AND fin_plan_type_id=l_fin_plan_type_id