eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_PB_MGR dependencies on CZ_PB_CLIENT_APPS

Line 13779: ---------------- insert the fields of cz_pb_client_apps

13775: AS
13776: BEGIN
13777: IF (x_status <> PUBLICATION_ERROR) AND(p_session_parameter <> model_copy)
13778: THEN
13779: ---------------- insert the fields of cz_pb_client_apps
13780: cz_pb_mgr.v_insert_string :='INSERT INTO cz_pb_client_apps'||p_db_link || ' ' ||
13781: '(PUBLICATION_ID,FND_APPLICATION_ID,APPLICATION_SHORT_NAME,NOTES)' || ' ' ||
13782: 'SELECT '||p_new_publication_id||',t.APPLICATION_ID,t.APPLICATION_SHORT_NAME,NOTES' || ' ' ||
13783: 'FROM cz_pb_client_apps,fnd_application' ||p_db_link|| ' ' ||

Line 13780: cz_pb_mgr.v_insert_string :='INSERT INTO cz_pb_client_apps'||p_db_link || ' ' ||

13776: BEGIN
13777: IF (x_status <> PUBLICATION_ERROR) AND(p_session_parameter <> model_copy)
13778: THEN
13779: ---------------- insert the fields of cz_pb_client_apps
13780: cz_pb_mgr.v_insert_string :='INSERT INTO cz_pb_client_apps'||p_db_link || ' ' ||
13781: '(PUBLICATION_ID,FND_APPLICATION_ID,APPLICATION_SHORT_NAME,NOTES)' || ' ' ||
13782: 'SELECT '||p_new_publication_id||',t.APPLICATION_ID,t.APPLICATION_SHORT_NAME,NOTES' || ' ' ||
13783: 'FROM cz_pb_client_apps,fnd_application' ||p_db_link|| ' ' ||
13784: 't WHERE cz_pb_client_apps.publication_id = :1' || ' ' ||

Line 13783: 'FROM cz_pb_client_apps,fnd_application' ||p_db_link|| ' ' ||

13779: ---------------- insert the fields of cz_pb_client_apps
13780: cz_pb_mgr.v_insert_string :='INSERT INTO cz_pb_client_apps'||p_db_link || ' ' ||
13781: '(PUBLICATION_ID,FND_APPLICATION_ID,APPLICATION_SHORT_NAME,NOTES)' || ' ' ||
13782: 'SELECT '||p_new_publication_id||',t.APPLICATION_ID,t.APPLICATION_SHORT_NAME,NOTES' || ' ' ||
13783: 'FROM cz_pb_client_apps,fnd_application' ||p_db_link|| ' ' ||
13784: 't WHERE cz_pb_client_apps.publication_id = :1' || ' ' ||
13785: 'and cz_pb_client_apps.APPLICATION_SHORT_NAME=t.APPLICATION_SHORT_NAME';
13786: EXECUTE IMMEDIATE v_insert_string using p_old_publication_id;
13787:

Line 13784: 't WHERE cz_pb_client_apps.publication_id = :1' || ' ' ||

13780: cz_pb_mgr.v_insert_string :='INSERT INTO cz_pb_client_apps'||p_db_link || ' ' ||
13781: '(PUBLICATION_ID,FND_APPLICATION_ID,APPLICATION_SHORT_NAME,NOTES)' || ' ' ||
13782: 'SELECT '||p_new_publication_id||',t.APPLICATION_ID,t.APPLICATION_SHORT_NAME,NOTES' || ' ' ||
13783: 'FROM cz_pb_client_apps,fnd_application' ||p_db_link|| ' ' ||
13784: 't WHERE cz_pb_client_apps.publication_id = :1' || ' ' ||
13785: 'and cz_pb_client_apps.APPLICATION_SHORT_NAME=t.APPLICATION_SHORT_NAME';
13786: EXECUTE IMMEDIATE v_insert_string using p_old_publication_id;
13787:
13788: COMMIT;

Line 13785: 'and cz_pb_client_apps.APPLICATION_SHORT_NAME=t.APPLICATION_SHORT_NAME';

13781: '(PUBLICATION_ID,FND_APPLICATION_ID,APPLICATION_SHORT_NAME,NOTES)' || ' ' ||
13782: 'SELECT '||p_new_publication_id||',t.APPLICATION_ID,t.APPLICATION_SHORT_NAME,NOTES' || ' ' ||
13783: 'FROM cz_pb_client_apps,fnd_application' ||p_db_link|| ' ' ||
13784: 't WHERE cz_pb_client_apps.publication_id = :1' || ' ' ||
13785: 'and cz_pb_client_apps.APPLICATION_SHORT_NAME=t.APPLICATION_SHORT_NAME';
13786: EXECUTE IMMEDIATE v_insert_string using p_old_publication_id;
13787:
13788: COMMIT;
13789: ----------insert the fields of cz_publication_usages

Line 21090: DELETE FROM cz_pb_client_apps

21086: UPDATE cz_model_publications
21087: SET deleted_flag = '1'
21088: WHERE publication_id = publicationid;
21089:
21090: DELETE FROM cz_pb_client_apps
21091: WHERE publication_id = publicationid;
21092:
21093: DELETE FROM cz_publication_usages
21094: WHERE publication_id = publicationid;

Line 21121: || 'DELETE FROM cz_pb_client_apps'

21117: || 'END;';
21118:
21119: EXECUTE IMMEDIATE 'BEGIN'
21120: || ' '
21121: || 'DELETE FROM cz_pb_client_apps'
21122: || v_cz_link_name
21123: || ''
21124: || ' '
21125: || 'WHERE publication_id = '

Line 21373: DELETE FROM cz_pb_client_apps

21369: BEGIN
21370: DELETE FROM cz_publication_usages
21371: WHERE cz_publication_usages.publication_id = publicationid;
21372:
21373: DELETE FROM cz_pb_client_apps
21374: WHERE cz_pb_client_apps.publication_id = publicationid;
21375:
21376: DELETE FROM cz_pb_languages
21377: WHERE cz_pb_languages.publication_id = publicationid;

Line 21374: WHERE cz_pb_client_apps.publication_id = publicationid;

21370: DELETE FROM cz_publication_usages
21371: WHERE cz_publication_usages.publication_id = publicationid;
21372:
21373: DELETE FROM cz_pb_client_apps
21374: WHERE cz_pb_client_apps.publication_id = publicationid;
21375:
21376: DELETE FROM cz_pb_languages
21377: WHERE cz_pb_languages.publication_id = publicationid;
21378: EXCEPTION

Line 21402: INSERT INTO cz_pb_client_apps

21398: INTO v_application_short_name
21399: FROM fnd_application
21400: WHERE application_id = p_application_id_tbl(i);
21401:
21402: INSERT INTO cz_pb_client_apps
21403: (publication_id, fnd_application_id, application_short_name, notes
21404: )
21405: VALUES (publicationid, p_application_id_tbl(i), v_application_short_name, NULL
21406: );

Line 21477: v_edit_str := 'DELETE FROM cz_pb_client_apps'||p_tgt_link||' ' ||

21473:
21474: EXECUTE IMMEDIATE v_edit_str using p_remote_publication_id;
21475:
21476:
21477: v_edit_str := 'DELETE FROM cz_pb_client_apps'||p_tgt_link||' ' ||
21478: 'WHERE cz_pb_client_apps.publication_id = :1';
21479:
21480: EXECUTE IMMEDIATE v_edit_str using p_remote_publication_id;
21481:

Line 21478: 'WHERE cz_pb_client_apps.publication_id = :1';

21474: EXECUTE IMMEDIATE v_edit_str using p_remote_publication_id;
21475:
21476:
21477: v_edit_str := 'DELETE FROM cz_pb_client_apps'||p_tgt_link||' ' ||
21478: 'WHERE cz_pb_client_apps.publication_id = :1';
21479:
21480: EXECUTE IMMEDIATE v_edit_str using p_remote_publication_id;
21481:
21482: v_edit_str := 'DELETE FROM cz_pb_languages'||p_tgt_link||' ' ||

Line 21497: v_edit_str :='INSERT INTO cz_pb_client_apps'||p_tgt_link||' (publication_id,fnd_application_id,application_short_name)'

21493: ||' t WHERE s.application_id =:1 and '
21494: ||' s.APPLICATION_SHORT_NAME=t.APPLICATION_SHORT_NAME'
21495: into v_application_short_name,tgt_appl_id using p_application_id_tbl(i);
21496:
21497: v_edit_str :='INSERT INTO cz_pb_client_apps'||p_tgt_link||' (publication_id,fnd_application_id,application_short_name)'
21498: || ' ' || ' values (:1,:2,:3)';
21499:
21500: EXECUTE IMMEDIATE v_edit_str USING p_remote_publication_id,tgt_appl_id,v_application_short_name;
21501:

Line 22242: FROM cz_pb_client_apps

22238: AS
22239: BEGIN
22240: SELECT fnd_application_id
22241: BULK COLLECT INTO x_applicationid_tbl
22242: FROM cz_pb_client_apps
22243: WHERE publication_id = p_publication_id;
22244:
22245: SELECT usage_id
22246: BULK COLLECT INTO x_usageid_tbl

Line 23104: l_short_name cz_pb_client_apps.application_short_name%TYPE;

23100: l_inventory_item_id cz_devl_projects.inventory_item_id%TYPE;
23101: l_organization_id cz_devl_projects.organization_id%TYPE;
23102: l_product_key cz_devl_projects.product_key%TYPE;
23103: l_ui_def_id cz_ui_defs.ui_def_id%TYPE;
23104: l_short_name cz_pb_client_apps.application_short_name%TYPE;
23105: pub_overlap EXCEPTION;
23106: no_model_id EXCEPTION;
23107: no_model_exists EXCEPTION;
23108: no_ui_exists EXCEPTION;

Line 23285: INSERT INTO cz_pb_client_apps

23281: INTO l_short_name
23282: FROM fnd_application
23283: WHERE application_id = p_appl_id_tbl(i);
23284:
23285: INSERT INTO cz_pb_client_apps
23286: (publication_id, fnd_application_id, application_short_name
23287: )
23288: VALUES (v_new_publication_id, p_appl_id_tbl(i), l_short_name
23289: );