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.

[Home] [Help]

APPS.CE_CEPURGE_XMLP_PKG dependencies on CE_INTRA_STMT_LINES

Line 108: CE_INTRA_STMT_LINES CSL

104: CURSOR C_PURGE_INTRA_LINES IS
105: SELECT
106: CSL.STATEMENT_LINE_ID
107: FROM
108: CE_INTRA_STMT_LINES CSL
109: WHERE CSL.STATEMENT_HEADER_ID = X_HEADER_ID;
110: BEGIN
111: P_STATEMENT_DATE_TO1 := P_STATEMENT_DATE_TO;
112:

Line 1632: CE_INTRA_STMT_LINES

1628: LAST_UPDATED_BY,
1629: LAST_UPDATE_DATE,
1630: RECONCILE_TO_STATEMENT_FLAG
1631: FROM
1632: CE_INTRA_STMT_LINES
1633: WHERE STATEMENT_HEADER_ID IN (
1634: SELECT
1635: STATEMENT_HEADER_ID
1636: FROM

Line 1657: DELETE FROM CE_INTRA_STMT_LINES

1653: INTO
1654: X_LINE_ID;
1655: LOOP
1656: EXIT WHEN C_PURGE_INTRA_LINES%NOTFOUND;
1657: DELETE FROM CE_INTRA_STMT_LINES
1658: WHERE STATEMENT_HEADER_ID = X_HEADER_ID;
1659: PURGE_LINES := PURGE_LINES + SQL%ROWCOUNT;
1660: FETCH C_PURGE_INTRA_LINES
1661: INTO