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 323: DELETE FROM CE_STATEMENT_LINES

319: END insert_row;
320:
321: PROCEDURE Delete_Row( X_Row_Id VARCHAR2 ) IS
322: BEGIN
323: DELETE FROM CE_STATEMENT_LINES
324: WHERE rowid = X_Row_Id;
325:
326: if (SQL%NOTFOUND) then
327: Raise NO_DATA_FOUND;

Line 395: UPDATE CE_STATEMENT_LINES

391: X_global_attribute19 VARCHAR2,
392: X_global_attribute20 VARCHAR2
393: ) IS
394: BEGIN
395: UPDATE CE_STATEMENT_LINES
396: SET
397: statement_line_id = X_statement_line_id,
398: statement_header_id = X_statement_header_id,
399: line_number = X_line_number,

Line 527: FROM CE_STATEMENT_LINES

523: X_global_attribute20 VARCHAR2
524: ) IS
525: CURSOR C IS
526: SELECT *
527: FROM CE_STATEMENT_LINES
528: WHERE rowid = X_Row_Id
529: FOR UPDATE OF statement_line_id NOWAIT;
530: Recinfo C%ROWTYPE;
531: BEGIN