APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_MODEL_USAGES

Line 4859: l_usage_name cz_model_usages.name%TYPE;

4855: l_api_name CONSTANT VARCHAR2(30) := 'copy_model_usage';
4856: INVALID_MODEL_USAGE_ID_EXCP EXCEPTION;
4857: USER_IS_NULL_EXCP EXCEPTION;
4858: usageID NUMBER := 0;
4859: l_usage_name cz_model_usages.name%TYPE;
4860: BEGIN
4861: FND_MSG_PUB.initialize;
4862: x_return_status := FND_API.G_RET_STS_SUCCESS;
4863: new_usage (p_encl_folder_id,usageID);

Line 4879: UPDATE cz_model_usages

4875: SET name = l_usage_name
4876: WHERE object_id = usageID
4877: AND object_type = 'USG';
4878:
4879: UPDATE cz_model_usages
4880: SET name = l_usage_name,
4881: note=(select note from cz_model_usages
4882: where model_usage_id=usageID)
4883: WHERE model_usage_id = usageID;

Line 4881: note=(select note from cz_model_usages

4877: AND object_type = 'USG';
4878:
4879: UPDATE cz_model_usages
4880: SET name = l_usage_name,
4881: note=(select note from cz_model_usages
4882: where model_usage_id=usageID)
4883: WHERE model_usage_id = usageID;
4884:
4885:

Line 4886: update cz_model_usages_tl target

4882: where model_usage_id=usageID)
4883: WHERE model_usage_id = usageID;
4884:
4885:
4886: update cz_model_usages_tl target
4887: set (LANGUAGE,SOURCE_LANG,DESCRIPTION)=(select LANGUAGE,SOURCE_LANG,DESCRIPTION
4888: from
4889: cz_model_usages_tl source where model_usage_id=p_model_usage_id and target.language=source.language)
4890: where model_usage_id=usageID;

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

4885:
4886: update cz_model_usages_tl target
4887: set (LANGUAGE,SOURCE_LANG,DESCRIPTION)=(select LANGUAGE,SOURCE_LANG,DESCRIPTION
4888: from
4889: cz_model_usages_tl source where model_usage_id=p_model_usage_id and target.language=source.language)
4890: where model_usage_id=usageID;
4891:
4892: x_new_model_usage_id := usageID;
4893: END IF;

Line 7293: l_usage_name cz_model_usages.name%TYPE;

7289: v_nodes t_indexes;
7290: v_rules t_indexes;
7291: v_masks_nodes t_mask;
7292: v_masks_rules t_mask;
7293: l_usage_name cz_model_usages.name%TYPE;
7294: BEGIN
7295: FND_MSG_PUB.initialize;
7296: x_return_status := FND_API.G_RET_STS_SUCCESS;
7297: x_msg_count := 0;

Line 7303: FROM cz_model_usages

7299:
7300: BEGIN
7301: SELECT name
7302: INTO l_usage_name
7303: FROM cz_model_usages
7304: WHERE cz_model_usages.model_usage_id = p_usage_id
7305: AND cz_model_usages.in_use <> 'X';
7306: EXCEPTION
7307: WHEN NO_DATA_FOUND THEN

Line 7304: WHERE cz_model_usages.model_usage_id = p_usage_id

7300: BEGIN
7301: SELECT name
7302: INTO l_usage_name
7303: FROM cz_model_usages
7304: WHERE cz_model_usages.model_usage_id = p_usage_id
7305: AND cz_model_usages.in_use <> 'X';
7306: EXCEPTION
7307: WHEN NO_DATA_FOUND THEN
7308: RAISE NO_USG_EXISTS;

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

7301: SELECT name
7302: INTO l_usage_name
7303: FROM cz_model_usages
7304: WHERE cz_model_usages.model_usage_id = p_usage_id
7305: AND cz_model_usages.in_use <> 'X';
7306: EXCEPTION
7307: WHEN NO_DATA_FOUND THEN
7308: RAISE NO_USG_EXISTS;
7309: END;

Line 7463: UPDATE cz_model_usages

7459: NULL;
7460: END;
7461:
7462: BEGIN
7463: UPDATE cz_model_usages
7464: SET in_use = 'X',
7465: name = append_name(usageId, 'USG', name)
7466: WHERE model_usage_id = usageId;
7467:

Line 7643: l_usage_name cz_model_usages.name%TYPE;

7639: l_ui_pages_count NUMBER := 0;
7640: l_prop_count NUMBER := 0;
7641: l_folder_count NUMBER := 0;
7642: l_ui_name_tbl model_names_tbl;
7643: l_usage_name cz_model_usages.name%TYPE;
7644:
7645: l_usage_count NUMBER := 0;
7646: l_map_has_usg_id NUMBER := 1;
7647: v_nodes number_type_tbl ;

Line 8287: FROM cz_model_usages

8283: LOOP
8284: BEGIN
8285: SELECT model_usage_id,name
8286: INTO l_usage_count,l_usage_name
8287: FROM cz_model_usages
8288: WHERE cz_model_usages.model_usage_id = l_usg_ref(modelId)
8289: AND cz_model_usages.in_use <> 'X';
8290:
8291: BEGIN

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

8284: BEGIN
8285: SELECT model_usage_id,name
8286: INTO l_usage_count,l_usage_name
8287: FROM cz_model_usages
8288: WHERE cz_model_usages.model_usage_id = l_usg_ref(modelId)
8289: AND cz_model_usages.in_use <> 'X';
8290:
8291: BEGIN
8292: SELECT 1

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

8285: SELECT model_usage_id,name
8286: INTO l_usage_count,l_usage_name
8287: FROM cz_model_usages
8288: WHERE cz_model_usages.model_usage_id = l_usg_ref(modelId)
8289: AND cz_model_usages.in_use <> 'X';
8290:
8291: BEGIN
8292: SELECT 1
8293: INTO l_usage_count

Line 8522: FROM cz_model_usages

8518: try_id NUMBER := -1;
8519: nextVal NUMBER;
8520: CURSOR Xed_usages IS
8521: SELECT model_usage_id
8522: FROM cz_model_usages
8523: WHERE in_use = 'X'
8524: AND model_usage_id < 64
8525: ORDER BY model_usage_id;
8526: BEGIN

Line 8533: UPDATE cz_model_usages SET

8529: LOOP
8530: FETCH Xed_usages INTO try_id;
8531: EXIT WHEN Xed_usages%NOTFOUND;
8532: usageId := try_id;
8533: UPDATE cz_model_usages SET
8534: in_use = '1', name = 'New Usage ' || try_id
8535: WHERE model_usage_id = try_id AND in_use = 'X';
8536: INSERT INTO cz_rp_entries(object_id, object_type, enclosing_folder, name)
8537: VALUES (usageId, 'USG',enclosingFolderId, 'New Usage ' || try_id);

Line 11901: trans_desc cz_model_usages_tl.description%TYPE;

11897: */
11898:
11899: FUNCTION get_trans_desc(object_id IN NUMBER,object_type IN varchar2) RETURN VARCHAR2 IS
11900:
11901: trans_desc cz_model_usages_tl.description%TYPE;
11902:
11903: BEGIN
11904:
11905: IF (OBJECT_TYPE='USG')

Line 11907: SELECT description INTO trans_desc FROM cz_model_usages_tl

11903: BEGIN
11904:
11905: IF (OBJECT_TYPE='USG')
11906: THEN
11907: SELECT description INTO trans_desc FROM cz_model_usages_tl
11908: where model_usage_id=object_id AND language = userenv('LANG');
11909: END IF;
11910:
11911: RETURN trans_desc;