APPS.JTF_IH_OUTCOME_RSLTS_SEED_PUB dependencies on JTF_IH_OUTCOME_RESULTS

Line 17: FROM jtf_ih_outcome_results

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

Line 20: INSERT INTO jtf_ih_outcome_results (

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

Line 52: DELETE FROM jtf_ih_outcome_results

48: PROCEDURE delete_row(
49: x_result_id NUMBER
50: ) IS
51: BEGIN
52: DELETE FROM jtf_ih_outcome_results
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_outcome_results

67: , x_last_update_date DATE
68: , x_last_update_login NUMBER
69: ) IS
70: BEGIN
71: UPDATE jtf_ih_outcome_results
72: SET
73: result_id=DECODE(x_result_id,FND_API.G_MISS_NUM,NULL,x_result_id)
74: , outcome_id=DECODE(x_outcome_id,FND_API.G_MISS_NUM,NULL,x_outcome_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_outcome_results

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