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

Line 554: pa_expenditure_items_all pei

550: x_err_code := 0;
551: x_err_stage := 'Updating the expenditure_items';
552:
553: UPDATE
554: pa_expenditure_items_all pei
555: SET
556: revenue_distributed_flag = x_revenue_distributed_flag,
557: last_update_date = sysdate,
558: last_updated_by = x_last_updated_by,

Line 1232: update pa_expenditure_items_all ei

1228: x_err_code := 0;
1229: x_err_stage := 'Deleting the project asset line details';
1230:
1231: /*Added by Bug 9279069 */ /*Added join condition for lines and details for bug 13652513 */
1232: update pa_expenditure_items_all ei
1233: set ei.capital_event_id = null
1234: where ei.revenue_distributed_flag = 'N'
1235: and ei.capital_event_id = -1
1236: and EXISTS

Line 1857: pa_expenditure_items_all pei,

1853: --pa_xla_interface_pkg.get_source(pei.transaction_source, pei.document_payment_id) transaction_source
1854:
1855: FROM
1856: pa_cost_distribution_lines_all pcdl,
1857: pa_expenditure_items_all pei,
1858: pa_expenditure_types pet,
1859: pa_tasks pt
1860: WHERE
1861: pcdl.expenditure_item_id = pei.expenditure_item_id

Line 1932: FROM PA_EXPENDITURE_ITEMS_ALL EI1

1928: AND PALD1.REVERSED_FLAG ||'' = 'N')
1929: UNION ALL
1930: /* For ei adjustment e.g. transfer from cap to expense task
1931: SELECT NULL
1932: FROM PA_EXPENDITURE_ITEMS_ALL EI1
1933: WHERE EI1.EXPENDITURE_ITEM_ID = PEI.EXPENDITURE_ITEM_ID
1934: AND EI1.NET_ZERO_ADJUSTMENT_FLAG = 'Y'
1935: /* checking if the adjusted ei has already been capitalized
1936: AND NOT EXISTS (SELECT NULL

Line 1944: FROM PA_EXPENDITURE_ITEMS_ALL EI1

1940: EI1.ADJUSTED_EXPENDITURE_ITEM_ID)
1941: AND PALD2.REVERSED_FLAG ||'' = 'N')
1942: Commented the above code and added below two selects for Bug 7445771 */
1943: SELECT NULL
1944: FROM PA_EXPENDITURE_ITEMS_ALL EI1
1945: WHERE EI1.EXPENDITURE_ITEM_ID = PEI.EXPENDITURE_ITEM_ID
1946: AND EI1.NET_ZERO_ADJUSTMENT_FLAG = 'Y'
1947: AND EI1.ADJUSTED_EXPENDITURE_ITEM_ID IS NULL
1948: AND NOT EXISTS (SELECT NULL

Line 1950: PA_EXPENDITURE_ITEMS_ALL EI2

1946: AND EI1.NET_ZERO_ADJUSTMENT_FLAG = 'Y'
1947: AND EI1.ADJUSTED_EXPENDITURE_ITEM_ID IS NULL
1948: AND NOT EXISTS (SELECT NULL
1949: FROM PA_PROJECT_ASSET_LINE_DETAILS PALD2,
1950: PA_EXPENDITURE_ITEMS_ALL EI2
1951: WHERE EI2.ADJUSTED_EXPENDITURE_ITEM_ID = EI1.EXPENDITURE_ITEM_ID
1952: --AND PALD2.EXPENDITURE_ITEM_ID = EI2.ADJUSTED_EXPENDITURE_ITEM_ID for bug 9776526
1953: AND PALD2.EXPENDITURE_ITEM_ID = EI2.EXPENDITURE_ITEM_ID
1954: AND PALD2.REVERSED_FLAG||'' = 'N')

Line 1962: FROM PA_EXPENDITURE_ITEMS_ALL EI3,

1958: WHERE PALD3.EXPENDITURE_ITEM_ID = EI1.EXPENDITURE_ITEM_ID
1959: AND PALD3.REVERSED_FLAG||'' = 'N')
1960: -- End: Changes for bug 14530008
1961: AND EXISTS (SELECT 1
1962: FROM PA_EXPENDITURE_ITEMS_ALL EI3,
1963: PA_COST_DISTRIBUTION_LINES_ALL PCDL2
1964: WHERE EI3.ADJUSTED_EXPENDITURE_ITEM_ID = EI1.EXPENDITURE_ITEM_ID
1965: AND EI3.EXPENDITURE_ITEM_ID = PCDL2.EXPENDITURE_ITEM_ID
1966: AND TRUNC(PCDL2.PA_DATE) <= TRUNC(P_PA_THROUGH_DATE)

Line 1972: FROM PA_EXPENDITURE_ITEMS_ALL EI1

1968: AND ((PCDL2.line_type = 'I' and PCDL2.transfer_status_code = 'G') OR
1969: PCDL2.line_type in ('R', 'D') and PCDL2.transfer_status_code in ('V', 'A'))) /*Added for bug 11935501 */
1970: UNION ALL
1971: SELECT NULL
1972: FROM PA_EXPENDITURE_ITEMS_ALL EI1
1973: WHERE EI1.EXPENDITURE_ITEM_ID = PEI.EXPENDITURE_ITEM_ID
1974: AND EI1.NET_ZERO_ADJUSTMENT_FLAG = 'Y'
1975: AND EI1.ADJUSTED_EXPENDITURE_ITEM_ID IS NOT NULL
1976: AND NOT EXISTS (SELECT NULL

Line 2002: AND EXISTS(select NULL from pa_expenditure_items_all ei1

1998: AND pt.project_id =p_project_id
1999: /*start of change for bug 6037734*/
2000: AND (pa_nl_installed.is_nl_installed='N'
2001: OR (pa_nl_installed.is_nl_installed='Y'
2002: AND EXISTS(select NULL from pa_expenditure_items_all ei1
2003: where ei1.expenditure_item_id = pei.expenditure_item_id
2004: and (ei1.attribute6 is not null OR ei1.attribute7 is not null OR ei1.attribute8 is not null
2005: OR ei1.attribute9 is not null OR ei1.attribute10 is not null)
2006: )

Line 2007: AND NOT EXISTS (select null from pa_expenditure_items_all ei2

2003: where ei1.expenditure_item_id = pei.expenditure_item_id
2004: and (ei1.attribute6 is not null OR ei1.attribute7 is not null OR ei1.attribute8 is not null
2005: OR ei1.attribute9 is not null OR ei1.attribute10 is not null)
2006: )
2007: AND NOT EXISTS (select null from pa_expenditure_items_all ei2
2008: where ei2.expenditure_item_id = pei.expenditure_item_id
2009: and ei2.attribute8 is NULL
2010: and ei2.attribute9 is NULL
2011: )

Line 2014: AND EXISTS(select null from pa_expenditure_items_all ei3

2010: and ei2.attribute9 is NULL
2011: )
2012: )
2013: OR (pa_nl_installed.is_nl_installed='Y'
2014: AND EXISTS(select null from pa_expenditure_items_all ei3
2015: where ei3.expenditure_item_id = pei.expenditure_item_id
2016: and ei3.attribute6 is NULL
2017: and ei3.attribute7 is NULL
2018: and ei3.attribute8 is NULL

Line 2115: curr_nlr pa_expenditure_items_all.non_labor_resource%TYPE;

2111: l_asset_id NUMBER;
2112: l_num_asset_assignment NUMBER;
2113: curr_ccid NUMBER;
2114: prev_ccid NUMBER;
2115: curr_nlr pa_expenditure_items_all.non_labor_resource%TYPE;
2116: prev_nlr pa_expenditure_items_all.non_labor_resource%TYPE;
2117: curr_expend_type VARCHAR2(100);
2118: prev_expend_type VARCHAR2(100);
2119: curr_expend_cat VARCHAR2(100);

Line 2116: prev_nlr pa_expenditure_items_all.non_labor_resource%TYPE;

2112: l_num_asset_assignment NUMBER;
2113: curr_ccid NUMBER;
2114: prev_ccid NUMBER;
2115: curr_nlr pa_expenditure_items_all.non_labor_resource%TYPE;
2116: prev_nlr pa_expenditure_items_all.non_labor_resource%TYPE;
2117: curr_expend_type VARCHAR2(100);
2118: prev_expend_type VARCHAR2(100);
2119: curr_expend_cat VARCHAR2(100);
2120: curr_grouping_method VARCHAR2(255);

Line 2131: prev_sys_link_fun pa_expenditure_items_all.system_linkage_function%TYPE;

2127: prev_asset_cost NUMBER;
2128: proj_asset_line_detail_id NUMBER;
2129: description pa_project_asset_lines.description%TYPE;
2130: depreciation_expense_ccid NUMBER;
2131: prev_sys_link_fun pa_expenditure_items_all.system_linkage_function%TYPE;
2132:
2133: curr_employee_id po_vendors.employee_id%type;
2134: curr_invoice_num ap_invoices.invoice_num%TYPE;
2135: curr_vendor_number po_vendors.segment1%TYPE;

Line 4459: pa_expenditure_items_all pei,

4455: /* removed this logic from this cursor and added function is_project_eligible for this logic
4456: Change done for bug 1280252.
4457: and ( exists (select 'x' -- project has costed,uncapitalized expenditure items
4458: from pa_cost_distribution_lines_all pcdl,
4459: pa_expenditure_items_all pei,
4460: pa_tasks pat
4461: where pcdl.expenditure_item_id = pei.expenditure_item_id
4462: and pei.revenue_distributed_flag||'' = 'N'
4463: and pei.cost_distributed_flag ='Y'

Line 5381: pa_expenditure_items_all pei,

5377: SELECT 1 INTO dummy
5378: FROM dual
5379: WHERE EXISTS (SELECT 'x' -- project has costed,uncapitalized expenditure items
5380: FROM pa_cost_distribution_lines_all pcdl,
5381: pa_expenditure_items_all pei,
5382: pa_tasks pat,
5383: pa_projects pp,
5384: pa_project_types pt
5385: WHERE pcdl.expenditure_item_id = pei.expenditure_item_id

Line 5469: pa_expenditure_items_all pei,

5465: SELECT 1 INTO dummy
5466: FROM dual
5467: WHERE EXISTS (SELECT 'x' -- project has costed,uncapitalized Retirement Cost expenditure items
5468: FROM pa_cost_distribution_lines_all pcdl,
5469: pa_expenditure_items_all pei,
5470: pa_tasks pat,
5471: pa_projects pp,
5472: pa_project_types pt
5473: WHERE pcdl.expenditure_item_id = pei.expenditure_item_id

Line 5520: pa_expenditure_items_all pei,

5516: SELECT 1 INTO dummy
5517: FROM dual
5518: WHERE EXISTS (SELECT 'x' -- project has costed,uncapitalized expenditure items
5519: FROM pa_cost_distribution_lines_all pcdl,
5520: pa_expenditure_items_all pei,
5521: --pa_tasks pat, /* bug fix :2830211 task_id is not reqd */
5522: pa_projects_all pp,
5523: pa_project_types pt
5524: WHERE pcdl.expenditure_item_id = pei.expenditure_item_id

Line 6047: UPDATE pa_expenditure_items_all EI

6043: AND capital_event_id IS NULL
6044: AND capital_hold_flag = 'N';
6045:
6046: --Update all capital Expenditure Items
6047: UPDATE pa_expenditure_items_all EI
6048: SET capital_event_id = -1,
6049: last_update_date = SYSDATE,
6050: last_updated_by = x_last_updated_by,
6051: last_update_login = x_last_update_login,

Line 6094: UPDATE pa_expenditure_items_all peia

6090: ));
6091:
6092:
6093: --Update all retirement cost Expenditure Items
6094: UPDATE pa_expenditure_items_all peia
6095: SET capital_event_id = -1,
6096: last_update_date = SYSDATE,
6097: last_updated_by = x_last_updated_by,
6098: last_update_login = x_last_update_login,

Line 6187: FROM pa_expenditure_items_all ei,

6183: nvl(pts.predefined_flag,'Y'), cdl.system_reference5, ei.document_distribution_id, ei.document_payment_id
6184: INTO l_line_type, l_transfer_status_code, l_acct_event_id, l_denom_raw_cost, l_exchange_rate_type, l_exchange_rate,
6185: l_acct_source_code, l_transaction_source, l_gl_date, l_denom_currency_code, l_historical_flag,
6186: l_predefined_flag , l_system_reference5, l_document_distribution_id, l_document_payment_id
6187: FROM pa_expenditure_items_all ei,
6188: pa_cost_distribution_lines_all cdl,
6189: pa_transaction_sources pts
6190: WHERE cdl.expenditure_item_id = x_expenditure_item_id
6191: AND cdl.line_num = x_line_num