APPS.CE_BANK_STMT_LDR_PKG dependencies on CE_BANK_STMT_MAP_LINE

Line 653: SELECT CE_BANK_STMT_MAP_LINE_S.nextval

649: X_ATTRIBUTE14 VARCHAR2,
650: X_ATTRIBUTE15 VARCHAR2) IS
651:
652: CURSOR C_map_id IS
653: SELECT CE_BANK_STMT_MAP_LINE_S.nextval
654: FROM sys.dual;
655:
656: CURSOR C_row_id IS
657: SELECT rowid

Line 658: FROM ce_bank_stmt_map_line

654: FROM sys.dual;
655:
656: CURSOR C_row_id IS
657: SELECT rowid
658: FROM ce_bank_stmt_map_line
659: WHERE map_line_id = TO_NUMBER(X_MAP_LINE_ID);
660: BEGIN
661: OPEN C_map_id;
662: FETCH C_map_id

Line 666: INSERT INTO ce_bank_stmt_map_line(

662: FETCH C_map_id
663: INTO X_MAP_LINE_ID;
664: CLOSE C_map_id;
665:
666: INSERT INTO ce_bank_stmt_map_line(
667: MAP_LINE_ID,
668: MAP_ID,
669: COLUMN_NAME,
670: REC_ID_NO,

Line 768: UPDATE ce_bank_stmt_map_line

764: X_ATTRIBUTE13 VARCHAR2,
765: X_ATTRIBUTE14 VARCHAR2,
766: X_ATTRIBUTE15 VARCHAR2) IS
767: BEGIN
768: UPDATE ce_bank_stmt_map_line
769: SET map_line_id = X_map_line_id,
770: map_id = X_map_id,
771: column_name = X_column_name,
772: rec_id_no = X_rec_id,

Line 836: FROM ce_bank_stmt_map_line

832: X_ATTRIBUTE15 VARCHAR2) IS
833:
834: CURSOR C IS
835: SELECT *
836: FROM ce_bank_stmt_map_line
837: WHERE rowid = X_row_id
838: FOR UPDATE of map_line_id NOWAIT;
839:
840: Recinfo C%ROWTYPE;