APPS.JTF_IH_RESULT_REASONS_SEED_PUB dependencies on JTF_IH_RESULT_REASONS

Line 1: PACKAGE BODY jtf_ih_result_reasons_seed_pub AS

1: PACKAGE BODY jtf_ih_result_reasons_seed_pub AS
2: /* $Header: JTFIHRRB.pls 115.2 2001/11/09 19:00:26 pkm ship $ */
3:
4: PROCEDURE insert_row(
5: x_rowid IN OUT VARCHAR2

Line 17: FROM jtf_ih_result_reasons

13: , x_last_update_login NUMBER
14: ) IS
15: CURSOR l_insert IS
16: SELECT ROWID
17: FROM jtf_ih_result_reasons
18: WHERE result_id = x_result_id;
19: BEGIN
20: INSERT INTO jtf_ih_result_reasons (
21: result_id

Line 20: INSERT INTO jtf_ih_result_reasons (

16: SELECT ROWID
17: FROM jtf_ih_result_reasons
18: WHERE result_id = x_result_id;
19: BEGIN
20: INSERT INTO jtf_ih_result_reasons (
21: result_id
22: , reason_id
23: , object_version_number
24: , created_by

Line 52: DELETE FROM jtf_ih_result_reasons

48: PROCEDURE delete_row(
49: x_result_id NUMBER
50: ) IS
51: BEGIN
52: DELETE FROM jtf_ih_result_reasons
53: WHERE result_id = x_result_id;
54: IF (SQL%NOTFOUND) THEN
55: RAISE NO_DATA_FOUND;
56: END IF;

Line 71: UPDATE jtf_ih_result_reasons

67: , x_last_update_date DATE
68: , x_last_update_login NUMBER
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)

Line 100: FROM jtf_ih_result_reasons

96: , x_last_update_login NUMBER
97: ) IS
98: CURSOR l_lock IS
99: SELECT *
100: FROM jtf_ih_result_reasons
101: WHERE rowid = x_rowid
102: FOR UPDATE OF result_id NOWAIT;
103: l_table_rec l_lock%ROWTYPE;
104: BEGIN

Line 145: END jtf_ih_result_reasons_seed_pub;

141: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
142: APP_EXCEPTION.RAISE_EXCEPTION;
143: END IF;
144: END lock_row;
145: END jtf_ih_result_reasons_seed_pub;