APPS.CE_STAT_HDRS_INF_PKG dependencies on CE_STATEMENT_HEADERS_INT

Line 69: CURSOR C IS SELECT rowid FROM CE_STATEMENT_HEADERS_INT

65: --X_Org_Id NUMBER,
66: X_Bank_Name VARCHAR2,
67: X_Subsidiary_flag VARCHAR2
68: ) IS
69: CURSOR C IS SELECT rowid FROM CE_STATEMENT_HEADERS_INT
70: WHERE statement_number = X_Statement_Number
71: AND bank_account_num = X_Bank_Account_Num;
72:
73: BEGIN

Line 76: INSERT INTO CE_STATEMENT_HEADERS_INT(

72:
73: BEGIN
74:
75:
76: INSERT INTO CE_STATEMENT_HEADERS_INT(
77: statement_number,
78: bank_branch_name,
79: bank_account_num,
80: statement_date,

Line 220: FROM CE_STATEMENT_HEADERS_INT

216: X_Bank_Name VARCHAR2
217: ) IS
218: CURSOR C IS
219: SELECT *
220: FROM CE_STATEMENT_HEADERS_INT
221: WHERE rowid = X_Rowid
222: FOR UPDATE of Statement_Number NOWAIT;
223: Recinfo C%ROWTYPE;
224:

Line 402: UPDATE CE_STATEMENT_HEADERS_INT

398: X_Bank_Name VARCHAR2,
399: X_Subsidiary_flag VARCHAR2
400: ) IS
401: BEGIN
402: UPDATE CE_STATEMENT_HEADERS_INT
403: SET
404: statement_number = X_Statement_Number,
405: bank_branch_name = X_Bank_Branch_Name,
406: bank_account_num = X_Bank_Account_Num,

Line 452: DELETE FROM CE_STATEMENT_HEADERS_INT

448: end if;
449: END Update_Row;
450: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
451: BEGIN
452: DELETE FROM CE_STATEMENT_HEADERS_INT
453: WHERE rowid = X_Rowid;
454:
455: if (SQL%NOTFOUND) then
456: Raise NO_DATA_FOUND;

Line 465: FROM CE_STATEMENT_HEADERS_INT csr

461: X_bank_account_num VARCHAR2,
462: X_row_id VARCHAR2) IS
463: CURSOR chk_duplicates is
464: SELECT 'Duplicate'
465: FROM CE_STATEMENT_HEADERS_INT csr
466: WHERE csr.statement_number = X_statement_number
467: AND csr.bank_account_num = X_bank_account_num
468: AND ( X_row_id is null
469: OR csr.rowid <> chartorowid(X_row_id));