APPS.WSH_ITM_USERS_PKG dependencies on WSH_ITM_USER_SETUPS

Line 94: select wsh_itm_user_setups_s.nextval into l_ITM_USER_SEQUENCE_ID from dual;

90: -- Initialize API return status to success
91: x_return_status := FND_API.G_RET_STS_SUCCESS;
92: --dbms_output.put_line('begin api-2');
93:
94: select wsh_itm_user_setups_s.nextval into l_ITM_USER_SEQUENCE_ID from dual;
95: /* Validate input parameters if any */
96:
97: -- Insert a row into wsh_itm_users entity with all detail information
98: insert into wsh_itm_user_setups

Line 98: insert into wsh_itm_user_setups

94: select wsh_itm_user_setups_s.nextval into l_ITM_USER_SEQUENCE_ID from dual;
95: /* Validate input parameters if any */
96:
97: -- Insert a row into wsh_itm_users entity with all detail information
98: insert into wsh_itm_user_setups
99: ( ITM_USER_SEQUENCE_ID
100: ,VENDOR_ID
101: ,APPLICATION_ID
102: ,MASTER_ORGANIZATION_ID

Line 276: update wsh_itm_user_setups

272:
273: -- Update a row into wsh_itm_users entity with all detail information
274: -- for the given seq id
275:
276: update wsh_itm_user_setups
277: SET
278: VENDOR_ID = p_VENDOR_ID
279: ,APPLICATION_ID = p_APPLICATION_ID
280: ,MASTER_ORGANIZATION_ID = p_MASTER_ORGANIZATION_ID

Line 427: DELETE from wsh_itm_user_setups

423:
424: -- Delete a row from wsh_itm_users entity
425: -- for the given cc seq id
426:
427: DELETE from wsh_itm_user_setups
428: WHERE itm_user_sequence_id = p_itm_user_sequence_id ;
429: IF SQL%NOTFOUND THEN
430: FND_MESSAGE.SET_NAME('WSH', 'WSH_DELETE_FAILED');
431: FND_MSG_PUB.ADD;

Line 553: FROM wsh_itm_user_setups

549: )
550: IS
551: CURSOR lock_row IS
552: SELECT *
553: FROM wsh_itm_user_setups
554: WHERE ITM_USER_SEQUENCE_ID = p_ITM_USER_SEQUENCE_ID
555: FOR UPDATE OF ITM_USER_SEQUENCE_ID NOWAIT;
556:
557: Recinfo lock_row%ROWTYPE;