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.

[Home] [Help]

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 5907: l_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;

5903: ) IS
5904:
5905: -- l_api_version CONSTANT NUMBER := 1.0;
5906: -- l_api_name CONSTANT VARCHAR2(30) := 'copy_ui_template';
5907: l_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;
5908: l_copied_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;
5909: INVALID_TEMPLATE_ID_EXCP EXCEPTION;
5910: l_name cz_rp_entries.name%TYPE;
5911: l_title_id NUMBER;

Line 5908: l_copied_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;

5904:
5905: -- l_api_version CONSTANT NUMBER := 1.0;
5906: -- l_api_name CONSTANT VARCHAR2(30) := 'copy_ui_template';
5907: l_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;
5908: l_copied_jrad_doc CZ_UI_TEMPLATES.jrad_doc%TYPE;
5909: INVALID_TEMPLATE_ID_EXCP EXCEPTION;
5910: l_name cz_rp_entries.name%TYPE;
5911: l_title_id NUMBER;
5912: l_main_message_id NUMBER;

Line 5917: l_template_name cz_ui_templates.template_name%TYPE;

5913: l_old_title_id NUMBER;
5914: l_old_main_message_id NUMBER;
5915: l_index NUMBER;
5916: l_template_type NUMBER;
5917: l_template_name cz_ui_templates.template_name%TYPE;
5918: l_templates cz_security_pvt.number_type_tbl;
5919: l_locked_templates cz_security_pvt.number_type_tbl;
5920: l_return_status VARCHAR2(1);
5921: l_msg_count NUMBER;

Line 5928: FROM CZ_UI_TEMPLATES

5924:
5925: BEGIN
5926: SELECT jrad_doc, template_name, template_type
5927: INTO l_jrad_doc, l_template_name, l_template_type
5928: FROM CZ_UI_TEMPLATES
5929: WHERE ui_def_id=0 AND template_id=p_template_id;
5930:
5931: l_templates(1) := p_template_id;
5932: cz_security_pvt.lock_template(

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

5940: x_msg_data => x_msg_data);
5941: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5942: RAISE FAILED_TO_LOCK_UCT;
5943: END IF;
5944: x_new_template_id := allocateId('CZ_UI_TEMPLATES_S');
5945: l_name := copy_name(p_template_id,'UCT');
5946:
5947: -- The jrad_doc is broken up into pieces (paths and fileName) and saved in
5948: -- jdr_paths.path_name. jdr_paths.path_name is a varchar2(60) type. So the fileName

Line 5969: INSERT INTO CZ_UI_TEMPLATES(

5965: x_return_status,
5966: x_msg_count,
5967: x_msg_data);
5968:
5969: INSERT INTO CZ_UI_TEMPLATES(
5970: TEMPLATE_ID
5971: ,UI_DEF_ID
5972: ,TEMPLATE_NAME
5973: ,TEMPLATE_TYPE

Line 6008: FROM CZ_UI_TEMPLATES

6004: ,ROOT_REGION_TYPE
6005: ,BUTTON_BAR_TEMPL_UIDEF_ID
6006: ,ROOT_ELEMENT_SIGNATURE_ID
6007: ,AMN_USAGE
6008: FROM CZ_UI_TEMPLATES
6009: WHERE ui_def_id=0 AND template_id = p_template_id;
6010:
6011: IF SQL%ROWCOUNT = 0 THEN
6012: RAISE INVALID_TEMPLATE_ID_EXCP;

Line 6018: FROM cz_ui_templates

6014:
6015: -----create new title id and main message id fix for bug# 3939234
6016: SELECT title_id, main_message_id
6017: INTO l_old_title_id, l_old_main_message_id
6018: FROM cz_ui_templates
6019: WHERE template_id = p_template_id
6020: AND ui_def_id = 0;
6021:
6022: IF (l_old_title_id IS NOT NULL) THEN

Line 6030: UPDATE cz_ui_templates

6026: IF (l_old_main_message_id IS NOT NULL) THEN
6027: l_main_message_id := copy_INTL_TEXT(l_old_main_message_id);
6028: END IF;
6029:
6030: UPDATE cz_ui_templates
6031: SET title_id = l_title_id,
6032: main_message_id = l_main_message_id
6033: WHERE template_id = x_new_template_id
6034: AND ui_def_id = 0;

Line 6947: l_ref_template_name cz_ui_templates.template_name%TYPE;

6943: l_ui_name_tbl ui_name_tbl;
6944: l_mt_flag_tbl ui_name_tbl;
6945: l_ref_template_tbl num_type_tbl;
6946: l_ref_templ_ui_tbl num_type_tbl;
6947: l_ref_template_name cz_ui_templates.template_name%TYPE;
6948:
6949: BEGIN
6950: FND_MSG_PUB.initialize;
6951: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7035: FROM cz_ui_templates

7031: FOR I IN l_ref_template_tbl.FIRST..l_ref_template_tbl.LAST
7032: LOOP
7033: BEGIN
7034: SELECT template_name INTO l_ref_template_name
7035: FROM cz_ui_templates
7036: WHERE cz_ui_templates.template_id = l_ref_template_tbl(i)
7037: AND cz_ui_templates.ui_def_id = l_ref_templ_ui_tbl(i)
7038: AND cz_ui_templates.deleted_flag = '0';
7039: EXCEPTION

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

7032: LOOP
7033: BEGIN
7034: SELECT template_name INTO l_ref_template_name
7035: FROM cz_ui_templates
7036: WHERE cz_ui_templates.template_id = l_ref_template_tbl(i)
7037: AND cz_ui_templates.ui_def_id = l_ref_templ_ui_tbl(i)
7038: AND cz_ui_templates.deleted_flag = '0';
7039: EXCEPTION
7040: WHEN NO_DATA_FOUND THEN

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

7033: BEGIN
7034: SELECT template_name INTO l_ref_template_name
7035: FROM cz_ui_templates
7036: WHERE cz_ui_templates.template_id = l_ref_template_tbl(i)
7037: AND cz_ui_templates.ui_def_id = l_ref_templ_ui_tbl(i)
7038: AND cz_ui_templates.deleted_flag = '0';
7039: EXCEPTION
7040: WHEN NO_DATA_FOUND THEN
7041: l_ref_template_name := NULL;

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

7034: SELECT template_name INTO l_ref_template_name
7035: FROM cz_ui_templates
7036: WHERE cz_ui_templates.template_id = l_ref_template_tbl(i)
7037: AND cz_ui_templates.ui_def_id = l_ref_templ_ui_tbl(i)
7038: AND cz_ui_templates.deleted_flag = '0';
7039: EXCEPTION
7040: WHEN NO_DATA_FOUND THEN
7041: l_ref_template_name := NULL;
7042: END;

Line 7100: UPDATE cz_ui_templates

7096: WHERE object_id = p_uct_id
7097: AND object_type = 'UCT'
7098: AND seeded_flag <> '1';
7099:
7100: UPDATE cz_ui_templates
7101: SET deleted_flag = '1',
7102: template_name = append_name(p_uct_id, 'UCT', template_name)
7103: WHERE template_id = p_uct_id;
7104: ELSE

Line 7575: l_template_name cz_ui_templates.template_name%TYPE;

7571: l_eff_encl_fld_id NUMBER := 0;
7572: rec_count NUMBER := 0;
7573: l_checkout_user cz_devl_projects.checkout_user%TYPE;
7574: l_model_name cz_devl_projects.name%TYPE;
7575: l_template_name cz_ui_templates.template_name%TYPE;
7576: l_fld_name cz_rp_entries.name%TYPE;
7577: l_priv VARCHAR2(1) := 'F';
7578: l_return_status VARCHAR2(1);
7579: l_msg_count NUMBER := 0;

Line 7777: FROM cz_rp_entries, cz_ui_templates

7773: l_uct_tbl.DELETE;
7774: SELECT object_id, checkout_user, template_name
7775: BULK COLLECT
7776: INTO l_uct_tbl, l_checkout_user_tbl, l_template_name_tbl
7777: FROM cz_rp_entries, cz_ui_templates
7778: WHERE cz_rp_entries.object_type = 'UCT'
7779: AND cz_rp_entries.deleted_flag = '0'
7780: AND cz_rp_entries.seeded_flag <> '1'
7781: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)

Line 7782: AND cz_rp_entries.object_id = cz_ui_templates.template_id

7778: WHERE cz_rp_entries.object_type = 'UCT'
7779: AND cz_rp_entries.deleted_flag = '0'
7780: AND cz_rp_entries.seeded_flag <> '1'
7781: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)
7782: AND cz_rp_entries.object_id = cz_ui_templates.template_id
7783: AND cz_ui_templates.ui_def_id = 0;
7784:
7785: IF (l_uct_tbl.COUNT > 0) THEN
7786: rec_count := l_uct_ref.COUNT;

Line 7783: AND cz_ui_templates.ui_def_id = 0;

7779: AND cz_rp_entries.deleted_flag = '0'
7780: AND cz_rp_entries.seeded_flag <> '1'
7781: AND cz_rp_entries.enclosing_folder = l_rp_fld_tbl(i)
7782: AND cz_rp_entries.object_id = cz_ui_templates.template_id
7783: AND cz_ui_templates.ui_def_id = 0;
7784:
7785: IF (l_uct_tbl.COUNT > 0) THEN
7786: rec_count := l_uct_ref.COUNT;
7787: FOR J IN l_uct_tbl.FIRST..l_uct_tbl.LAST

Line 8310: l_template_name cz_ui_templates.template_name%TYPE;

8306: l_object_id_tbl number_type_tbl;
8307: l_object_typ_tbl object_type_tbl;
8308: l_locked_models_tbl cz_security_pvt.number_type_tbl;
8309: l_model_name cz_devl_projects.name%TYPE;
8310: l_template_name cz_ui_templates.template_name%TYPE;
8311: l_count NUMBER := 0;
8312: FAILED_TO_LOCK_PRJ EXCEPTION;
8313: FAILED_TO_LOCK_UCT EXCEPTION;
8314: BEGIN

Line 8386: SELECT template_name INTO l_template_name FROM cz_ui_templates

8382: x_return_status => x_return_status,
8383: x_msg_count => x_msg_count,
8384: x_msg_data => x_msg_data);
8385: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
8386: SELECT template_name INTO l_template_name FROM cz_ui_templates
8387: WHERE template_id = l_object_id_tbl(i);
8388: RAISE FAILED_TO_LOCK_UCT;
8389: END IF;
8390: UPDATE cz_ui_templates

Line 8390: UPDATE cz_ui_templates

8386: SELECT template_name INTO l_template_name FROM cz_ui_templates
8387: WHERE template_id = l_object_id_tbl(i);
8388: RAISE FAILED_TO_LOCK_UCT;
8389: END IF;
8390: UPDATE cz_ui_templates
8391: SET deleted_flag = '1'
8392: WHERE template_id = l_object_id_tbl(i)
8393: AND ui_def_id = 0;
8394: