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 12783: '(PUBLICATION_ID,FND_APPLICATION_ID,APPLICATION_SHORT_NAME,NOTES)' || ' ' ||

12779: IF (x_status <> PUBLICATION_ERROR) AND(p_session_parameter <> model_copy)
12780: THEN
12781: ---------------- insert the fields of cz_pb_client_apps
12782: cz_pb_mgr.v_insert_string :='INSERT INTO cz_pb_client_apps'||p_db_link || ' ' ||
12783: '(PUBLICATION_ID,FND_APPLICATION_ID,APPLICATION_SHORT_NAME,NOTES)' || ' ' ||
12784: 'SELECT '||p_new_publication_id||',t.APPLICATION_ID,t.APPLICATION_SHORT_NAME,NOTES' || ' ' ||
12785: 'FROM cz_pb_client_apps,fnd_application' ||p_db_link|| ' ' ||
12786: 't WHERE cz_pb_client_apps.publication_id = :1' || ' ' ||
12787: 'and cz_pb_client_apps.APPLICATION_SHORT_NAME=t.APPLICATION_SHORT_NAME';

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

12781: ---------------- insert the fields of cz_pb_client_apps
12782: cz_pb_mgr.v_insert_string :='INSERT INTO cz_pb_client_apps'||p_db_link || ' ' ||
12783: '(PUBLICATION_ID,FND_APPLICATION_ID,APPLICATION_SHORT_NAME,NOTES)' || ' ' ||
12784: 'SELECT '||p_new_publication_id||',t.APPLICATION_ID,t.APPLICATION_SHORT_NAME,NOTES' || ' ' ||
12785: 'FROM cz_pb_client_apps,fnd_application' ||p_db_link|| ' ' ||
12786: 't WHERE cz_pb_client_apps.publication_id = :1' || ' ' ||
12787: 'and cz_pb_client_apps.APPLICATION_SHORT_NAME=t.APPLICATION_SHORT_NAME';
12788: EXECUTE IMMEDIATE v_insert_string using p_old_publication_id;
12789:

Line 19735: PROCEDURE seed_fnd_application_cp(errbuf IN OUT NOCOPY VARCHAR2, retcode IN OUT NOCOPY PLS_INTEGER, p_application_name VARCHAR2)

19731: errbuf := cz_utils.get_text('CZ_PB_OTHERS');
19732: END;
19733:
19734: --------------------------------------
19735: PROCEDURE seed_fnd_application_cp(errbuf IN OUT NOCOPY VARCHAR2, retcode IN OUT NOCOPY PLS_INTEGER, p_application_name VARCHAR2)
19736: AS
19737: v_run_id NUMBER := 0.0;
19738: v_pb_status VARCHAR2(3);
19739: l_application_id NUMBER;

Line 19745: FROM fnd_application_tl

19741: retcode := 0;
19742:
19743: SELECT application_id
19744: INTO l_application_id
19745: FROM fnd_application_tl
19746: WHERE fnd_application_tl.application_name = p_application_name AND fnd_application_tl.language = USERENV('LANG');
19747:
19748: INSERT INTO cz_ext_applications
19749: (application_id, preferred_ui_style, seeded_flag, deleted_flag

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

19742:
19743: SELECT application_id
19744: INTO l_application_id
19745: FROM fnd_application_tl
19746: WHERE fnd_application_tl.application_name = p_application_name AND fnd_application_tl.language = USERENV('LANG');
19747:
19748: INSERT INTO cz_ext_applications
19749: (application_id, preferred_ui_style, seeded_flag, deleted_flag
19750: )

Line 20190: FROM fnd_application

20186: FOR i IN p_application_id_tbl.FIRST .. p_application_id_tbl.LAST
20187: LOOP
20188: SELECT application_short_name
20189: INTO v_application_short_name
20190: FROM fnd_application
20191: WHERE application_id = p_application_id_tbl(i);
20192:
20193: INSERT INTO cz_pb_client_apps
20194: (publication_id, fnd_application_id, application_short_name, notes

Line 20194: (publication_id, fnd_application_id, application_short_name, notes

20190: FROM fnd_application
20191: WHERE application_id = p_application_id_tbl(i);
20192:
20193: INSERT INTO cz_pb_client_apps
20194: (publication_id, fnd_application_id, application_short_name, notes
20195: )
20196: VALUES (publicationid, p_application_id_tbl(i), v_application_short_name, NULL
20197: );
20198: END LOOP;

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

20279: FOR i IN p_application_id_tbl.FIRST .. p_application_id_tbl.LAST
20280: LOOP
20281:
20282: EXECUTE IMMEDIATE 'SELECT t.application_short_name,t.application_id'
20283: ||' FROM fnd_application s,fnd_application'||p_tgt_link
20284: ||' t WHERE s.application_id =:1 and '
20285: ||' s.APPLICATION_SHORT_NAME=t.APPLICATION_SHORT_NAME'
20286: into v_application_short_name,tgt_appl_id using p_application_id_tbl(i);
20287:

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

20284: ||' t WHERE s.application_id =:1 and '
20285: ||' s.APPLICATION_SHORT_NAME=t.APPLICATION_SHORT_NAME'
20286: into v_application_short_name,tgt_appl_id using p_application_id_tbl(i);
20287:
20288: v_edit_str :='INSERT INTO cz_pb_client_apps'||p_tgt_link||' (publication_id,fnd_application_id,application_short_name)'
20289: || ' ' || ' values (:1,:2,:3)';
20290:
20291: EXECUTE IMMEDIATE v_edit_str USING p_remote_publication_id,tgt_appl_id,v_application_short_name;
20292:

Line 20788: AND fnd_application_id = v_appl_id

20784: FROM cz_model_applicabilities_v
20785: WHERE product_key = LTRIM(RTRIM(productkey))
20786: AND UPPER(publication_mode) = LTRIM(RTRIM(UPPER(publicationmode)))
20787: AND server_id = serverid
20788: AND fnd_application_id = v_appl_id
20789: AND usage_id = v_usg_id
20790: AND LANGUAGE = v_lang_id
20791: AND deleted_flag = '0'
20792: AND UPPER(source_target_flag) = LTRIM(RTRIM(UPPER(sourcetargetflag)))

Line 21031: SELECT fnd_application_id

21027: ,x_status IN OUT NOCOPY VARCHAR2
21028: )
21029: AS
21030: BEGIN
21031: SELECT fnd_application_id
21032: BULK COLLECT INTO x_applicationid_tbl
21033: FROM cz_pb_client_apps
21034: WHERE publication_id = p_publication_id;
21035:

Line 22073: FROM fnd_application

22069: l_short_name := ' ';
22070:
22071: SELECT application_short_name
22072: INTO l_short_name
22073: FROM fnd_application
22074: WHERE application_id = p_appl_id_tbl(i);
22075:
22076: INSERT INTO cz_pb_client_apps
22077: (publication_id, fnd_application_id, application_short_name

Line 22077: (publication_id, fnd_application_id, application_short_name

22073: FROM fnd_application
22074: WHERE application_id = p_appl_id_tbl(i);
22075:
22076: INSERT INTO cz_pb_client_apps
22077: (publication_id, fnd_application_id, application_short_name
22078: )
22079: VALUES (v_new_publication_id, p_appl_id_tbl(i), l_short_name
22080: );
22081: ---- short name must be retrieved from fnd_applications_tl

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

22077: (publication_id, fnd_application_id, application_short_name
22078: )
22079: VALUES (v_new_publication_id, p_appl_id_tbl(i), l_short_name
22080: );
22081: ---- short name must be retrieved from fnd_applications_tl
22082: END LOOP;
22083: END IF;
22084:
22085: IF (p_usg_id_tbl.COUNT > 0)