DBA Data[Home] [Help]

APPS.IEM_ACQ_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:
20: CURSOR c_inb_nodes_1 IS

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

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

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

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

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

Line 87: IEU_PUB.ADD_UWQ_NODE_DATA

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