APPS.QP_LOADER_PVT dependencies on QP_PTE_SOURCE_SYSTEMS

Line 205: from qp_pte_source_systems

201: end if;
202:
203: begin
204: select last_updated_by, last_update_date into l_db_last_updated_by, l_db_last_update_date
205: from qp_pte_source_systems
206: where pte_code = x_pte_code
207: and application_short_name = x_application_short_name
208: and rownum = 1;
209:

Line 220: update qp_pte_source_systems

216: x_file_who => l_db_who))
217: THEN
218: null;
219: else
220: update qp_pte_source_systems
221: set enabled_flag = x_enabled_flag,
222: last_updated_by = l_user_id,
223: last_update_date =to_date(x_last_update_date,'YYYY/MM/DD'),
224: last_update_login = 0

Line 236: insert into qp_pte_source_systems

232: begin
233:
234: select qp_pte_source_system_s.nextval into l_pte_source_system_id from dual;
235:
236: insert into qp_pte_source_systems
237: (pte_source_system_id,
238: pte_code,
239: application_short_name,
240: enabled_flag,

Line 286: from qp_pte_source_systems

282: end if;
283:
284: begin
285: select pte_source_system_id into l_pte_source_system_id
286: from qp_pte_source_systems
287: where pte_code = x_pte_code
288: and application_short_name = x_application_short_name
289: and rownum = 1;
290: exception