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_PROJECT_ASSET_LINE_DETAILS

Line 507: -- This procedure updates the pa_project_asset_line_details

503: x_err_code := SQLCODE;
504: RAISE;
505: END check_proj_asset_lines;
506:
507: -- This procedure updates the pa_project_asset_line_details
508: -- when all the project asset lines for a detail_line_id
509: -- are reversed then the detail itself are marked as reversed
510:
511: PROCEDURE update_line_details

Line 522: pa_project_asset_line_details

518: x_err_code := 0;
519: x_err_stage := 'Updating the detail lines';
520:
521: UPDATE
522: pa_project_asset_line_details
523: SET
524: reversed_flag = 'Y',
525: last_update_date = sysdate,
526: last_updated_by = x_last_updated_by,

Line 569: pa_project_asset_line_details pald

565: pei.expenditure_item_id IN
566: ( SELECT
567: expenditure_item_id
568: FROM
569: pa_project_asset_line_details pald
570: WHERE
571: project_asset_line_detail_id =
572: x_proj_asset_line_detail_id
573: GROUP BY expenditure_item_id

Line 1081: -- pa_project_asset_line_details as reversed

1077:
1078: END LOOP; --- FOR assetlinerec IN selprojassetlines .....
1079:
1080: -- If the cdl_fully_reversible is true then mark all the
1081: -- pa_project_asset_line_details as reversed
1082: -- and update the cip_cost to Zero
1083:
1084: IF ( cdl_fully_reversible ) THEN
1085:

Line 1238: pa_project_asset_line_Details det

1234: where ei.revenue_distributed_flag = 'N'
1235: and ei.capital_event_id = -1
1236: and EXISTS
1237: (select 1 from pa_project_asset_lines_all lines,
1238: pa_project_asset_line_Details det
1239: where lines.project_id=ei.project_id
1240: and det.expenditure_item_id= ei.expenditure_item_id
1241: and det.REVERSED_FLAG='N'
1242: and lines.project_asset_line_detail_id = det.project_asset_line_detail_id

Line 1247: pa_project_asset_line_details

1243: and lines.project_asset_line_detail_id =x_project_asset_line_detail_id
1244: );
1245:
1246: DELETE
1247: pa_project_asset_line_details
1248: WHERE
1249: project_asset_line_detail_id = x_project_asset_line_detail_id;
1250:
1251:

Line 1304: FROM pa_project_asset_line_details pald

1300: GROUP BY pal.project_asset_line_detail_id
1301: HAVING SUM(current_asset_cost) =
1302: ( SELECT
1303: SUM(cip_cost)
1304: FROM pa_project_asset_line_details pald
1305: WHERE pald.project_asset_line_detail_id = pal.project_asset_line_detail_id
1306: )
1307: )
1308: ORDER BY ppal.project_asset_line_detail_id;

Line 1418: INSERT INTO pa_project_asset_line_details(

1414: SELECT pa_proj_asset_line_dtls_uniq_s.nextval
1415: INTO l_proj_asset_line_dtl_uniq_id
1416: FROM sys.dual;
1417:
1418: INSERT INTO pa_project_asset_line_details(
1419: proj_asset_line_dtl_uniq_id,
1420: expenditure_item_id,
1421: line_num,
1422: project_asset_line_detail_id,

Line 1899: FROM PA_PROJECT_ASSET_LINE_DETAILS PALD1

1895: AND ((CDL2.line_type = 'I' and CDL2.transfer_status_code = 'G') OR
1896: CDL2.line_type in ('R', 'D') and CDL2.transfer_status_code in ('V', 'A')) /*Added for bug 11935501 */ /* Added for Bug 7445771 */
1897: /* Start: Added for Bug 14852040 */
1898: AND NOT EXISTS (SELECT NULL
1899: FROM PA_PROJECT_ASSET_LINE_DETAILS PALD1
1900: WHERE PALD1.EXPENDITURE_ITEM_ID = CDL2.EXPENDITURE_ITEM_ID
1901: AND PALD1.LINE_NUM = CDL2.LINE_NUM
1902: AND PALD1.REVERSED_FLAG ||'' = 'N')
1903: /* End: Added for Bug 14852040 */

Line 1925: FROM PA_PROJECT_ASSET_LINE_DETAILS PALD1

1921: AND ((CDL2.line_type = 'I' and CDL2.transfer_status_code = 'G') OR
1922: CDL2.line_type in ('R', 'D') and CDL2.transfer_status_code in ('V', 'A')) /*Added for bug 11935501 */ /* Added for Bug 7445771 */
1923: /* To check if the reversed CDL has been capitalized*/
1924: AND NOT EXISTS (SELECT NULL
1925: FROM PA_PROJECT_ASSET_LINE_DETAILS PALD1
1926: WHERE PALD1.EXPENDITURE_ITEM_ID = CDL1.EXPENDITURE_ITEM_ID
1927: AND PALD1.LINE_NUM = CDL1.LINE_NUM
1928: AND PALD1.REVERSED_FLAG ||'' = 'N')
1929: UNION ALL

Line 1937: FROM PA_PROJECT_ASSET_LINE_DETAILS PALD2

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
1937: FROM PA_PROJECT_ASSET_LINE_DETAILS PALD2
1938: WHERE PALD2.EXPENDITURE_ITEM_ID =
1939: DECODE(EI1.ADJUSTED_EXPENDITURE_ITEM_ID,NULL,- 99,
1940: EI1.ADJUSTED_EXPENDITURE_ITEM_ID)
1941: AND PALD2.REVERSED_FLAG ||'' = 'N')

Line 1949: FROM PA_PROJECT_ASSET_LINE_DETAILS PALD2,

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
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

Line 1957: FROM PA_PROJECT_ASSET_LINE_DETAILS PALD3

1953: AND PALD2.EXPENDITURE_ITEM_ID = EI2.EXPENDITURE_ITEM_ID
1954: AND PALD2.REVERSED_FLAG||'' = 'N')
1955: -- Start: Changes for bug 14530008
1956: AND NOT EXISTS (SELECT NULL
1957: FROM PA_PROJECT_ASSET_LINE_DETAILS PALD3
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

Line 1977: FROM PA_PROJECT_ASSET_LINE_DETAILS PALD2

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
1977: FROM PA_PROJECT_ASSET_LINE_DETAILS PALD2
1978: WHERE PALD2.EXPENDITURE_ITEM_ID = EI1.ADJUSTED_EXPENDITURE_ITEM_ID
1979: AND PALD2.REVERSED_FLAG||'' = 'N')
1980: AND EXISTS (SELECT 1
1981: FROM PA_COST_DISTRIBUTION_LINES_ALL PCDL2

Line 2085: pa_project_asset_line_details pald

2081: (
2082: SELECT
2083: 'This CDL was summarized before'
2084: FROM
2085: pa_project_asset_line_details pald
2086: WHERE
2087: pald.expenditure_item_id = pcdl.expenditure_item_id
2088: AND pald.line_num = pcdl.line_num
2089: AND pald.reversed_flag||'' = 'N'

Line 3723: from pa_project_asset_line_details d,

3719: -- R12 changes. Table pa_gl_interface is obsolete. This check is left for
3720: -- asset lines which are not yet interfaced to FA before uptake of R12.
3721: CURSOR un_gl_xferred_cdls (x_detail_id IN NUMBER) IS
3722: select 'X'
3723: from pa_project_asset_line_details d,
3724: pa_cost_distribution_lines_all cdl
3725: where d.PROJECT_ASSET_LINE_DETAIL_ID = x_detail_id and
3726: d.expenditure_item_id = cdl.expenditure_item_id and
3727: d.line_num = cdl.line_num and

Line 5738: from pa_project_asset_line_details d,

5734: -- R12 changes. Table pa_gl_interface is obsolete. This check is left for
5735: -- asset lines which are not yet interfaced to FA before uptake of R12.
5736: CURSOR un_gl_xferred_cdls (x_detail_id IN NUMBER) IS
5737: select 'X'
5738: from pa_project_asset_line_details d,
5739: pa_cost_distribution_lines_all cdl
5740: where d.PROJECT_ASSET_LINE_DETAIL_ID = x_detail_id and
5741: d.expenditure_item_id = cdl.expenditure_item_id and
5742: d.line_num = cdl.line_num and

Line 6068: PA_PROJECT_ASSET_LINE_DETAILS DET

6064: AND EXISTS
6065: (
6066: SELECT 1
6067: FROM PA_PROJECT_ASSET_LINES_ALL LINES,
6068: PA_PROJECT_ASSET_LINE_DETAILS DET
6069: WHERE Det.expenditure_item_id = cdl.expenditure_item_id
6070: AND DET.LINE_NUM = CDL.LINE_NUM_REVERSED
6071: AND lines.transfer_status_code = 'T'
6072: AND det.project_asset_line_detail_id = lines.project_asset_line_detail_id

Line 6076: pa_project_asset_line_details det

6072: AND det.project_asset_line_detail_id = lines.project_asset_line_detail_id
6073: AND NOT EXISTS
6074: (SELECT NULL
6075: FROM pa_project_asset_lines_all lines,
6076: pa_project_asset_line_details det
6077: WHERE det.expenditure_item_id = cdl.expenditure_item_id
6078: AND det.line_num = cdl.line_num
6079: AND lines.transfer_status_code = 'T'
6080: AND det.project_asset_line_detail_id = lines.project_asset_line_detail_id