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_FP_MERGED_CTRL_ITEMS

Line 3399: c_version_type pa_fp_merged_ctrl_items.version_type%TYPE)

3395: l_module_name VARCHAR2(100) := 'pa.plsql.Pa_Fp_Control_Items_Utils';
3396:
3397: CURSOR c_upd_impact_val_csr
3398: (c_ci_id pa_control_items.ci_id%TYPE,
3399: c_version_type pa_fp_merged_ctrl_items.version_type%TYPE)
3400: IS
3401: SELECT 'Y'
3402: FROM pa_fp_merged_ctrl_items
3403: WHERE ci_id =c_ci_id

Line 3402: FROM pa_fp_merged_ctrl_items

3398: (c_ci_id pa_control_items.ci_id%TYPE,
3399: c_version_type pa_fp_merged_ctrl_items.version_type%TYPE)
3400: IS
3401: SELECT 'Y'
3402: FROM pa_fp_merged_ctrl_items
3403: WHERE ci_id =c_ci_id
3404: AND project_id=p_project_id
3405: AND plan_version_id=p_target_version_id
3406: AND ci_plan_version_id=NVL(p_source_version_id,ci_plan_version_id)

Line 4564: c_change_documents_current should rely on inclusion_method_code in pa_fp_merged_ctrl_items.

4560: -- AND pbv.budget_status_code in ('S','W'); -- Bug#3815378
4561:
4562: /* Bug - 3882985.
4563: Cursor c_change_documents_current is commented out below and re-written.
4564: c_change_documents_current should rely on inclusion_method_code in pa_fp_merged_ctrl_items.
4565: Basically All records having inclusion_method_code as (MANUAL,AUTOMATIC) should
4566: be considered while deriving Amounts/Quantities for the Current Working Version.
4567: We should NOT use a 'not exists' clause on change documents that have been already
4568: included in the current baseline version(as it was done earlier).

Line 4595: from pa_fp_merged_ctrl_items merge,

4591: nvl(sum(decode(c_margin_derived_from_code,
4592: 'B',nvl(merge.impl_proj_burdened_cost,0),
4593: nvl(merge.impl_proj_raw_cost,0))),0) as cost,
4594: nvl(sum(nvl(merge.impl_proj_revenue,0)),0)
4595: from pa_fp_merged_ctrl_items merge,
4596: pa_budget_versions pbv
4597: where pbv.project_id = c_project_id
4598: and pbv.fin_plan_type_id in (c_ac_fin_plan_type_id, c_ar_fin_plan_type_id)
4599: and pbv.current_working_flag = 'Y'

Line 4606: from pa_fp_merged_ctrl_items merge1, pa_budget_versions pbv1

4602: and pbv.ci_id is null
4603: -- and pbv.budget_status_code in ('S','W') -- Bug#3815378
4604: -- Added by Raja, filter all the ci versions included/copied in current baseline version
4605: and not exists(select 1
4606: from pa_fp_merged_ctrl_items merge1, pa_budget_versions pbv1
4607: where pbv1.project_id = c_project_id
4608: and pbv1.fin_plan_type_id in (c_ac_fin_plan_type_id,
4609: c_ar_fin_plan_type_id)
4610: and pbv1.budget_status_code = 'B'

Line 4639: from pa_fp_merged_ctrl_items merge,

4635: nvl(sum(decode(c_margin_derived_from_code,
4636: 'B',nvl(merge.impl_proj_burdened_cost,0),
4637: nvl(merge.impl_proj_raw_cost,0))),0) as cost,
4638: nvl(sum(nvl(merge.impl_proj_revenue,0)),0)
4639: from pa_fp_merged_ctrl_items merge,
4640: pa_budget_versions pbv
4641: where pbv.project_id = c_project_id
4642: and pbv.fin_plan_type_id in (c_ac_fin_plan_type_id, c_ar_fin_plan_type_id)
4643: and pbv.current_working_flag = 'Y'

Line 4653: c_change_documents_prior should rely on inclusion_method_code in pa_fp_merged_ctrl_items.

4649:
4650:
4651: /* Bug - 3882985.
4652: Cursor c_change_documents_prior is modified below.
4653: c_change_documents_prior should rely on inclusion_method_code in pa_fp_merged_ctrl_items.
4654: Basically All records having inclusion_method_code as (COPIED - for Current Baseline) should
4655: be considered while deriving Amounts/Quantities for the Prior Baselined Versions
4656: */
4657: CURSOR c_change_documents_prior

Line 4681: from pa_fp_merged_ctrl_items merge,

4677: nvl(sum(decode(c_margin_derived_from_code,'B'
4678: ,nvl(merge.impl_proj_burdened_cost,0)
4679: ,nvl(merge.impl_proj_raw_cost,0))),0) as cost,
4680: nvl(sum(nvl(merge.impl_proj_revenue,0)),0)
4681: from pa_fp_merged_ctrl_items merge,
4682: pa_budget_versions pbv
4683: where merge.plan_version_id = pbv.budget_version_id
4684: and pbv.fin_plan_type_id in (c_ac_fin_plan_type_id, c_ar_fin_plan_type_id)
4685: and pbv.current_flag = 'Y'

Line 4693: from pa_fp_merged_ctrl_items merge1, pa_budget_versions pbv1

4689: and pbv.budget_status_code = 'B'
4690: and merge.inclusion_method_code = 'COPIED' -- Bug 3882985
4691: /* Raja filter all the change orders that have been included/copied in the original baseline version */
4692: and not exists(select 1
4693: from pa_fp_merged_ctrl_items merge1, pa_budget_versions pbv1
4694: where pbv1.project_id = c_project_id
4695: and pbv1.fin_plan_type_id in (c_ac_fin_plan_type_id,
4696: c_ar_fin_plan_type_id)
4697: and pbv1.current_original_flag = 'Y'

Line 4774: from pa_fp_merged_ctrl_items merge1, pa_budget_versions pbv1

4770: where pfca.project_id = c_project_id
4771: and pfca.project_system_status_code = c_system_status_code
4772: and pfca.ci_version_type in ('COST', 'ALL')
4773: and not exists(select 1
4774: from pa_fp_merged_ctrl_items merge1, pa_budget_versions pbv1
4775: where merge1.project_id = c_project_id
4776: and merge1.ci_id = pfca.ci_id
4777: and merge1.ci_plan_version_id = pfca.ci_version_id
4778: and merge1.version_type = 'COST'

Line 4839: from pa_fp_merged_ctrl_items merge1, pa_budget_versions pbv1

4835: and pfca.project_system_status_code = c_system_status_code
4836: and pfca.ci_version_type in ('REVENUE', 'ALL')
4837: and (pfca.REV_PARTIALLY_IMPL_FLAG = 'Y' OR
4838: not exists(select 1
4839: from pa_fp_merged_ctrl_items merge1, pa_budget_versions pbv1
4840: where merge1.project_id = c_project_id
4841: and merge1.ci_id = pfca.ci_id
4842: and merge1.ci_plan_version_id = pfca.ci_version_id
4843: and merge1.version_type = 'REVENUE'

Line 6103: FROM PA_FP_MERGED_CTRL_ITEMS

6099: SELECT 'Y'
6100: INTO l_impl_qty_exists
6101: FROM DUAL
6102: WHERE EXISTS (SELECT 1
6103: FROM PA_FP_MERGED_CTRL_ITEMS
6104: WHERE CI_PLAN_VERSION_ID = p_ci_version_id
6105: AND PLAN_VERSION_ID = p_budget_version_id
6106: AND VERSION_TYPE = 'COST');
6107: EXCEPTION

Line 6138: FROM PA_FP_MERGED_CTRL_ITEMS A

6134: SELECT 'Y'
6135: INTO l_impl_qty_exists
6136: FROM DUAL
6137: WHERE EXISTS (SELECT 1
6138: FROM PA_FP_MERGED_CTRL_ITEMS A
6139: WHERE A.CI_PLAN_VERSION_ID = P_CI_VERSION_ID
6140: AND A.PLAN_VERSION_ID = P_BUDGET_VERSION_ID
6141: AND A.VERSION_TYPE = 'REVENUE');
6142: EXCEPTION

Line 6153: FROM PA_FP_MERGED_CTRL_ITEMS A , PA_BUDGET_VERSIONS B

6149: IF l_impl_qty_exists = 'Y' THEN
6150: BEGIN
6151: SELECT NVL(B.REV_PARTIALLY_IMPL_FLAG,'N') , A.IMPL_QUANTITY
6152: INTO l_revenue_partial_flag, l_partial_quantity
6153: FROM PA_FP_MERGED_CTRL_ITEMS A , PA_BUDGET_VERSIONS B
6154: WHERE A.CI_PLAN_VERSION_ID = p_ci_version_id
6155: AND A.PLAN_VERSION_ID = p_budget_version_id
6156: AND A.VERSION_TYPE = 'REVENUE'
6157: AND B.BUDGET_VERSION_ID = A.CI_PLAN_VERSION_ID;

Line 6217: FROM PA_FP_MERGED_CTRL_ITEMS

6213: SELECT 'Y'
6214: INTO l_impl_qty_exists
6215: FROM DUAL
6216: WHERE EXISTS (SELECT 1
6217: FROM PA_FP_MERGED_CTRL_ITEMS
6218: WHERE CI_PLAN_VERSION_ID = p_ci_version_id
6219: AND PLAN_VERSION_ID = p_budget_version_id
6220: AND VERSION_TYPE = 'COST');
6221: EXCEPTION

Line 6250: FROM PA_FP_MERGED_CTRL_ITEMS A

6246: SELECT 'Y'
6247: INTO l_impl_qty_exists
6248: FROM DUAL
6249: WHERE EXISTS (SELECT 1
6250: FROM PA_FP_MERGED_CTRL_ITEMS A
6251: WHERE A.CI_PLAN_VERSION_ID = P_CI_VERSION_ID
6252: AND A.PLAN_VERSION_ID = P_BUDGET_VERSION_ID
6253: AND A.VERSION_TYPE = 'REVENUE');
6254: EXCEPTION

Line 6265: FROM PA_FP_MERGED_CTRL_ITEMS A , PA_BUDGET_VERSIONS B

6261: IF l_impl_qty_exists = 'Y' THEN
6262: BEGIN
6263: SELECT NVL(B.REV_PARTIALLY_IMPL_FLAG,'N') , A.IMPL_QUANTITY
6264: INTO l_revenue_partial_flag, l_partial_quantity
6265: FROM PA_FP_MERGED_CTRL_ITEMS A , PA_BUDGET_VERSIONS B
6266: WHERE A.CI_PLAN_VERSION_ID = p_ci_version_id
6267: AND A.PLAN_VERSION_ID = p_budget_version_id
6268: AND A.VERSION_TYPE = 'REVENUE'
6269: AND B.BUDGET_VERSION_ID = A.CI_PLAN_VERSION_ID;

Line 6413: FROM PA_FP_MERGED_CTRL_ITEMS

6409: SELECT 'Y'
6410: INTO l_impl_qty_exists
6411: FROM DUAL
6412: WHERE EXISTS (SELECT 1
6413: FROM PA_FP_MERGED_CTRL_ITEMS
6414: WHERE CI_PLAN_VERSION_ID = p_ci_version_id
6415: AND PLAN_VERSION_ID = p_budget_version_id
6416: AND VERSION_TYPE = 'COST');
6417: EXCEPTION

Line 6447: FROM PA_FP_MERGED_CTRL_ITEMS A

6443: SELECT 'Y'
6444: INTO l_impl_qty_exists
6445: FROM DUAL
6446: WHERE EXISTS (SELECT 1
6447: FROM PA_FP_MERGED_CTRL_ITEMS A
6448: WHERE A.CI_PLAN_VERSION_ID = P_CI_VERSION_ID
6449: AND A.PLAN_VERSION_ID = P_BUDGET_VERSION_ID
6450: AND A.VERSION_TYPE = 'REVENUE');
6451: EXCEPTION

Line 6462: FROM PA_FP_MERGED_CTRL_ITEMS A , PA_BUDGET_VERSIONS B

6458: IF l_impl_qty_exists = 'Y' THEN
6459: BEGIN
6460: SELECT NVL(B.REV_PARTIALLY_IMPL_FLAG,'N') , A.IMPL_EQUIPMENT_QUANTITY
6461: INTO l_revenue_partial_flag, l_partial_quantity
6462: FROM PA_FP_MERGED_CTRL_ITEMS A , PA_BUDGET_VERSIONS B
6463: WHERE A.CI_PLAN_VERSION_ID = p_ci_version_id
6464: AND A.PLAN_VERSION_ID = p_budget_version_id
6465: AND A.VERSION_TYPE = 'REVENUE'
6466: AND B.BUDGET_VERSION_ID = A.CI_PLAN_VERSION_ID;

Line 6526: FROM PA_FP_MERGED_CTRL_ITEMS

6522: SELECT 'Y'
6523: INTO l_impl_qty_exists
6524: FROM DUAL
6525: WHERE EXISTS (SELECT 1
6526: FROM PA_FP_MERGED_CTRL_ITEMS
6527: WHERE CI_PLAN_VERSION_ID = p_ci_version_id
6528: AND PLAN_VERSION_ID = p_budget_version_id
6529: AND VERSION_TYPE = 'COST');
6530: EXCEPTION

Line 6559: FROM PA_FP_MERGED_CTRL_ITEMS A

6555: SELECT 'Y'
6556: INTO l_impl_qty_exists
6557: FROM DUAL
6558: WHERE EXISTS (SELECT 1
6559: FROM PA_FP_MERGED_CTRL_ITEMS A
6560: WHERE A.CI_PLAN_VERSION_ID = P_CI_VERSION_ID
6561: AND A.PLAN_VERSION_ID = P_BUDGET_VERSION_ID
6562: AND A.VERSION_TYPE = 'REVENUE');
6563: EXCEPTION

Line 6574: FROM PA_FP_MERGED_CTRL_ITEMS A , PA_BUDGET_VERSIONS B

6570: IF l_impl_qty_exists = 'Y' THEN
6571: BEGIN
6572: SELECT NVL(B.REV_PARTIALLY_IMPL_FLAG,'N') , A.IMPL_EQUIPMENT_QUANTITY
6573: INTO l_revenue_partial_flag, l_partial_quantity
6574: FROM PA_FP_MERGED_CTRL_ITEMS A , PA_BUDGET_VERSIONS B
6575: WHERE A.CI_PLAN_VERSION_ID = p_ci_version_id
6576: AND A.PLAN_VERSION_ID = p_budget_version_id
6577: AND A.VERSION_TYPE = 'REVENUE'
6578: AND B.BUDGET_VERSION_ID = A.CI_PLAN_VERSION_ID;

Line 6675: FROM PA_FP_MERGED_CTRL_ITEMS A

6671: SELECT 'Y'
6672: INTO l_exists
6673: FROM DUAL
6674: WHERE EXISTS (SELECT 1
6675: FROM PA_FP_MERGED_CTRL_ITEMS A
6676: WHERE A.CI_PLAN_VERSION_ID = P_CI_VERSION_ID
6677: AND A.PLAN_VERSION_ID = P_BUDGET_VERSION_ID
6678: AND A.VERSION_TYPE = 'REVENUE');
6679: EXCEPTION

Line 6735: FROM PA_FP_MERGED_CTRL_ITEMS A , PA_BUDGET_VERSIONS B

6731: IF l_exists = 'Y' THEN
6732: BEGIN
6733: SELECT NVL(B.REV_PARTIALLY_IMPL_FLAG,'N') , A.IMPL_PROJ_REVENUE
6734: INTO l_revenue_partial_flag, l_partial_revenue
6735: FROM PA_FP_MERGED_CTRL_ITEMS A , PA_BUDGET_VERSIONS B
6736: WHERE A.CI_PLAN_VERSION_ID = p_ci_version_id
6737: AND A.PLAN_VERSION_ID = p_budget_version_id
6738: AND A.VERSION_TYPE = 'REVENUE'
6739: AND B.BUDGET_VERSION_ID = A.CI_PLAN_VERSION_ID;

Line 6944: from pa_fp_merged_ctrl_items

6940: Select l_cost
6941: into l_return_cost
6942: from dual
6943: where not exists (Select 1
6944: from pa_fp_merged_ctrl_items
6945: where plan_version_id = p_budget_version_id
6946: and version_type = 'COST'
6947: and ci_plan_version_id = p_ci_version_id);
6948:

Line 7068: FROM pa_fp_merged_ctrl_items merge1

7064: and pfca.PROJECT_SYSTEM_STATUS_CODE = c_system_status_code
7065: and ( pfca.REV_PARTIALLY_IMPL_FLAG='Y'
7066: or (pfca.ci_version_type='ALL'
7067: AND DECODE(c_version_type,'ALL',2,1) > (SELECT COUNT(*)
7068: FROM pa_fp_merged_ctrl_items merge1
7069: where merge1.ci_plan_version_id = pfca.ci_version_id
7070: and merge1.plan_version_id = c_budget_version_id
7071: and merge1.project_id = c_project_id))
7072: or (pfca.ci_version_type <> 'ALL'

Line 7074: from pa_fp_merged_ctrl_items merge2

7070: and merge1.plan_version_id = c_budget_version_id
7071: and merge1.project_id = c_project_id))
7072: or (pfca.ci_version_type <> 'ALL'
7073: AND not exists (Select 'X'
7074: from pa_fp_merged_ctrl_items merge2
7075: where merge2.ci_plan_version_id = pfca.ci_version_id
7076: and merge2.plan_version_id = c_budget_version_id
7077: and merge2.version_type = pfca.ci_version_type
7078: and merge2.project_id = c_project_id)));

Line 8528: CURSOR c_impact_impl_csr(c_version_id IN pa_fp_merged_Ctrl_items.plan_version_id%TYPE,

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);
8527:
8528: CURSOR c_impact_impl_csr(c_version_id IN pa_fp_merged_Ctrl_items.plan_version_id%TYPE,
8529: c_ci_version_id IN pa_fp_merged_Ctrl_items.ci_plan_version_id%TYPE,
8530: c_version_type IN pa_fp_merged_Ctrl_items.version_type%TYPE) IS
8531: SELECT 'X'
8532: FROM pa_fp_merged_Ctrl_items

Line 8529: c_ci_version_id IN pa_fp_merged_Ctrl_items.ci_plan_version_id%TYPE,

8525: AND popt.fin_plan_type_id = p_fin_plan_type_id
8526: AND popt.ci_type_id = c_ci_type_id);
8527:
8528: CURSOR c_impact_impl_csr(c_version_id IN pa_fp_merged_Ctrl_items.plan_version_id%TYPE,
8529: c_ci_version_id IN pa_fp_merged_Ctrl_items.ci_plan_version_id%TYPE,
8530: c_version_type IN pa_fp_merged_Ctrl_items.version_type%TYPE) IS
8531: SELECT 'X'
8532: FROM pa_fp_merged_Ctrl_items
8533: WHERE ci_id=p_ci_id

Line 8530: c_version_type IN pa_fp_merged_Ctrl_items.version_type%TYPE) IS

8526: AND popt.ci_type_id = c_ci_type_id);
8527:
8528: CURSOR c_impact_impl_csr(c_version_id IN pa_fp_merged_Ctrl_items.plan_version_id%TYPE,
8529: c_ci_version_id IN pa_fp_merged_Ctrl_items.ci_plan_version_id%TYPE,
8530: c_version_type IN pa_fp_merged_Ctrl_items.version_type%TYPE) IS
8531: SELECT 'X'
8532: FROM pa_fp_merged_Ctrl_items
8533: WHERE ci_id=p_ci_id
8534: AND plan_version_id = c_version_id

Line 8532: FROM pa_fp_merged_Ctrl_items

8528: CURSOR c_impact_impl_csr(c_version_id IN pa_fp_merged_Ctrl_items.plan_version_id%TYPE,
8529: c_ci_version_id IN pa_fp_merged_Ctrl_items.ci_plan_version_id%TYPE,
8530: c_version_type IN pa_fp_merged_Ctrl_items.version_type%TYPE) IS
8531: SELECT 'X'
8532: FROM pa_fp_merged_Ctrl_items
8533: WHERE ci_id=p_ci_id
8534: AND plan_version_id = c_version_id
8535: AND ci_plan_version_id = c_ci_version_id
8536: AND project_id = p_project_id

Line 8929: in pa_fp_merged_ctrl_items.

8925: If Flag is Y then
8926: Return Y
8927: If Flag is not Y then
8928: Check if revenue record exists for ci version and plan version
8929: in pa_fp_merged_ctrl_items.
8930: If Record Exists - Fuull Impl has taken place return N
8931: Else Check Partial Rev Enable FLag for plan type
8932: If Y then
8933: return Y

Line 8967: FROM PA_FP_MERGED_CTRL_ITEMS

8963: SELECT 'Y'
8964: INTO l_rev_impl_full
8965: FROM DUAL
8966: WHERE EXISTS (SELECT 1
8967: FROM PA_FP_MERGED_CTRL_ITEMS
8968: WHERE CI_PLAN_VERSION_ID = nvl(l_ci_rev_version_id,l_ci_all_version_id)
8969: AND version_type = 'REVENUE'
8970: AND PLAN_VERSION_ID = decode(nvl(l_rev_budget_version_id,-1),-1,l_all_budget_version_id
8971: ,l_rev_budget_version_id));

Line 9177: FROM pa_fp_merged_ctrl_items

9173: IS
9174: SELECT 'x'
9175: FROM DUAL
9176: WHERE EXISTS (SELECT 'x'
9177: FROM pa_fp_merged_ctrl_items
9178: WHERE ci_id=p_ci_id
9179: AND plan_version_id=c_app_cw_ver_id
9180: AND ci_plan_version_id=c_ci_version_id
9181: AND version_type=c_version_type);

Line 9691: p_ci_id IN pa_fp_merged_ctrl_items.ci_id%TYPE)

9687: /* Bug 3731948- New Function to return the CO amount already implemented
9688: * for REVENUE implementation in agreement currency
9689: */
9690: FUNCTION get_impl_agr_revenue (p_project_id IN pa_projects_all.project_id%TYPE,
9691: p_ci_id IN pa_fp_merged_ctrl_items.ci_id%TYPE)
9692: RETURN NUMBER
9693: IS
9694: l_impl_agr_rev_amt NUMBER := 0;
9695: l_cw_bv_id NUMBER;

Line 9773: FROM pa_fp_merged_ctrl_items

9769: BEGIN
9770: -- Selecting the revenue amount implemeted in agreement currency
9771: SELECT Nvl(impl_agr_revenue,0)
9772: INTO l_impl_agr_rev_amt
9773: FROM pa_fp_merged_ctrl_items
9774: WHERE project_id = p_project_id
9775: AND ci_id = p_ci_id
9776: AND plan_version_id = l_cw_bv_id
9777: AND ci_plan_version_id = l_ci_rev_version_id

Line 9843: FROM PA_FP_MERGED_CTRL_ITEMS

9839: SELECT 'Y'
9840: INTO l_is_merged
9841: FROM DUAL
9842: WHERE EXISTS (SELECT 1
9843: FROM PA_FP_MERGED_CTRL_ITEMS
9844: WHERE CI_ID = p_ci_id);
9845:
9846: RETURN l_is_merged;
9847: