APPS.CE_BANK_STMT_LDR_PKG dependencies on CE_BANK_STMT_INT_MAP

Line 38: SELECT CE_BANK_STMT_INT_MAP_S.nextval

34: X_ATTRIBUTE14 VARCHAR2,
35: X_ATTRIBUTE15 VARCHAR2) IS
36:
37: CURSOR C_map_id IS
38: SELECT CE_BANK_STMT_INT_MAP_S.nextval
39: FROM sys.dual;
40:
41: CURSOR C_row_id IS
42: SELECT rowid

Line 43: FROM ce_bank_stmt_int_map

39: FROM sys.dual;
40:
41: CURSOR C_row_id IS
42: SELECT rowid
43: FROM ce_bank_stmt_int_map
44: WHERE map_id = TO_NUMBER(X_MAP_ID);
45: BEGIN
46: OPEN C_map_id;
47: FETCH C_map_id

Line 51: INSERT INTO ce_bank_stmt_int_map(

47: FETCH C_map_id
48: INTO X_MAP_ID;
49: CLOSE C_map_id;
50:
51: INSERT INTO ce_bank_stmt_int_map(
52: MAP_ID,
53: FORMAT_NAME,
54: DESCRIPTION,
55: FORMAT_TYPE,

Line 157: UPDATE ce_bank_stmt_int_map

153: X_ATTRIBUTE13 VARCHAR2,
154: X_ATTRIBUTE14 VARCHAR2,
155: X_ATTRIBUTE15 VARCHAR2) IS
156: BEGIN
157: UPDATE ce_bank_stmt_int_map
158: SET map_id = X_map_id,
159: format_name = X_format_name,
160: description = X_description,
161: format_type = X_format_type,

Line 227: FROM ce_bank_stmt_int_map

223: X_ATTRIBUTE15 VARCHAR2) IS
224:
225: CURSOR C IS
226: SELECT *
227: FROM ce_bank_stmt_int_map
228: WHERE rowid = X_row_id
229: FOR UPDATE of map_id NOWAIT;
230:
231: Recinfo C%ROWTYPE;