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:
19: CURSOR c_inb_nodes_1 IS
20: select a.from_name, a.email_account_id, c.resource_id

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:
19: CURSOR c_inb_nodes_1 IS
20: select a.from_name, a.email_account_id, c.resource_id
21: from iem_mstemail_accounts a,iem_agents c

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

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

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

73: l_tk_list(l_node_counter).WHERE_CLAUSE := l_def_where ||'and EMAIL_ACCOUNT_ID = ' || ':ACCOUNT_ID';
74: l_tk_list(l_node_counter).NODE_TYPE := 0;
75: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
76: l_tk_list(l_node_counter).NODE_DEPTH := 2;
77: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_bind_list);
78: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
79: l_tk_list(l_node_counter).REFRESH_VIEW_NAME := 'IEM_REFINBEMAIL_ACCOUNTS_V';
80: l_tk_list(l_node_counter).REFRESH_VIEW_SUM_COL := 'Total';
81:

Line 86: IEU_PUB.ADD_UWQ_NODE_DATA

82: l_node_counter := l_node_counter + 1;
83:
84: END LOOP;
85:
86: IEU_PUB.ADD_UWQ_NODE_DATA
87: (P_RESOURCE_ID,
88: P_SEL_ENUM_ID,
89: l_tk_list
90: );