APPS.AHL_OSP_ORDERS_PKG dependencies on AHL_OSP_ORDERS_TL

Line 144: insert into AHL_OSP_ORDERS_TL (

140: X_LAST_UPDATED_BY,
141: X_LAST_UPDATE_LOGIN
142: );
143:
144: insert into AHL_OSP_ORDERS_TL (
145: OSP_ORDER_ID,
146: LAST_UPDATE_DATE,
147: LAST_UPDATED_BY,
148: CREATION_DATE,

Line 168: from AHL_OSP_ORDERS_TL T

164: from FND_LANGUAGES L
165: where L.INSTALLED_FLAG in ('I', 'B')
166: and not exists
167: (select NULL
168: from AHL_OSP_ORDERS_TL T
169: where T.OSP_ORDER_ID = X_OSP_ORDER_ID
170: and T.LANGUAGE = L.LANGUAGE_CODE);
171:
172: open c;

Line 269: from AHL_OSP_ORDERS_TL

265:
266: cursor c1 is select
267: DESCRIPTION,
268: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
269: from AHL_OSP_ORDERS_TL
270: where OSP_ORDER_ID = X_OSP_ORDER_ID
271: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
272: for update of OSP_ORDER_ID nowait;
273: begin

Line 463: update AHL_OSP_ORDERS_TL set

459: if (sql%notfound) then
460: raise no_data_found;
461: end if;
462:
463: update AHL_OSP_ORDERS_TL set
464: DESCRIPTION = X_DESCRIPTION,
465: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
466: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
467: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 481: delete from AHL_OSP_ORDERS_TL

477: procedure DELETE_ROW (
478: X_OSP_ORDER_ID in NUMBER
479: ) is
480: begin
481: delete from AHL_OSP_ORDERS_TL
482: where OSP_ORDER_ID = X_OSP_ORDER_ID;
483:
484: if (sql%notfound) then
485: raise no_data_found;

Line 499: delete from AHL_OSP_ORDERS_TL T

495:
496: procedure ADD_LANGUAGE
497: is
498: begin
499: delete from AHL_OSP_ORDERS_TL T
500: where not exists
501: (select NULL
502: from AHL_OSP_ORDERS_B B
503: where B.OSP_ORDER_ID = T.OSP_ORDER_ID

Line 506: update AHL_OSP_ORDERS_TL T set (

502: from AHL_OSP_ORDERS_B B
503: where B.OSP_ORDER_ID = T.OSP_ORDER_ID
504: );
505:
506: update AHL_OSP_ORDERS_TL T set (
507: DESCRIPTION
508: ) = (select
509: B.DESCRIPTION
510: from AHL_OSP_ORDERS_TL B

Line 510: from AHL_OSP_ORDERS_TL B

506: update AHL_OSP_ORDERS_TL T set (
507: DESCRIPTION
508: ) = (select
509: B.DESCRIPTION
510: from AHL_OSP_ORDERS_TL B
511: where B.OSP_ORDER_ID = T.OSP_ORDER_ID
512: and B.LANGUAGE = T.SOURCE_LANG)
513: where (
514: T.OSP_ORDER_ID,

Line 519: from AHL_OSP_ORDERS_TL SUBB, AHL_OSP_ORDERS_TL SUBT

515: T.LANGUAGE
516: ) in (select
517: SUBT.OSP_ORDER_ID,
518: SUBT.LANGUAGE
519: from AHL_OSP_ORDERS_TL SUBB, AHL_OSP_ORDERS_TL SUBT
520: where SUBB.OSP_ORDER_ID = SUBT.OSP_ORDER_ID
521: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
522: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
523: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 527: insert into AHL_OSP_ORDERS_TL (

523: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
524: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
525: ));
526:
527: insert into AHL_OSP_ORDERS_TL (
528: OSP_ORDER_ID,
529: LAST_UPDATE_DATE,
530: LAST_UPDATED_BY,
531: CREATION_DATE,

Line 547: from AHL_OSP_ORDERS_TL B, FND_LANGUAGES L

543: B.LAST_UPDATE_LOGIN,
544: B.DESCRIPTION,
545: L.LANGUAGE_CODE,
546: B.SOURCE_LANG
547: from AHL_OSP_ORDERS_TL B, FND_LANGUAGES L
548: where L.INSTALLED_FLAG in ('I', 'B')
549: and B.LANGUAGE = userenv('LANG')
550: and not exists
551: (select NULL

Line 552: from AHL_OSP_ORDERS_TL T

548: where L.INSTALLED_FLAG in ('I', 'B')
549: and B.LANGUAGE = userenv('LANG')
550: and not exists
551: (select NULL
552: from AHL_OSP_ORDERS_TL T
553: where T.OSP_ORDER_ID = B.OSP_ORDER_ID
554: and T.LANGUAGE = L.LANGUAGE_CODE);
555: end ADD_LANGUAGE;
556: