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_DEVELOPER_UTILS_PVT dependencies on CZ_UI_TEMPLATES

Line 249: l_user_name cz_ui_templates.checkout_user%type;

245: TYPE t_checkout_user_tbl IS TABLE OF cz_devl_projects.checkout_user%TYPE INDEX BY BINARY_INTEGER;
246: TYPE number_type_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
247: TYPE name_tbl IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
248:
249: l_user_name cz_ui_templates.checkout_user%type;
250: l_rp_folder NUMBER;
251: l_rp_model_tbl number_type_tbl;
252: l_rp_fld_tbl number_type_tbl;
253: l_uct_tbl number_type_tbl;

Line 322: FROM cz_rp_entries, cz_ui_templates

318: l_uct_tbl.DELETE;
319: SELECT object_id, checkout_user, template_name
320: BULK COLLECT
321: INTO l_uct_tbl, l_checkout_user_tbl, l_template_name_tbl
322: FROM cz_rp_entries, cz_ui_templates
323: WHERE cz_rp_entries.object_type = 'UCT'
324: AND cz_rp_entries.deleted_flag = '0'
325: AND cz_rp_entries.seeded_flag <> '1'
326: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)

Line 327: AND cz_rp_entries.object_id = cz_ui_templates.template_id

323: WHERE cz_rp_entries.object_type = 'UCT'
324: AND cz_rp_entries.deleted_flag = '0'
325: AND cz_rp_entries.seeded_flag <> '1'
326: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)
327: AND cz_rp_entries.object_id = cz_ui_templates.template_id
328: AND cz_ui_templates.ui_def_id = 0;
329:
330: IF (l_uct_tbl.COUNT > 0) THEN
331: FOR J IN l_uct_tbl.FIRST..l_uct_tbl.LAST

Line 328: AND cz_ui_templates.ui_def_id = 0;

324: AND cz_rp_entries.deleted_flag = '0'
325: AND cz_rp_entries.seeded_flag <> '1'
326: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)
327: AND cz_rp_entries.object_id = cz_ui_templates.template_id
328: AND cz_ui_templates.ui_def_id = 0;
329:
330: IF (l_uct_tbl.COUNT > 0) THEN
331: FOR J IN l_uct_tbl.FIRST..l_uct_tbl.LAST
332: LOOP

Line 5936: l_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;

5932: ) IS
5933:
5934: -- l_api_version CONSTANT NUMBER := 1.0;
5935: -- l_api_name CONSTANT VARCHAR2(30) := 'copy_ui_template';
5936: l_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;
5937: l_copied_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;
5938: INVALID_TEMPLATE_ID_EXCP EXCEPTION;
5939: l_name cz_rp_entries.name%TYPE;
5940: l_title_id NUMBER;

Line 5937: l_copied_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;

5933:
5934: -- l_api_version CONSTANT NUMBER := 1.0;
5935: -- l_api_name CONSTANT VARCHAR2(30) := 'copy_ui_template';
5936: l_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;
5937: l_copied_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;
5938: INVALID_TEMPLATE_ID_EXCP EXCEPTION;
5939: l_name cz_rp_entries.name%TYPE;
5940: l_title_id NUMBER;
5941: l_main_message_id NUMBER;

Line 5946: l_template_name cz_ui_templates.template_name%TYPE;

5942: l_old_title_id NUMBER;
5943: l_old_main_message_id NUMBER;
5944: l_index NUMBER;
5945: l_template_type NUMBER;
5946: l_template_name cz_ui_templates.template_name%TYPE;
5947: l_templates cz_security_pvt.number_type_tbl;
5948: l_locked_templates cz_security_pvt.number_type_tbl;
5949: l_return_status VARCHAR2(1);
5950: l_msg_count NUMBER;

Line 5957: FROM CZ_UI_TEMPLATES

5953:
5954: BEGIN
5955: SELECT jrad_doc, template_name, template_type
5956: INTO l_jrad_doc, l_template_name, l_template_type
5957: FROM CZ_UI_TEMPLATES
5958: WHERE ui_def_id=0 AND template_id=p_template_id;
5959:
5960: l_templates(1) := p_template_id;
5961: cz_security_pvt.lock_template(

Line 5973: x_new_template_id := allocateId('CZ_UI_TEMPLATES_S');

5969: x_msg_data => x_msg_data);
5970: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5971: RAISE FAILED_TO_LOCK_UCT;
5972: END IF;
5973: x_new_template_id := allocateId('CZ_UI_TEMPLATES_S');
5974: l_name := copy_name(p_template_id,'UCT');
5975:
5976: -- The jrad_doc is broken up into pieces (paths and fileName) and saved in
5977: -- jdr_paths.path_name. jdr_paths.path_name is a varchar2(60) type. So the fileName

Line 5998: INSERT INTO CZ_UI_TEMPLATES(

5994: x_return_status,
5995: x_msg_count,
5996: x_msg_data);
5997:
5998: INSERT INTO CZ_UI_TEMPLATES(
5999: TEMPLATE_ID
6000: ,UI_DEF_ID
6001: ,TEMPLATE_NAME
6002: ,TEMPLATE_TYPE

Line 6037: FROM CZ_UI_TEMPLATES

6033: ,ROOT_REGION_TYPE
6034: ,BUTTON_BAR_TEMPL_UIDEF_ID
6035: ,ROOT_ELEMENT_SIGNATURE_ID
6036: ,AMN_USAGE
6037: FROM CZ_UI_TEMPLATES
6038: WHERE ui_def_id=0 AND template_id = p_template_id;
6039:
6040: IF SQL%ROWCOUNT = 0 THEN
6041: RAISE INVALID_TEMPLATE_ID_EXCP;

Line 6047: FROM cz_ui_templates

6043:
6044: -----create new title id and main message id fix for bug# 3939234
6045: SELECT title_id, main_message_id
6046: INTO l_old_title_id, l_old_main_message_id
6047: FROM cz_ui_templates
6048: WHERE template_id = p_template_id
6049: AND ui_def_id = 0;
6050:
6051: IF (l_old_title_id IS NOT NULL) THEN

Line 6059: UPDATE cz_ui_templates

6055: IF (l_old_main_message_id IS NOT NULL) THEN
6056: l_main_message_id := copy_INTL_TEXT(l_old_main_message_id);
6057: END IF;
6058:
6059: UPDATE cz_ui_templates
6060: SET title_id = l_title_id,
6061: main_message_id = l_main_message_id
6062: WHERE template_id = x_new_template_id
6063: AND ui_def_id = 0;

Line 6976: l_ref_template_name cz_ui_templates.template_name%TYPE;

6972: l_ui_name_tbl ui_name_tbl;
6973: l_mt_flag_tbl ui_name_tbl;
6974: l_ref_template_tbl num_type_tbl;
6975: l_ref_templ_ui_tbl num_type_tbl;
6976: l_ref_template_name cz_ui_templates.template_name%TYPE;
6977:
6978: BEGIN
6979: FND_MSG_PUB.initialize;
6980: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7064: FROM cz_ui_templates

7060: FOR I IN l_ref_template_tbl.FIRST..l_ref_template_tbl.LAST
7061: LOOP
7062: BEGIN
7063: SELECT template_name INTO l_ref_template_name
7064: FROM cz_ui_templates
7065: WHERE cz_ui_templates.template_id = l_ref_template_tbl(i)
7066: AND cz_ui_templates.ui_def_id = l_ref_templ_ui_tbl(i)
7067: AND cz_ui_templates.deleted_flag = '0';
7068: EXCEPTION

Line 7065: WHERE cz_ui_templates.template_id = l_ref_template_tbl(i)

7061: LOOP
7062: BEGIN
7063: SELECT template_name INTO l_ref_template_name
7064: FROM cz_ui_templates
7065: WHERE cz_ui_templates.template_id = l_ref_template_tbl(i)
7066: AND cz_ui_templates.ui_def_id = l_ref_templ_ui_tbl(i)
7067: AND cz_ui_templates.deleted_flag = '0';
7068: EXCEPTION
7069: WHEN NO_DATA_FOUND THEN

Line 7066: AND cz_ui_templates.ui_def_id = l_ref_templ_ui_tbl(i)

7062: BEGIN
7063: SELECT template_name INTO l_ref_template_name
7064: FROM cz_ui_templates
7065: WHERE cz_ui_templates.template_id = l_ref_template_tbl(i)
7066: AND cz_ui_templates.ui_def_id = l_ref_templ_ui_tbl(i)
7067: AND cz_ui_templates.deleted_flag = '0';
7068: EXCEPTION
7069: WHEN NO_DATA_FOUND THEN
7070: l_ref_template_name := NULL;

Line 7067: AND cz_ui_templates.deleted_flag = '0';

7063: SELECT template_name INTO l_ref_template_name
7064: FROM cz_ui_templates
7065: WHERE cz_ui_templates.template_id = l_ref_template_tbl(i)
7066: AND cz_ui_templates.ui_def_id = l_ref_templ_ui_tbl(i)
7067: AND cz_ui_templates.deleted_flag = '0';
7068: EXCEPTION
7069: WHEN NO_DATA_FOUND THEN
7070: l_ref_template_name := NULL;
7071: END;

Line 7113: l_template_name cz_ui_templates.template_name%TYPE;

7109:
7110: l_return_status VARCHAR2(1);
7111: l_msg_count NUMBER := 0;
7112: l_msg_data VARCHAR2(2000);
7113: l_template_name cz_ui_templates.template_name%TYPE;
7114: FAILED_TO_LOCK_UCT EXCEPTION;
7115:
7116: BEGIN
7117: FND_MSG_PUB.initialize;

Line 7134: SELECT template_name INTO l_template_name FROM cz_ui_templates

7130: x_return_status => x_return_status,
7131: x_msg_count => x_msg_count,
7132: x_msg_data => x_msg_data);
7133: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7134: SELECT template_name INTO l_template_name FROM cz_ui_templates
7135: WHERE template_id = p_uct_id;
7136: RAISE FAILED_TO_LOCK_UCT;
7137: END IF;
7138:

Line 7146: UPDATE cz_ui_templates

7142: WHERE object_id = p_uct_id
7143: AND object_type = 'UCT'
7144: AND seeded_flag <> '1';
7145:
7146: UPDATE cz_ui_templates
7147: SET deleted_flag = '1',
7148: template_name = append_name(p_uct_id, 'UCT', template_name)
7149: WHERE template_id = p_uct_id;
7150: ELSE

Line 7628: l_template_name cz_ui_templates.template_name%TYPE;

7624: l_eff_encl_fld_id NUMBER := 0;
7625: rec_count NUMBER := 0;
7626: l_checkout_user cz_devl_projects.checkout_user%TYPE;
7627: l_model_name cz_devl_projects.name%TYPE;
7628: l_template_name cz_ui_templates.template_name%TYPE;
7629: l_fld_name cz_rp_entries.name%TYPE;
7630: l_priv VARCHAR2(1) := 'F';
7631: l_return_status VARCHAR2(1);
7632: l_msg_count NUMBER := 0;

Line 7665: l_ref_template_name cz_ui_templates.template_name%TYPE;

7661: l_template_name_tbl name_tbl;
7662: --Bug#13770170: Additional declations for missing checked in UCT
7663: l_ref_template_tbl number_type_tbl;
7664: l_ref_templ_ui_tbl number_type_tbl;
7665: l_ref_template_name cz_ui_templates.template_name%TYPE;
7666:
7667: BEGIN
7668: FND_MSG_PUB.initialize;
7669: x_return_status := FND_API.g_ret_sts_success;

Line 7835: FROM cz_rp_entries, cz_ui_templates

7831: l_uct_tbl.DELETE;
7832: SELECT object_id, checkout_user, template_name
7833: BULK COLLECT
7834: INTO l_uct_tbl, l_checkout_user_tbl, l_template_name_tbl
7835: FROM cz_rp_entries, cz_ui_templates
7836: WHERE cz_rp_entries.object_type = 'UCT'
7837: AND cz_rp_entries.deleted_flag = '0'
7838: AND cz_rp_entries.seeded_flag <> '1'
7839: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)

Line 7840: AND cz_rp_entries.object_id = cz_ui_templates.template_id

7836: WHERE cz_rp_entries.object_type = 'UCT'
7837: AND cz_rp_entries.deleted_flag = '0'
7838: AND cz_rp_entries.seeded_flag <> '1'
7839: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)
7840: AND cz_rp_entries.object_id = cz_ui_templates.template_id
7841: AND cz_ui_templates.ui_def_id = 0;
7842:
7843: IF (l_uct_tbl.COUNT > 0) THEN
7844: rec_count := l_uct_ref.COUNT;

Line 7841: AND cz_ui_templates.ui_def_id = 0;

7837: AND cz_rp_entries.deleted_flag = '0'
7838: AND cz_rp_entries.seeded_flag <> '1'
7839: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)
7840: AND cz_rp_entries.object_id = cz_ui_templates.template_id
7841: AND cz_ui_templates.ui_def_id = 0;
7842:
7843: IF (l_uct_tbl.COUNT > 0) THEN
7844: rec_count := l_uct_ref.COUNT;
7845: FOR J IN l_uct_tbl.FIRST..l_uct_tbl.LAST

Line 8254: FROM cz_ui_templates

8250: FOR i IN l_ref_template_tbl.FIRST..l_ref_template_tbl.LAST
8251: LOOP
8252: BEGIN
8253: SELECT template_name INTO l_ref_template_name
8254: FROM cz_ui_templates
8255: WHERE cz_ui_templates.template_id = l_ref_template_tbl(i)
8256: AND cz_ui_templates.ui_def_id = l_ref_templ_ui_tbl(i)
8257: AND cz_ui_templates.deleted_flag = '0';
8258:

Line 8255: WHERE cz_ui_templates.template_id = l_ref_template_tbl(i)

8251: LOOP
8252: BEGIN
8253: SELECT template_name INTO l_ref_template_name
8254: FROM cz_ui_templates
8255: WHERE cz_ui_templates.template_id = l_ref_template_tbl(i)
8256: AND cz_ui_templates.ui_def_id = l_ref_templ_ui_tbl(i)
8257: AND cz_ui_templates.deleted_flag = '0';
8258:
8259: EXCEPTION

Line 8256: AND cz_ui_templates.ui_def_id = l_ref_templ_ui_tbl(i)

8252: BEGIN
8253: SELECT template_name INTO l_ref_template_name
8254: FROM cz_ui_templates
8255: WHERE cz_ui_templates.template_id = l_ref_template_tbl(i)
8256: AND cz_ui_templates.ui_def_id = l_ref_templ_ui_tbl(i)
8257: AND cz_ui_templates.deleted_flag = '0';
8258:
8259: EXCEPTION
8260: WHEN NO_DATA_FOUND THEN

Line 8257: AND cz_ui_templates.deleted_flag = '0';

8253: SELECT template_name INTO l_ref_template_name
8254: FROM cz_ui_templates
8255: WHERE cz_ui_templates.template_id = l_ref_template_tbl(i)
8256: AND cz_ui_templates.ui_def_id = l_ref_templ_ui_tbl(i)
8257: AND cz_ui_templates.deleted_flag = '0';
8258:
8259: EXCEPTION
8260: WHEN NO_DATA_FOUND THEN
8261: l_ref_template_name := NULL;

Line 8419: l_template_name cz_ui_templates.template_name%TYPE;

8415: l_object_id_tbl number_type_tbl;
8416: l_object_typ_tbl object_type_tbl;
8417: l_locked_models_tbl cz_security_pvt.number_type_tbl;
8418: l_model_name cz_devl_projects.name%TYPE;
8419: l_template_name cz_ui_templates.template_name%TYPE;
8420: l_count NUMBER := 0;
8421:
8422: BEGIN
8423: FND_MSG_PUB.initialize;