DBA Data[Home] [Help]

APPS.CE_STAT_LINES_DML_PKG dependencies on CE_STATEMENT_LINES_S

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