APPS.CE_BANK_STMT_LDR_PKG dependencies on CE_BANK_STMT_MAP_HDR

Line 351: SELECT CE_BANK_STMT_MAP_HDR_S.nextval

347: X_ATTRIBUTE14 VARCHAR2,
348: X_ATTRIBUTE15 VARCHAR2) IS
349:
350: CURSOR C_map_id IS
351: SELECT CE_BANK_STMT_MAP_HDR_S.nextval
352: FROM sys.dual;
353:
354: CURSOR C_row_id IS
355: SELECT rowid

Line 356: FROM ce_bank_stmt_map_hdr

352: FROM sys.dual;
353:
354: CURSOR C_row_id IS
355: SELECT rowid
356: FROM ce_bank_stmt_map_hdr
357: WHERE map_header_id = TO_NUMBER(X_MAP_HEADER_ID);
358: BEGIN
359: OPEN C_map_id;
360: FETCH C_map_id

Line 364: INSERT INTO ce_bank_stmt_map_hdr(

360: FETCH C_map_id
361: INTO X_MAP_HEADER_ID;
362: CLOSE C_map_id;
363:
364: INSERT INTO ce_bank_stmt_map_hdr(
365: MAP_HEADER_ID,
366: MAP_ID,
367: COLUMN_NAME,
368: REC_ID_NO,

Line 466: UPDATE ce_bank_stmt_map_hdr

462: X_ATTRIBUTE13 VARCHAR2,
463: X_ATTRIBUTE14 VARCHAR2,
464: X_ATTRIBUTE15 VARCHAR2) IS
465: BEGIN
466: UPDATE ce_bank_stmt_map_hdr
467: SET map_header_id = X_map_header_id,
468: map_id = X_map_id,
469: column_name = X_column_name,
470: rec_id_no = X_rec_id,

Line 534: FROM ce_bank_stmt_map_hdr

530: X_ATTRIBUTE15 VARCHAR2) IS
531:
532: CURSOR C IS
533: SELECT *
534: FROM ce_bank_stmt_map_hdr
535: WHERE rowid = X_row_id
536: FOR UPDATE of map_header_id NOWAIT;
537:
538: Recinfo C%ROWTYPE;