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_MODEL_USAGES

Line 4830: l_usage_name cz_model_usages.name%TYPE;

4826: l_api_name CONSTANT VARCHAR2(30) := 'copy_model_usage';
4827: INVALID_MODEL_USAGE_ID_EXCP EXCEPTION;
4828: USER_IS_NULL_EXCP EXCEPTION;
4829: usageID NUMBER := 0;
4830: l_usage_name cz_model_usages.name%TYPE;
4831: BEGIN
4832: FND_MSG_PUB.initialize;
4833: x_return_status := FND_API.G_RET_STS_SUCCESS;
4834: new_usage (p_encl_folder_id,usageID);

Line 4850: UPDATE cz_model_usages

4846: SET name = l_usage_name
4847: WHERE object_id = usageID
4848: AND object_type = 'USG';
4849:
4850: UPDATE cz_model_usages
4851: SET name = l_usage_name,
4852: note=(select note from cz_model_usages
4853: where model_usage_id=usageID)
4854: WHERE model_usage_id = usageID;

Line 4852: note=(select note from cz_model_usages

4848: AND object_type = 'USG';
4849:
4850: UPDATE cz_model_usages
4851: SET name = l_usage_name,
4852: note=(select note from cz_model_usages
4853: where model_usage_id=usageID)
4854: WHERE model_usage_id = usageID;
4855:
4856:

Line 4857: update cz_model_usages_tl target

4853: where model_usage_id=usageID)
4854: WHERE model_usage_id = usageID;
4855:
4856:
4857: update cz_model_usages_tl target
4858: set (LANGUAGE,SOURCE_LANG,DESCRIPTION)=(select LANGUAGE,SOURCE_LANG,DESCRIPTION
4859: from
4860: cz_model_usages_tl source where model_usage_id=p_model_usage_id and target.language=source.language)
4861: where model_usage_id=usageID;

Line 4860: cz_model_usages_tl source where model_usage_id=p_model_usage_id and target.language=source.language)

4856:
4857: update cz_model_usages_tl target
4858: set (LANGUAGE,SOURCE_LANG,DESCRIPTION)=(select LANGUAGE,SOURCE_LANG,DESCRIPTION
4859: from
4860: cz_model_usages_tl source where model_usage_id=p_model_usage_id and target.language=source.language)
4861: where model_usage_id=usageID;
4862:
4863: x_new_model_usage_id := usageID;
4864: END IF;

Line 7240: l_usage_name cz_model_usages.name%TYPE;

7236: v_nodes t_indexes;
7237: v_rules t_indexes;
7238: v_masks_nodes t_mask;
7239: v_masks_rules t_mask;
7240: l_usage_name cz_model_usages.name%TYPE;
7241: BEGIN
7242: FND_MSG_PUB.initialize;
7243: x_return_status := FND_API.G_RET_STS_SUCCESS;
7244: x_msg_count := 0;

Line 7250: FROM cz_model_usages

7246:
7247: BEGIN
7248: SELECT name
7249: INTO l_usage_name
7250: FROM cz_model_usages
7251: WHERE cz_model_usages.model_usage_id = p_usage_id
7252: AND cz_model_usages.in_use <> 'X';
7253: EXCEPTION
7254: WHEN NO_DATA_FOUND THEN

Line 7251: WHERE cz_model_usages.model_usage_id = p_usage_id

7247: BEGIN
7248: SELECT name
7249: INTO l_usage_name
7250: FROM cz_model_usages
7251: WHERE cz_model_usages.model_usage_id = p_usage_id
7252: AND cz_model_usages.in_use <> 'X';
7253: EXCEPTION
7254: WHEN NO_DATA_FOUND THEN
7255: RAISE NO_USG_EXISTS;

Line 7252: AND cz_model_usages.in_use <> 'X';

7248: SELECT name
7249: INTO l_usage_name
7250: FROM cz_model_usages
7251: WHERE cz_model_usages.model_usage_id = p_usage_id
7252: AND cz_model_usages.in_use <> 'X';
7253: EXCEPTION
7254: WHEN NO_DATA_FOUND THEN
7255: RAISE NO_USG_EXISTS;
7256: END;

Line 7410: UPDATE cz_model_usages

7406: NULL;
7407: END;
7408:
7409: BEGIN
7410: UPDATE cz_model_usages
7411: SET in_use = 'X',
7412: name = append_name(usageId, 'USG', name)
7413: WHERE model_usage_id = usageId;
7414:

Line 7590: l_usage_name cz_model_usages.name%TYPE;

7586: l_ui_pages_count NUMBER := 0;
7587: l_prop_count NUMBER := 0;
7588: l_folder_count NUMBER := 0;
7589: l_ui_name_tbl model_names_tbl;
7590: l_usage_name cz_model_usages.name%TYPE;
7591:
7592: l_usage_count NUMBER := 0;
7593: l_map_has_usg_id NUMBER := 1;
7594: v_nodes number_type_tbl ;

Line 8178: FROM cz_model_usages

8174: LOOP
8175: BEGIN
8176: SELECT model_usage_id,name
8177: INTO l_usage_count,l_usage_name
8178: FROM cz_model_usages
8179: WHERE cz_model_usages.model_usage_id = l_usg_ref(modelId)
8180: AND cz_model_usages.in_use <> 'X';
8181:
8182: BEGIN

Line 8179: WHERE cz_model_usages.model_usage_id = l_usg_ref(modelId)

8175: BEGIN
8176: SELECT model_usage_id,name
8177: INTO l_usage_count,l_usage_name
8178: FROM cz_model_usages
8179: WHERE cz_model_usages.model_usage_id = l_usg_ref(modelId)
8180: AND cz_model_usages.in_use <> 'X';
8181:
8182: BEGIN
8183: SELECT 1

Line 8180: AND cz_model_usages.in_use <> 'X';

8176: SELECT model_usage_id,name
8177: INTO l_usage_count,l_usage_name
8178: FROM cz_model_usages
8179: WHERE cz_model_usages.model_usage_id = l_usg_ref(modelId)
8180: AND cz_model_usages.in_use <> 'X';
8181:
8182: BEGIN
8183: SELECT 1
8184: INTO l_usage_count

Line 8400: UPDATE cz_model_usages

8396: UPDATE cz_ui_defs
8397: SET deleted_flag = '1'
8398: WHERE ui_def_id = l_object_id_tbl(i);
8399: ELSIF (l_object_typ_tbl(i) = 'USG') THEN
8400: UPDATE cz_model_usages
8401: SET in_use = 'X'
8402: WHERE model_usage_id = l_object_id_tbl(i);
8403: DELETE FROM CZ_RP_ENTRIES
8404: WHERE OBJECT_TYPE = 'USG'

Line 8471: FROM cz_model_usages

8467: try_id NUMBER := -1;
8468: nextVal NUMBER;
8469: CURSOR Xed_usages IS
8470: SELECT model_usage_id
8471: FROM cz_model_usages
8472: WHERE in_use = 'X'
8473: AND model_usage_id < 64
8474: ORDER BY model_usage_id;
8475: BEGIN

Line 8482: UPDATE cz_model_usages SET

8478: LOOP
8479: FETCH Xed_usages INTO try_id;
8480: EXIT WHEN Xed_usages%NOTFOUND;
8481: usageId := try_id;
8482: UPDATE cz_model_usages SET
8483: in_use = '1', name = 'New Usage ' || try_id
8484: WHERE model_usage_id = try_id AND in_use = 'X';
8485: INSERT INTO cz_rp_entries(object_id, object_type, enclosing_folder, name)
8486: VALUES (usageId, 'USG',enclosingFolderId, 'New Usage ' || try_id);

Line 11827: trans_desc cz_model_usages_tl.description%TYPE;

11823: */
11824:
11825: FUNCTION get_trans_desc(object_id IN NUMBER,object_type IN varchar2) RETURN VARCHAR2 IS
11826:
11827: trans_desc cz_model_usages_tl.description%TYPE;
11828:
11829: BEGIN
11830:
11831: IF (OBJECT_TYPE='USG')

Line 11833: SELECT description INTO trans_desc FROM cz_model_usages_tl

11829: BEGIN
11830:
11831: IF (OBJECT_TYPE='USG')
11832: THEN
11833: SELECT description INTO trans_desc FROM cz_model_usages_tl
11834: where model_usage_id=object_id AND language = userenv('LANG');
11835: END IF;
11836:
11837: RETURN trans_desc;