DBA Data[Home] [Help]

APPS.AST_UWQ_PLISTS_OPPS_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(300);
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:

Line 17: l_bind_list IEU_PUB.BindVariableRecordList;

13: l_node_label VARCHAR2(300);
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:
20: l_Access varchar2(10);
21: l_OrgID number;

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

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

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

83:
84: FOR cur_rec IN c_opp_lists(P_RESOURCE_ID) LOOP
85:
86: -- insert the bind variable names and values into l_bind_list
87: --and then call the function ieu_pub.setBindVar to get the String
88:
89: l_bind_list(1).bind_var_name := ':resource_id';
90: l_bind_list(1).bind_var_value := P_RESOURCE_ID;
91: l_bind_list(1).bind_var_data_type := 'NUMBER';

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

134: l_tk_list(l_node_counter).MEDIA_TYPE_ID := '';
135: l_tk_list(l_node_counter).NODE_TYPE := 0;
136: l_tk_list(l_node_counter).HIDE_IF_EMPTY := '';
137: l_tk_list(l_node_counter).NODE_DEPTH := 2;
138: l_tk_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_bind_list);
139: l_tk_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
140:
141: l_node_counter := l_node_counter + 1;
142:

Line 145: IEU_PUB.ADD_UWQ_NODE_DATA

141: l_node_counter := l_node_counter + 1;
142:
143: END LOOP;
144:
145: IEU_PUB.ADD_UWQ_NODE_DATA
146: (P_RESOURCE_ID,
147: P_SEL_ENUM_ID,
148: l_tk_list
149: );