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.CE_STAT_LINES_DML_PKG dependencies on CE_STATEMENT_LINES

Line 84: CURSOR C IS SELECT rowid FROM CE_STATEMENT_LINES

80: X_global_attribute18 VARCHAR2,
81: X_global_attribute19 VARCHAR2,
82: X_global_attribute20 VARCHAR2
83: ) IS
84: CURSOR C IS SELECT rowid FROM CE_STATEMENT_LINES
85: WHERE statement_line_id = X_Statement_line_Id;
86: CURSOR C1 IS SELECT ce_statement_lines_s.nextval from sys.dual;
87: CURSOR C2 IS SELECT NVL(MAX(line_number),0) + 10 FROM CE_STATEMENT_LINES
88: WHERE statement_header_id = X_statement_header_Id;

Line 86: CURSOR C1 IS SELECT ce_statement_lines_s.nextval from sys.dual;

82: X_global_attribute20 VARCHAR2
83: ) IS
84: CURSOR C IS SELECT rowid FROM CE_STATEMENT_LINES
85: WHERE statement_line_id = X_Statement_line_Id;
86: CURSOR C1 IS SELECT ce_statement_lines_s.nextval from sys.dual;
87: CURSOR C2 IS SELECT NVL(MAX(line_number),0) + 10 FROM CE_STATEMENT_LINES
88: WHERE statement_header_id = X_statement_header_Id;
89: CURSOR C3 IS SELECT ce_statement_headers_s.nextval FROM sys.dual;
90: sl_number NUMBER;

Line 87: CURSOR C2 IS SELECT NVL(MAX(line_number),0) + 10 FROM CE_STATEMENT_LINES

83: ) IS
84: CURSOR C IS SELECT rowid FROM CE_STATEMENT_LINES
85: WHERE statement_line_id = X_Statement_line_Id;
86: CURSOR C1 IS SELECT ce_statement_lines_s.nextval from sys.dual;
87: CURSOR C2 IS SELECT NVL(MAX(line_number),0) + 10 FROM CE_STATEMENT_LINES
88: WHERE statement_header_id = X_statement_header_Id;
89: CURSOR C3 IS SELECT ce_statement_headers_s.nextval FROM sys.dual;
90: sl_number NUMBER;
91: line_type VARCHAR2(20);

Line 187: INSERT INTO CE_STATEMENT_LINES

183: END IF;
184: */
185: END IF;
186: --
187: INSERT INTO CE_STATEMENT_LINES
188: (statement_line_id,
189: statement_header_id,
190: line_number,
191: trx_date,

Line 322: L_STMT_LINE_ID CE_STATEMENT_LINES.STATEMENT_LINE_ID%TYPE; -- Bug 9099087

318: CLOSE C;
319: END insert_row;
320:
321: PROCEDURE Delete_Row( X_Row_Id VARCHAR2 ) IS
322: L_STMT_LINE_ID CE_STATEMENT_LINES.STATEMENT_LINE_ID%TYPE; -- Bug 9099087
323: BEGIN
324: -- Bug 9099087 Start
325: SELECT STATEMENT_LINE_ID INTO L_STMT_LINE_ID
326: FROM CE_STATEMENT_LINES

Line 326: FROM CE_STATEMENT_LINES

322: L_STMT_LINE_ID CE_STATEMENT_LINES.STATEMENT_LINE_ID%TYPE; -- Bug 9099087
323: BEGIN
324: -- Bug 9099087 Start
325: SELECT STATEMENT_LINE_ID INTO L_STMT_LINE_ID
326: FROM CE_STATEMENT_LINES
327: WHERE rowid = X_Row_Id;
328:
329: DELETE FROM CE_STATEMENT_RECONCILS_ALL
330: WHERE STATEMENT_LINE_ID = L_STMT_LINE_ID;

Line 334: DELETE FROM CE_STATEMENT_LINES

330: WHERE STATEMENT_LINE_ID = L_STMT_LINE_ID;
331:
332: -- Bug 9099087 Start
333:
334: DELETE FROM CE_STATEMENT_LINES
335: WHERE rowid = X_Row_Id;
336:
337: if (SQL%NOTFOUND) then
338: Raise NO_DATA_FOUND;

Line 406: UPDATE CE_STATEMENT_LINES

402: X_global_attribute19 VARCHAR2,
403: X_global_attribute20 VARCHAR2
404: ) IS
405: BEGIN
406: UPDATE CE_STATEMENT_LINES
407: SET
408: statement_line_id = X_statement_line_id,
409: statement_header_id = X_statement_header_id,
410: line_number = X_line_number,

Line 538: FROM CE_STATEMENT_LINES

534: X_global_attribute20 VARCHAR2
535: ) IS
536: CURSOR C IS
537: SELECT *
538: FROM CE_STATEMENT_LINES
539: WHERE rowid = X_Row_Id
540: FOR UPDATE OF statement_line_id NOWAIT;
541: Recinfo C%ROWTYPE;
542: BEGIN