APPS.CZ_PB_SYNC dependencies on CZ_PB_LANGUAGES

Line 423: ---procedure that deletes data from cz_pb_languages for a given publication

419: RAISE;
420: END clear_pb_clients;
421:
422: -----------------------------------------------------
423: ---procedure that deletes data from cz_pb_languages for a given publication
424: PROCEDURE clear_pb_lang(p_publication_id IN cz_model_publications.publication_id%TYPE)
425: IS
426:
427: BEGIN

Line 428: DELETE FROM cz_pb_languages

424: PROCEDURE clear_pb_lang(p_publication_id IN cz_model_publications.publication_id%TYPE)
425: IS
426:
427: BEGIN
428: DELETE FROM cz_pb_languages
429: WHERE publication_id = p_publication_id;
430: EXCEPTION
431: WHEN OTHERS THEN
432: m_err_message := CZ_UTILS.GET_TEXT('CZ_PB_SYNC_DEL_LANG_ERR','PUBID',p_publication_id, 'SQLERRM', SQLERRM);

Line 763: ----insert into cz_pb_languages

759: ' SELECT '||l_new_pb_id||',usage_id' ||
760: ' FROM cz_publication_usages'||p_link_name||' z' ||
761: ' WHERE z.publication_id = '||p_publication_id ;
762:
763: ----insert into cz_pb_languages
764: EXECUTE IMMEDIATE
765: 'INSERT INTO cz_pb_languages(publication_id,language)' ||
766: ' SELECT '||l_new_pb_id||', language' ||
767: ' FROM cz_pb_languages'||p_link_name||' y' ||

Line 765: 'INSERT INTO cz_pb_languages(publication_id,language)' ||

761: ' WHERE z.publication_id = '||p_publication_id ;
762:
763: ----insert into cz_pb_languages
764: EXECUTE IMMEDIATE
765: 'INSERT INTO cz_pb_languages(publication_id,language)' ||
766: ' SELECT '||l_new_pb_id||', language' ||
767: ' FROM cz_pb_languages'||p_link_name||' y' ||
768: ' WHERE y.publication_id = '||p_publication_id;
769:

Line 767: ' FROM cz_pb_languages'||p_link_name||' y' ||

763: ----insert into cz_pb_languages
764: EXECUTE IMMEDIATE
765: 'INSERT INTO cz_pb_languages(publication_id,language)' ||
766: ' SELECT '||l_new_pb_id||', language' ||
767: ' FROM cz_pb_languages'||p_link_name||' y' ||
768: ' WHERE y.publication_id = '||p_publication_id;
769:
770: m_err_message := 'source pb: '||l_new_pb_id||' created for target pb: '||p_publication_id;
771: error_msg_populate(m_err_message ,'CZ_PB_MGR.CREATESRCPBRECORDS',SQLCODE);