APPS.IEM_INBE_PVT dependencies on IEU_PUB

Line 16: l_tk_list IEU_PUB.EnumeratorDataRecordList;

12: l_node_counter NUMBER;
13: l_node_pid NUMBER;
14: l_node_label VARCHAR2(100);
15: l_def_where VARCHAR2(20000);
16: l_tk_list IEU_PUB.EnumeratorDataRecordList;
17: l_bind_list IEU_PUB.BindVariableRecordList;
18: p_user_flag varchar2(1);
19: p_acct_flag varchar2(1);
20:

Line 17: l_bind_list IEU_PUB.BindVariableRecordList;

13: l_node_pid NUMBER;
14: l_node_label VARCHAR2(100);
15: l_def_where VARCHAR2(20000);
16: l_tk_list IEU_PUB.EnumeratorDataRecordList;
17: l_bind_list IEU_PUB.BindVariableRecordList;
18: p_user_flag varchar2(1);
19: p_acct_flag varchar2(1);
20:
21: CURSOR c_inb_nodes_1 IS

Line 38: l_def_where := ieu_pub.get_enum_res_cat(p_sel_enum_id);

34: l_node_counter := 0;
35:
36: SAVEPOINT start_enumeration;
37:
38: l_def_where := ieu_pub.get_enum_res_cat(p_sel_enum_id);
39:
40: Select meaning into l_node_label
41: from fnd_lookups
42: where lookup_type = 'IEM_UWQ_EMAIL_LABELS'

Line 96: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_bind_list);

92: l_tk_list(l_node_counter).WHERE_CLAUSE := l_def_where ||'and EMAIL_ACCOUNT_ID =' ||':ACCOUNT_ID';
93: l_tk_list(l_node_counter).NODE_TYPE := 0;
94: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
95: l_tk_list(l_node_counter).NODE_DEPTH := 2;
96: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_bind_list);
97: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
98: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEM_REFINBEMAIL_ACCOUNTS_V';
99: l_tk_list(l_node_counter).REFRESH_VIEW_SUM_COL := 'Total';
100:

Line 113: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_bind_list);

109: l_tk_list(l_node_counter).WHERE_CLAUSE := l_def_where ||'and EMAIL_ACCOUNT_ID = ' || ':ACCOUNT_ID';
110: l_tk_list(l_node_counter).NODE_TYPE := 0;
111: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
112: l_tk_list(l_node_counter).NODE_DEPTH := 2;
113: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_bind_list);
114: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
115: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEM_REFINBEMAIL_ACCOUNTS_V';
116: l_tk_list(l_node_counter).REFRESH_VIEW_SUM_COL := 'Total';
117:

Line 123: IEU_PUB.ADD_UWQ_NODE_DATA

119: end if;
120:
121: END LOOP;
122:
123: IEU_PUB.ADD_UWQ_NODE_DATA
124: (P_RESOURCE_ID,
125: P_SEL_ENUM_ID,
126: l_tk_list
127: );