APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_MODEL_USAGES_TL

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