27: , last_update_date
28: , last_update_login
29: ) VALUES (
30: x_result_id
31: , DECODE(x_reason_id,FND_API.G_MISS_NUM,NULL,x_reason_id)
32: , DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
33: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
34: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
35: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
28: , last_update_login
29: ) VALUES (
30: x_result_id
31: , DECODE(x_reason_id,FND_API.G_MISS_NUM,NULL,x_reason_id)
32: , DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
33: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
34: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
35: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
36: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
29: ) VALUES (
30: x_result_id
31: , DECODE(x_reason_id,FND_API.G_MISS_NUM,NULL,x_reason_id)
32: , DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
33: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
34: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
35: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
36: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
37: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
30: x_result_id
31: , DECODE(x_reason_id,FND_API.G_MISS_NUM,NULL,x_reason_id)
32: , DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
33: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
34: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
35: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
36: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
37: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
38: );
31: , DECODE(x_reason_id,FND_API.G_MISS_NUM,NULL,x_reason_id)
32: , DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
33: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
34: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
35: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
36: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
37: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
38: );
39:
32: , DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
33: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
34: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
35: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
36: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
37: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
38: );
39:
40: OPEN l_insert;
33: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
34: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
35: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
36: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
37: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
38: );
39:
40: OPEN l_insert;
41: FETCH l_insert INTO x_rowid;
69: ) IS
70: BEGIN
71: UPDATE jtf_ih_result_reasons
72: SET
73: result_id=DECODE(x_result_id,FND_API.G_MISS_NUM,NULL,x_result_id)
74: , reason_id=DECODE(x_reason_id,FND_API.G_MISS_NUM,NULL,x_reason_id)
75: , object_version_number=DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
76: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
77: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
70: BEGIN
71: UPDATE jtf_ih_result_reasons
72: SET
73: result_id=DECODE(x_result_id,FND_API.G_MISS_NUM,NULL,x_result_id)
74: , reason_id=DECODE(x_reason_id,FND_API.G_MISS_NUM,NULL,x_reason_id)
75: , object_version_number=DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
76: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
77: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
78: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
71: UPDATE jtf_ih_result_reasons
72: SET
73: result_id=DECODE(x_result_id,FND_API.G_MISS_NUM,NULL,x_result_id)
74: , reason_id=DECODE(x_reason_id,FND_API.G_MISS_NUM,NULL,x_reason_id)
75: , object_version_number=DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
76: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
77: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
78: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
79: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
72: SET
73: result_id=DECODE(x_result_id,FND_API.G_MISS_NUM,NULL,x_result_id)
74: , reason_id=DECODE(x_reason_id,FND_API.G_MISS_NUM,NULL,x_reason_id)
75: , object_version_number=DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
76: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
77: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
78: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
79: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
80: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
73: result_id=DECODE(x_result_id,FND_API.G_MISS_NUM,NULL,x_result_id)
74: , reason_id=DECODE(x_reason_id,FND_API.G_MISS_NUM,NULL,x_reason_id)
75: , object_version_number=DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
76: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
77: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
78: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
79: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
80: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
81: WHERE ROWID = x_rowid;
74: , reason_id=DECODE(x_reason_id,FND_API.G_MISS_NUM,NULL,x_reason_id)
75: , object_version_number=DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
76: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
77: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
78: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
79: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
80: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
81: WHERE ROWID = x_rowid;
82: IF (SQL%NOTFOUND) THEN
75: , object_version_number=DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
76: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
77: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
78: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
79: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
80: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
81: WHERE ROWID = x_rowid;
82: IF (SQL%NOTFOUND) THEN
83: RAISE NO_DATA_FOUND;
76: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
77: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
78: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
79: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
80: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
81: WHERE ROWID = x_rowid;
82: IF (SQL%NOTFOUND) THEN
83: RAISE NO_DATA_FOUND;
84: END IF;