APPS.WMS_OP_PLANS_PKG dependencies on WMS_OP_PLANS_TL

Line 122: insert into WMS_OP_PLANS_TL (

118: ,x_template_flag
119: ,x_crossdock_to_wip_flag
120: );
121:
122: insert into WMS_OP_PLANS_TL (
123: operation_plan_id
124: ,last_updated_by
125: ,last_update_date
126: ,created_by

Line 148: from WMS_OP_PLANS_TL T

144: from FND_LANGUAGES L
145: where L.INSTALLED_FLAG in ('I', 'B')
146: and not exists
147: (select NULL
148: from WMS_OP_PLANS_TL T
149: where T.OPERATION_PLAN_ID = X_OPERATION_PLAN_ID
150: and T.LANGUAGE = L.LANGUAGE_CODE);
151:
152: OPEN C;

Line 239: update WMS_OP_PLANS_TL set

235: if (sql%notfound) then
236: raise no_data_found;
237: end if;
238:
239: update WMS_OP_PLANS_TL set
240: operation_plan_name = x_operation_plan_name,
241: description = x_description,
242: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
243: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 412: delete from WMS_OP_PLANS_TL

408: if (sql%notfound) then
409: raise no_data_found;
410: end if;
411:
412: delete from WMS_OP_PLANS_TL
413: where operation_plan_id = X_OPERATION_PLAN_ID;
414:
415: if (sql%notfound) then
416: raise no_data_found;

Line 496: from wms_op_plans_tl

492: cursor c1 is select
493: operation_plan_name,
494: description,
495: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
496: from wms_op_plans_tl
497: where operation_plan_id = x_operation_plan_id
498: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
499: for UPDATE of OPERATION_PLAN_ID NOWAIT;
500: --recinfo1 c1%rowtype;

Line 659: UPDATE wms_op_plans_tl SET

655: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
656: db_ludate, x_custom_mode)) then
657:
658: -- Update translations for this language
659: UPDATE wms_op_plans_tl SET
660: operation_plan_name = x_operation_plan_name,
661: description = x_description,
662: last_update_date = f_ludate,
663: last_updated_by = f_luby,

Line 680: delete from WMS_OP_PLANS_TL T

676:
677: procedure ADD_LANGUAGE
678: is
679: begin
680: delete from WMS_OP_PLANS_TL T
681: where not exists
682: (select NULL
683: from WMS_OP_PLANS_B B
684: where B.OPERATION_PLAN_ID = T.OPERATION_PLAN_ID

Line 687: update WMS_OP_PLANS_TL T set (

683: from WMS_OP_PLANS_B B
684: where B.OPERATION_PLAN_ID = T.OPERATION_PLAN_ID
685: );
686:
687: update WMS_OP_PLANS_TL T set (
688: OPERATION_PLAN_NAME,
689: DESCRIPTION
690: ) = (select
691: B.OPERATION_PLAN_NAME,

Line 693: from WMS_OP_PLANS_TL B

689: DESCRIPTION
690: ) = (select
691: B.OPERATION_PLAN_NAME,
692: B.DESCRIPTION
693: from WMS_OP_PLANS_TL B
694: where B.OPERATION_PLAN_ID = T.OPERATION_PLAN_ID
695: and B.LANGUAGE = T.SOURCE_LANG)
696: where (
697: T.OPERATION_PLAN_ID,

Line 702: from WMS_OP_PLANS_TL SUBB, WMS_OP_PLANS_TL SUBT

698: T.LANGUAGE
699: ) in (select
700: SUBT.OPERATION_PLAN_ID,
701: SUBT.LANGUAGE
702: from WMS_OP_PLANS_TL SUBB, WMS_OP_PLANS_TL SUBT
703: where SUBB.OPERATION_PLAN_ID = SUBT.OPERATION_PLAN_ID
704: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
705: and (SUBB.OPERATION_PLAN_NAME <> SUBT.OPERATION_PLAN_NAME
706: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 711: insert into WMS_OP_PLANS_TL (

707: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
708: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
709: ));
710:
711: insert into WMS_OP_PLANS_TL (
712: DESCRIPTION,
713: CREATED_BY,
714: OPERATION_PLAN_NAME,
715: LAST_UPDATE_LOGIN,

Line 733: from WMS_OP_PLANS_TL B, FND_LANGUAGES L

729: B.LAST_UPDATE_DATE,
730: B.CREATION_DATE,
731: L.LANGUAGE_CODE,
732: B.SOURCE_LANG
733: from WMS_OP_PLANS_TL B, FND_LANGUAGES L
734: where L.INSTALLED_FLAG in ('I', 'B')
735: and B.LANGUAGE = userenv('LANG')
736: and not exists
737: (select NULL

Line 738: from WMS_OP_PLANS_TL T

734: where L.INSTALLED_FLAG in ('I', 'B')
735: and B.LANGUAGE = userenv('LANG')
736: and not exists
737: (select NULL
738: from WMS_OP_PLANS_TL T
739: where T.OPERATION_PLAN_ID = B.OPERATION_PLAN_ID
740: and T.LANGUAGE = L.LANGUAGE_CODE);
741: end ADD_LANGUAGE;
742: