APPS.FEM_WEBADI_FEM_BAL_UTILS_PVT dependencies on BNE_INTERFACE_COLS_TL

Line 357: ------------------------------------ Updating BNE_INTERFACE_COLS_TL table -------------------------

353: exception
354: when NO_DATA_FOUND then
355: goto end_loop; ---- Simulating what 'CONTINUE' key word does in c/c++
356: end;
357: ------------------------------------ Updating BNE_INTERFACE_COLS_TL table -------------------------
358: if(l_fem_type <> 'DIMENSION') then
359:
360: update bne_interface_cols_tl
361: set user_hint = DECODE(interface_cols.DATA_TYPE, 'VARCHAR2',

Line 360: update bne_interface_cols_tl

356: end;
357: ------------------------------------ Updating BNE_INTERFACE_COLS_TL table -------------------------
358: if(l_fem_type <> 'DIMENSION') then
359:
360: update bne_interface_cols_tl
361: set user_hint = DECODE(interface_cols.DATA_TYPE, 'VARCHAR2',
362: DECODE(interface_cols.nullable, 'N',l_varchar_req_field, l_varchar_field),
363: DECODE(interface_cols.DATA_TYPE, 'NUMBER',
364: DECODE(interface_cols.nullable, 'N',l_number_req_field, l_number_field),

Line 373: update bne_interface_cols_tl

369: and interface_code = 'FEM_BALANCES_INTF'
370: and language = userenv('LANG');
371: else
372:
373: update bne_interface_cols_tl
374: set user_hint = DECODE(interface_cols.nullable, 'N',l_lov_req_field, l_lov_field)
375: where sequence_num = (select sequence_num from bne_interface_cols_b where interface_col_name = 'P_' || interface_cols.column_name
376: and interface_code = 'FEM_BALANCES_INTF')
377: and interface_code = 'FEM_BALANCES_INTF'

Line 431: ------------------------------------ Updating BNE_INTERFACE_COLS_TL table -------------------------

427: when NO_DATA_FOUND then
428: goto end_last_loop; ---- Simulating what 'CONTINUE' key word does in c/c++
429: end;
430:
431: ------------------------------------ Updating BNE_INTERFACE_COLS_TL table -------------------------
432: if(l_fem_type <> 'DIMENSION') then
433:
434: update bne_interface_cols_tl
435: set user_hint = DECODE(key_recs.DATA_TYPE, 'VARCHAR2',l_varchar_req_field,'NUMBER',l_number_req_field,

Line 434: update bne_interface_cols_tl

430:
431: ------------------------------------ Updating BNE_INTERFACE_COLS_TL table -------------------------
432: if(l_fem_type <> 'DIMENSION') then
433:
434: update bne_interface_cols_tl
435: set user_hint = DECODE(key_recs.DATA_TYPE, 'VARCHAR2',l_varchar_req_field,'NUMBER',l_number_req_field,
436: 'DATE',l_date_req_field, NULL)
437: where sequence_num = (select sequence_num from bne_interface_cols_b where interface_col_name = 'P_' || key_recs.column_name
438: and interface_code = 'FEM_BALANCES_INTF')

Line 443: update bne_interface_cols_tl

439: and interface_code = 'FEM_BALANCES_INTF'
440: and language = userenv('LANG');
441:
442: else
443: update bne_interface_cols_tl
444: set user_hint = l_lov_req_field
445: where sequence_num = (select sequence_num from bne_interface_cols_b where interface_col_name = 'P_' || key_recs.column_name
446: and interface_code = 'FEM_BALANCES_INTF')
447: and interface_code = 'FEM_BALANCES_INTF'