APPS.WSH_ITM_PARAMETER_SETUPS_PKG dependencies on WSH_ITM_PARAMETER_SETUPS_B

Line 11: -- Insert a row into WSH_ITM_PARAMETER_SETUPS_B entity

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

Line 96: insert into WSH_ITM_PARAMETER_SETUPS_B (

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

Line 292: from WSH_ITM_PARAMETER_SETUPS_B

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

Line 395: -- Update a row into WSH_ITM_parameter_setups_b entity

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

Line 481: update WSH_ITM_PARAMETER_SETUPS_B set

477:
478: -- Update a row into WSH_ITM_parameter_setups entity with all detail information
479: -- for the given parameter id
480:
481: update WSH_ITM_PARAMETER_SETUPS_B set
482: PARAMETER_NAME = P_PARAMETER_NAME,
483: VALUE = P_VALUE,
484: DEFAULT_VALUE = P_DEFAULT_VALUE,
485: USER_SETTABLE = P_USER_SETTABLE,

Line 581: -- Delete a row from WSH_ITM_PARAMETER_SETUPS_B entity

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

Line 680: delete from WSH_ITM_PARAMETER_SETUPS_B

676: ( p_count => x_msg_count,
677: p_data => x_msg_data
678: );
679:
680: delete from WSH_ITM_PARAMETER_SETUPS_B
681: where PARAMETER_ID = p_PARAMETER_ID;
682:
683: IF SQL%NOTFOUND THEN
684: FND_MESSAGE.SET_NAME('WSH', 'WSH_DELETE_FAILED');

Line 749: from WSH_ITM_PARAMETER_SETUPS_B B

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
751: );
752:
753: update WSH_ITM_PARAMETER_SETUPS_TL T set (

Line 863: update WSH_ITM_PARAMETER_SETUPS_B set

859: SELECT Sysdate INTO l_sysdate FROM dual;
860: l_parameter_id := fnd_number.canonical_to_number(x_parameter_id);
861:
862:
863: update WSH_ITM_PARAMETER_SETUPS_B set
864: PARAMETER_NAME = x_PARAMETER_NAME,
865: VALUE = x_VALUE,
866: DEFAULT_VALUE = x_DEFAULT_VALUE,
867: USER_SETTABLE = x_USER_SETTABLE,

Line 882: insert into WSH_ITM_PARAMETER_SETUPS_B (

878: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
879:
880: IF SQL%NOTFOUND THEN
881:
882: insert into WSH_ITM_PARAMETER_SETUPS_B (
883: PARAMETER_ID,
884: PARAMETER_NAME,
885: VALUE,
886: DEFAULT_VALUE,