APPS.GML_OP_ORDR_STS_PKG dependencies on OP_ORDR_STS_TL

Line 46: insert into OP_ORDR_STS_TL (

42: X_LAST_UPDATED_BY,
43: X_LAST_UPDATE_LOGIN
44: );
45:
46: insert into OP_ORDR_STS_TL (
47: ORDER_STATUS,
48: ORDER_STATUS_CODE,
49: ORDER_STATUS_DESC,
50: CREATED_BY,

Line 72: from OP_ORDR_STS_TL T

68: from FND_LANGUAGES L
69: where L.INSTALLED_FLAG in ('I', 'B')
70: and not exists
71: (select NULL
72: from OP_ORDR_STS_TL T
73: where T.ORDER_STATUS = X_ORDER_STATUS
74: and T.LANGUAGE = L.LANGUAGE_CODE);
75:
76: open c;

Line 111: from OP_ORDR_STS_TL

107: cursor c1 is select
108: ORDER_STATUS_CODE,
109: ORDER_STATUS_DESC,
110: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
111: from OP_ORDR_STS_TL
112: where ORDER_STATUS = X_ORDER_STATUS
113: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
114: for update of ORDER_STATUS nowait;
115: begin

Line 178: update OP_ORDR_STS_TL set

174: if (sql%notfound) then
175: raise no_data_found;
176: end if;
177:
178: update OP_ORDR_STS_TL set
179: ORDER_STATUS_CODE = X_ORDER_STATUS_CODE,
180: ORDER_STATUS_DESC = X_ORDER_STATUS_DESC,
181: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
182: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 197: delete from OP_ORDR_STS_TL

193: procedure DELETE_ROW (
194: X_ORDER_STATUS in NUMBER
195: ) is
196: begin
197: delete from OP_ORDR_STS_TL
198: where ORDER_STATUS = X_ORDER_STATUS;
199:
200: if (sql%notfound) then
201: raise no_data_found;

Line 215: delete from OP_ORDR_STS_TL T

211:
212: procedure ADD_LANGUAGE
213: is
214: begin
215: delete from OP_ORDR_STS_TL T
216: where not exists
217: (select NULL
218: from OP_ORDR_STS_B B
219: where B.ORDER_STATUS = T.ORDER_STATUS

Line 222: update OP_ORDR_STS_TL T set (

218: from OP_ORDR_STS_B B
219: where B.ORDER_STATUS = T.ORDER_STATUS
220: );
221:
222: update OP_ORDR_STS_TL T set (
223: ORDER_STATUS_CODE,
224: ORDER_STATUS_DESC
225: ) = (select
226: B.ORDER_STATUS_CODE,

Line 228: from OP_ORDR_STS_TL B

224: ORDER_STATUS_DESC
225: ) = (select
226: B.ORDER_STATUS_CODE,
227: B.ORDER_STATUS_DESC
228: from OP_ORDR_STS_TL B
229: where B.ORDER_STATUS = T.ORDER_STATUS
230: and B.LANGUAGE = T.SOURCE_LANG)
231: where (
232: T.ORDER_STATUS,

Line 237: from OP_ORDR_STS_TL SUBB, OP_ORDR_STS_TL SUBT

233: T.LANGUAGE
234: ) in (select
235: SUBT.ORDER_STATUS,
236: SUBT.LANGUAGE
237: from OP_ORDR_STS_TL SUBB, OP_ORDR_STS_TL SUBT
238: where SUBB.ORDER_STATUS = SUBT.ORDER_STATUS
239: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
240: and (SUBB.ORDER_STATUS_CODE <> SUBT.ORDER_STATUS_CODE
241: or SUBB.ORDER_STATUS_DESC <> SUBT.ORDER_STATUS_DESC

Line 244: insert into OP_ORDR_STS_TL (

240: and (SUBB.ORDER_STATUS_CODE <> SUBT.ORDER_STATUS_CODE
241: or SUBB.ORDER_STATUS_DESC <> SUBT.ORDER_STATUS_DESC
242: ));
243:
244: insert into OP_ORDR_STS_TL (
245: ORDER_STATUS,
246: ORDER_STATUS_CODE,
247: ORDER_STATUS_DESC,
248: CREATED_BY,

Line 266: from OP_ORDR_STS_TL B, FND_LANGUAGES L

262: B.LAST_UPDATE_DATE,
263: B.LAST_UPDATE_LOGIN,
264: L.LANGUAGE_CODE,
265: B.SOURCE_LANG
266: from OP_ORDR_STS_TL B, FND_LANGUAGES L
267: where L.INSTALLED_FLAG in ('I', 'B')
268: and B.LANGUAGE = userenv('LANG')
269: and not exists
270: (select NULL

Line 271: from OP_ORDR_STS_TL T

267: where L.INSTALLED_FLAG in ('I', 'B')
268: and B.LANGUAGE = userenv('LANG')
269: and not exists
270: (select NULL
271: from OP_ORDR_STS_TL T
272: where T.ORDER_STATUS = B.ORDER_STATUS
273: and T.LANGUAGE = L.LANGUAGE_CODE);
274: end ADD_LANGUAGE;
275:

Line 283: update OP_ORDR_STS_TL set

279: X_ORDER_STATUS_CODE VARCHAR2
280: ) IS
281:
282: BEGIN
283: update OP_ORDR_STS_TL set
284: ORDER_STATUS_DESC = X_ORDER_STATUS_DESC,
285: ORDER_STATUS_CODE = X_ORDER_STATUS_CODE,
286: SOURCE_LANG = userenv('LANG'),
287: LAST_UPDATE_DATE = sysdate,