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 3448: c_version_type pa_fp_merged_ctrl_items.version_type%TYPE)

3444: l_module_name VARCHAR2(100) := 'pa.plsql.Pa_Fp_Control_Items_Utils';
3445:
3446: CURSOR c_upd_impact_val_csr
3447: (c_ci_id pa_control_items.ci_id%TYPE,
3448: c_version_type pa_fp_merged_ctrl_items.version_type%TYPE)
3449: IS
3450: SELECT 'Y'
3451: FROM pa_fp_merged_ctrl_items
3452: WHERE ci_id =c_ci_id

Line 3451: FROM pa_fp_merged_ctrl_items

3447: (c_ci_id pa_control_items.ci_id%TYPE,
3448: c_version_type pa_fp_merged_ctrl_items.version_type%TYPE)
3449: IS
3450: SELECT 'Y'
3451: FROM pa_fp_merged_ctrl_items
3452: WHERE ci_id =c_ci_id
3453: AND project_id=p_project_id
3454: AND plan_version_id=p_target_version_id
3455: AND ci_plan_version_id=NVL(p_source_version_id,ci_plan_version_id)

Line 4613: c_change_documents_current should rely on inclusion_method_code in pa_fp_merged_ctrl_items.

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

Line 4644: from pa_fp_merged_ctrl_items merge,

4640: nvl(sum(decode(c_margin_derived_from_code,
4641: 'B',nvl(merge.impl_proj_burdened_cost,0),
4642: nvl(merge.impl_proj_raw_cost,0))),0) as cost,
4643: nvl(sum(nvl(merge.impl_proj_revenue,0)),0)
4644: from pa_fp_merged_ctrl_items merge,
4645: pa_budget_versions pbv
4646: where pbv.project_id = c_project_id
4647: and pbv.fin_plan_type_id in (c_ac_fin_plan_type_id, c_ar_fin_plan_type_id)
4648: and pbv.current_working_flag = 'Y'

Line 4655: from pa_fp_merged_ctrl_items merge1, pa_budget_versions pbv1

4651: and pbv.ci_id is null
4652: -- and pbv.budget_status_code in ('S','W') -- Bug#3815378
4653: -- Added by Raja, filter all the ci versions included/copied in current baseline version
4654: and not exists(select 1
4655: from pa_fp_merged_ctrl_items merge1, pa_budget_versions pbv1
4656: where pbv1.project_id = c_project_id
4657: and pbv1.fin_plan_type_id in (c_ac_fin_plan_type_id,
4658: c_ar_fin_plan_type_id)
4659: and pbv1.budget_status_code = 'B'

Line 4691: from pa_fp_merged_ctrl_items merge,

4687: nvl(merge.impl_proj_raw_cost,0))),0) as cost,
4688: nvl(sum(decode(pbv.fin_plan_type_id,
4689: c_ar_fin_plan_type_id,nvl(merge.impl_proj_revenue,0),
4690: 0)),0)
4691: from pa_fp_merged_ctrl_items merge,
4692: pa_budget_versions pbv
4693: where pbv.project_id = c_project_id
4694: and pbv.fin_plan_type_id in (c_ac_fin_plan_type_id, c_ar_fin_plan_type_id)
4695: and pbv.current_working_flag = 'Y'

Line 4705: c_change_documents_prior should rely on inclusion_method_code in pa_fp_merged_ctrl_items.

4701:
4702:
4703: /* Bug - 3882985.
4704: Cursor c_change_documents_prior is modified below.
4705: c_change_documents_prior should rely on inclusion_method_code in pa_fp_merged_ctrl_items.
4706: Basically All records having inclusion_method_code as (COPIED - for Current Baseline) should
4707: be considered while deriving Amounts/Quantities for the Prior Baselined Versions
4708: */
4709: -- Bug 5845142. Take the revenue amounts only from revenue impact.Note that cost impacts

Line 4737: from pa_fp_merged_ctrl_items merge,

4733: ,nvl(merge.impl_proj_raw_cost,0))),0) as cost,
4734: nvl(sum(decode(pbv.fin_plan_type_id,
4735: c_ar_fin_plan_type_id,nvl(merge.impl_proj_revenue,0),
4736: 0)),0)
4737: from pa_fp_merged_ctrl_items merge,
4738: pa_budget_versions pbv
4739: where merge.plan_version_id = pbv.budget_version_id
4740: and pbv.fin_plan_type_id in (c_ac_fin_plan_type_id, c_ar_fin_plan_type_id)
4741: and pbv.current_flag = 'Y'

Line 4749: from pa_fp_merged_ctrl_items merge1, pa_budget_versions pbv1

4745: and pbv.budget_status_code = 'B'
4746: and merge.inclusion_method_code = 'COPIED' -- Bug 3882985
4747: /* Raja filter all the change orders that have been included/copied in the original baseline version */
4748: and not exists(select 1
4749: from pa_fp_merged_ctrl_items merge1, pa_budget_versions pbv1
4750: where pbv1.project_id = c_project_id
4751: and pbv1.fin_plan_type_id in (c_ac_fin_plan_type_id,
4752: c_ar_fin_plan_type_id)
4753: and pbv1.current_original_flag = 'Y'

Line 4830: from pa_fp_merged_ctrl_items merge1, pa_budget_versions pbv1

4826: where pfca.project_id = c_project_id
4827: and pfca.project_system_status_code = c_system_status_code
4828: and pfca.ci_version_type in ('COST', 'ALL')
4829: and not exists(select 1
4830: from pa_fp_merged_ctrl_items merge1, pa_budget_versions pbv1
4831: where merge1.project_id = c_project_id
4832: and merge1.ci_id = pfca.ci_id
4833: and merge1.ci_plan_version_id = pfca.ci_version_id
4834: and merge1.version_type = 'COST'

Line 4895: from pa_fp_merged_ctrl_items merge1, pa_budget_versions pbv1

4891: and pfca.project_system_status_code = c_system_status_code
4892: and pfca.ci_version_type in ('REVENUE', 'ALL')
4893: and (pfca.REV_PARTIALLY_IMPL_FLAG = 'Y' OR
4894: not exists(select 1
4895: from pa_fp_merged_ctrl_items merge1, pa_budget_versions pbv1
4896: where merge1.project_id = c_project_id
4897: and merge1.ci_id = pfca.ci_id
4898: and merge1.ci_plan_version_id = pfca.ci_version_id
4899: and merge1.version_type = 'REVENUE'

Line 6159: FROM PA_FP_MERGED_CTRL_ITEMS

6155: SELECT 'Y'
6156: INTO l_impl_qty_exists
6157: FROM DUAL
6158: WHERE EXISTS (SELECT 1
6159: FROM PA_FP_MERGED_CTRL_ITEMS
6160: WHERE CI_PLAN_VERSION_ID = p_ci_version_id
6161: AND PLAN_VERSION_ID = p_budget_version_id
6162: AND VERSION_TYPE = 'COST');
6163: EXCEPTION

Line 6194: FROM PA_FP_MERGED_CTRL_ITEMS A

6190: SELECT 'Y'
6191: INTO l_impl_qty_exists
6192: FROM DUAL
6193: WHERE EXISTS (SELECT 1
6194: FROM PA_FP_MERGED_CTRL_ITEMS A
6195: WHERE A.CI_PLAN_VERSION_ID = P_CI_VERSION_ID
6196: AND A.PLAN_VERSION_ID = P_BUDGET_VERSION_ID
6197: AND A.VERSION_TYPE = 'REVENUE');
6198: EXCEPTION

Line 6209: FROM PA_FP_MERGED_CTRL_ITEMS A , PA_BUDGET_VERSIONS B

6205: IF l_impl_qty_exists = 'Y' THEN
6206: BEGIN
6207: SELECT NVL(B.REV_PARTIALLY_IMPL_FLAG,'N') , A.IMPL_QUANTITY
6208: INTO l_revenue_partial_flag, l_partial_quantity
6209: FROM PA_FP_MERGED_CTRL_ITEMS A , PA_BUDGET_VERSIONS B
6210: WHERE A.CI_PLAN_VERSION_ID = p_ci_version_id
6211: AND A.PLAN_VERSION_ID = p_budget_version_id
6212: AND A.VERSION_TYPE = 'REVENUE'
6213: AND B.BUDGET_VERSION_ID = A.CI_PLAN_VERSION_ID;

Line 6273: FROM PA_FP_MERGED_CTRL_ITEMS

6269: SELECT 'Y'
6270: INTO l_impl_qty_exists
6271: FROM DUAL
6272: WHERE EXISTS (SELECT 1
6273: FROM PA_FP_MERGED_CTRL_ITEMS
6274: WHERE CI_PLAN_VERSION_ID = p_ci_version_id
6275: AND PLAN_VERSION_ID = p_budget_version_id
6276: AND VERSION_TYPE = 'COST');
6277: EXCEPTION

Line 6306: FROM PA_FP_MERGED_CTRL_ITEMS A

6302: SELECT 'Y'
6303: INTO l_impl_qty_exists
6304: FROM DUAL
6305: WHERE EXISTS (SELECT 1
6306: FROM PA_FP_MERGED_CTRL_ITEMS A
6307: WHERE A.CI_PLAN_VERSION_ID = P_CI_VERSION_ID
6308: AND A.PLAN_VERSION_ID = P_BUDGET_VERSION_ID
6309: AND A.VERSION_TYPE = 'REVENUE');
6310: EXCEPTION

Line 6321: FROM PA_FP_MERGED_CTRL_ITEMS A , PA_BUDGET_VERSIONS B

6317: IF l_impl_qty_exists = 'Y' THEN
6318: BEGIN
6319: SELECT NVL(B.REV_PARTIALLY_IMPL_FLAG,'N') , A.IMPL_QUANTITY
6320: INTO l_revenue_partial_flag, l_partial_quantity
6321: FROM PA_FP_MERGED_CTRL_ITEMS A , PA_BUDGET_VERSIONS B
6322: WHERE A.CI_PLAN_VERSION_ID = p_ci_version_id
6323: AND A.PLAN_VERSION_ID = p_budget_version_id
6324: AND A.VERSION_TYPE = 'REVENUE'
6325: AND B.BUDGET_VERSION_ID = A.CI_PLAN_VERSION_ID;

Line 6469: FROM PA_FP_MERGED_CTRL_ITEMS

6465: SELECT 'Y'
6466: INTO l_impl_qty_exists
6467: FROM DUAL
6468: WHERE EXISTS (SELECT 1
6469: FROM PA_FP_MERGED_CTRL_ITEMS
6470: WHERE CI_PLAN_VERSION_ID = p_ci_version_id
6471: AND PLAN_VERSION_ID = p_budget_version_id
6472: AND VERSION_TYPE = 'COST');
6473: EXCEPTION

Line 6503: FROM PA_FP_MERGED_CTRL_ITEMS A

6499: SELECT 'Y'
6500: INTO l_impl_qty_exists
6501: FROM DUAL
6502: WHERE EXISTS (SELECT 1
6503: FROM PA_FP_MERGED_CTRL_ITEMS A
6504: WHERE A.CI_PLAN_VERSION_ID = P_CI_VERSION_ID
6505: AND A.PLAN_VERSION_ID = P_BUDGET_VERSION_ID
6506: AND A.VERSION_TYPE = 'REVENUE');
6507: EXCEPTION

Line 6518: FROM PA_FP_MERGED_CTRL_ITEMS A , PA_BUDGET_VERSIONS B

6514: IF l_impl_qty_exists = 'Y' THEN
6515: BEGIN
6516: SELECT NVL(B.REV_PARTIALLY_IMPL_FLAG,'N') , A.IMPL_EQUIPMENT_QUANTITY
6517: INTO l_revenue_partial_flag, l_partial_quantity
6518: FROM PA_FP_MERGED_CTRL_ITEMS A , PA_BUDGET_VERSIONS B
6519: WHERE A.CI_PLAN_VERSION_ID = p_ci_version_id
6520: AND A.PLAN_VERSION_ID = p_budget_version_id
6521: AND A.VERSION_TYPE = 'REVENUE'
6522: AND B.BUDGET_VERSION_ID = A.CI_PLAN_VERSION_ID;

Line 6582: FROM PA_FP_MERGED_CTRL_ITEMS

6578: SELECT 'Y'
6579: INTO l_impl_qty_exists
6580: FROM DUAL
6581: WHERE EXISTS (SELECT 1
6582: FROM PA_FP_MERGED_CTRL_ITEMS
6583: WHERE CI_PLAN_VERSION_ID = p_ci_version_id
6584: AND PLAN_VERSION_ID = p_budget_version_id
6585: AND VERSION_TYPE = 'COST');
6586: EXCEPTION

Line 6615: FROM PA_FP_MERGED_CTRL_ITEMS A

6611: SELECT 'Y'
6612: INTO l_impl_qty_exists
6613: FROM DUAL
6614: WHERE EXISTS (SELECT 1
6615: FROM PA_FP_MERGED_CTRL_ITEMS A
6616: WHERE A.CI_PLAN_VERSION_ID = P_CI_VERSION_ID
6617: AND A.PLAN_VERSION_ID = P_BUDGET_VERSION_ID
6618: AND A.VERSION_TYPE = 'REVENUE');
6619: EXCEPTION

Line 6630: FROM PA_FP_MERGED_CTRL_ITEMS A , PA_BUDGET_VERSIONS B

6626: IF l_impl_qty_exists = 'Y' THEN
6627: BEGIN
6628: SELECT NVL(B.REV_PARTIALLY_IMPL_FLAG,'N') , A.IMPL_EQUIPMENT_QUANTITY
6629: INTO l_revenue_partial_flag, l_partial_quantity
6630: FROM PA_FP_MERGED_CTRL_ITEMS A , PA_BUDGET_VERSIONS B
6631: WHERE A.CI_PLAN_VERSION_ID = p_ci_version_id
6632: AND A.PLAN_VERSION_ID = p_budget_version_id
6633: AND A.VERSION_TYPE = 'REVENUE'
6634: AND B.BUDGET_VERSION_ID = A.CI_PLAN_VERSION_ID;

Line 6744: FROM PA_FP_MERGED_CTRL_ITEMS A

6740: SELECT 'Y'
6741: INTO l_exists
6742: FROM DUAL
6743: WHERE EXISTS (SELECT 1
6744: FROM PA_FP_MERGED_CTRL_ITEMS A
6745: WHERE A.CI_PLAN_VERSION_ID = P_CI_VERSION_ID
6746: AND A.PLAN_VERSION_ID = P_BUDGET_VERSION_ID
6747: AND A.VERSION_TYPE = 'REVENUE');
6748: EXCEPTION

Line 6804: FROM PA_FP_MERGED_CTRL_ITEMS A , PA_BUDGET_VERSIONS B

6800: IF l_exists = 'Y' THEN
6801: BEGIN
6802: SELECT NVL(B.REV_PARTIALLY_IMPL_FLAG,'N') , A.IMPL_PROJ_REVENUE
6803: INTO l_revenue_partial_flag, l_partial_revenue
6804: FROM PA_FP_MERGED_CTRL_ITEMS A , PA_BUDGET_VERSIONS B
6805: WHERE A.CI_PLAN_VERSION_ID = p_ci_version_id
6806: AND A.PLAN_VERSION_ID = p_budget_version_id
6807: AND A.VERSION_TYPE = 'REVENUE'
6808: AND B.BUDGET_VERSION_ID = A.CI_PLAN_VERSION_ID;

Line 7016: from pa_fp_merged_ctrl_items

7012: Select l_cost
7013: into l_return_cost
7014: from dual
7015: where not exists (Select 1
7016: from pa_fp_merged_ctrl_items
7017: where plan_version_id = p_budget_version_id
7018: and version_type = 'COST'
7019: and ci_plan_version_id = p_ci_version_id);
7020:

Line 7140: FROM pa_fp_merged_ctrl_items merge1

7136: and pfca.PROJECT_SYSTEM_STATUS_CODE = c_system_status_code
7137: and ( pfca.REV_PARTIALLY_IMPL_FLAG='Y'
7138: or (pfca.ci_version_type='ALL'
7139: AND DECODE(c_version_type,'ALL',2,1) > (SELECT COUNT(*)
7140: FROM pa_fp_merged_ctrl_items merge1
7141: where merge1.ci_plan_version_id = pfca.ci_version_id
7142: and merge1.plan_version_id = c_budget_version_id
7143: and merge1.project_id = c_project_id))
7144: or (pfca.ci_version_type <> 'ALL'

Line 7146: from pa_fp_merged_ctrl_items merge2

7142: and merge1.plan_version_id = c_budget_version_id
7143: and merge1.project_id = c_project_id))
7144: or (pfca.ci_version_type <> 'ALL'
7145: AND not exists (Select 'X'
7146: from pa_fp_merged_ctrl_items merge2
7147: where merge2.ci_plan_version_id = pfca.ci_version_id
7148: and merge2.plan_version_id = c_budget_version_id
7149: and merge2.version_type = pfca.ci_version_type
7150: and merge2.project_id = c_project_id)));

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

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);
8659:
8660: CURSOR c_impact_impl_csr(c_version_id IN pa_fp_merged_Ctrl_items.plan_version_id%TYPE,
8661: c_ci_version_id IN pa_fp_merged_Ctrl_items.ci_plan_version_id%TYPE,
8662: c_version_type IN pa_fp_merged_Ctrl_items.version_type%TYPE) IS
8663: SELECT 'X'
8664: FROM pa_fp_merged_Ctrl_items

Line 8661: c_ci_version_id IN pa_fp_merged_Ctrl_items.ci_plan_version_id%TYPE,

8657: AND popt.fin_plan_type_id = p_fin_plan_type_id
8658: AND popt.ci_type_id = c_ci_type_id);
8659:
8660: CURSOR c_impact_impl_csr(c_version_id IN pa_fp_merged_Ctrl_items.plan_version_id%TYPE,
8661: c_ci_version_id IN pa_fp_merged_Ctrl_items.ci_plan_version_id%TYPE,
8662: c_version_type IN pa_fp_merged_Ctrl_items.version_type%TYPE) IS
8663: SELECT 'X'
8664: FROM pa_fp_merged_Ctrl_items
8665: WHERE ci_id=p_ci_id

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

8658: AND popt.ci_type_id = c_ci_type_id);
8659:
8660: CURSOR c_impact_impl_csr(c_version_id IN pa_fp_merged_Ctrl_items.plan_version_id%TYPE,
8661: c_ci_version_id IN pa_fp_merged_Ctrl_items.ci_plan_version_id%TYPE,
8662: c_version_type IN pa_fp_merged_Ctrl_items.version_type%TYPE) IS
8663: SELECT 'X'
8664: FROM pa_fp_merged_Ctrl_items
8665: WHERE ci_id=p_ci_id
8666: AND plan_version_id = c_version_id

Line 8664: FROM pa_fp_merged_Ctrl_items

8660: CURSOR c_impact_impl_csr(c_version_id IN pa_fp_merged_Ctrl_items.plan_version_id%TYPE,
8661: c_ci_version_id IN pa_fp_merged_Ctrl_items.ci_plan_version_id%TYPE,
8662: c_version_type IN pa_fp_merged_Ctrl_items.version_type%TYPE) IS
8663: SELECT 'X'
8664: FROM pa_fp_merged_Ctrl_items
8665: WHERE ci_id=p_ci_id
8666: AND plan_version_id = c_version_id
8667: AND ci_plan_version_id = c_ci_version_id
8668: AND project_id = p_project_id

Line 9087: in pa_fp_merged_ctrl_items.

9083: If Flag is Y then
9084: Return Y
9085: If Flag is not Y then
9086: Check if revenue record exists for ci version and plan version
9087: in pa_fp_merged_ctrl_items.
9088: If Record Exists - Fuull Impl has taken place return N
9089: Else Check Partial Rev Enable FLag for plan type
9090: If Y then
9091: return Y

Line 9125: FROM PA_FP_MERGED_CTRL_ITEMS

9121: SELECT 'Y'
9122: INTO l_rev_impl_full
9123: FROM DUAL
9124: WHERE EXISTS (SELECT 1
9125: FROM PA_FP_MERGED_CTRL_ITEMS
9126: WHERE CI_PLAN_VERSION_ID = nvl(l_ci_rev_version_id,l_ci_all_version_id)
9127: AND version_type = 'REVENUE'
9128: AND PLAN_VERSION_ID = decode(nvl(l_rev_budget_version_id,-1),-1,l_all_budget_version_id
9129: ,l_rev_budget_version_id));

Line 9335: FROM pa_fp_merged_ctrl_items

9331: IS
9332: SELECT 'x'
9333: FROM DUAL
9334: WHERE EXISTS (SELECT 'x'
9335: FROM pa_fp_merged_ctrl_items
9336: WHERE ci_id=p_ci_id
9337: AND plan_version_id=c_app_cw_ver_id
9338: AND ci_plan_version_id=c_ci_version_id
9339: AND version_type=c_version_type);

Line 9849: p_ci_id IN pa_fp_merged_ctrl_items.ci_id%TYPE)

9845: /* Bug 3731948- New Function to return the CO amount already implemented
9846: * for REVENUE implementation in agreement currency
9847: */
9848: FUNCTION get_impl_agr_revenue (p_project_id IN pa_projects_all.project_id%TYPE,
9849: p_ci_id IN pa_fp_merged_ctrl_items.ci_id%TYPE)
9850: RETURN NUMBER
9851: IS
9852: l_impl_agr_rev_amt NUMBER := 0;
9853: l_cw_bv_id NUMBER;

Line 9931: FROM pa_fp_merged_ctrl_items

9927: BEGIN
9928: -- Selecting the revenue amount implemeted in agreement currency
9929: SELECT Nvl(impl_agr_revenue,0)
9930: INTO l_impl_agr_rev_amt
9931: FROM pa_fp_merged_ctrl_items
9932: WHERE project_id = p_project_id
9933: AND ci_id = p_ci_id
9934: AND plan_version_id = l_cw_bv_id
9935: AND ci_plan_version_id = l_ci_rev_version_id

Line 10027: FROM PA_FP_MERGED_CTRL_ITEMS

10023: SELECT 'Y'
10024: INTO l_is_merged
10025: FROM DUAL
10026: WHERE EXISTS (SELECT 1
10027: FROM PA_FP_MERGED_CTRL_ITEMS
10028: WHERE CI_ID = p_ci_id);
10029:
10030: RETURN l_is_merged;
10031: