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_CC_PARAMETER_SETUPS_PKG dependencies on WSH_CC_PARAMETER_SETUPS_TL

Line 12: -- Insert a row into WSH_CC_PARAMETER_SETUPS_TL entity

8: /*----------------------------------------------------------*/
9: /* --
10: -- Purpose
11: -- Insert a row into WSH_CC_PARAMETER_SETUPS_B entity
12: -- Insert a row into WSH_CC_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 144: insert into WSH_CC_PARAMETER_SETUPS_TL (

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

Line 170: from WSH_CC_PARAMETER_SETUPS_TL T

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

Line 306: from WSH_CC_PARAMETER_SETUPS_TL

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

Line 390: -- Update a row into WSH_CC_parameter_setups_tl entity

386: /*----------------------------------------------------------*/
387: /* --
388: -- Purpose
389: -- Update a row into WSH_CC_parameter_setups_b entity
390: -- Update a row into WSH_CC_parameter_setups_tl entity
391: -- for the given parameter id
392: --
393: -- Input Parameters
394: -- p_api_version

Line 506: update WSH_CC_PARAMETER_SETUPS_TL set

502: ( p_count => x_msg_count,
503: p_data => x_msg_data
504: );
505:
506: update WSH_CC_PARAMETER_SETUPS_TL set
507: USER_PARAMETER_NAME = P_USER_PARAMETER_NAME,
508: DESCRIPTION = P_DESCRIPTION,
509: SOURCE_LANG = userenv('LANG')
510: where PARAMETER_ID = P_PARAMETER_ID

Line 576: -- Delete a row from WSH_CC_PARAMETER_SETUPS_TL entity

572: /*----------------------------------------------------------*/
573: /* --
574: -- Purpose
575: -- Delete a row from WSH_CC_PARAMETER_SETUPS_B entity
576: -- Delete a row from WSH_CC_PARAMETER_SETUPS_TL entity
577: -- for the given parameter id
578: --
579: -- Input Parameters
580: -- p_api_version

Line 650: delete from WSH_CC_PARAMETER_SETUPS_TL

646: -- Delete a row from wsh_cc_parameter_setups entity
647: -- for the given parameter id
648:
649:
650: delete from WSH_CC_PARAMETER_SETUPS_TL
651: where PARAMETER_ID = P_PARAMETER_ID;
652:
653: IF SQL%NOTFOUND THEN
654: FND_MESSAGE.SET_NAME('WSH', 'WSH_DELETE_FAILED');

Line 740: delete from WSH_CC_PARAMETER_SETUPS_TL T

736: /*----------------------------------------------------------*/
737: procedure ADD_LANGUAGE
738: is
739: begin
740: delete from WSH_CC_PARAMETER_SETUPS_TL T
741: where not exists
742: (select NULL
743: from WSH_CC_PARAMETER_SETUPS_B B
744: where B.PARAMETER_ID = T.PARAMETER_ID

Line 747: update WSH_CC_PARAMETER_SETUPS_TL T set (

743: from WSH_CC_PARAMETER_SETUPS_B B
744: where B.PARAMETER_ID = T.PARAMETER_ID
745: );
746:
747: update WSH_CC_PARAMETER_SETUPS_TL T set (
748: USER_PARAMETER_NAME,
749: DESCRIPTION
750: ) = (select
751: B.USER_PARAMETER_NAME,

Line 753: from WSH_CC_PARAMETER_SETUPS_TL B

749: DESCRIPTION
750: ) = (select
751: B.USER_PARAMETER_NAME,
752: B.DESCRIPTION
753: from WSH_CC_PARAMETER_SETUPS_TL B
754: where B.PARAMETER_ID = T.PARAMETER_ID
755: and B.LANGUAGE = T.SOURCE_LANG)
756: where (
757: T.PARAMETER_ID,

Line 762: from WSH_CC_PARAMETER_SETUPS_TL SUBB, WSH_CC_PARAMETER_SETUPS_TL SUBT

758: T.LANGUAGE
759: ) in (select
760: SUBT.PARAMETER_ID,
761: SUBT.LANGUAGE
762: from WSH_CC_PARAMETER_SETUPS_TL SUBB, WSH_CC_PARAMETER_SETUPS_TL SUBT
763: where SUBB.PARAMETER_ID = SUBT.PARAMETER_ID
764: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
765: and (SUBB.USER_PARAMETER_NAME <> SUBT.USER_PARAMETER_NAME
766: or (SUBB.USER_PARAMETER_NAME is null and SUBT.USER_PARAMETER_NAME is not null)

Line 773: insert into WSH_CC_PARAMETER_SETUPS_TL (

769: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
770: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
771: ));
772:
773: insert into WSH_CC_PARAMETER_SETUPS_TL (
774: PARAMETER_ID,
775: USER_PARAMETER_NAME,
776: DESCRIPTION,
777: LAST_UPDATE_DATE,

Line 795: from WSH_CC_PARAMETER_SETUPS_TL B, FND_LANGUAGES L

791: B.CREATED_BY,
792: B.LAST_UPDATE_LOGIN,
793: L.LANGUAGE_CODE,
794: B.SOURCE_LANG
795: from WSH_CC_PARAMETER_SETUPS_TL B, FND_LANGUAGES L
796: where L.INSTALLED_FLAG in ('I', 'B')
797: and B.LANGUAGE = userenv('LANG')
798: and not exists
799: (select NULL

Line 800: from WSH_CC_PARAMETER_SETUPS_TL T

796: where L.INSTALLED_FLAG in ('I', 'B')
797: and B.LANGUAGE = userenv('LANG')
798: and not exists
799: (select NULL
800: from WSH_CC_PARAMETER_SETUPS_TL T
801: where T.PARAMETER_ID = B.PARAMETER_ID
802: and T.LANGUAGE = L.LANGUAGE_CODE);
803: end ADD_LANGUAGE;
804:

Line 816: UPDATE wsh_cc_parameter_setups_tl SET

812: x_user_parameter_name IN VARCHAR2 ,
813: x_description IN VARCHAR2
814: ) IS
815: BEGIN
816: UPDATE wsh_cc_parameter_setups_tl SET
817: user_parameter_name = x_user_parameter_name,
818: description = x_description,
819: last_update_date = sysdate,
820: last_updated_by = Decode(x_owner, 'SEED', 1, 0),

Line 867: update WSH_CC_PARAMETER_SETUPS_TL set

863: LAST_UPDATED_BY = l_user_id,
864: LAST_UPDATE_LOGIN = 0
865: where PARAMETER_ID = l_PARAMETER_ID;
866:
867: update WSH_CC_PARAMETER_SETUPS_TL set
868: USER_PARAMETER_NAME = x_USER_PARAMETER_NAME,
869: DESCRIPTION = x_DESCRIPTION,
870: SOURCE_LANG = userenv('LANG')
871: where PARAMETER_ID = l_PARAMETER_ID

Line 901: insert into WSH_CC_PARAMETER_SETUPS_TL (

897: l_user_id,
898: 0
899: );
900:
901: insert into WSH_CC_PARAMETER_SETUPS_TL (
902: PARAMETER_ID,
903: USER_PARAMETER_NAME,
904: DESCRIPTION,
905: LAST_UPDATE_DATE,

Line 927: from WSH_CC_PARAMETER_SETUPS_TL T

923: from FND_LANGUAGES L
924: where L.INSTALLED_FLAG in ('I', 'B')
925: and not exists
926: (select NULL
927: from WSH_CC_PARAMETER_SETUPS_TL T
928: where T.PARAMETER_ID = l_PARAMETER_ID
929: and T.LANGUAGE = L.LANGUAGE_CODE);
930:
931: END IF;