APPS.CZ_PB_SYNC dependencies on CZ_PB_CLIENT_APPS

Line 408: ---procedure that deletes data from cz_pb_client_apps for a given publication

404: RAISE;
405: END clear_source_pb_record;
406:
407: ----------------------------------------------------
408: ---procedure that deletes data from cz_pb_client_apps for a given publication
409: PROCEDURE clear_pb_clients(p_publication_id IN cz_model_publications.publication_id%TYPE)
410: IS
411:
412: BEGIN

Line 413: DELETE FROM cz_pb_client_apps

409: PROCEDURE clear_pb_clients(p_publication_id IN cz_model_publications.publication_id%TYPE)
410: IS
411:
412: BEGIN
413: DELETE FROM cz_pb_client_apps
414: WHERE publication_id = p_publication_id;
415: EXCEPTION
416: WHEN OTHERS THEN
417: m_err_message := CZ_UTILS.GET_TEXT('CZ_PB_SYNC_DEL_PB_CLIENT_ERR', 'PUBID',p_publication_id, 'SQLERRM', SQLERRM);

Line 438: ---procedure that deletes data from cz_pb_client_apps for a given publication

434: RAISE;
435: END clear_pb_lang;
436:
437: -----------------------------------------------------
438: ---procedure that deletes data from cz_pb_client_apps for a given publication
439: PROCEDURE clear_pb_usages(p_publication_id IN cz_model_publications.publication_id%TYPE)
440: IS
441:
442: BEGIN

Line 745: ----insert into cz_pb_client_apps

741: 'UPDATE cz_model_publications'||p_link_name||' t ' ||
742: ' SET t.remote_publication_id = '||l_new_pb_id||
743: ' WHERE t.publication_id = '||p_publication_id ;
744:
745: ----insert into cz_pb_client_apps
746: EXECUTE IMMEDIATE
747: 'INSERT INTO cz_pb_client_apps(publication_id,fnd_application_id,application_short_name,notes)' ||
748: ' SELECT '||l_new_pb_id||',' ||
749: ' s.application_id,' ||

Line 747: 'INSERT INTO cz_pb_client_apps(publication_id,fnd_application_id,application_short_name,notes)' ||

743: ' WHERE t.publication_id = '||p_publication_id ;
744:
745: ----insert into cz_pb_client_apps
746: EXECUTE IMMEDIATE
747: 'INSERT INTO cz_pb_client_apps(publication_id,fnd_application_id,application_short_name,notes)' ||
748: ' SELECT '||l_new_pb_id||',' ||
749: ' s.application_id,' ||
750: ' x.application_short_name,' ||
751: ' x.notes' ||

Line 752: ' FROM cz_pb_client_apps'||p_link_name||' x, fnd_applications s' ||

748: ' SELECT '||l_new_pb_id||',' ||
749: ' s.application_id,' ||
750: ' x.application_short_name,' ||
751: ' x.notes' ||
752: ' FROM cz_pb_client_apps'||p_link_name||' x, fnd_applications 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