APPS.BNE_INTERFACE_COLS_PKG dependencies on BNE_INTERFACE_COLS_B

Line 60: cursor C is select ROWID from BNE_INTERFACE_COLS_B

56: X_EXPANDED_SQL_QUERY_APP_ID in NUMBER,
57: X_EXPANDED_SQL_QUERY_CODE in VARCHAR2,
58: X_DISPLAY_WIDTH in NUMBER
59: ) is
60: cursor C is select ROWID from BNE_INTERFACE_COLS_B
61: where APPLICATION_ID = X_APPLICATION_ID
62: and INTERFACE_CODE = X_INTERFACE_CODE
63: and SEQUENCE_NUM = X_SEQUENCE_NUM
64: ;

Line 66: insert into BNE_INTERFACE_COLS_B (

62: and INTERFACE_CODE = X_INTERFACE_CODE
63: and SEQUENCE_NUM = X_SEQUENCE_NUM
64: ;
65: begin
66: insert into BNE_INTERFACE_COLS_B (
67: INTERFACE_COL_TYPE,
68: INTERFACE_COL_NAME,
69: ENABLED_FLAG,
70: REQUIRED_FLAG,

Line 310: from BNE_INTERFACE_COLS_B

306: VAL_QUERY_CODE,
307: EXPANDED_SQL_QUERY_APP_ID,
308: EXPANDED_SQL_QUERY_CODE,
309: DISPLAY_WIDTH
310: from BNE_INTERFACE_COLS_B
311: where APPLICATION_ID = X_APPLICATION_ID
312: and INTERFACE_CODE = X_INTERFACE_CODE
313: and SEQUENCE_NUM = X_SEQUENCE_NUM
314: for update of APPLICATION_ID nowait;

Line 492: update BNE_INTERFACE_COLS_B set

488: X_EXPANDED_SQL_QUERY_CODE in VARCHAR2,
489: X_DISPLAY_WIDTH in NUMBER
490: ) is
491: begin
492: update BNE_INTERFACE_COLS_B set
493: INTERFACE_COL_TYPE = X_INTERFACE_COL_TYPE,
494: INTERFACE_COL_NAME = X_INTERFACE_COL_NAME,
495: ENABLED_FLAG = X_ENABLED_FLAG,
496: REQUIRED_FLAG = X_REQUIRED_FLAG,

Line 579: delete from BNE_INTERFACE_COLS_B

575: if (sql%notfound) then
576: raise no_data_found;
577: end if;
578:
579: delete from BNE_INTERFACE_COLS_B
580: where APPLICATION_ID = X_APPLICATION_ID
581: and INTERFACE_CODE = X_INTERFACE_CODE
582: and SEQUENCE_NUM = X_SEQUENCE_NUM;
583:

Line 595: from BNE_INTERFACE_COLS_B B

591: begin
592: delete from BNE_INTERFACE_COLS_TL T
593: where not exists
594: (select NULL
595: from BNE_INTERFACE_COLS_B B
596: where B.APPLICATION_ID = T.APPLICATION_ID
597: and B.INTERFACE_CODE = T.INTERFACE_CODE
598: and B.SEQUENCE_NUM = T.SEQUENCE_NUM
599: );

Line 853: from BNE_INTERFACE_COLS_B

849: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
850: begin
851: select LAST_UPDATED_BY, LAST_UPDATE_DATE
852: into db_luby, db_ludate
853: from BNE_INTERFACE_COLS_B
854: where APPLICATION_ID = l_app_id
855: and SEQUENCE_NUM = x_sequence_num
856: and INTERFACE_CODE = x_interface_code;
857: