APPS.PJM_TASK_ATTR_USAGES_PKG dependencies on PJM_TASK_ATTR_USAGES_TL

Line 44: INSERT INTO PJM_TASK_ATTR_USAGES_TL

40: , X_LAST_UPDATED_BY
41: , X_LAST_UPDATE_LOGIN
42: );
43:
44: INSERT INTO PJM_TASK_ATTR_USAGES_TL
45: ( ASSIGNMENT_TYPE
46: , ATTRIBUTE_CODE
47: , CREATION_DATE
48: , CREATED_BY

Line 74: FROM PJM_TASK_ATTR_USAGES_TL T

70: AND A.ASSIGNMENT_TYPE = X_ASSIGNMENT_TYPE
71: AND A.ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
72: AND NOT EXISTS (
73: SELECT NULL
74: FROM PJM_TASK_ATTR_USAGES_TL T
75: WHERE T.ASSIGNMENT_TYPE = X_ASSIGNMENT_TYPE
76: AND T.ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
77: AND T.LANGUAGE = L.LANGUAGE_CODE);
78:

Line 106: FROM PJM_TASK_ATTR_USAGES_TL

102: recinfo c%rowtype;
103:
104: CURSOR c1 IS
105: SELECT PROMPT , DECODE(LANGUAGE , USERENV('LANG') , 'Y' , 'N') BASELANG
106: FROM PJM_TASK_ATTR_USAGES_TL
107: WHERE ASSIGNMENT_TYPE = X_ASSIGNMENT_TYPE
108: AND ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
109: AND USERENV('LANG') IN ( LANGUAGE , SOURCE_LANG )
110: FOR UPDATE OF ASSIGNMENT_TYPE NOWAIT;

Line 171: UPDATE PJM_TASK_ATTR_USAGES_TL

167: IF (sql%notfound) THEN
168: RAISE no_data_found;
169: END IF;
170:
171: UPDATE PJM_TASK_ATTR_USAGES_TL
172: SET PROMPT = X_PROMPT
173: , LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
174: , LAST_UPDATED_BY = X_LAST_UPDATED_BY
175: , LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 193: DELETE FROM PJM_TASK_ATTR_USAGES_TL

189: , X_ATTRIBUTE_CODE IN VARCHAR2
190: ) IS
191: BEGIN
192:
193: DELETE FROM PJM_TASK_ATTR_USAGES_TL
194: WHERE ASSIGNMENT_TYPE = X_ASSIGNMENT_TYPE
195: AND ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
196:
197: IF (sql%notfound) THEN

Line 215: DELETE FROM PJM_TASK_ATTR_USAGES_TL T

211: PROCEDURE ADD_LANGUAGE
212: IS
213: BEGIN
214:
215: DELETE FROM PJM_TASK_ATTR_USAGES_TL T
216: WHERE NOT EXISTS (
217: SELECT NULL
218: FROM PJM_TASK_ATTR_USAGES_B B
219: WHERE B.ASSIGNMENT_TYPE = T.ASSIGNMENT_TYPE

Line 223: UPDATE PJM_TASK_ATTR_USAGES_TL T

219: WHERE B.ASSIGNMENT_TYPE = T.ASSIGNMENT_TYPE
220: AND B.ATTRIBUTE_CODE = T.ATTRIBUTE_CODE
221: );
222:
223: UPDATE PJM_TASK_ATTR_USAGES_TL T
224: SET ( PROMPT ) = (
225: SELECT B.PROMPT
226: FROM PJM_TASK_ATTR_USAGES_TL B
227: WHERE B.ASSIGNMENT_TYPE = T.ASSIGNMENT_TYPE

Line 226: FROM PJM_TASK_ATTR_USAGES_TL B

222:
223: UPDATE PJM_TASK_ATTR_USAGES_TL T
224: SET ( PROMPT ) = (
225: SELECT B.PROMPT
226: FROM PJM_TASK_ATTR_USAGES_TL B
227: WHERE B.ASSIGNMENT_TYPE = T.ASSIGNMENT_TYPE
228: AND B.ATTRIBUTE_CODE = T.ATTRIBUTE_CODE
229: AND B.LANGUAGE = T.SOURCE_LANG)
230: WHERE ( T.ASSIGNMENT_TYPE

Line 237: FROM PJM_TASK_ATTR_USAGES_TL SUBB

233: ) IN (
234: SELECT SUBT.ASSIGNMENT_TYPE
235: , SUBT.ATTRIBUTE_CODE
236: , SUBT.LANGUAGE
237: FROM PJM_TASK_ATTR_USAGES_TL SUBB
238: , PJM_TASK_ATTR_USAGES_TL SUBT
239: WHERE SUBB.ASSIGNMENT_TYPE = SUBT.ASSIGNMENT_TYPE
240: AND SUBB.ATTRIBUTE_CODE = SUBT.ATTRIBUTE_CODE
241: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG

Line 238: , PJM_TASK_ATTR_USAGES_TL SUBT

234: SELECT SUBT.ASSIGNMENT_TYPE
235: , SUBT.ATTRIBUTE_CODE
236: , SUBT.LANGUAGE
237: FROM PJM_TASK_ATTR_USAGES_TL SUBB
238: , PJM_TASK_ATTR_USAGES_TL SUBT
239: WHERE SUBB.ASSIGNMENT_TYPE = SUBT.ASSIGNMENT_TYPE
240: AND SUBB.ATTRIBUTE_CODE = SUBT.ATTRIBUTE_CODE
241: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
242: AND (SUBB.PROMPT <> SUBT.PROMPT

Line 247: INSERT INTO PJM_TASK_ATTR_USAGES_TL

243: OR (SUBB.PROMPT IS NULL AND SUBT.PROMPT IS NOT NULL)
244: OR (SUBB.PROMPT IS NOT NULL AND SUBT.PROMPT IS NULL)
245: ));
246:
247: INSERT INTO PJM_TASK_ATTR_USAGES_TL
248: ( ASSIGNMENT_TYPE
249: , ATTRIBUTE_CODE
250: , CREATION_DATE
251: , CREATED_BY

Line 278: FROM PJM_TASK_ATTR_USAGES_TL T

274: AND B.ASSIGNMENT_TYPE = A.ASSIGNMENT_TYPE
275: AND B.ATTRIBUTE_CODE = A.ATTRIBUTE_CODE
276: AND NOT EXISTS (
277: SELECT NULL
278: FROM PJM_TASK_ATTR_USAGES_TL T
279: WHERE T.ASSIGNMENT_TYPE = B.ASSIGNMENT_TYPE
280: AND T.ATTRIBUTE_CODE = B.ATTRIBUTE_CODE
281: AND T.LANGUAGE = L.LANGUAGE_CODE
282: );