APPS.PV_GQ_ELEMENTS_PVT dependencies on PV_PARTNER_PROGRAM_TL

Line 358: FROM pv_partner_program_tl tl

354: WHERE qsnr_element_id = l_id;
355:
356: CURSOR c_get_additional_tl_info (cv_program_id IN NUMBER) IS
357: SELECT QSNR_TITLE, QSNR_HEADER, QSNR_FOOTER, language
358: FROM pv_partner_program_tl tl
359: WHERE program_id = cv_program_id;
360:
361: l_qsnr_element_id NUMBER;
362: l_object_version_number NUMBER;

Line 563: update pv_partner_program_tl

559: END IF;
560: FETCH c_get_additional_tl_info bulk collect into
561: QSNR_TITLE_ARRAY, QSNR_HEADER_ARRAY, QSNR_FOOTER_ARRAY, PRGM_LANGUAGE_ARRAY LIMIT 100;
562: Forall i in 1..QSNR_TITLE_ARRAY.count
563: update pv_partner_program_tl
564: set
565: QSNR_TITLE = QSNR_TITLE_ARRAY(i),
566: QSNR_HEADER = QSNR_HEADER_ARRAY(i),
567: QSNR_FOOTER = QSNR_FOOTER_ARRAY(i),