APPS.WSH_CC_USERS_PKG dependencies on WSH_CC_USER_SETUPS

Line 92: select wsh_cc_user_setups_s.nextval into l_CC_USER_SEQUENCE_ID from dual;

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

Line 96: insert into wsh_cc_user_setups

92: select wsh_cc_user_setups_s.nextval into l_CC_USER_SEQUENCE_ID from dual;
93: /* Validate input parameters if any */
94:
95: -- Insert a row into wsh_cc_users entity with all detail information
96: insert into wsh_cc_user_setups
97: ( CC_USER_SEQUENCE_ID
98: ,APPLICATION_ID
99: ,MASTER_ORGANIZATION_ID
100: ,ORGANIZATION_ID

Line 264: update wsh_cc_user_setups

260:
261: -- Update a row into wsh_cc_users entity with all detail information
262: -- for the given cc seq id
263:
264: update wsh_cc_user_setups
265: SET
266: APPLICATION_ID = p_APPLICATION_ID
267: ,MASTER_ORGANIZATION_ID = p_MASTER_ORGANIZATION_ID
268: ,ORGANIZATION_ID = decode(p_ORGANIZATION_ID,fnd_api.g_miss_num,

Line 410: DELETE from wsh_cc_user_setups

406:
407: -- Delete a row from wsh_cc_users entity
408: -- for the given cc seq id
409:
410: DELETE from wsh_cc_user_setups
411: WHERE cc_user_sequence_id = p_cc_user_sequence_id ;
412: IF SQL%NOTFOUND THEN
413: FND_MESSAGE.SET_NAME('WSH', 'WSH_DELETE_FAILED');
414: FND_MSG_PUB.ADD;

Line 534: FROM wsh_cc_user_setups

530: )
531: IS
532: CURSOR lock_row IS
533: SELECT *
534: FROM wsh_cc_user_setups
535: WHERE rowid = p_rowid
536: FOR UPDATE OF CC_USER_SEQUENCE_ID NOWAIT;
537:
538: Recinfo lock_row%ROWTYPE;