APPS.PJM_TASK_ATTR_USAGES_PKG dependencies on PJM_TASK_ATTR_USAGES_B

Line 18: FROM PJM_TASK_ATTR_USAGES_B

14: ) IS
15:
16: CURSOR c IS
17: SELECT ROWID
18: FROM PJM_TASK_ATTR_USAGES_B
19: WHERE ASSIGNMENT_TYPE = X_ASSIGNMENT_TYPE
20: AND ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
21:
22: BEGIN

Line 24: INSERT INTO PJM_TASK_ATTR_USAGES_B

20: AND ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
21:
22: BEGIN
23:
24: INSERT INTO PJM_TASK_ATTR_USAGES_B
25: ( ASSIGNMENT_TYPE
26: , ATTRIBUTE_CODE
27: , SEQUENCE_NUMBER
28: , CREATION_DATE

Line 98: FROM PJM_TASK_ATTR_USAGES_B

94: ) IS
95:
96: CURSOR c IS
97: SELECT SEQUENCE_NUMBER
98: FROM PJM_TASK_ATTR_USAGES_B
99: WHERE ASSIGNMENT_TYPE = X_ASSIGNMENT_TYPE
100: AND ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
101: FOR UPDATE OF ASSIGNMENT_TYPE NOWAIT;
102: recinfo c%rowtype;

Line 159: UPDATE PJM_TASK_ATTR_USAGES_B

155: , X_LAST_UPDATE_LOGIN IN NUMBER
156: ) IS
157: BEGIN
158:
159: UPDATE PJM_TASK_ATTR_USAGES_B
160: SET SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
161: , LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
162: , LAST_UPDATED_BY = X_LAST_UPDATED_BY
163: , LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 201: DELETE FROM PJM_TASK_ATTR_USAGES_B

197: IF (sql%notfound) THEN
198: RAISE no_data_found;
199: END IF;
200:
201: DELETE FROM PJM_TASK_ATTR_USAGES_B
202: WHERE ASSIGNMENT_TYPE = X_ASSIGNMENT_TYPE
203: AND ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
204:
205: IF (sql%notfound) THEN

Line 218: FROM PJM_TASK_ATTR_USAGES_B B

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
220: AND B.ATTRIBUTE_CODE = T.ATTRIBUTE_CODE
221: );
222:

Line 270: , PJM_TASK_ATTR_USAGES_B B

266: , A.ATTRIBUTE_NAME
267: , A.LANGUAGE
268: , A.SOURCE_LANG
269: FROM PJM_TASK_ATTRIBUTES_TL A
270: , PJM_TASK_ATTR_USAGES_B B
271: , FND_LANGUAGES L
272: WHERE L.INSTALLED_FLAG IN ( 'I' , 'B' )
273: AND A.LANGUAGE = L.LANGUAGE_CODE
274: AND B.ASSIGNMENT_TYPE = A.ASSIGNMENT_TYPE