APPS.CZ_PB_SYNC dependencies on CZ_PUBLICATION_USAGES

Line 443: DELETE FROM cz_publication_usages

439: PROCEDURE clear_pb_usages(p_publication_id IN cz_model_publications.publication_id%TYPE)
440: IS
441:
442: BEGIN
443: DELETE FROM cz_publication_usages
444: WHERE publication_id = p_publication_id;
445: EXCEPTION
446: WHEN OTHERS THEN
447: m_err_message := CZ_UTILS.GET_TEXT('CZ_PB_SYNC_DEL_PB_USAGE_ERR','PUBID',p_publication_id, 'SQLERRM', SQLERRM);

Line 756: ----insert into cz_publication_usages

752: ' FROM cz_pb_client_apps'||p_link_name||' x, fnd_application s' ||
753: ' WHERE x.publication_id = '||p_publication_id ||
754: ' AND x.application_short_name = s.application_short_name' ;
755:
756: ----insert into cz_publication_usages
757: EXECUTE IMMEDIATE
758: 'INSERT INTO cz_publication_usages(publication_id,usage_id)' ||
759: ' SELECT '||l_new_pb_id||',usage_id' ||
760: ' FROM cz_publication_usages'||p_link_name||' z' ||

Line 758: 'INSERT INTO cz_publication_usages(publication_id,usage_id)' ||

754: ' AND x.application_short_name = s.application_short_name' ;
755:
756: ----insert into cz_publication_usages
757: EXECUTE IMMEDIATE
758: 'INSERT INTO cz_publication_usages(publication_id,usage_id)' ||
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:

Line 760: ' FROM cz_publication_usages'||p_link_name||' z' ||

756: ----insert into cz_publication_usages
757: EXECUTE IMMEDIATE
758: 'INSERT INTO cz_publication_usages(publication_id,usage_id)' ||
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