APPS.GML_OP_PRSL_TYP_PKG dependencies on OP_PRSL_TYP_TL

Line 52: insert into OP_PRSL_TYP_TL (

48: X_LAST_UPDATED_BY,
49: X_LAST_UPDATE_LOGIN
50: );
51:
52: insert into OP_PRSL_TYP_TL (
53: PRESALES_ORD_TYPE,
54: PRESALES_ORD_CODE,
55: PRESALES_ORD_DESC,
56: CREATED_BY,

Line 78: from OP_PRSL_TYP_TL T

74: from FND_LANGUAGES L
75: where L.INSTALLED_FLAG in ('I', 'B')
76: and not exists
77: (select NULL
78: from OP_PRSL_TYP_TL T
79: where T.PRESALES_ORD_TYPE = X_PRESALES_ORD_TYPE
80: and T.LANGUAGE = L.LANGUAGE_CODE);
81:
82: open c;

Line 119: from OP_PRSL_TYP_TL

115: cursor c1 is select
116: PRESALES_ORD_CODE,
117: PRESALES_ORD_DESC,
118: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
119: from OP_PRSL_TYP_TL
120: where PRESALES_ORD_TYPE = X_PRESALES_ORD_TYPE
121: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
122: for update of PRESALES_ORD_TYPE nowait;
123: begin

Line 192: update OP_PRSL_TYP_TL set

188: if (sql%notfound) then
189: raise no_data_found;
190: end if;
191:
192: update OP_PRSL_TYP_TL set
193: PRESALES_ORD_CODE = X_PRESALES_ORD_CODE,
194: PRESALES_ORD_DESC = X_PRESALES_ORD_DESC,
195: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
196: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 211: delete from OP_PRSL_TYP_TL

207: procedure DELETE_ROW (
208: X_PRESALES_ORD_TYPE in NUMBER
209: ) is
210: begin
211: delete from OP_PRSL_TYP_TL
212: where PRESALES_ORD_TYPE = X_PRESALES_ORD_TYPE;
213:
214: if (sql%notfound) then
215: raise no_data_found;

Line 229: delete from OP_PRSL_TYP_TL T

225:
226: procedure ADD_LANGUAGE
227: is
228: begin
229: delete from OP_PRSL_TYP_TL T
230: where not exists
231: (select NULL
232: from OP_PRSL_TYP_B B
233: where B.PRESALES_ORD_TYPE = T.PRESALES_ORD_TYPE

Line 236: update OP_PRSL_TYP_TL T set (

232: from OP_PRSL_TYP_B B
233: where B.PRESALES_ORD_TYPE = T.PRESALES_ORD_TYPE
234: );
235:
236: update OP_PRSL_TYP_TL T set (
237: PRESALES_ORD_CODE,
238: PRESALES_ORD_DESC
239: ) = (select
240: B.PRESALES_ORD_CODE,

Line 242: from OP_PRSL_TYP_TL B

238: PRESALES_ORD_DESC
239: ) = (select
240: B.PRESALES_ORD_CODE,
241: B.PRESALES_ORD_DESC
242: from OP_PRSL_TYP_TL B
243: where B.PRESALES_ORD_TYPE = T.PRESALES_ORD_TYPE
244: and B.LANGUAGE = T.SOURCE_LANG)
245: where (
246: T.PRESALES_ORD_TYPE,

Line 251: from OP_PRSL_TYP_TL SUBB, OP_PRSL_TYP_TL SUBT

247: T.LANGUAGE
248: ) in (select
249: SUBT.PRESALES_ORD_TYPE,
250: SUBT.LANGUAGE
251: from OP_PRSL_TYP_TL SUBB, OP_PRSL_TYP_TL SUBT
252: where SUBB.PRESALES_ORD_TYPE = SUBT.PRESALES_ORD_TYPE
253: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
254: and (SUBB.PRESALES_ORD_CODE <> SUBT.PRESALES_ORD_CODE
255: or SUBB.PRESALES_ORD_DESC <> SUBT.PRESALES_ORD_DESC

Line 258: insert into OP_PRSL_TYP_TL (

254: and (SUBB.PRESALES_ORD_CODE <> SUBT.PRESALES_ORD_CODE
255: or SUBB.PRESALES_ORD_DESC <> SUBT.PRESALES_ORD_DESC
256: ));
257:
258: insert into OP_PRSL_TYP_TL (
259: PRESALES_ORD_TYPE,
260: PRESALES_ORD_CODE,
261: PRESALES_ORD_DESC,
262: CREATED_BY,

Line 280: from OP_PRSL_TYP_TL B, FND_LANGUAGES L

276: B.CREATION_DATE,
277: B.LAST_UPDATE_LOGIN,
278: L.LANGUAGE_CODE,
279: B.SOURCE_LANG
280: from OP_PRSL_TYP_TL B, FND_LANGUAGES L
281: where L.INSTALLED_FLAG in ('I', 'B')
282: and B.LANGUAGE = userenv('LANG')
283: and not exists
284: (select NULL

Line 285: from OP_PRSL_TYP_TL T

281: where L.INSTALLED_FLAG in ('I', 'B')
282: and B.LANGUAGE = userenv('LANG')
283: and not exists
284: (select NULL
285: from OP_PRSL_TYP_TL T
286: where T.PRESALES_ORD_TYPE = B.PRESALES_ORD_TYPE
287: and T.LANGUAGE = L.LANGUAGE_CODE);
288: end ADD_LANGUAGE;
289:

Line 296: update OP_PRSL_TYP_TL set

292: X_PRESALES_ORD_DESC VARCHAR2
293: ) IS
294:
295: BEGIN
296: update OP_PRSL_TYP_TL set
297: PRESALES_ORD_DESC = X_PRESALES_ORD_DESC,
298: SOURCE_LANG = userenv('LANG'),
299: LAST_UPDATE_DATE = sysdate,
300: LAST_UPDATED_BY = 0,