APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_MODEL_USAGES_TL

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 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;