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_UTILS dependencies on PA_PT_CO_IMPL_STATUSES

Line 263: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,

259: /* dbora - FP M New functions to check for CI
260: smullapp-Changed NON_APP_STATUSES_EXIST to add p_fin_plan_type_id as input parameter(bug 3899756)
261: */
262: FUNCTION NON_APP_STATUSES_EXIST (
263: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,
264: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,
265: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE)
266: RETURN VARCHAR2;
267:

Line 264: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,

260: smullapp-Changed NON_APP_STATUSES_EXIST to add p_fin_plan_type_id as input parameter(bug 3899756)
261: */
262: FUNCTION NON_APP_STATUSES_EXIST (
263: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,
264: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,
265: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE)
266: RETURN VARCHAR2;
267:
268: FUNCTION GET_CI_ALLOWED_IMPACTS (

Line 265: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE)

261: */
262: FUNCTION NON_APP_STATUSES_EXIST (
263: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,
264: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,
265: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE)
266: RETURN VARCHAR2;
267:
268: FUNCTION GET_CI_ALLOWED_IMPACTS (
269: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE)

Line 269: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE)

265: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE)
266: RETURN VARCHAR2;
267:
268: FUNCTION GET_CI_ALLOWED_IMPACTS (
269: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE)
270: RETURN VARCHAR2;
271:
272: -- This procedure will reutrn data for populating Plan Summary Region
273: PROCEDURE get_summary_data

Line 302: p_pt_ct_version_type IN pa_pt_co_impl_statuses.version_type%TYPE DEFAULT NULL

298: p_version_type IN pa_budget_versions.version_type%TYPE, -- This is the CI version type
299: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
300: p_ci_version_id IN pa_budget_versions.budget_version_id%TYPE,
301: p_labor_qty IN pa_budget_versions.labor_quantity%TYPE DEFAULT NULL, -- CI qty
302: p_pt_ct_version_type IN pa_pt_co_impl_statuses.version_type%TYPE DEFAULT NULL
303: )
304: RETURN NUMBER;
305:
306: FUNCTION get_equip_qty_partial(

Line 311: p_pt_ct_version_type IN pa_pt_co_impl_statuses.version_type%TYPE DEFAULT NULL

307: p_version_type IN pa_budget_versions.version_type%TYPE, -- This is the CI version type
308: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
309: p_ci_version_id IN pa_budget_versions.budget_version_id%TYPE,
310: p_equip_qty IN pa_budget_versions.equipment_quantity%TYPE DEFAULT NULL, -- CI qty
311: p_pt_ct_version_type IN pa_pt_co_impl_statuses.version_type%TYPE DEFAULT NULL
312: )
313: RETURN NUMBER;
314:
315: FUNCTION get_pc_revenue_partial (

Line 320: p_pt_ct_version_type IN pa_pt_co_impl_statuses.version_type%TYPE DEFAULT NULL

316: p_version_type IN pa_budget_versions.version_type%TYPE, -- This is the CI version type
317: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
318: p_ci_version_id IN pa_budget_versions.budget_version_id%TYPE,
319: p_revenue IN pa_budget_versions.total_project_revenue%TYPE DEFAULT NULL,
320: p_pt_ct_version_type IN pa_pt_co_impl_statuses.version_type%TYPE DEFAULT NULL
321: )
322: RETURN NUMBER;
323:
324: FUNCTION get_pc_cost (

Line 330: p_pt_ct_version_type IN pa_pt_co_impl_statuses.version_type%TYPE DEFAULT NULL

326: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
327: p_ci_version_id IN pa_budget_versions.budget_version_id%TYPE,
328: p_raw_cost IN pa_budget_versions.total_project_raw_cost%TYPE DEFAULT NULL ,
329: p_burdened_cost IN pa_budget_versions.total_project_burdened_cost%TYPE DEFAULT NULL,
330: p_pt_ct_version_type IN pa_pt_co_impl_statuses.version_type%TYPE DEFAULT NULL
331: )
332: RETURN NUMBER;
333:
334: PROCEDURE get_not_included

Line 431: --This function returns either Y or N. If the user status code passed exists in pa_pt_co_impl_statuses, meaning

427: ,x_return_status OUT NOCOPY VARCHAR2 -- Indicates the exit status of the API --File.Sql.39 bug 4440895
428: ,x_msg_data OUT NOCOPY VARCHAR2 -- Indicates the error occurred --File.Sql.39 bug 4440895
429: ,X_msg_count OUT NOCOPY NUMBER); -- Indicates the number of error messages --File.Sql.39 bug 4440895
430:
431: --This function returns either Y or N. If the user status code passed exists in pa_pt_co_impl_statuses, meaning
432: --that there exists a ci type whose change documents can be implemented/included into the working versions of a
433: --plan type, then Y is returned. N is returned otherwise
434: FUNCTION is_user_status_implementable(p_status_code IN pa_control_items.status_code%TYPE)
435: RETURN VARCHAR2 ;