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 480: -- This procedure updates the pa_project_asset_line_details

476: x_err_code := SQLCODE;
477: RAISE;
478: END check_proj_asset_lines;
479:
480: -- This procedure updates the pa_project_asset_line_details
481: -- when all the project asset lines for a detail_line_id
482: -- are reversed then the detail itself are marked as reversed
483:
484: PROCEDURE update_line_details

Line 495: pa_project_asset_line_details

491: x_err_code := 0;
492: x_err_stage := 'Updating the detail lines';
493:
494: UPDATE
495: pa_project_asset_line_details
496: SET
497: reversed_flag = 'Y',
498: last_update_date = sysdate,
499: last_updated_by = x_last_updated_by,

Line 542: pa_project_asset_line_details pald

538: pei.expenditure_item_id IN
539: ( SELECT
540: expenditure_item_id
541: FROM
542: pa_project_asset_line_details pald
543: WHERE
544: project_asset_line_detail_id =
545: x_proj_asset_line_detail_id
546: GROUP BY expenditure_item_id

Line 1023: -- pa_project_asset_line_details as reversed

1019:
1020: END LOOP; --- FOR assetlinerec IN selprojassetlines .....
1021:
1022: -- If the cdl_fully_reversible is true then mark all the
1023: -- pa_project_asset_line_details as reversed
1024: -- and update the cip_cost to Zero
1025:
1026: IF ( cdl_fully_reversible ) THEN
1027:

Line 1174: pa_project_asset_line_details

1170: x_err_code := 0;
1171: x_err_stage := 'Deleting the project asset line details';
1172:
1173: DELETE
1174: pa_project_asset_line_details
1175: WHERE
1176: project_asset_line_detail_id = x_project_asset_line_detail_id;
1177:
1178: IF l_mrc_flag = 'Y' THEN

Line 1226: FROM pa_project_asset_line_details pald

1222: GROUP BY pal.project_asset_line_detail_id
1223: HAVING SUM(current_asset_cost) =
1224: ( SELECT
1225: SUM(cip_cost)
1226: FROM pa_project_asset_line_details pald
1227: WHERE pald.project_asset_line_detail_id = pal.project_asset_line_detail_id
1228: )
1229: )
1230: ORDER BY ppal.project_asset_line_detail_id;

Line 1331: INSERT INTO pa_project_asset_line_details(

1327: SELECT pa_proj_asset_line_dtls_uniq_s.nextval
1328: INTO l_proj_asset_line_dtl_uniq_id
1329: FROM sys.dual;
1330:
1331: INSERT INTO pa_project_asset_line_details(
1332: proj_asset_line_dtl_uniq_id,
1333: expenditure_item_id,
1334: line_num,
1335: project_asset_line_detail_id,

Line 1702: FROM PA_PROJECT_ASSET_LINE_DETAILS PALD1

1698: AND CDL2.BILLABLE_FLAG = 'Y'
1699: AND TRUNC(CDL1.PA_DATE) <= TRUNC(P_PA_THROUGH_DATE) /* Added for Bug 7445771 */
1700: /* To check if the reversed CDL has been capitalized*/
1701: AND NOT EXISTS (SELECT NULL
1702: FROM PA_PROJECT_ASSET_LINE_DETAILS PALD1
1703: WHERE PALD1.EXPENDITURE_ITEM_ID = CDL1.EXPENDITURE_ITEM_ID
1704: AND PALD1.LINE_NUM = CDL1.LINE_NUM
1705: AND PALD1.REVERSED_FLAG ||'' = 'N')
1706: UNION ALL

Line 1714: FROM PA_PROJECT_ASSET_LINE_DETAILS PALD2

1710: WHERE EI1.EXPENDITURE_ITEM_ID = PEI.EXPENDITURE_ITEM_ID
1711: AND EI1.NET_ZERO_ADJUSTMENT_FLAG = 'Y'
1712: /* checking if the adjusted ei has already been capitalized
1713: AND NOT EXISTS (SELECT NULL
1714: FROM PA_PROJECT_ASSET_LINE_DETAILS PALD2
1715: WHERE PALD2.EXPENDITURE_ITEM_ID =
1716: DECODE(EI1.ADJUSTED_EXPENDITURE_ITEM_ID,NULL,- 99,
1717: EI1.ADJUSTED_EXPENDITURE_ITEM_ID)
1718: AND PALD2.REVERSED_FLAG ||'' = 'N')

Line 1726: FROM PA_PROJECT_ASSET_LINE_DETAILS PALD2,

1722: WHERE EI1.EXPENDITURE_ITEM_ID = PEI.EXPENDITURE_ITEM_ID
1723: AND EI1.NET_ZERO_ADJUSTMENT_FLAG = 'Y'
1724: AND EI1.ADJUSTED_EXPENDITURE_ITEM_ID IS NULL
1725: AND NOT EXISTS (SELECT NULL
1726: FROM PA_PROJECT_ASSET_LINE_DETAILS PALD2,
1727: PA_EXPENDITURE_ITEMS_ALL EI2
1728: WHERE EI2.ADJUSTED_EXPENDITURE_ITEM_ID = EI1.EXPENDITURE_ITEM_ID
1729: AND PALD2.EXPENDITURE_ITEM_ID = EI2.ADJUSTED_EXPENDITURE_ITEM_ID
1730: AND PALD2.REVERSED_FLAG||'' = 'N')

Line 1744: FROM PA_PROJECT_ASSET_LINE_DETAILS PALD2

1740: WHERE EI1.EXPENDITURE_ITEM_ID = PEI.EXPENDITURE_ITEM_ID
1741: AND EI1.NET_ZERO_ADJUSTMENT_FLAG = 'Y'
1742: AND EI1.ADJUSTED_EXPENDITURE_ITEM_ID IS NOT NULL
1743: AND NOT EXISTS (SELECT NULL
1744: FROM PA_PROJECT_ASSET_LINE_DETAILS PALD2
1745: WHERE PALD2.EXPENDITURE_ITEM_ID = EI1.ADJUSTED_EXPENDITURE_ITEM_ID
1746: AND PALD2.REVERSED_FLAG||'' = 'N')
1747: AND EXISTS (SELECT 1
1748: FROM PA_COST_DISTRIBUTION_LINES_ALL PCDL2

Line 1849: pa_project_asset_line_details pald

1845: (
1846: SELECT
1847: 'This CDL was summarized before'
1848: FROM
1849: pa_project_asset_line_details pald
1850: WHERE
1851: pald.expenditure_item_id = pcdl.expenditure_item_id
1852: AND pald.line_num = pcdl.line_num
1853: AND pald.reversed_flag||'' = 'N'

Line 3355: from pa_project_asset_line_details d,

3351: -- R12 changes. Table pa_gl_interface is obsolete. This check is left for
3352: -- asset lines which are not yet interfaced to FA before uptake of R12.
3353: CURSOR un_gl_xferred_cdls (x_detail_id IN NUMBER) IS
3354: select 'X'
3355: from pa_project_asset_line_details d,
3356: pa_cost_distribution_lines_all cdl
3357: where d.PROJECT_ASSET_LINE_DETAIL_ID = x_detail_id and
3358: d.expenditure_item_id = cdl.expenditure_item_id and
3359: d.line_num = cdl.line_num and

Line 5352: from pa_project_asset_line_details d,

5348: -- R12 changes. Table pa_gl_interface is obsolete. This check is left for
5349: -- asset lines which are not yet interfaced to FA before uptake of R12.
5350: CURSOR un_gl_xferred_cdls (x_detail_id IN NUMBER) IS
5351: select 'X'
5352: from pa_project_asset_line_details d,
5353: pa_cost_distribution_lines_all cdl
5354: where d.PROJECT_ASSET_LINE_DETAIL_ID = x_detail_id and
5355: d.expenditure_item_id = cdl.expenditure_item_id and
5356: d.line_num = cdl.line_num and