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

4236: /* dbora - FP M - New function to check for valid status
4237: smullapp-Changed NON_APP_STATUSES_EXIST to add p_fin_plan_type_id as input parameter(bug 3899756)
4238: */
4239: FUNCTION NON_APP_STATUSES_EXIST (
4240: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,
4241: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,
4242: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE)
4243: RETURN VARCHAR2
4244: IS

Line 4241: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,

4237: smullapp-Changed NON_APP_STATUSES_EXIST to add p_fin_plan_type_id as input parameter(bug 3899756)
4238: */
4239: FUNCTION NON_APP_STATUSES_EXIST (
4240: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,
4241: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,
4242: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE)
4243: RETURN VARCHAR2
4244: IS
4245: l_return VARCHAR2(1);

Line 4242: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE)

4238: */
4239: FUNCTION NON_APP_STATUSES_EXIST (
4240: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE,
4241: p_version_type IN pa_pt_co_impl_statuses.version_type%TYPE,
4242: p_fin_plan_type_id IN pa_pt_co_impl_statuses.fin_plan_type_id%TYPE)
4243: RETURN VARCHAR2
4244: IS
4245: l_return VARCHAR2(1);
4246:

Line 4266: FROM pa_pt_co_impl_statuses ptco,

4262: INTO l_return
4263: FROM dual
4264: WHERE
4265: EXISTS (SELECT 'X'
4266: FROM pa_pt_co_impl_statuses ptco,
4267: pa_ci_statuses_v pcs
4268: WHERE ptco.ci_type_id = p_ci_type_id
4269: AND ptco.version_type = p_version_type
4270: AND ptco.ci_type_id = pcs.ci_type_id

Line 4290: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE)

4286:
4287: /* FP M - dbora - To return the CI type
4288: */
4289: FUNCTION GET_CI_ALLOWED_IMPACTS(
4290: p_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE)
4291: RETURN VARCHAR2
4292:
4293: IS
4294: l_cost_impact_flag VARCHAR2(30);

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

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

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

5997: p_version_type IN pa_budget_versions.version_type%TYPE, -- This is the CI version type
5998: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
5999: p_ci_version_id IN pa_budget_versions.budget_version_id%TYPE,
6000: p_labor_qty IN pa_budget_versions.labor_quantity%TYPE DEFAULT NULL, -- CI qty
6001: p_pt_ct_version_type IN pa_pt_co_impl_statuses.version_type%TYPE DEFAULT NULL
6002: )
6003: RETURN NUMBER
6004: IS
6005: l_debug_mode VARCHAR2(30);

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

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

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

6307: p_version_type IN pa_budget_versions.version_type%TYPE, -- This is the CI version type
6308: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
6309: p_ci_version_id IN pa_budget_versions.budget_version_id%TYPE,
6310: p_equip_qty IN pa_budget_versions.equipment_quantity%TYPE DEFAULT NULL, -- CI qty
6311: p_pt_ct_version_type IN pa_pt_co_impl_statuses.version_type%TYPE DEFAULT NULL
6312: )
6313: RETURN NUMBER
6314: IS
6315: l_debug_mode VARCHAR2(30);

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

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

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

6614: p_version_type IN pa_budget_versions.version_type%TYPE, -- version type of CI
6615: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
6616: p_ci_version_id IN pa_budget_versions.budget_version_id%TYPE,
6617: p_revenue IN pa_budget_versions.total_project_revenue%TYPE DEFAULT NULL,
6618: p_pt_ct_version_type IN pa_pt_co_impl_statuses.version_type%TYPE DEFAULT NULL
6619: )
6620: RETURN NUMBER
6621: IS
6622: l_return_revenue NUMBER :=0;

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

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

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

6814: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
6815: p_ci_version_id IN pa_budget_versions.budget_version_id%TYPE,
6816: p_raw_cost IN pa_budget_versions.total_project_raw_cost%TYPE DEFAULT NULL,
6817: p_burdened_cost IN pa_budget_versions.total_project_burdened_cost%TYPE DEFAULT NULL,
6818: p_pt_ct_version_type IN pa_pt_co_impl_statuses.version_type%TYPE DEFAULT NULL
6819: )
6820: RETURN NUMBER
6821: IS
6822: l_return_cost NUMBER :=0;

Line 8232: from pa_pt_co_impl_statuses

8228:
8229: BEGIN
8230: select impl_default_flag
8231: INTO x_select_flag_tbl(i)
8232: from pa_pt_co_impl_statuses
8233: WHERE fin_plan_type_id = c_plan_type_rec.fin_plan_type_id
8234: AND ci_type_id = l_ci_type_id
8235: AND ROWNUM = 1 ;
8236:

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

8511: ,x_msg_data OUT NOCOPY VARCHAR2 -- Indicates the error occurred --File.Sql.39 bug 4440895
8512: ,X_msg_count OUT NOCOPY NUMBER) -- Indicates the number of error messages --File.Sql.39 bug 4440895
8513: IS
8514:
8515: CURSOR c_implementable_status(c_status_code IN pa_pt_co_impl_statuses.status_code%TYPE,
8516: c_impact_type_code IN pa_pt_co_impl_statuses.version_type%TYPE,
8517: c_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE) IS
8518: SELECT 'Y'
8519: FROM dual

Line 8516: c_impact_type_code IN pa_pt_co_impl_statuses.version_type%TYPE,

8512: ,X_msg_count OUT NOCOPY NUMBER) -- Indicates the number of error messages --File.Sql.39 bug 4440895
8513: IS
8514:
8515: CURSOR c_implementable_status(c_status_code IN pa_pt_co_impl_statuses.status_code%TYPE,
8516: c_impact_type_code IN pa_pt_co_impl_statuses.version_type%TYPE,
8517: c_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE) IS
8518: SELECT 'Y'
8519: FROM dual
8520: WHERE

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

8513: IS
8514:
8515: CURSOR c_implementable_status(c_status_code IN pa_pt_co_impl_statuses.status_code%TYPE,
8516: c_impact_type_code IN pa_pt_co_impl_statuses.version_type%TYPE,
8517: c_ci_type_id IN pa_pt_co_impl_statuses.ci_type_id%TYPE) IS
8518: SELECT 'Y'
8519: FROM dual
8520: WHERE
8521: EXISTS (SELECT 'X'

Line 8522: FROM pa_pt_co_impl_statuses popt

8518: SELECT 'Y'
8519: FROM dual
8520: WHERE
8521: EXISTS (SELECT 'X'
8522: FROM pa_pt_co_impl_statuses popt
8523: WHERE popt.status_code =c_status_code
8524: AND popt.version_type = c_impact_type_code
8525: AND popt.fin_plan_type_id = p_fin_plan_type_id
8526: AND popt.ci_type_id = c_ci_type_id);

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

9094:
9095: END GET_IMPL_DETAILS;
9096:
9097: -- This function returns either Y or N. If the user status code passed exists in
9098: -- pa_pt_co_impl_statuses, meaning that there exists a ci type whose change
9099: -- documents can be implemented/included into the working versions of a
9100: -- plan type, then Y is returned. N is returned otherwise
9101: FUNCTION is_user_status_implementable(p_status_code IN pa_control_items.status_code%TYPE)
9102: RETURN VARCHAR2

Line 9112: FROM pa_pt_co_impl_statuses

9108: SELECT 'Y'
9109: INTO l_status_implementable
9110: FROM DUAL
9111: WHERE EXISTS (SELECT 'X'
9112: FROM pa_pt_co_impl_statuses
9113: WHERE status_code=p_status_code);
9114: EXCEPTION
9115: WHEN NO_DATA_FOUND THEN
9116: l_status_implementable:='N';

Line 10031: FROM pa_pt_co_impl_statuses

10027: SELECT 'N'
10028: INTO is_delete_allowed
10029: FROM DUAL
10030: WHERE EXISTS (SELECT 'X'
10031: FROM pa_pt_co_impl_statuses
10032: WHERE ci_type_id = p_ci_type_id);
10033: EXCEPTION
10034: WHEN NO_DATA_FOUND THEN
10035: RETURN is_delete_allowed;