APPS.CE_STAT_LINES_INF_PKG dependencies on CE_STATEMENT_LINES_INTERFACE

Line 57: CURSOR C IS SELECT rowid FROM CE_STATEMENT_LINES_INTERFACE

53: X_Attribute7 VARCHAR2,
54: X_Attribute8 VARCHAR2,
55: X_Attribute9 VARCHAR2
56: ) IS
57: CURSOR C IS SELECT rowid FROM CE_STATEMENT_LINES_INTERFACE
58: WHERE statement_number = X_Statement_Number
59: AND bank_account_num = X_Bank_Account_Num
60: AND line_number = X_Line_Number;
61:

Line 65: INSERT INTO CE_STATEMENT_LINES_INTERFACE(

61:
62: BEGIN
63:
64:
65: INSERT INTO CE_STATEMENT_LINES_INTERFACE(
66: bank_account_num,
67: statement_number,
68: line_number,
69: trx_date,

Line 195: FROM CE_STATEMENT_LINES_INTERFACE

191: X_Attribute9 VARCHAR2
192: ) IS
193: CURSOR C IS
194: SELECT *
195: FROM CE_STATEMENT_LINES_INTERFACE
196: WHERE rowid = X_Rowid
197: FOR UPDATE of Statement_Number NOWAIT;
198: Recinfo C%ROWTYPE;
199:

Line 356: UPDATE CE_STATEMENT_LINES_INTERFACE

352: X_Attribute9 VARCHAR2
353:
354: ) IS
355: BEGIN
356: UPDATE CE_STATEMENT_LINES_INTERFACE
357: SET
358: bank_account_num = X_Bank_Account_Num,
359: statement_number = X_Statement_Number,
360: line_number = X_Line_Number,

Line 402: DELETE FROM CE_STATEMENT_LINES_INTERFACE

398: end if;
399: END Update_Row;
400: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
401: BEGIN
402: DELETE FROM CE_STATEMENT_LINES_INTERFACE
403: WHERE rowid = X_Rowid;
404:
405: if (SQL%NOTFOUND) then
406: Raise NO_DATA_FOUND;

Line 416: FROM CE_STATEMENT_LINES_INTERFACE csr

412: X_line_number NUMBER,
413: X_row_id VARCHAR2) IS
414: CURSOR chk_duplicates is
415: SELECT 'Duplicate'
416: FROM CE_STATEMENT_LINES_INTERFACE csr
417: WHERE csr.statement_number = X_statement_number
418: AND csr.bank_account_num = X_bank_account_num
419: AND csr.line_number = X_line_number
420: AND ( X_row_id is null