APPS.CE_STAT_HDRS_DML_PKG dependencies on CE_STATEMENT_HEADERS

Line 97: FROM CE_STATEMENT_HEADERS

93: ) IS
94: p_bank_acct_balance_id number;
95: p_xtr_val boolean;
96: CURSOR C IS SELECT rowid
97: FROM CE_STATEMENT_HEADERS
98: WHERE statement_header_id = X_Statement_Header_Id;
99: CURSOR C2 IS SELECT CE_STATEMENT_HEADERS_S.nextval FROM SYS.dual;
100: CURSOR C3 IS SELECT CE_BANK_ACCT_BALANCES_S.nextval FROM SYS.dual;
101: BEGIN

Line 99: CURSOR C2 IS SELECT CE_STATEMENT_HEADERS_S.nextval FROM SYS.dual;

95: p_xtr_val boolean;
96: CURSOR C IS SELECT rowid
97: FROM CE_STATEMENT_HEADERS
98: WHERE statement_header_id = X_Statement_Header_Id;
99: CURSOR C2 IS SELECT CE_STATEMENT_HEADERS_S.nextval FROM SYS.dual;
100: CURSOR C3 IS SELECT CE_BANK_ACCT_BALANCES_S.nextval FROM SYS.dual;
101: BEGIN
102: IF (X_statement_header_id IS NULL) THEN
103: OPEN C2;

Line 107: INSERT INTO CE_STATEMENT_HEADERS (

103: OPEN C2;
104: FETCH C2 INTO X_statement_header_id;
105: CLOSE C2;
106: END IF;
107: INSERT INTO CE_STATEMENT_HEADERS (
108: statement_header_id,
109: bank_account_id,
110: statement_number,
111: statement_date,

Line 379: FROM CE_STATEMENT_HEADERS

375: IF (x_flag = 'YO') THEN
376: BEGIN
377: SELECT BANK_ACCOUNT_ID,STATEMENT_DATE
378: INTO X_bank_account_id,X_Balance_Date
379: FROM CE_STATEMENT_HEADERS
380: WHERE STATEMENT_HEADER_ID = X_Statement_Header_Id;
381:
382: UPDATE CE_BANK_ACCT_BALANCES
383: SET

Line 405: UPDATE CE_STATEMENT_HEADERS

401:
402: --
403: -- Standard ON-UPDATE routine
404: --
405: UPDATE CE_STATEMENT_HEADERS
406: SET
407: statement_header_id = X_statement_header_id,
408: statement_number = X_statement_number,
409: statement_date = X_statement_date,

Line 481: FROM CE_STATEMENT_HEADERS

477:
478: /*BEGIN
479: SELECT BANK_ACCOUNT_ID,STATEMENT_DATE
480: INTO X_bank_account_id,X_balance_date
481: FROM CE_STATEMENT_HEADERS
482: WHERE rowid = X_Row_Id;
483:
484: DELETE FROM CE_BANK_ACCT_BALANCES
485: WHERE bank_account_id = X_bank_account_id

Line 492: DELETE FROM CE_STATEMENT_HEADERS

488: WHEN OTHERS THEN
489: NULL;
490: END;*/
491:
492: DELETE FROM CE_STATEMENT_HEADERS
493: WHERE rowid = X_Row_Id;
494:
495: if (SQL%NOTFOUND) then
496: Raise NO_DATA_FOUND;

Line 562: FROM CE_STATEMENT_HEADERS

558: X_global_attribute20 VARCHAR2
559: ) IS
560: CURSOR C IS
561: SELECT *
562: FROM CE_STATEMENT_HEADERS
563: WHERE rowid = X_Row_Id
564: FOR UPDATE of Statement_Header_Id NOWAIT;
565: Recinfo C%ROWTYPE;
566: