DBA Data[Home] [Help]

APPS.AST_UWQ_PLISTS_CONTS_ENUMS_PVT dependencies on IEU_PUB

Line 15: l_tk_list IEU_PUB.EnumeratorDataRecordList;

11: AS
12: l_node_counter NUMBER;
13: l_node_label VARCHAR2(100);
14: l_node_pid NUMBER := 3100;
15: l_tk_list IEU_PUB.EnumeratorDataRecordList;
16: l_def_where VARCHAR2(20000);
17: l_bind_list IEU_PUB.BindVariableRecordList ;
18:
19: l_OrgID number;

Line 17: l_bind_list IEU_PUB.BindVariableRecordList ;

13: l_node_label VARCHAR2(100);
14: l_node_pid NUMBER := 3100;
15: l_tk_list IEU_PUB.EnumeratorDataRecordList;
16: l_def_where VARCHAR2(20000);
17: l_bind_list IEU_PUB.BindVariableRecordList ;
18:
19: l_OrgID number;
20: l_view_name VARCHAR2(50);
21: l_ds_name VARCHAR2(50);

Line 72: l_tk_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list);

68: 'and list_source = ''UWQ'' AND enabled_flag = ''Y'' and resource_id = :resource_id';
69: l_tk_list(l_node_counter).NODE_TYPE := 0;
70: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
71: l_tk_list(l_node_counter).NODE_DEPTH := 1;
72: l_tk_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list);
73: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
74:
75: l_node_counter := l_node_counter + 1;
76:

Line 83: --and then call the function ieu_pub.setBindVar to get the String

79:
80: FOR cur_rec IN c_contact_lists(P_RESOURCE_ID) LOOP
81:
82: -- insert the bind variable names and values into l_bind_list
83: --and then call the function ieu_pub.setBindVar to get the String
84:
85: l_bind_list(1).bind_var_name := ':RESOURCE_ID' ;
86: l_bind_list(1).bind_var_value := P_RESOURCE_ID;
87: l_bind_list(1).bind_var_data_type := 'NUMBER';

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

127: l_tk_list(l_node_counter).MEDIA_TYPE_ID := '';
128: l_tk_list(l_node_counter).NODE_TYPE := 0;
129: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
130: l_tk_list(l_node_counter).NODE_DEPTH := 2;
131: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_bind_list);
132: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
133:
134: l_node_counter := l_node_counter + 1;
135:

Line 138: IEU_PUB.ADD_UWQ_NODE_DATA

134: l_node_counter := l_node_counter + 1;
135:
136: END LOOP;
137:
138: IEU_PUB.ADD_UWQ_NODE_DATA
139: (P_RESOURCE_ID,
140: P_SEL_ENUM_ID,
141: l_tk_list
142: );