APPS.PJM_TASK_ATTRIBUTES_PKG dependencies on PJM_TASK_ATTRIBUTES_TL

Line 29: UPDATE pjm_task_attributes_tl

25: BEGIN
26: --
27: -- Update non-translated values in all languages
28: --
29: UPDATE pjm_task_attributes_tl
30: SET form_field_name = X_Form_Field_Name
31: , last_update_date = sysdate
32: , last_updated_by = user_id
33: WHERE assignment_type = X_Assignment_Type

Line 39: UPDATE pjm_task_attributes_tl

35:
36: --
37: -- Update translated values in current language
38: --
39: UPDATE pjm_task_attributes_tl
40: SET attribute_name = X_Attribute_Name
41: , source_lang = userenv('LANG')
42: WHERE assignment_type = X_Assignment_Type
43: AND attribute_code = X_Attribute_Code

Line 62: INSERT INTO pjm_task_attributes_tl

58:
59: --
60: -- Insert if missing
61: --
62: INSERT INTO pjm_task_attributes_tl
63: ( assignment_type
64: , attribute_code
65: , last_update_date
66: , last_updated_by

Line 89: FROM pjm_task_attributes_tl

85: FROM fnd_languages L
86: WHERE L.installed_flag in ('I' , 'B')
87: AND NOT EXISTS (
88: SELECT null
89: FROM pjm_task_attributes_tl
90: WHERE assignment_type = X_Assignment_Type
91: AND attribute_code = X_Attribute_Code
92: AND language = L.language_code
93: );

Line 123: UPDATE pjm_task_attributes_tl

119:
120: --
121: -- update the translation
122: --
123: UPDATE pjm_task_attributes_tl
124: SET attribute_name = X_Attribute_Name
125: , last_update_date = sysdate
126: , last_updated_by = user_id
127: , source_lang = userenv('LANG')

Line 156: INSERT INTO pjm_task_attributes_tl

152: PROCEDURE ADD_LANGUAGE
153: IS
154: BEGIN
155:
156: INSERT INTO pjm_task_attributes_tl
157: ( assignment_type
158: , attribute_code
159: , creation_date
160: , created_by

Line 180: FROM pjm_task_attributes_tl M

176: , M.form_field_name
177: , M.attribute_name
178: , L.language_code
179: , M.source_lang
180: FROM pjm_task_attributes_tl M
181: , fnd_languages L
182: WHERE M.language = userenv('LANG')
183: AND L.installed_flag in ( 'I' , 'B' )
184: AND NOT EXISTS (

Line 186: FROM pjm_task_attributes_tl

182: WHERE M.language = userenv('LANG')
183: AND L.installed_flag in ( 'I' , 'B' )
184: AND NOT EXISTS (
185: SELECT null
186: FROM pjm_task_attributes_tl
187: WHERE assignment_type = M.assignment_type
188: AND attribute_code = M.attribute_code
189: AND language = L.language_code );
190: