eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEU_UWQ_MEDIA_TYPES_PVT dependencies on DBMS_SQL

Line 85: v_cursorID := DBMS_SQL.OPEN_CURSOR;

81:
82: BEGIN
83: x_return_status := fnd_api.g_ret_sts_success;
84:
85: v_cursorID := DBMS_SQL.OPEN_CURSOR;
86:
87:
88: v_is_server_side := 'N';
89:

Line 98: DBMS_SQL.PARSE(v_cursorID, v_selectStmt, DBMS_SQL.V7);

94: ' where b.MEDIA_TYPE_ID = tl.MEDIA_TYPE_ID and b.MEDIA_TYPE_ID = cl.MEDIA_TYPE_ID ' ||
95: ' and tl.LANGUAGE = '||''''||p_language||''''||' and b.MEDIA_TYPE_ID = svm.MEDIA_TYPE_ID ' ||
96: ' and svm.SVR_TYPE_ID = svp.SVR_TYPE_ID order by ' || p_order_by || ' ' || p_asc;
97:
98: DBMS_SQL.PARSE(v_cursorID, v_selectStmt, DBMS_SQL.V7);
99:
100: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 1, v_media_type_id);
101: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 2, v_tel_reqd_flag, 1);
102: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 3, v_media_type_name, 1996);

Line 100: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 1, v_media_type_id);

96: ' and svm.SVR_TYPE_ID = svp.SVR_TYPE_ID order by ' || p_order_by || ' ' || p_asc;
97:
98: DBMS_SQL.PARSE(v_cursorID, v_selectStmt, DBMS_SQL.V7);
99:
100: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 1, v_media_type_id);
101: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 2, v_tel_reqd_flag, 1);
102: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 3, v_media_type_name, 1996);
103: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 4, v_media_type_description,1996);
104: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 5, v_cli_plugin_id);

Line 101: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 2, v_tel_reqd_flag, 1);

97:
98: DBMS_SQL.PARSE(v_cursorID, v_selectStmt, DBMS_SQL.V7);
99:
100: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 1, v_media_type_id);
101: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 2, v_tel_reqd_flag, 1);
102: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 3, v_media_type_name, 1996);
103: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 4, v_media_type_description,1996);
104: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 5, v_cli_plugin_id);
105: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 6, v_cli_plugin_class, 1996);

Line 102: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 3, v_media_type_name, 1996);

98: DBMS_SQL.PARSE(v_cursorID, v_selectStmt, DBMS_SQL.V7);
99:
100: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 1, v_media_type_id);
101: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 2, v_tel_reqd_flag, 1);
102: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 3, v_media_type_name, 1996);
103: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 4, v_media_type_description,1996);
104: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 5, v_cli_plugin_id);
105: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 6, v_cli_plugin_class, 1996);
106: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 7, v_svr_type_id);

Line 103: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 4, v_media_type_description,1996);

99:
100: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 1, v_media_type_id);
101: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 2, v_tel_reqd_flag, 1);
102: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 3, v_media_type_name, 1996);
103: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 4, v_media_type_description,1996);
104: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 5, v_cli_plugin_id);
105: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 6, v_cli_plugin_class, 1996);
106: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 7, v_svr_type_id);
107: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 8, v_svr_mps_plugin_id);

Line 104: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 5, v_cli_plugin_id);

100: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 1, v_media_type_id);
101: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 2, v_tel_reqd_flag, 1);
102: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 3, v_media_type_name, 1996);
103: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 4, v_media_type_description,1996);
104: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 5, v_cli_plugin_id);
105: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 6, v_cli_plugin_class, 1996);
106: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 7, v_svr_type_id);
107: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 8, v_svr_mps_plugin_id);
108: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 9, v_svr_plugin_class, 1996);

Line 105: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 6, v_cli_plugin_class, 1996);

101: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 2, v_tel_reqd_flag, 1);
102: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 3, v_media_type_name, 1996);
103: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 4, v_media_type_description,1996);
104: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 5, v_cli_plugin_id);
105: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 6, v_cli_plugin_class, 1996);
106: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 7, v_svr_type_id);
107: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 8, v_svr_mps_plugin_id);
108: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 9, v_svr_plugin_class, 1996);
109: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 10, v_media_type_uuid, 38);

Line 106: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 7, v_svr_type_id);

102: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 3, v_media_type_name, 1996);
103: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 4, v_media_type_description,1996);
104: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 5, v_cli_plugin_id);
105: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 6, v_cli_plugin_class, 1996);
106: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 7, v_svr_type_id);
107: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 8, v_svr_mps_plugin_id);
108: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 9, v_svr_plugin_class, 1996);
109: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 10, v_media_type_uuid, 38);
110: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 11, v_svr_login_rule_id);

Line 107: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 8, v_svr_mps_plugin_id);

103: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 4, v_media_type_description,1996);
104: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 5, v_cli_plugin_id);
105: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 6, v_cli_plugin_class, 1996);
106: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 7, v_svr_type_id);
107: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 8, v_svr_mps_plugin_id);
108: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 9, v_svr_plugin_class, 1996);
109: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 10, v_media_type_uuid, 38);
110: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 11, v_svr_login_rule_id);
111: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 12, v_application_id);

Line 108: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 9, v_svr_plugin_class, 1996);

104: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 5, v_cli_plugin_id);
105: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 6, v_cli_plugin_class, 1996);
106: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 7, v_svr_type_id);
107: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 8, v_svr_mps_plugin_id);
108: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 9, v_svr_plugin_class, 1996);
109: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 10, v_media_type_uuid, 38);
110: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 11, v_svr_login_rule_id);
111: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 12, v_application_id);
112:

Line 109: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 10, v_media_type_uuid, 38);

105: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 6, v_cli_plugin_class, 1996);
106: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 7, v_svr_type_id);
107: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 8, v_svr_mps_plugin_id);
108: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 9, v_svr_plugin_class, 1996);
109: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 10, v_media_type_uuid, 38);
110: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 11, v_svr_login_rule_id);
111: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 12, v_application_id);
112:
113: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 13, v_is_server_side, 1);

Line 110: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 11, v_svr_login_rule_id);

106: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 7, v_svr_type_id);
107: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 8, v_svr_mps_plugin_id);
108: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 9, v_svr_plugin_class, 1996);
109: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 10, v_media_type_uuid, 38);
110: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 11, v_svr_login_rule_id);
111: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 12, v_application_id);
112:
113: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 13, v_is_server_side, 1);
114: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 14, v_classfn_query_proc, 60);

Line 111: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 12, v_application_id);

107: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 8, v_svr_mps_plugin_id);
108: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 9, v_svr_plugin_class, 1996);
109: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 10, v_media_type_uuid, 38);
110: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 11, v_svr_login_rule_id);
111: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 12, v_application_id);
112:
113: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 13, v_is_server_side, 1);
114: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 14, v_classfn_query_proc, 60);
115:

Line 113: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 13, v_is_server_side, 1);

109: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 10, v_media_type_uuid, 38);
110: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 11, v_svr_login_rule_id);
111: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 12, v_application_id);
112:
113: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 13, v_is_server_side, 1);
114: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 14, v_classfn_query_proc, 60);
115:
116:
117: v_dummy := DBMS_SQL.EXECUTE(v_cursorID);

Line 114: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 14, v_classfn_query_proc, 60);

110: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 11, v_svr_login_rule_id);
111: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 12, v_application_id);
112:
113: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 13, v_is_server_side, 1);
114: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 14, v_classfn_query_proc, 60);
115:
116:
117: v_dummy := DBMS_SQL.EXECUTE(v_cursorID);
118:

Line 117: v_dummy := DBMS_SQL.EXECUTE(v_cursorID);

113: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 13, v_is_server_side, 1);
114: DBMS_SQL.DEFINE_COLUMN(v_cursorID, 14, v_classfn_query_proc, 60);
115:
116:
117: v_dummy := DBMS_SQL.EXECUTE(v_cursorID);
118:
119: x_media_type_list := SYSTEM.IEU_MEDIA_TYPE_NST();
120: loop
121: if DBMS_SQL.FETCH_ROWS(v_cursorID) = 0 then

Line 121: if DBMS_SQL.FETCH_ROWS(v_cursorID) = 0 then

117: v_dummy := DBMS_SQL.EXECUTE(v_cursorID);
118:
119: x_media_type_list := SYSTEM.IEU_MEDIA_TYPE_NST();
120: loop
121: if DBMS_SQL.FETCH_ROWS(v_cursorID) = 0 then
122: exit;
123: end if;
124:
125: DBMS_SQL.COLUMN_VALUE(v_cursorID, 1, v_media_type_id);

Line 125: DBMS_SQL.COLUMN_VALUE(v_cursorID, 1, v_media_type_id);

121: if DBMS_SQL.FETCH_ROWS(v_cursorID) = 0 then
122: exit;
123: end if;
124:
125: DBMS_SQL.COLUMN_VALUE(v_cursorID, 1, v_media_type_id);
126:
127: DBMS_SQL.COLUMN_VALUE(v_cursorID, 2, v_tel_reqd_flag);
128:
129: DBMS_SQL.COLUMN_VALUE(v_cursorID, 3, v_media_type_name);

Line 127: DBMS_SQL.COLUMN_VALUE(v_cursorID, 2, v_tel_reqd_flag);

123: end if;
124:
125: DBMS_SQL.COLUMN_VALUE(v_cursorID, 1, v_media_type_id);
126:
127: DBMS_SQL.COLUMN_VALUE(v_cursorID, 2, v_tel_reqd_flag);
128:
129: DBMS_SQL.COLUMN_VALUE(v_cursorID, 3, v_media_type_name);
130:
131: DBMS_SQL.COLUMN_VALUE(v_cursorID, 4, v_media_type_description);

Line 129: DBMS_SQL.COLUMN_VALUE(v_cursorID, 3, v_media_type_name);

125: DBMS_SQL.COLUMN_VALUE(v_cursorID, 1, v_media_type_id);
126:
127: DBMS_SQL.COLUMN_VALUE(v_cursorID, 2, v_tel_reqd_flag);
128:
129: DBMS_SQL.COLUMN_VALUE(v_cursorID, 3, v_media_type_name);
130:
131: DBMS_SQL.COLUMN_VALUE(v_cursorID, 4, v_media_type_description);
132:
133: DBMS_SQL.COLUMN_VALUE(v_cursorID, 5, v_cli_plugin_id);

Line 131: DBMS_SQL.COLUMN_VALUE(v_cursorID, 4, v_media_type_description);

127: DBMS_SQL.COLUMN_VALUE(v_cursorID, 2, v_tel_reqd_flag);
128:
129: DBMS_SQL.COLUMN_VALUE(v_cursorID, 3, v_media_type_name);
130:
131: DBMS_SQL.COLUMN_VALUE(v_cursorID, 4, v_media_type_description);
132:
133: DBMS_SQL.COLUMN_VALUE(v_cursorID, 5, v_cli_plugin_id);
134:
135: DBMS_SQL.COLUMN_VALUE(v_cursorID, 6, v_cli_plugin_class);

Line 133: DBMS_SQL.COLUMN_VALUE(v_cursorID, 5, v_cli_plugin_id);

129: DBMS_SQL.COLUMN_VALUE(v_cursorID, 3, v_media_type_name);
130:
131: DBMS_SQL.COLUMN_VALUE(v_cursorID, 4, v_media_type_description);
132:
133: DBMS_SQL.COLUMN_VALUE(v_cursorID, 5, v_cli_plugin_id);
134:
135: DBMS_SQL.COLUMN_VALUE(v_cursorID, 6, v_cli_plugin_class);
136:
137: DBMS_SQL.COLUMN_VALUE(v_cursorID, 7, v_svr_type_id);

Line 135: DBMS_SQL.COLUMN_VALUE(v_cursorID, 6, v_cli_plugin_class);

131: DBMS_SQL.COLUMN_VALUE(v_cursorID, 4, v_media_type_description);
132:
133: DBMS_SQL.COLUMN_VALUE(v_cursorID, 5, v_cli_plugin_id);
134:
135: DBMS_SQL.COLUMN_VALUE(v_cursorID, 6, v_cli_plugin_class);
136:
137: DBMS_SQL.COLUMN_VALUE(v_cursorID, 7, v_svr_type_id);
138:
139: DBMS_SQL.COLUMN_VALUE(v_cursorID, 8, v_svr_mps_plugin_id);

Line 137: DBMS_SQL.COLUMN_VALUE(v_cursorID, 7, v_svr_type_id);

133: DBMS_SQL.COLUMN_VALUE(v_cursorID, 5, v_cli_plugin_id);
134:
135: DBMS_SQL.COLUMN_VALUE(v_cursorID, 6, v_cli_plugin_class);
136:
137: DBMS_SQL.COLUMN_VALUE(v_cursorID, 7, v_svr_type_id);
138:
139: DBMS_SQL.COLUMN_VALUE(v_cursorID, 8, v_svr_mps_plugin_id);
140:
141: DBMS_SQL.COLUMN_VALUE(v_cursorID, 9, v_svr_plugin_class);

Line 139: DBMS_SQL.COLUMN_VALUE(v_cursorID, 8, v_svr_mps_plugin_id);

135: DBMS_SQL.COLUMN_VALUE(v_cursorID, 6, v_cli_plugin_class);
136:
137: DBMS_SQL.COLUMN_VALUE(v_cursorID, 7, v_svr_type_id);
138:
139: DBMS_SQL.COLUMN_VALUE(v_cursorID, 8, v_svr_mps_plugin_id);
140:
141: DBMS_SQL.COLUMN_VALUE(v_cursorID, 9, v_svr_plugin_class);
142:
143: DBMS_SQL.COLUMN_VALUE(v_cursorID, 10, v_media_type_uuid);

Line 141: DBMS_SQL.COLUMN_VALUE(v_cursorID, 9, v_svr_plugin_class);

137: DBMS_SQL.COLUMN_VALUE(v_cursorID, 7, v_svr_type_id);
138:
139: DBMS_SQL.COLUMN_VALUE(v_cursorID, 8, v_svr_mps_plugin_id);
140:
141: DBMS_SQL.COLUMN_VALUE(v_cursorID, 9, v_svr_plugin_class);
142:
143: DBMS_SQL.COLUMN_VALUE(v_cursorID, 10, v_media_type_uuid);
144:
145: DBMS_SQL.COLUMN_VALUE(v_cursorID, 11, v_svr_login_rule_id);

Line 143: DBMS_SQL.COLUMN_VALUE(v_cursorID, 10, v_media_type_uuid);

139: DBMS_SQL.COLUMN_VALUE(v_cursorID, 8, v_svr_mps_plugin_id);
140:
141: DBMS_SQL.COLUMN_VALUE(v_cursorID, 9, v_svr_plugin_class);
142:
143: DBMS_SQL.COLUMN_VALUE(v_cursorID, 10, v_media_type_uuid);
144:
145: DBMS_SQL.COLUMN_VALUE(v_cursorID, 11, v_svr_login_rule_id);
146:
147: DBMS_SQL.COLUMN_VALUE(v_cursorID, 12, v_application_id);

Line 145: DBMS_SQL.COLUMN_VALUE(v_cursorID, 11, v_svr_login_rule_id);

141: DBMS_SQL.COLUMN_VALUE(v_cursorID, 9, v_svr_plugin_class);
142:
143: DBMS_SQL.COLUMN_VALUE(v_cursorID, 10, v_media_type_uuid);
144:
145: DBMS_SQL.COLUMN_VALUE(v_cursorID, 11, v_svr_login_rule_id);
146:
147: DBMS_SQL.COLUMN_VALUE(v_cursorID, 12, v_application_id);
148:
149: DBMS_SQL.COLUMN_VALUE(v_cursorID, 13, v_is_server_side);

Line 147: DBMS_SQL.COLUMN_VALUE(v_cursorID, 12, v_application_id);

143: DBMS_SQL.COLUMN_VALUE(v_cursorID, 10, v_media_type_uuid);
144:
145: DBMS_SQL.COLUMN_VALUE(v_cursorID, 11, v_svr_login_rule_id);
146:
147: DBMS_SQL.COLUMN_VALUE(v_cursorID, 12, v_application_id);
148:
149: DBMS_SQL.COLUMN_VALUE(v_cursorID, 13, v_is_server_side);
150:
151: DBMS_SQL.COLUMN_VALUE(v_cursorID, 14, v_classfn_query_proc);

Line 149: DBMS_SQL.COLUMN_VALUE(v_cursorID, 13, v_is_server_side);

145: DBMS_SQL.COLUMN_VALUE(v_cursorID, 11, v_svr_login_rule_id);
146:
147: DBMS_SQL.COLUMN_VALUE(v_cursorID, 12, v_application_id);
148:
149: DBMS_SQL.COLUMN_VALUE(v_cursorID, 13, v_is_server_side);
150:
151: DBMS_SQL.COLUMN_VALUE(v_cursorID, 14, v_classfn_query_proc);
152:
153:

Line 151: DBMS_SQL.COLUMN_VALUE(v_cursorID, 14, v_classfn_query_proc);

147: DBMS_SQL.COLUMN_VALUE(v_cursorID, 12, v_application_id);
148:
149: DBMS_SQL.COLUMN_VALUE(v_cursorID, 13, v_is_server_side);
150:
151: DBMS_SQL.COLUMN_VALUE(v_cursorID, 14, v_classfn_query_proc);
152:
153:
154:
155: x_media_type_list.EXTEND;

Line 174: DBMS_SQL.CLOSE_CURSOR(v_cursorID);

170: v_classfn_query_proc
171: );
172: end loop;
173:
174: DBMS_SQL.CLOSE_CURSOR(v_cursorID);
175:
176: EXCEPTION
177: WHEN fnd_api.g_exc_error THEN
178:

Line 179: DBMS_SQL.CLOSE_CURSOR(v_cursorID);

175:
176: EXCEPTION
177: WHEN fnd_api.g_exc_error THEN
178:
179: DBMS_SQL.CLOSE_CURSOR(v_cursorID);
180: x_return_status := fnd_api.g_ret_sts_error;
181:
182: WHEN fnd_api.g_exc_unexpected_error THEN
183:

Line 184: DBMS_SQL.CLOSE_CURSOR(v_cursorID);

180: x_return_status := fnd_api.g_ret_sts_error;
181:
182: WHEN fnd_api.g_exc_unexpected_error THEN
183:
184: DBMS_SQL.CLOSE_CURSOR(v_cursorID);
185: x_return_status := fnd_api.g_ret_sts_unexp_error;
186:
187: WHEN OTHERS THEN
188:

Line 189: DBMS_SQL.CLOSE_CURSOR(v_cursorID);

185: x_return_status := fnd_api.g_ret_sts_unexp_error;
186:
187: WHEN OTHERS THEN
188:
189: DBMS_SQL.CLOSE_CURSOR(v_cursorID);
190: x_return_status := fnd_api.g_ret_sts_unexp_error;
191:
192: END GET_MEDIA_TYPE_LIST;
193: