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_COST_PLUS dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 1647: quantity pa_expenditure_items_all.quantity%TYPE;

1643: l_denom_currency_code VARCHAR2(15);
1644: l_acct_currency_code VARCHAR2(15);
1645: l_project_currency_code VARCHAR2(15);
1646: l_projfunc_currency_code VARCHAR2(15);
1647: quantity pa_expenditure_items_all.quantity%TYPE;
1648: burden_cost pa_expenditure_items_all.burden_cost%TYPE;
1649: burden_cost_denom pa_expenditure_items_all.denom_burdened_cost%TYPE;
1650: burden_cost_acct pa_expenditure_items_all.acct_burdened_cost%TYPE;
1651: burden_cost_project pa_expenditure_items_all.project_burdened_cost%TYPE; /* ProjCurr Changes */

Line 1648: burden_cost pa_expenditure_items_all.burden_cost%TYPE;

1644: l_acct_currency_code VARCHAR2(15);
1645: l_project_currency_code VARCHAR2(15);
1646: l_projfunc_currency_code VARCHAR2(15);
1647: quantity pa_expenditure_items_all.quantity%TYPE;
1648: burden_cost pa_expenditure_items_all.burden_cost%TYPE;
1649: burden_cost_denom pa_expenditure_items_all.denom_burdened_cost%TYPE;
1650: burden_cost_acct pa_expenditure_items_all.acct_burdened_cost%TYPE;
1651: burden_cost_project pa_expenditure_items_all.project_burdened_cost%TYPE; /* ProjCurr Changes */
1652: system_linkage pa_expenditure_items_all.system_linkage_function%TYPE;

Line 1649: burden_cost_denom pa_expenditure_items_all.denom_burdened_cost%TYPE;

1645: l_project_currency_code VARCHAR2(15);
1646: l_projfunc_currency_code VARCHAR2(15);
1647: quantity pa_expenditure_items_all.quantity%TYPE;
1648: burden_cost pa_expenditure_items_all.burden_cost%TYPE;
1649: burden_cost_denom pa_expenditure_items_all.denom_burdened_cost%TYPE;
1650: burden_cost_acct pa_expenditure_items_all.acct_burdened_cost%TYPE;
1651: burden_cost_project pa_expenditure_items_all.project_burdened_cost%TYPE; /* ProjCurr Changes */
1652: system_linkage pa_expenditure_items_all.system_linkage_function%TYPE;
1653: compiled_multiplier pa_compiled_multipliers.compiled_multiplier%TYPE;

Line 1650: burden_cost_acct pa_expenditure_items_all.acct_burdened_cost%TYPE;

1646: l_projfunc_currency_code VARCHAR2(15);
1647: quantity pa_expenditure_items_all.quantity%TYPE;
1648: burden_cost pa_expenditure_items_all.burden_cost%TYPE;
1649: burden_cost_denom pa_expenditure_items_all.denom_burdened_cost%TYPE;
1650: burden_cost_acct pa_expenditure_items_all.acct_burdened_cost%TYPE;
1651: burden_cost_project pa_expenditure_items_all.project_burdened_cost%TYPE; /* ProjCurr Changes */
1652: system_linkage pa_expenditure_items_all.system_linkage_function%TYPE;
1653: compiled_multiplier pa_compiled_multipliers.compiled_multiplier%TYPE;
1654:

Line 1651: burden_cost_project pa_expenditure_items_all.project_burdened_cost%TYPE; /* ProjCurr Changes */

1647: quantity pa_expenditure_items_all.quantity%TYPE;
1648: burden_cost pa_expenditure_items_all.burden_cost%TYPE;
1649: burden_cost_denom pa_expenditure_items_all.denom_burdened_cost%TYPE;
1650: burden_cost_acct pa_expenditure_items_all.acct_burdened_cost%TYPE;
1651: burden_cost_project pa_expenditure_items_all.project_burdened_cost%TYPE; /* ProjCurr Changes */
1652: system_linkage pa_expenditure_items_all.system_linkage_function%TYPE;
1653: compiled_multiplier pa_compiled_multipliers.compiled_multiplier%TYPE;
1654:
1655: BEGIN

Line 1652: system_linkage pa_expenditure_items_all.system_linkage_function%TYPE;

1648: burden_cost pa_expenditure_items_all.burden_cost%TYPE;
1649: burden_cost_denom pa_expenditure_items_all.denom_burdened_cost%TYPE;
1650: burden_cost_acct pa_expenditure_items_all.acct_burdened_cost%TYPE;
1651: burden_cost_project pa_expenditure_items_all.project_burdened_cost%TYPE; /* ProjCurr Changes */
1652: system_linkage pa_expenditure_items_all.system_linkage_function%TYPE;
1653: compiled_multiplier pa_compiled_multipliers.compiled_multiplier%TYPE;
1654:
1655: BEGIN
1656:

Line 1706: FROM pa_expenditure_items_all

1702: l_acct_currency_code,
1703: l_denom_currency_code,
1704: l_project_currency_code,
1705: system_linkage
1706: FROM pa_expenditure_items_all
1707: WHERE expenditure_item_id = exp_item_id;
1708:
1709: -- For Project Manufacturing, specifically BURDEN_TRANSACTIONS, raw_cost,
1710: -- quantity will be zero but burden_cost will not be zero

Line 2086: FROM pa_expenditure_items_all

2082: -1 * Denom_Burdened_Cost,
2083: -1 * Acct_Burdened_Cost ,
2084: -1 * Project_burdened_Cost,
2085: Burden_Cost_Rate
2086: FROM pa_expenditure_items_all
2087: WHERE expenditure_item_id = p_exp_item_id
2088: AND Denom_Raw_Cost = -1 * p_denom_raw_cost
2089: AND Denom_Burdened_Cost IS NOT NULL
2090: AND Acct_Burdened_Cost IS NOT NULL

Line 3435: FROM pa_expenditure_items_all

3431: SELECT task_id,
3432: expenditure_item_date
3433: INTO t_id,
3434: exp_item_date
3435: FROM pa_expenditure_items_all
3436: WHERE expenditure_item_id = exp_item_id;
3437:
3438: --
3439: -- Get the indirect rate schedule

Line 3595: FROM pa_expenditure_items_all

3591: -- oriented process, hence the uderlying select uses base table.
3592:
3593: SELECT override_to_organization_id
3594: INTO organization_id
3595: FROM pa_expenditure_items_all
3596: WHERE expenditure_item_id = exp_item_id;
3597:
3598: IF organization_id IS NULL THEN
3599: --

Line 3607: pa_expenditure_items_all exp_item

3603:
3604: SELECT incurred_by_organization_id
3605: INTO organization_id
3606: FROM pa_expenditures_all exp,
3607: pa_expenditure_items_all exp_item
3608: WHERE exp_item.expenditure_item_id = exp_item_id
3609: AND exp_item.expenditure_id = exp.expenditure_id
3610: AND ( (exp_item.org_id is null) or (exp_item.org_id = exp.org_id));
3611:

Line 3828: -- pa_expenditure_items_all ITEM

3824:
3825: --S.O. /*Bug 4527736 */
3826: -- SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS
3827: -- (SELECT 1 FROM pa_ind_compiled_sets ICS, /* Removed Hint NO_INDEX(ITEM PA_EXPENDITURE_ITEMS_N13) */
3828: -- pa_expenditure_items_all ITEM
3829: -- WHERE
3830: -- ICS.ind_rate_sch_revision_id = rate_sch_rev_id
3831: -- AND ( (ICS.ind_compiled_set_id = ITEM.cost_ind_compiled_set_id)
3832: -- OR (ICS.ind_compiled_set_id = ITEM.rev_ind_compiled_set_id)

Line 3844: FROM PA_EXPENDITURE_ITEMS_ALL ITEM

3840: FROM PA_IND_COMPILED_SETS ICS
3841: WHERE ICS.IND_RATE_SCH_REVISION_ID = rate_sch_rev_id
3842: AND EXISTS
3843: (SELECT /*+ no_unnest */ ITEM.COST_IND_COMPILED_SET_ID --Bug 12811820
3844: FROM PA_EXPENDITURE_ITEMS_ALL ITEM
3845: WHERE ICS.IND_COMPILED_SET_ID = ITEM.COST_IND_COMPILED_SET_ID
3846: UNION ALL
3847: SELECT ITEM.REV_IND_COMPILED_SET_ID
3848: FROM PA_EXPENDITURE_ITEMS_ALL ITEM

Line 3848: FROM PA_EXPENDITURE_ITEMS_ALL ITEM

3844: FROM PA_EXPENDITURE_ITEMS_ALL ITEM
3845: WHERE ICS.IND_COMPILED_SET_ID = ITEM.COST_IND_COMPILED_SET_ID
3846: UNION ALL
3847: SELECT ITEM.REV_IND_COMPILED_SET_ID
3848: FROM PA_EXPENDITURE_ITEMS_ALL ITEM
3849: WHERE ICS.IND_COMPILED_SET_ID = ITEM.REV_IND_COMPILED_SET_ID
3850: UNION ALL
3851: SELECT ITEM.TP_IND_COMPILED_SET_ID
3852: FROM PA_EXPENDITURE_ITEMS_ALL ITEM

Line 3852: FROM PA_EXPENDITURE_ITEMS_ALL ITEM

3848: FROM PA_EXPENDITURE_ITEMS_ALL ITEM
3849: WHERE ICS.IND_COMPILED_SET_ID = ITEM.REV_IND_COMPILED_SET_ID
3850: UNION ALL
3851: SELECT ITEM.TP_IND_COMPILED_SET_ID
3852: FROM PA_EXPENDITURE_ITEMS_ALL ITEM
3853: WHERE ICS.IND_COMPILED_SET_ID = ITEM.TP_IND_COMPILED_SET_ID
3854: UNION ALL
3855: SELECT ITEM.INV_IND_COMPILED_SET_ID
3856: FROM PA_EXPENDITURE_ITEMS_ALL ITEM

Line 3856: FROM PA_EXPENDITURE_ITEMS_ALL ITEM

3852: FROM PA_EXPENDITURE_ITEMS_ALL ITEM
3853: WHERE ICS.IND_COMPILED_SET_ID = ITEM.TP_IND_COMPILED_SET_ID
3854: UNION ALL
3855: SELECT ITEM.INV_IND_COMPILED_SET_ID
3856: FROM PA_EXPENDITURE_ITEMS_ALL ITEM
3857: WHERE ICS.IND_COMPILED_SET_ID = ITEM.INV_IND_COMPILED_SET_ID
3858: )
3859: );
3860: --E.N. /*Bug 4527736 */

Line 4249: UPDATE pa_expenditure_items_all ITEM

4245: G_EXPENDITURE_ITEM_ID_TAB.DELETE; /*4456789*/
4246: G_ADJ_TYPE_TAB.DELETE; /*4456789*/
4247:
4248: stage := 100;
4249: UPDATE pa_expenditure_items_all ITEM
4250: SET ITEM.cost_distributed_flag =
4251: DECODE(ITEM.cost_distributed_flag, 'Y',
4252: decode(ITEM.cost_ind_compiled_set_id, cs1_row.ind_compiled_set_id,
4253: 'N',ITEM.cost_distributed_flag), ITEM.cost_distributed_flag),

Line 4448: UPDATE pa_expenditure_items_all ITEM

4444:
4445: G_EXPENDITURE_ITEM_ID_TAB.DELETE; /*4527736*/
4446: G_ADJ_TYPE_TAB.DELETE; /*4527736*/
4447:
4448: UPDATE pa_expenditure_items_all ITEM
4449: SET ITEM.last_update_date = SYSDATE,
4450: ITEM.last_updated_by = x_last_updated_by,
4451: ITEM.last_update_login = x_last_update_login,
4452: ITEM.request_id = x_request_id,

Line 4635: UPDATE pa_expenditure_items_all ITEM

4631:
4632: G_EXPENDITURE_ITEM_ID_TAB.DELETE; /*4527736*/
4633: G_ADJ_TYPE_TAB.DELETE; /*4527736*/
4634:
4635: UPDATE pa_expenditure_items_all ITEM
4636: SET ITEM.revenue_distributed_flag = 'N',
4637: ITEM.last_update_date = SYSDATE,
4638: ITEM.last_updated_by = x_last_updated_by,
4639: ITEM.last_update_login = x_last_update_login,

Line 4841: -- PA_EXPENDITURE_ITEMS_ALL instead of PA_EXPENDITURE_ITEMS to support

4837:
4838: -- Cursor definition
4839:
4840: -- The following cursor definitions were changed to select from
4841: -- PA_EXPENDITURE_ITEMS_ALL instead of PA_EXPENDITURE_ITEMS to support
4842: -- a multi-org implementation where expenditure items may span across
4843: -- operating units.
4844:
4845: -- Modifying the statement to exclude closed project items as well as

Line 4854: FROM pa_expenditure_items_all ei

4850: --
4851: CURSOR ei1_cursor
4852: IS
4853: SELECT expenditure_item_id
4854: FROM pa_expenditure_items_all ei
4855: WHERE cost_ind_compiled_set_id = compiled_set_id
4856: AND EXISTS
4857: (SELECT task_id
4858: FROM pa_tasks task

Line 4876: FROM pa_expenditure_items_all ei

4872:
4873: CURSOR ei2_cursor
4874: IS
4875: SELECT expenditure_item_id
4876: FROM pa_expenditure_items_all ei
4877: WHERE rev_ind_compiled_set_id = compiled_set_id
4878: AND EXISTS
4879: (SELECT task_id
4880: FROM pa_tasks task

Line 4898: FROM pa_expenditure_items_all ei

4894:
4895: CURSOR ei3_cursor
4896: IS
4897: SELECT expenditure_item_id
4898: FROM pa_expenditure_items_all ei
4899: WHERE inv_ind_compiled_set_id = compiled_set_id
4900: AND EXISTS
4901: (SELECT task_id
4902: FROM pa_tasks task

Line 4921: FROM pa_expenditure_items_all ei

4917:
4918: CURSOR ei4_cursor
4919: IS
4920: SELECT expenditure_item_id
4921: FROM pa_expenditure_items_all ei
4922: WHERE cost_ind_compiled_set_id = compiled_set_id
4923: AND expenditure_item_date BETWEEN --Bug 5917245 Removed TRUNC
4924: l_start_date AND
4925: NVL(l_end_date, expenditure_item_date)

Line 4945: FROM pa_expenditure_items_all ei

4941:
4942: CURSOR ei5_cursor
4943: IS
4944: SELECT expenditure_item_id
4945: FROM pa_expenditure_items_all ei
4946: WHERE rev_ind_compiled_set_id = compiled_set_id
4947: AND expenditure_item_date BETWEEN --Bug 5917245 Removed TRUNC
4948: l_start_date AND
4949: NVL(l_end_date, expenditure_item_date)

Line 4969: FROM pa_expenditure_items_all ei

4965:
4966: CURSOR ei6_cursor
4967: IS
4968: SELECT expenditure_item_id
4969: FROM pa_expenditure_items_all ei
4970: WHERE inv_ind_compiled_set_id = compiled_set_id
4971: AND expenditure_item_date BETWEEN --Bug 5917245 Removed TRUNC
4972: l_start_date AND
4973: NVL(l_end_date, expenditure_item_date)

Line 4993: FROM pa_expenditure_items_all ei

4989:
4990: CURSOR ei7_cursor
4991: IS
4992: SELECT expenditure_item_id
4993: FROM pa_expenditure_items_all ei
4994: WHERE cost_ind_compiled_set_id = compiled_set_id
4995: AND expenditure_item_date BETWEEN --Bug 5917245 removed TRUNC
4996: l_start_date AND NVL(l_end_date, expenditure_item_date)
4997: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'

Line 5010: FROM pa_expenditure_items_all ei

5006:
5007: CURSOR ei8_cursor
5008: IS
5009: SELECT expenditure_item_id
5010: FROM pa_expenditure_items_all ei
5011: WHERE rev_ind_compiled_set_id = compiled_set_id
5012: AND expenditure_item_date BETWEEN --Bug 5917245 Removed TRUNC
5013: l_start_date AND
5014: NVL(l_end_date, expenditure_item_date)

Line 5028: FROM pa_expenditure_items_all ei

5024:
5025: CURSOR ei9_cursor
5026: IS
5027: SELECT expenditure_item_id
5028: FROM pa_expenditure_items_all ei
5029: WHERE inv_ind_compiled_set_id = compiled_set_id
5030: AND expenditure_item_date BETWEEN --Bug 5917245 Removed TRUNC
5031: l_start_date AND
5032: NVL(l_end_date, expenditure_item_date)

Line 5046: FROM pa_expenditure_items_all ei

5042:
5043: CURSOR ei10_cursor
5044: IS
5045: SELECT expenditure_item_id
5046: FROM pa_expenditure_items_all ei
5047: WHERE cost_ind_compiled_set_id = compiled_set_id
5048: AND EXISTS
5049: (SELECT t1.task_id
5050: FROM pa_project_types_all pt,

Line 5076: FROM pa_expenditure_items_all ei

5072:
5073: CURSOR ei11_cursor
5074: IS
5075: SELECT expenditure_item_id
5076: FROM pa_expenditure_items_all ei
5077: WHERE cost_ind_compiled_set_id = compiled_set_id
5078: AND expenditure_item_date BETWEEN --Bug 5917245 Removed TRUNC
5079: l_start_date AND
5080: NVL(l_end_date, expenditure_item_date)

Line 5107: FROM pa_expenditure_items_all ei

5103:
5104: CURSOR ei12_cursor
5105: IS
5106: SELECT expenditure_item_id
5107: FROM pa_expenditure_items_all ei
5108: WHERE cost_ind_compiled_set_id = compiled_set_id
5109: AND expenditure_item_date BETWEEN --Bug 5917245 Removed TRUNC
5110: l_start_date AND
5111: NVL(l_end_date, expenditure_item_date)

Line 5147: FROM pa_expenditure_items_all ei,

5143: /*
5144: CURSOR ei13_cursor
5145: IS
5146: SELECT expenditure_item_id
5147: FROM pa_expenditure_items_all ei,
5148: pa_system_linkages syslink,
5149: pa_tasks task,
5150: pa_projects_all proj
5151: WHERE ei.tp_ind_compiled_set_id = compiled_set_id

Line 5175: FROM PA_EXPENDITURE_ITEMS_ALL EI

5171: /*Bug# 2164590:Changed ei13_cursor for performance*/
5172: CURSOR ei13_cursor
5173: IS
5174: SELECT EXPENDITURE_ITEM_ID
5175: FROM PA_EXPENDITURE_ITEMS_ALL EI
5176: WHERE tp_ind_compiled_set_id = compiled_set_id
5177: AND EXISTS
5178: (SELECT task_id
5179: FROM pa_tasks task, pa_system_linkages syslink /*2933915 : ,pa_projects_all proj :Join with pa_projects is not required here */

Line 5200: FROM pa_expenditure_items_all ei

5196:
5197: CURSOR ei14_cursor
5198: IS
5199: SELECT expenditure_item_id
5200: FROM pa_expenditure_items_all ei
5201: /* pa_tasks task -- Commented for Bug#3585192 */
5202: /* pa_projects_all proj :2933915 :Redundant join and hence can be removed */
5203: WHERE tp_ind_compiled_set_id = compiled_set_id
5204: AND ei.expenditure_item_date BETWEEN --Bug 5917245 Removed TRUNC

Line 5290: UPDATE pa_expenditure_items_all ei

5286: /***Bug 2933915 : Added the exists clause in this update to indicate that except profile ='Y' and display_method ='D' -for all
5287: cases we will be marking ei for cost reprocessing */
5288: /*If Burdening is on same ei then update adjustment_type as BURDEN_COMPILE else update it as BURDEN_RESUMMARIZE .*/
5289:
5290: UPDATE pa_expenditure_items_all ei
5291: SET cost_distributed_flag = 'N',
5292: adjustment_type ='BURDEN_RECOMPILE', /*2933915*/
5293: cost_burden_distributed_flag = 'N',
5294: last_update_date = SYSDATE,

Line 5383: UPDATE pa_expenditure_items_all ei

5379: -- (09/17/98)
5380: --
5381: -- Added Nvl for net_zero_adjustment_flag (896190)
5382: --
5383: UPDATE pa_expenditure_items_all ei
5384: SET revenue_distributed_flag = 'N',
5385: last_update_date = SYSDATE,
5386: last_updated_by = x_last_updated_by,
5387: last_update_login = x_last_update_login,

Line 5451: UPDATE pa_expenditure_items_all ei

5447: --
5448: -- Added Nvl for net_zero_adjustment_flag (896190)
5449: --
5450:
5451: UPDATE pa_expenditure_items_all ei
5452: SET revenue_distributed_flag = 'N',
5453: last_update_date = SYSDATE,
5454: last_updated_by = x_last_updated_by,
5455: last_update_login = x_last_update_login,

Line 5517: UPDATE pa_expenditure_items_all ei

5513: -- Section For Capital Projects
5514: --
5515: -- This section is added as a part of fix for bug 897479.
5516: --
5517: UPDATE pa_expenditure_items_all ei
5518: SET revenue_distributed_flag = 'N',
5519: last_update_date = SYSDATE,
5520: last_updated_by = x_last_updated_by,
5521: last_update_login = x_last_update_login,

Line 5603: UPDATE pa_expenditure_items_all ei

5599: --
5600: -- Added Nvl for net_zero_adjustment_flag (896190)
5601: -- ---------------------------------------------------------------------
5602: /* Updating Project_Burdened_Cost also for Bug 2736773 */
5603: UPDATE pa_expenditure_items_all ei
5604: SET cost_distributed_flag = 'N' ,
5605: adjustment_type ='BURDEN_RECOMPILE', /*2933915*/
5606: cost_burden_distributed_flag = 'N',
5607: last_update_date = SYSDATE,

Line 5694: UPDATE pa_expenditure_items_all ei

5690: --
5691: -- Added Nvl for net_zero_adjustment_flag (896190)
5692: --
5693:
5694: UPDATE pa_expenditure_items_all ei
5695: SET revenue_distributed_flag = 'N',
5696: last_update_date = SYSDATE,
5697: last_updated_by = x_last_updated_by,
5698: last_update_login = x_last_update_login,

Line 5762: UPDATE pa_expenditure_items_all ei

5758: -- (09/17/98)
5759: --
5760: -- Added Nvl for net_zero_adjustment_flag (896190)
5761: --
5762: UPDATE pa_expenditure_items_all ei
5763: SET revenue_distributed_flag = 'N',
5764: last_update_date = SYSDATE,
5765: last_updated_by = x_last_updated_by,
5766: last_update_login = x_last_update_login,

Line 5834: UPDATE pa_expenditure_items_all ei

5830: --
5831:
5832: IF l_end_date IS NOT NULL THEN
5833:
5834: UPDATE pa_expenditure_items_all ei
5835: SET revenue_distributed_flag = 'N',
5836: last_update_date = SYSDATE,
5837: last_updated_by = x_last_updated_by,
5838: last_update_login = x_last_update_login,

Line 5870: UPDATE pa_expenditure_items_all ei

5866: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5867: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5868:
5869: ELSE
5870: UPDATE pa_expenditure_items_all ei
5871: SET revenue_distributed_flag = 'N',
5872: last_update_date = SYSDATE,
5873: last_updated_by = x_last_updated_by,
5874: last_update_login = x_last_update_login,

Line 5954: UPDATE pa_expenditure_items_all ei

5950: /*
5951: * Bug 4885396 : Moved 3 EI based checks from Exists subquery to the
5952: * main query.
5953: */
5954: UPDATE pa_expenditure_items_all ei
5955: SET cc_bl_distributed_code =
5956: decode( cc_cross_charge_code,'B',
5957: 'N',
5958: cc_bl_distributed_code),

Line 6043: UPDATE pa_expenditure_items_all ITEM

6039:
6040: /* Changes for bug 8282545 start here */
6041:
6042: /* When fixed date is NULL */
6043: UPDATE pa_expenditure_items_all ITEM
6044: SET ITEM.adjustment_type = decode(ITEM.cost_ind_compiled_set_id, compiled_set_id, 'BURDEN_RESUMMARIZE' ,ITEM.adjustment_type)
6045: WHERE ITEM.cost_distributed_flag ='Y'
6046: AND ITEM.adjustment_type IS NULL
6047: AND exists ( select 1 from pa_cost_distribution_lines_all cdl

Line 6071: UPDATE pa_expenditure_items_all ITEM

6067: COMMIT;
6068:
6069: /* When fixed date is NOT NULL */
6070:
6071: UPDATE pa_expenditure_items_all ITEM
6072: SET ITEM.adjustment_type = decode(ITEM.cost_ind_compiled_set_id, compiled_set_id, 'BURDEN_RESUMMARIZE' ,ITEM.adjustment_type)
6073: WHERE ITEM.cost_distributed_flag ='Y'
6074: AND ITEM.adjustment_type IS NULL
6075: AND exists ( select 1 from pa_cost_distribution_lines_all cdl

Line 6118: UPDATE pa_expenditure_items_all ei

6114: /* Updating Project_Burdened_Cost also for Bug 2736773 */
6115:
6116: if l_end_date is NOT NULL THEN
6117:
6118: UPDATE pa_expenditure_items_all ei
6119: SET cost_distributed_flag = 'N' ,
6120: adjustment_type ='BURDEN_RECOMPILE',
6121: cost_burden_distributed_flag = 'N',
6122: last_update_date = SYSDATE,

Line 6150: UPDATE pa_expenditure_items_all ei

6146: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s') AND l_burden_profile ='Y'))
6147: AND ( l_gms_enabled = 'N' OR gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' ) ;
6148:
6149: else
6150: UPDATE pa_expenditure_items_all ei
6151: SET cost_distributed_flag = 'N' ,
6152: adjustment_type ='BURDEN_RECOMPILE',
6153: cost_burden_distributed_flag = 'N',
6154: last_update_date = SYSDATE,

Line 6238: UPDATE pa_expenditure_items_all ei

6234: -- Added Nvl for net_zero_adjustment_flag (896190)
6235: --
6236: -- Split the update into 2 seperate statements and added l_gms_enabled check for perf issue 9266246
6237: /* 9266246 - Start */
6238: UPDATE pa_expenditure_items_all ei
6239: SET revenue_distributed_flag = 'N',
6240: last_update_date = SYSDATE,
6241: last_updated_by = x_last_updated_by,
6242: last_update_login = x_last_update_login,

Line 6262: UPDATE pa_expenditure_items_all ei

6258: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/
6259: AND (l_gms_enabled = 'N' OR gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' ) ;
6260:
6261:
6262: UPDATE pa_expenditure_items_all ei
6263: SET revenue_distributed_flag = 'N',
6264: last_update_date = SYSDATE,
6265: last_updated_by = x_last_updated_by,
6266: last_update_login = x_last_update_login,

Line 6351: UPDATE pa_expenditure_items_all ei

6347: --
6348: --
6349:
6350: IF l_end_date IS NOT NULL THEN
6351: UPDATE pa_expenditure_items_all ei
6352: SET revenue_distributed_flag = 'N',
6353: last_update_date = SYSDATE,
6354: last_updated_by = x_last_updated_by,
6355: last_update_login = x_last_update_login,

Line 6387: UPDATE pa_expenditure_items_all ei

6383: -- consider volume of expenditure items having the same compiled set id
6384: COMMIT;
6385:
6386: ELSE
6387: UPDATE pa_expenditure_items_all ei
6388: SET revenue_distributed_flag = 'N',
6389: last_update_date = SYSDATE,
6390: last_updated_by = x_last_updated_by,
6391: last_update_login = x_last_update_login,

Line 6460: UPDATE pa_expenditure_items_all ei

6456: * updates and activity logging done for TP schedule change.
6457: * Note: explain plan is fine in RBO, cant test it in CBO because of
6458: * non-availability of volume data.
6459: */
6460: UPDATE pa_expenditure_items_all ei
6461: SET cc_bl_distributed_code =
6462: decode( cc_cross_charge_code,'B',
6463: 'N',
6464: cc_bl_distributed_code),

Line 6512: UPDATE pa_expenditure_items_all ITEM

6508: | M - If Enhanced Burdening is SET, for Separate line burdening |
6509: | transactions the adjustment_type is set to BURDEN_RESUMMARIZE |
6510: | - if cost_distributed_flag is Y. |
6511: +====================================================================*/
6512: UPDATE pa_expenditure_items_all ITEM
6513: SET ITEM.adjustment_type = decode(ITEM.cost_ind_compiled_set_id, compiled_set_id, 'BURDEN_RESUMMARIZE' ,ITEM.adjustment_type)
6514: WHERE ITEM.cost_distributed_flag ='Y'
6515: AND ITEM.adjustment_type IS NULL
6516: AND exists ( select 1 from pa_cost_distribution_lines_all cdl

Line 6627: FROM pa_expenditure_items_all ITEM

6623:
6624: CURSOR ei_cost_cursor
6625: IS
6626: SELECT expenditure_item_id
6627: FROM pa_expenditure_items_all ITEM
6628: WHERE cost_ind_compiled_set_id = compiled_set_id
6629: AND adjustment_type in ('BURDEN_RECOMPILE','BURDEN_RESUMMARIZE','RECALC_BURDEN')
6630: AND request_id = x_request_id
6631: AND EXISTS (SELECT NULL

Line 6643: FROM pa_expenditure_items_all ITEM

6639:
6640: CURSOR ei_rev_cursor
6641: IS
6642: SELECT expenditure_item_id
6643: FROM pa_expenditure_items_all ITEM
6644: WHERE rev_ind_compiled_set_id = compiled_set_id
6645: AND request_id = x_request_id
6646: AND EXISTS (SELECT NULL
6647: FROM pa_cost_base_exp_types cbet

Line 6658: FROM pa_expenditure_items_all ITEM

6654:
6655: CURSOR ei_inv_cursor
6656: IS
6657: SELECT expenditure_item_id
6658: FROM pa_expenditure_items_all ITEM
6659: WHERE inv_ind_compiled_set_id = compiled_set_id
6660: AND request_id = x_request_id
6661: AND EXISTS (SELECT NULL
6662: FROM pa_cost_base_exp_types cbet

Line 6677: FROM pa_expenditure_items_all ITEM

6673: /* Commented for bug 4527736
6674: CURSOR ei_tp_cursor
6675: IS
6676: SELECT expenditure_item_id
6677: FROM pa_expenditure_items_all ITEM
6678: WHERE tp_ind_compiled_set_id = compiled_set_id
6679: AND request_id = x_request_id
6680: AND EXISTS (SELECT NULL
6681: FROM pa_cost_base_exp_types cbet