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 FND_APPLICATION

Line 13781: '(PUBLICATION_ID,FND_APPLICATION_ID,APPLICATION_SHORT_NAME,NOTES)' || ' ' ||

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' || ' ' ||
13785: 'and cz_pb_client_apps.APPLICATION_SHORT_NAME=t.APPLICATION_SHORT_NAME';

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 20943: PROCEDURE seed_fnd_application_cp(errbuf IN OUT NOCOPY VARCHAR2, retcode IN OUT NOCOPY PLS_INTEGER, p_application_name VARCHAR2)

20939: errbuf := cz_utils.get_text('CZ_PB_OTHERS');
20940: END;
20941:
20942: --------------------------------------
20943: PROCEDURE seed_fnd_application_cp(errbuf IN OUT NOCOPY VARCHAR2, retcode IN OUT NOCOPY PLS_INTEGER, p_application_name VARCHAR2)
20944: AS
20945: v_run_id NUMBER := 0.0;
20946: v_pb_status VARCHAR2(3);
20947: l_application_id NUMBER;

Line 20953: FROM fnd_application_tl

20949: retcode := 0;
20950:
20951: SELECT application_id
20952: INTO l_application_id
20953: FROM fnd_application_tl
20954: WHERE fnd_application_tl.application_name = p_application_name AND fnd_application_tl.language = USERENV('LANG');
20955:
20956: INSERT INTO cz_ext_applications
20957: (application_id, preferred_ui_style, seeded_flag, deleted_flag

Line 20954: WHERE fnd_application_tl.application_name = p_application_name AND fnd_application_tl.language = USERENV('LANG');

20950:
20951: SELECT application_id
20952: INTO l_application_id
20953: FROM fnd_application_tl
20954: WHERE fnd_application_tl.application_name = p_application_name AND fnd_application_tl.language = USERENV('LANG');
20955:
20956: INSERT INTO cz_ext_applications
20957: (application_id, preferred_ui_style, seeded_flag, deleted_flag
20958: )

Line 21399: FROM fnd_application

21395: FOR i IN p_application_id_tbl.FIRST .. p_application_id_tbl.LAST
21396: LOOP
21397: SELECT application_short_name
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

Line 21403: (publication_id, fnd_application_id, application_short_name, notes

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: );
21407: END LOOP;

Line 21492: ||' FROM fnd_application s,fnd_application'||p_tgt_link

21488: FOR i IN p_application_id_tbl.FIRST .. p_application_id_tbl.LAST
21489: LOOP
21490:
21491: EXECUTE IMMEDIATE 'SELECT t.application_short_name,t.application_id'
21492: ||' FROM fnd_application s,fnd_application'||p_tgt_link
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:

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 21997: AND fnd_application_id = v_appl_id

21993: FROM cz_model_applicabilities_v
21994: WHERE product_key = LTRIM(RTRIM(productkey))
21995: AND UPPER(publication_mode) = LTRIM(RTRIM(UPPER(publicationmode)))
21996: AND server_id = serverid
21997: AND fnd_application_id = v_appl_id
21998: AND usage_id = v_usg_id
21999: AND LANGUAGE = v_lang_id
22000: AND deleted_flag = '0'
22001: AND UPPER(source_target_flag) = LTRIM(RTRIM(UPPER(sourcetargetflag)))

Line 22240: SELECT fnd_application_id

22236: ,x_status IN OUT NOCOPY VARCHAR2
22237: )
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:

Line 23282: FROM fnd_application

23278: l_short_name := ' ';
23279:
23280: SELECT application_short_name
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

Line 23286: (publication_id, fnd_application_id, application_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: );
23290: ---- short name must be retrieved from fnd_applications_tl

Line 23290: ---- short name must be retrieved from fnd_applications_tl

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: );
23290: ---- short name must be retrieved from fnd_applications_tl
23291: END LOOP;
23292: END IF;
23293:
23294: IF (p_usg_id_tbl.COUNT > 0)