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 4289: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,

4285: /* dbora - FP M - New function to check for valid status
4286: smullapp-Changed NON_APP_STATUSES_EXIST to add p_fin_plan_type_id as input parameter(bug 3899756)
4287: */
4288: FUNCTION NON_APP_STATUSES_EXIST (
4289: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,
4290: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,
4291: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE)
4292: RETURN VARCHAR2
4293: IS

Line 4290: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,

4286: smullapp-Changed NON_APP_STATUSES_EXIST to add p_fin_plan_type_id as input parameter(bug 3899756)
4287: */
4288: FUNCTION NON_APP_STATUSES_EXIST (
4289: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,
4290: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,
4291: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE)
4292: RETURN VARCHAR2
4293: IS
4294: l_return VARCHAR2(1);

Line 4291: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE)

4287: */
4288: FUNCTION NON_APP_STATUSES_EXIST (
4289: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,
4290: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,
4291: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE)
4292: RETURN VARCHAR2
4293: IS
4294: l_return VARCHAR2(1);
4295:

Line 4315: FROM pa_pt_co_impl_statuses ptco,

4311: INTO l_return
4312: FROM dual
4313: WHERE
4314: EXISTS (SELECT 'X'
4315: FROM pa_pt_co_impl_statuses ptco,
4316: pa_ci_statuses_v pcs
4317: WHERE ptco.ci_type_id = p_ci_type_id
4318: AND ptco.version_type = p_version_type
4319: AND ptco.ci_type_id = pcs.ci_type_id

Line 4339: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE)

4335:
4336: /* FP M - dbora - To return the CI type
4337: */
4338: FUNCTION GET_CI_ALLOWED_IMPACTS(
4339: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE)
4340: RETURN VARCHAR2
4341:
4342: IS
4343: l_cost_impact_flag VARCHAR2(30);

Line 6043: -- change order versions, there would be two records in pa_pt_co_impl_statuses

6039: -- Please note that this function is called for Include Change Doc Page PLSql Apis
6040: -- View included Change Doc PlSql APIs, VO Queries, Change Doc Merge Apis
6041:
6042: -- 07-Jun-2004 Raja Added new input parameter p_pt_ct_version_type b/c for 'ALL'
6043: -- change order versions, there would be two records in pa_pt_co_impl_statuses
6044: -- table and so the view returns PA_FP_ELIGIBLE_CI_V two records.
6045: -- How to avoid double count here? If ci_version is 'ALL' and target version is
6046: -- also 'ALL', then compute quantity only if p_pt_ct_version_type is 'COST' as
6047: -- in this case Quantity gets merged along with cost amounts

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

6053: p_version_type IN pa_budget_versions.version_type%TYPE, -- This is the CI version type
6054: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
6055: p_ci_version_id IN pa_budget_versions.budget_version_id%TYPE,
6056: p_labor_qty IN pa_budget_versions.labor_quantity%TYPE DEFAULT NULL, -- CI qty
6057: p_pt_ct_version_type IN pa_pt_co_impl_statuses.version_type%TYPE DEFAULT NULL
6058: )
6059: RETURN NUMBER
6060: IS
6061: l_debug_mode VARCHAR2(30);

Line 6351: -- change order versions, there would be two records in pa_pt_co_impl_statuses

6347: -- Please note that this function is called for Include Change Doc Page PLSql Apis
6348: -- View included Change Doc PlSql APIs, VO Queries, Change Doc Merge Apis
6349:
6350: -- 07-Jun-2004 Raja Added new input parameter p_pt_ct_version_type b/c for 'ALL'
6351: -- change order versions, there would be two records in pa_pt_co_impl_statuses
6352: -- table and so the view returns PA_FP_ELIGIBLE_CI_V two records.
6353: -- How to avoid double count here? If ci_version is 'ALL' and target version is
6354: -- also 'ALL', then compute quantity only if p_pt_ct_version_type is 'COST' as
6355: -- in this case Quantity gets merged along with cost amounts

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

6363: p_version_type IN pa_budget_versions.version_type%TYPE, -- This is the CI version type
6364: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
6365: p_ci_version_id IN pa_budget_versions.budget_version_id%TYPE,
6366: p_equip_qty IN pa_budget_versions.equipment_quantity%TYPE DEFAULT NULL, -- CI qty
6367: p_pt_ct_version_type IN pa_pt_co_impl_statuses.version_type%TYPE DEFAULT NULL
6368: )
6369: RETURN NUMBER
6370: IS
6371: l_debug_mode VARCHAR2(30);

Line 6661: -- change order versions, there would be two records in pa_pt_co_impl_statuses

6657: -- Please note that this function is called for Include Change Doc Page PLSql Apis
6658: -- View included Change Doc PlSql APIs, VO Queries, Change Doc Merge Apis
6659:
6660: -- 07-Jun-2004 Raja Added new input parameter p_pt_ct_version_type b/c for 'ALL'
6661: -- change order versions, there would be two records in pa_pt_co_impl_statuses
6662: -- table and so the view returns PA_FP_ELIGIBLE_CI_V two records. To avoid double
6663: -- count revenue amount would be returned only if p_pt_ct_version_type is 'REVENUE'
6664:
6665: -- Note: In some cases, p_pt_ct_version_type is passed as null in this case

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

6670: p_version_type IN pa_budget_versions.version_type%TYPE, -- version type of CI
6671: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
6672: p_ci_version_id IN pa_budget_versions.budget_version_id%TYPE,
6673: p_revenue IN pa_budget_versions.total_project_revenue%TYPE DEFAULT NULL,
6674: p_pt_ct_version_type IN pa_pt_co_impl_statuses.version_type%TYPE DEFAULT NULL
6675: )
6676: RETURN NUMBER
6677: IS
6678: l_return_revenue NUMBER :=0;

Line 6874: -- change order versions, there would be two records in pa_pt_co_impl_statuses

6870: -- Please note that this function is called for Include Change Doc Page PLSql Apis
6871: -- View included Change Doc PlSql APIs, VO Queries, Change Doc Merge Apis
6872:
6873: -- 07-Jun-2004 Raja Added new input parameter p_pt_ct_version_type b/c for 'ALL'
6874: -- change order versions, there would be two records in pa_pt_co_impl_statuses
6875: -- table and so the view returns PA_FP_ELIGIBLE_CI_V two records. To avoid double
6876: -- count cost amount would be returned only if p_pt_ct_version_type is 'COST'
6877:
6878: -- Note: In some cases, p_pt_ct_version_type is passed as null in this case

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

6883: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
6884: p_ci_version_id IN pa_budget_versions.budget_version_id%TYPE,
6885: p_raw_cost IN pa_budget_versions.total_project_raw_cost%TYPE DEFAULT NULL,
6886: p_burdened_cost IN pa_budget_versions.total_project_burdened_cost%TYPE DEFAULT NULL,
6887: p_pt_ct_version_type IN pa_pt_co_impl_statuses.version_type%TYPE DEFAULT NULL
6888: )
6889: RETURN NUMBER
6890: IS
6891: l_return_cost NUMBER :=0;

Line 8327: from pa_pt_co_impl_statuses

8323:
8324: BEGIN
8325: select impl_default_flag
8326: INTO x_select_flag_tbl(i)
8327: from pa_pt_co_impl_statuses
8328: WHERE fin_plan_type_id = c_plan_type_rec.fin_plan_type_id
8329: AND ci_type_id = l_ci_type_id
8330: AND ROWNUM = 1 ;
8331:

Line 8647: CURSOR c_implementable_status(c_status_code IN pa_pt_co_impl_statuses.status_code%TYPE,

8643: ,x_msg_data OUT NOCOPY VARCHAR2 -- Indicates the error occurred --File.Sql.39 bug 4440895
8644: ,X_msg_count OUT NOCOPY NUMBER) -- Indicates the number of error messages --File.Sql.39 bug 4440895
8645: IS
8646:
8647: CURSOR c_implementable_status(c_status_code IN pa_pt_co_impl_statuses.status_code%TYPE,
8648: c_impact_type_code IN pa_pt_co_impl_statuses.version_type%TYPE,
8649: c_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE) IS
8650: SELECT 'Y'
8651: FROM dual

Line 8648: c_impact_type_code IN pa_pt_co_impl_statuses.version_type%TYPE,

8644: ,X_msg_count OUT NOCOPY NUMBER) -- Indicates the number of error messages --File.Sql.39 bug 4440895
8645: IS
8646:
8647: CURSOR c_implementable_status(c_status_code IN pa_pt_co_impl_statuses.status_code%TYPE,
8648: c_impact_type_code IN pa_pt_co_impl_statuses.version_type%TYPE,
8649: c_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE) IS
8650: SELECT 'Y'
8651: FROM dual
8652: WHERE

Line 8649: c_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE) IS

8645: IS
8646:
8647: CURSOR c_implementable_status(c_status_code IN pa_pt_co_impl_statuses.status_code%TYPE,
8648: c_impact_type_code IN pa_pt_co_impl_statuses.version_type%TYPE,
8649: c_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE) IS
8650: SELECT 'Y'
8651: FROM dual
8652: WHERE
8653: EXISTS (SELECT 'X'

Line 8654: FROM pa_pt_co_impl_statuses popt

8650: SELECT 'Y'
8651: FROM dual
8652: WHERE
8653: EXISTS (SELECT 'X'
8654: FROM pa_pt_co_impl_statuses popt
8655: WHERE popt.status_code =c_status_code
8656: AND popt.version_type = c_impact_type_code
8657: AND popt.fin_plan_type_id = p_fin_plan_type_id
8658: AND popt.ci_type_id = c_ci_type_id);

Line 9256: -- pa_pt_co_impl_statuses, meaning that there exists a ci type whose change

9252:
9253: END GET_IMPL_DETAILS;
9254:
9255: -- This function returns either Y or N. If the user status code passed exists in
9256: -- pa_pt_co_impl_statuses, meaning that there exists a ci type whose change
9257: -- documents can be implemented/included into the working versions of a
9258: -- plan type, then Y is returned. N is returned otherwise
9259: FUNCTION is_user_status_implementable(p_status_code IN pa_control_items.status_code%TYPE)
9260: RETURN VARCHAR2

Line 9270: FROM pa_pt_co_impl_statuses

9266: SELECT 'Y'
9267: INTO l_status_implementable
9268: FROM DUAL
9269: WHERE EXISTS (SELECT 'X'
9270: FROM pa_pt_co_impl_statuses
9271: WHERE status_code=p_status_code);
9272: EXCEPTION
9273: WHEN NO_DATA_FOUND THEN
9274: l_status_implementable:='N';

Line 10215: FROM pa_pt_co_impl_statuses

10211: SELECT 'N'
10212: INTO is_delete_allowed
10213: FROM DUAL
10214: WHERE EXISTS (SELECT 'X'
10215: FROM pa_pt_co_impl_statuses
10216: WHERE ci_type_id = p_ci_type_id);
10217: EXCEPTION
10218: WHEN NO_DATA_FOUND THEN
10219: RETURN is_delete_allowed;