8: /* Insert_Row Procedure */
9: /*----------------------------------------------------------*/
10: /* --
11: -- Purpose
12: -- Insert a row into WSH_ITM_RESPONSE_RULES entity
13: --
14: -- Input Parameters
15: -- p_api_version
16: -- API version number (current version is 1.0)
72:
73: -- Initialize API return status to success
74: x_return_status := FND_API.G_RET_STS_SUCCESS;
75:
76: insert into wsh_itm_response_rules
77: (VENDOR_ID,
78: ERROR_TYPE,
79: ERROR_CODE,
80: INTERPRETED_VALUE_CODE,
106: x_return_status := fnd_api.g_ret_sts_success;
107:
108: SELECT rowid
109: INTO x_rowid
110: FROM wsh_itm_response_rules
111: WHERE vendor_id = p_vendor_id
112: AND nvl(error_code,-99) = nvl(p_error_code,-99)
113: AND error_type = p_error_type
114: AND interpreted_value_code = p_interpreted_code;
166: /* Update_Row Procedure */
167: /*----------------------------------------------------------*/
168: /* --
169: -- Purpose
170: -- Update a row into WSH_ITM_RESPONSE_RULES entity
171: --
172: -- Input Parameters
173: -- p_api_version
174: -- API version number (current version is 1.0)
250:
251: -- Update a row into wsh_itm_users entity with all detail information
252: -- for the given cc seq id
253:
254: UPDATE WSH_ITM_RESPONSE_RULES
255: SET
256: VENDOR_ID = P_VENDOR_ID
257: ,ERROR_TYPE = P_ERROR_TYPE
258: ,ERROR_CODE = P_ERROR_CODE
396: -- Initialize API return status to success
397: x_return_status := FND_API.G_RET_STS_SUCCESS;
398:
399:
400: DELETE FROM WSH_ITM_RESPONSE_RULES
401: WHERE rowid = p_rowid;
402:
403: IF SQL%NOTFOUND THEN
404: FND_MESSAGE.SET_NAME('WSH', 'WSH_DELETE_FAILED');
463: /* Lock_Row Procedure */
464: /*----------------------------------------------------------*/
465: /* --
466: -- Purpose
467: -- Lock a row into WSH_ITM_RESPONSE_RULES entity
468: --
469: -- Input Parameters
470: -- p_api_version
471: -- API version number (current version is 1.0)
522: changed exception;
523: others exception;
524: CURSOR lock_row IS
525: SELECT *
526: FROM WSH_ITM_RESPONSE_RULES
527: WHERE rowid = p_rowid
528: FOR UPDATE OF VENDOR_ID NOWAIT;
529:
530: Recinfo lock_row%ROWTYPE;