eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EDW_GL_ACCT_M_T dependencies on EDW_VBH_TEMP1

Line 258: l_vbh_acct_name edw_vbh_temp1.parent%TYPE;

254: END update_temp_table;
255:
256: procedure update_class is
257: l_loop_counter integer :=0;
258: l_vbh_acct_name edw_vbh_temp1.parent%TYPE;
259: type t_vbh_temp_cur IS REF CURSOR;
260: cur_vbh_temp t_vbh_temp_cur;
261:
262: begin

Line 1152: parent edw_vbh_temp1.parent%TYPE,

1148: FUNCTION PROCESS_ROOT_HIR(p_root_value varchar2, p_hie_no integer , p_curid in integer)
1149: RETURN integer
1150: IS
1151: TYPE t_vbh_temp_rec IS RECORD(
1152: parent edw_vbh_temp1.parent%TYPE,
1153: parent_name edw_vbh_temp1.parent_name%TYPE,
1154: parent_type edw_vbh_temp1.parent_type%TYPE,
1155: parent_desc edw_vbh_temp1.parent_desc%TYPE,
1156: child edw_vbh_temp1.child%TYPE,

Line 1153: parent_name edw_vbh_temp1.parent_name%TYPE,

1149: RETURN integer
1150: IS
1151: TYPE t_vbh_temp_rec IS RECORD(
1152: parent edw_vbh_temp1.parent%TYPE,
1153: parent_name edw_vbh_temp1.parent_name%TYPE,
1154: parent_type edw_vbh_temp1.parent_type%TYPE,
1155: parent_desc edw_vbh_temp1.parent_desc%TYPE,
1156: child edw_vbh_temp1.child%TYPE,
1157: child_name edw_vbh_temp1.child_name%TYPE,

Line 1154: parent_type edw_vbh_temp1.parent_type%TYPE,

1150: IS
1151: TYPE t_vbh_temp_rec IS RECORD(
1152: parent edw_vbh_temp1.parent%TYPE,
1153: parent_name edw_vbh_temp1.parent_name%TYPE,
1154: parent_type edw_vbh_temp1.parent_type%TYPE,
1155: parent_desc edw_vbh_temp1.parent_desc%TYPE,
1156: child edw_vbh_temp1.child%TYPE,
1157: child_name edw_vbh_temp1.child_name%TYPE,
1158: child_type edw_vbh_temp1.child_type%TYPE,

Line 1155: parent_desc edw_vbh_temp1.parent_desc%TYPE,

1151: TYPE t_vbh_temp_rec IS RECORD(
1152: parent edw_vbh_temp1.parent%TYPE,
1153: parent_name edw_vbh_temp1.parent_name%TYPE,
1154: parent_type edw_vbh_temp1.parent_type%TYPE,
1155: parent_desc edw_vbh_temp1.parent_desc%TYPE,
1156: child edw_vbh_temp1.child%TYPE,
1157: child_name edw_vbh_temp1.child_name%TYPE,
1158: child_type edw_vbh_temp1.child_type%TYPE,
1159: child_desc edw_vbh_temp1.child_desc%TYPE,

Line 1156: child edw_vbh_temp1.child%TYPE,

1152: parent edw_vbh_temp1.parent%TYPE,
1153: parent_name edw_vbh_temp1.parent_name%TYPE,
1154: parent_type edw_vbh_temp1.parent_type%TYPE,
1155: parent_desc edw_vbh_temp1.parent_desc%TYPE,
1156: child edw_vbh_temp1.child%TYPE,
1157: child_name edw_vbh_temp1.child_name%TYPE,
1158: child_type edw_vbh_temp1.child_type%TYPE,
1159: child_desc edw_vbh_temp1.child_desc%TYPE,
1160: total_level NUMBER);

Line 1157: child_name edw_vbh_temp1.child_name%TYPE,

1153: parent_name edw_vbh_temp1.parent_name%TYPE,
1154: parent_type edw_vbh_temp1.parent_type%TYPE,
1155: parent_desc edw_vbh_temp1.parent_desc%TYPE,
1156: child edw_vbh_temp1.child%TYPE,
1157: child_name edw_vbh_temp1.child_name%TYPE,
1158: child_type edw_vbh_temp1.child_type%TYPE,
1159: child_desc edw_vbh_temp1.child_desc%TYPE,
1160: total_level NUMBER);
1161: TYPE t_cur_vbh_temp_ref IS REF CURSOR;

Line 1158: child_type edw_vbh_temp1.child_type%TYPE,

1154: parent_type edw_vbh_temp1.parent_type%TYPE,
1155: parent_desc edw_vbh_temp1.parent_desc%TYPE,
1156: child edw_vbh_temp1.child%TYPE,
1157: child_name edw_vbh_temp1.child_name%TYPE,
1158: child_type edw_vbh_temp1.child_type%TYPE,
1159: child_desc edw_vbh_temp1.child_desc%TYPE,
1160: total_level NUMBER);
1161: TYPE t_cur_vbh_temp_ref IS REF CURSOR;
1162:

Line 1159: child_desc edw_vbh_temp1.child_desc%TYPE,

1155: parent_desc edw_vbh_temp1.parent_desc%TYPE,
1156: child edw_vbh_temp1.child%TYPE,
1157: child_name edw_vbh_temp1.child_name%TYPE,
1158: child_type edw_vbh_temp1.child_type%TYPE,
1159: child_desc edw_vbh_temp1.child_desc%TYPE,
1160: total_level NUMBER);
1161: TYPE t_cur_vbh_temp_ref IS REF CURSOR;
1162:
1163: l_TreeBiuld_timestamp Date:=Null;

Line 1303: l_root_value edw_vbh_temp1.parent%TYPE;

1299: l_rows_inserted INTEGER :=0;
1300: l_table_counter INTEGER;
1301: l_hierachy_no NUMBER;
1302: l_rowsUpdated INTEGER;
1303: l_root_value edw_vbh_temp1.parent%TYPE;
1304: l_vbh_value edw_gl_acct1_m.l1_pk%TYPE;
1305: l_vbh_name edw_gl_acct1_m.l1_name%TYPE;
1306: l_vbh_desc edw_gl_acct1_m.l1_description%TYPE;
1307: l_pk_key edw_gl_acct1_m.l1_pk_key%TYPE;