APPS.PO_JOB_ASSOCIATIONS_PKG dependencies on PO_JOB_ASSOCIATIONS_TL

Line 41: insert into PO_JOB_ASSOCIATIONS_TL (

37: X_LAST_UPDATED_BY,
38: X_LAST_UPDATE_LOGIN
39: );
40:
41: insert into PO_JOB_ASSOCIATIONS_TL (
42: JOB_ID,
43: JOB_DESCRIPTION,
44: JOB_LONG_DESCRIPTION,
45: LAST_UPDATE_DATE,

Line 67: from PO_JOB_ASSOCIATIONS_TL T

63: from FND_LANGUAGES L
64: where L.INSTALLED_FLAG in ('I', 'B')
65: and not exists
66: (select NULL
67: from PO_JOB_ASSOCIATIONS_TL T
68: where T.JOB_ID = X_JOB_ID
69: and T.LANGUAGE = L.LANGUAGE_CODE);
70:
71: open c;

Line 100: from PO_JOB_ASSOCIATIONS_TL

96: cursor c1 is select
97: JOB_DESCRIPTION,
98: JOB_LONG_DESCRIPTION,
99: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
100: from PO_JOB_ASSOCIATIONS_TL
101: where JOB_ID = X_JOB_ID
102: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
103: for update of JOB_ID nowait;
104: begin

Line 162: update PO_JOB_ASSOCIATIONS_TL set

158: if (sql%notfound) then
159: raise no_data_found;
160: end if;
161:
162: update PO_JOB_ASSOCIATIONS_TL set
163: JOB_DESCRIPTION = X_JOB_DESCRIPTION,
164: JOB_LONG_DESCRIPTION = X_JOB_LONG_DESCRIPTION,
165: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
166: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 181: delete from PO_JOB_ASSOCIATIONS_TL

177: procedure DELETE_ROW (
178: X_JOB_ID in NUMBER
179: ) is
180: begin
181: delete from PO_JOB_ASSOCIATIONS_TL
182: where JOB_ID = X_JOB_ID;
183:
184: if (sql%notfound) then
185: raise no_data_found;

Line 199: delete from PO_JOB_ASSOCIATIONS_TL T

195:
196: procedure ADD_LANGUAGE
197: is
198: begin
199: delete from PO_JOB_ASSOCIATIONS_TL T
200: where not exists
201: (select NULL
202: from PO_JOB_ASSOCIATIONS_B B
203: where B.JOB_ID = T.JOB_ID

Line 206: insert into PO_JOB_ASSOCIATIONS_TL (

202: from PO_JOB_ASSOCIATIONS_B B
203: where B.JOB_ID = T.JOB_ID
204: );
205:
206: insert into PO_JOB_ASSOCIATIONS_TL (
207: JOB_ID,
208: JOB_DESCRIPTION,
209: JOB_LONG_DESCRIPTION,
210: LAST_UPDATE_DATE,

Line 228: from PO_JOB_ASSOCIATIONS_TL B, FND_LANGUAGES L

224: B.CREATED_BY,
225: B.CREATION_DATE,
226: L.LANGUAGE_CODE,
227: B.SOURCE_LANG
228: from PO_JOB_ASSOCIATIONS_TL B, FND_LANGUAGES L
229: where L.INSTALLED_FLAG in ('I', 'B')
230: and B.LANGUAGE = userenv('LANG')
231: and not exists
232: (select NULL

Line 233: from PO_JOB_ASSOCIATIONS_TL T

229: where L.INSTALLED_FLAG in ('I', 'B')
230: and B.LANGUAGE = userenv('LANG')
231: and not exists
232: (select NULL
233: from PO_JOB_ASSOCIATIONS_TL T
234: where T.JOB_ID = B.JOB_ID
235: and T.LANGUAGE = L.LANGUAGE_CODE);
236: end ADD_LANGUAGE;
237: