eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_ITM_PARAMETER_SETUPS_PKG dependencies on WSH_ITM_PARAMETER_SETUPS_TL

Line 12: -- Insert a row into WSH_ITM_PARAMETER_SETUPS_TL entity

8: /*----------------------------------------------------------*/
9: /* --
10: -- Purpose
11: -- Insert a row into WSH_ITM_PARAMETER_SETUPS_B entity
12: -- Insert a row into WSH_ITM_PARAMETER_SETUPS_TL entity
13: -- Input Parameters
14: -- p_api_version
15: -- API version number (current version is 1.0)
16: -- p_init_msg_list (optional, default FND_API.G_FALSE)

Line 143: insert into WSH_ITM_PARAMETER_SETUPS_TL (

139: p_data => x_msg_data
140: );
141:
142:
143: insert into WSH_ITM_PARAMETER_SETUPS_TL (
144: PARAMETER_ID,
145: USER_PARAMETER_NAME,
146: DESCRIPTION,
147: LAST_UPDATE_DATE,

Line 169: from WSH_ITM_PARAMETER_SETUPS_TL T

165: from FND_LANGUAGES L
166: where L.INSTALLED_FLAG in ('I', 'B')
167: and not exists
168: (select NULL
169: from WSH_ITM_PARAMETER_SETUPS_TL T
170: where T.PARAMETER_ID = l_PARAMETER_ID
171: and T.LANGUAGE = L.LANGUAGE_CODE);
172:
173: IF SQL%NOTFOUND THEN

Line 305: from WSH_ITM_PARAMETER_SETUPS_TL

301: cursor c1 is select
302: USER_PARAMETER_NAME,
303: DESCRIPTION,
304: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
305: from WSH_ITM_PARAMETER_SETUPS_TL
306: where PARAMETER_ID = P_PARAMETER_ID
307: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
308: for update of PARAMETER_ID nowait;
309:

Line 396: -- Update a row into WSH_ITM_parameter_setups_tl entity

392: /*----------------------------------------------------------*/
393: /* --
394: -- Purpose
395: -- Update a row into WSH_ITM_parameter_setups_b entity
396: -- Update a row into WSH_ITM_parameter_setups_tl entity
397: -- for the given parameter id
398: --
399: -- Input Parameters
400: -- p_api_version

Line 512: update WSH_ITM_PARAMETER_SETUPS_TL set

508: ( p_count => x_msg_count,
509: p_data => x_msg_data
510: );
511:
512: update WSH_ITM_PARAMETER_SETUPS_TL set
513: USER_PARAMETER_NAME = P_USER_PARAMETER_NAME,
514: DESCRIPTION = P_DESCRIPTION,
515: SOURCE_LANG = userenv('LANG')
516: where PARAMETER_ID = P_PARAMETER_ID

Line 582: -- Delete a row from WSH_ITM_PARAMETER_SETUPS_TL entity

578: /*----------------------------------------------------------*/
579: /* --
580: -- Purpose
581: -- Delete a row from WSH_ITM_PARAMETER_SETUPS_B entity
582: -- Delete a row from WSH_ITM_PARAMETER_SETUPS_TL entity
583: -- for the given parameter id
584: --
585: -- Input Parameters
586: -- p_api_version

Line 656: delete from WSH_ITM_PARAMETER_SETUPS_TL

652: -- Delete a row from WSH_ITM_parameter_setups entity
653: -- for the given parameter id
654:
655:
656: delete from WSH_ITM_PARAMETER_SETUPS_TL
657: where PARAMETER_ID = P_PARAMETER_ID;
658:
659: IF SQL%NOTFOUND THEN
660: FND_MESSAGE.SET_NAME('WSH', 'WSH_DELETE_FAILED');

Line 746: delete from WSH_ITM_PARAMETER_SETUPS_TL T

742: /*----------------------------------------------------------*/
743: procedure ADD_LANGUAGE
744: is
745: begin
746: delete from WSH_ITM_PARAMETER_SETUPS_TL T
747: where not exists
748: (select NULL
749: from WSH_ITM_PARAMETER_SETUPS_B B
750: where B.PARAMETER_ID = T.PARAMETER_ID

Line 753: update WSH_ITM_PARAMETER_SETUPS_TL T set (

749: from WSH_ITM_PARAMETER_SETUPS_B B
750: where B.PARAMETER_ID = T.PARAMETER_ID
751: );
752:
753: update WSH_ITM_PARAMETER_SETUPS_TL T set (
754: USER_PARAMETER_NAME,
755: DESCRIPTION
756: ) = (select
757: B.USER_PARAMETER_NAME,

Line 759: from WSH_ITM_PARAMETER_SETUPS_TL B

755: DESCRIPTION
756: ) = (select
757: B.USER_PARAMETER_NAME,
758: B.DESCRIPTION
759: from WSH_ITM_PARAMETER_SETUPS_TL B
760: where B.PARAMETER_ID = T.PARAMETER_ID
761: and B.LANGUAGE = T.SOURCE_LANG)
762: where (
763: T.PARAMETER_ID,

Line 768: from WSH_ITM_PARAMETER_SETUPS_TL SUBB, WSH_ITM_PARAMETER_SETUPS_TL SUBT

764: T.LANGUAGE
765: ) in (select
766: SUBT.PARAMETER_ID,
767: SUBT.LANGUAGE
768: from WSH_ITM_PARAMETER_SETUPS_TL SUBB, WSH_ITM_PARAMETER_SETUPS_TL SUBT
769: where SUBB.PARAMETER_ID = SUBT.PARAMETER_ID
770: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
771: and (SUBB.USER_PARAMETER_NAME <> SUBT.USER_PARAMETER_NAME
772: or (SUBB.USER_PARAMETER_NAME is null and SUBT.USER_PARAMETER_NAME is not null)

Line 779: insert into WSH_ITM_PARAMETER_SETUPS_TL (

775: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
776: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
777: ));
778:
779: insert into WSH_ITM_PARAMETER_SETUPS_TL (
780: PARAMETER_ID,
781: USER_PARAMETER_NAME,
782: DESCRIPTION,
783: LAST_UPDATE_DATE,

Line 801: from WSH_ITM_PARAMETER_SETUPS_TL B, FND_LANGUAGES L

797: B.CREATED_BY,
798: B.LAST_UPDATE_LOGIN,
799: L.LANGUAGE_CODE,
800: B.SOURCE_LANG
801: from WSH_ITM_PARAMETER_SETUPS_TL B, FND_LANGUAGES L
802: where L.INSTALLED_FLAG in ('I', 'B')
803: and B.LANGUAGE = userenv('LANG')
804: and not exists
805: (select NULL

Line 806: from WSH_ITM_PARAMETER_SETUPS_TL T

802: where L.INSTALLED_FLAG in ('I', 'B')
803: and B.LANGUAGE = userenv('LANG')
804: and not exists
805: (select NULL
806: from WSH_ITM_PARAMETER_SETUPS_TL T
807: where T.PARAMETER_ID = B.PARAMETER_ID
808: and T.LANGUAGE = L.LANGUAGE_CODE);
809: end ADD_LANGUAGE;
810:

Line 822: UPDATE WSH_ITM_parameter_setups_tl SET

818: x_user_parameter_name IN VARCHAR2 ,
819: x_description IN VARCHAR2
820: ) IS
821: BEGIN
822: UPDATE WSH_ITM_parameter_setups_tl SET
823: user_parameter_name = x_user_parameter_name,
824: description = x_description,
825: last_update_date = sysdate,
826: last_updated_by = Decode(x_owner, 'SEED', 1, 0),

Line 873: update WSH_ITM_PARAMETER_SETUPS_TL set

869: LAST_UPDATED_BY = l_user_id,
870: LAST_UPDATE_LOGIN = 0
871: where PARAMETER_ID = l_PARAMETER_ID;
872:
873: update WSH_ITM_PARAMETER_SETUPS_TL set
874: USER_PARAMETER_NAME = x_USER_PARAMETER_NAME,
875: DESCRIPTION = x_DESCRIPTION,
876: SOURCE_LANG = userenv('LANG')
877: where PARAMETER_ID = l_PARAMETER_ID

Line 907: insert into WSH_ITM_PARAMETER_SETUPS_TL (

903: l_user_id,
904: 0
905: );
906:
907: insert into WSH_ITM_PARAMETER_SETUPS_TL (
908: PARAMETER_ID,
909: USER_PARAMETER_NAME,
910: DESCRIPTION,
911: LAST_UPDATE_DATE,

Line 933: from WSH_ITM_PARAMETER_SETUPS_TL T

929: from FND_LANGUAGES L
930: where L.INSTALLED_FLAG in ('I', 'B')
931: and not exists
932: (select NULL
933: from WSH_ITM_PARAMETER_SETUPS_TL T
934: where T.PARAMETER_ID = l_PARAMETER_ID
935: and T.LANGUAGE = L.LANGUAGE_CODE);
936:
937: END IF;