APPS.WSH_CC_PARAMETER_SETUPS_PKG dependencies on WSH_CC_PARAMETER_SETUPS_B

Line 11: -- Insert a row into WSH_CC_PARAMETER_SETUPS_B entity

7: /* Insert_Row Procedure */
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)

Line 97: insert into WSH_CC_PARAMETER_SETUPS_B (

93: --dbms_output.put_line('begin api-2');
94:
95: SELECT WSH_CC_PARAMETER_SETUPS_S.NEXTVAL into l_parameter_id FROM dual;
96:
97: insert into WSH_CC_PARAMETER_SETUPS_B (
98: PARAMETER_ID,
99: PARAMETER_NAME,
100: VALUE,
101: DEFAULT_VALUE,

Line 293: from WSH_CC_PARAMETER_SETUPS_B

289: PARAMETER_NAME,
290: VALUE,
291: DEFAULT_VALUE,
292: USER_SETTABLE
293: from WSH_CC_PARAMETER_SETUPS_B
294: where PARAMETER_ID = P_PARAMETER_ID
295: for update of PARAMETER_ID nowait;
296: recinfo c%rowtype;
297:

Line 389: -- Update a row into WSH_CC_parameter_setups_b entity

385: /* Update_Row Procedure */
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

Line 475: update WSH_CC_PARAMETER_SETUPS_B set

471:
472: -- Update a row into wsh_cc_parameter_setups entity with all detail information
473: -- for the given parameter id
474:
475: update WSH_CC_PARAMETER_SETUPS_B set
476: PARAMETER_NAME = P_PARAMETER_NAME,
477: VALUE = P_VALUE,
478: DEFAULT_VALUE = P_DEFAULT_VALUE,
479: USER_SETTABLE = P_USER_SETTABLE,

Line 575: -- Delete a row from WSH_CC_PARAMETER_SETUPS_B entity

571: /* Delete_Row Procedure */
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

Line 674: delete from WSH_CC_PARAMETER_SETUPS_B

670: ( p_count => x_msg_count,
671: p_data => x_msg_data
672: );
673:
674: delete from WSH_CC_PARAMETER_SETUPS_B
675: where PARAMETER_ID = p_PARAMETER_ID;
676:
677: IF SQL%NOTFOUND THEN
678: FND_MESSAGE.SET_NAME('WSH', 'WSH_DELETE_FAILED');

Line 743: from WSH_CC_PARAMETER_SETUPS_B B

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
745: );
746:
747: update WSH_CC_PARAMETER_SETUPS_TL T set (

Line 857: update WSH_CC_PARAMETER_SETUPS_B set

853: SELECT Sysdate INTO l_sysdate FROM dual;
854: l_parameter_id := fnd_number.canonical_to_number(x_parameter_id);
855:
856:
857: update WSH_CC_PARAMETER_SETUPS_B set
858: PARAMETER_NAME = x_PARAMETER_NAME,
859: VALUE = x_VALUE,
860: DEFAULT_VALUE = x_DEFAULT_VALUE,
861: USER_SETTABLE = x_USER_SETTABLE,

Line 876: insert into WSH_CC_PARAMETER_SETUPS_B (

872: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
873:
874: IF SQL%NOTFOUND THEN
875:
876: insert into WSH_CC_PARAMETER_SETUPS_B (
877: PARAMETER_ID,
878: PARAMETER_NAME,
879: VALUE,
880: DEFAULT_VALUE,