APPS.CSF_GPS_PUB dependencies on CSF_GPS_VENDORS_TL

Line 85: l_label csf_gps_vendors_tl.vendor_name%TYPE;

81:
82: FUNCTION get_vendor_name(p_vendor_id NUMBER)
83: RETURN VARCHAR2 IS
84: --
85: l_label csf_gps_vendors_tl.vendor_name%TYPE;
86: CURSOR c_vendors IS
87: SELECT vendor_name
88: FROM csf_gps_vendors_vl
89: WHERE vendor_id = p_vendor_id;

Line 528: DELETE FROM csf_gps_vendors_tl t

524: END purge_location_feeds;
525:
526: PROCEDURE add_language IS
527: BEGIN
528: DELETE FROM csf_gps_vendors_tl t
529: WHERE NOT EXISTS (SELECT NULL FROM csf_gps_vendors_b b WHERE b.vendor_id = t.vendor_id);
530:
531: UPDATE csf_gps_vendors_tl cgvt
532: SET (cgvt.vendor_name, cgvt.description) = (

Line 531: UPDATE csf_gps_vendors_tl cgvt

527: BEGIN
528: DELETE FROM csf_gps_vendors_tl t
529: WHERE NOT EXISTS (SELECT NULL FROM csf_gps_vendors_b b WHERE b.vendor_id = t.vendor_id);
530:
531: UPDATE csf_gps_vendors_tl cgvt
532: SET (cgvt.vendor_name, cgvt.description) = (
533: SELECT cgvtl.vendor_name, cgvtl.description
534: FROM csf_gps_vendors_tl cgvtl
535: WHERE cgvtl.vendor_id = cgvt.vendor_id

Line 534: FROM csf_gps_vendors_tl cgvtl

530:
531: UPDATE csf_gps_vendors_tl cgvt
532: SET (cgvt.vendor_name, cgvt.description) = (
533: SELECT cgvtl.vendor_name, cgvtl.description
534: FROM csf_gps_vendors_tl cgvtl
535: WHERE cgvtl.vendor_id = cgvt.vendor_id
536: AND cgvtl.language = cgvt.source_lang
537: )
538: WHERE (cgvt.vendor_id, cgvt.language) IN (

Line 540: FROM csf_gps_vendors_tl subb, csf_gps_vendors_tl subt

536: AND cgvtl.language = cgvt.source_lang
537: )
538: WHERE (cgvt.vendor_id, cgvt.language) IN (
539: SELECT subt.vendor_id, subt.language
540: FROM csf_gps_vendors_tl subb, csf_gps_vendors_tl subt
541: WHERE subb.vendor_id = subt.vendor_id
542: AND subb.language = subt.source_lang
543: AND (
544: subb.vendor_name <> subt.vendor_name

Line 551: INSERT INTO csf_gps_vendors_tl (

547: OR (subb.description IS NOT NULL AND subt.description IS NULL)
548: )
549: );
550:
551: INSERT INTO csf_gps_vendors_tl (
552: vendor_id
553: , vendor_name
554: , description
555: , created_by

Line 573: FROM csf_gps_vendors_tl cgvt

569: , cgvt.last_update_date
570: , cgvt.last_update_login
571: , l.language_code
572: , cgvt.source_lang
573: FROM csf_gps_vendors_tl cgvt
574: , fnd_languages l
575: WHERE l.installed_flag IN ('I', 'B')
576: AND cgvt.language = userenv('LANG')
577: AND NOT EXISTS (

Line 579: FROM csf_gps_vendors_tl t

575: WHERE l.installed_flag IN ('I', 'B')
576: AND cgvt.language = userenv('LANG')
577: AND NOT EXISTS (
578: SELECT NULL
579: FROM csf_gps_vendors_tl t
580: WHERE t.vendor_id = cgvt.vendor_id
581: AND t.language = l.language_code
582: );
583: END add_language;