APPS.HR_COMM_API dependencies on HR_COMMENTS

Line 17: -- Description: Base table hr_comments insert dml.

13: -- |------------------------------< insert_dml >------------------------------|
14: -- ----------------------------------------------------------------------------
15: --
16: -- PRIVATE
17: -- Description: Base table hr_comments insert dml.
18: --
19: Procedure insert_dml(p_rec in out nocopy g_rec_type) is
20: --
21: l_proc varchar2(72) := g_package||'insert_dml';

Line 26: -- Insert the row into: hr_comments

22: --
23: Begin
24: hr_utility.set_location('Entering:'||l_proc, 5);
25: --
26: -- Insert the row into: hr_comments
27: --
28: insert into hr_comments
29: ( comment_id,
30: source_table_name,

Line 28: insert into hr_comments

24: hr_utility.set_location('Entering:'||l_proc, 5);
25: --
26: -- Insert the row into: hr_comments
27: --
28: insert into hr_comments
29: ( comment_id,
30: source_table_name,
31: comment_text
32: )

Line 47: -- Description: Base table hr_comments update dml.

43: -- |------------------------------< update_dml >------------------------------|
44: -- ----------------------------------------------------------------------------
45: --
46: -- PRIVATE
47: -- Description: Base table hr_comments update dml.
48: --
49: Procedure update_dml(p_rec in out nocopy g_rec_type) is
50: --
51: l_proc varchar2(72) := g_package||'update_dml';

Line 57: -- Update the hr_comments Row

53: Begin
54: hr_utility.set_location('Entering:'||l_proc, 5);
55: --
56: --
57: -- Update the hr_comments Row
58: --
59: update hr_comments
60: set
61: comment_id = p_rec.comment_id,

Line 59: update hr_comments

55: --
56: --
57: -- Update the hr_comments Row
58: --
59: update hr_comments
60: set
61: comment_id = p_rec.comment_id,
62: source_table_name = p_rec.source_table_name,
63: comment_text = p_rec.comment_text

Line 83: -- Delete the hr_comments row.

79: --
80: Begin
81: hr_utility.set_location('Entering:'||l_proc, 5);
82: --
83: -- Delete the hr_comments row.
84: --
85: delete from hr_comments
86: where comment_id = p_rec.comment_id;
87: --

Line 85: delete from hr_comments

81: hr_utility.set_location('Entering:'||l_proc, 5);
82: --
83: -- Delete the hr_comments row.
84: --
85: delete from hr_comments
86: where comment_id = p_rec.comment_id;
87: --
88: hr_utility.set_location(' Leaving:'||l_proc, 10);
89: End delete_dml;

Line 102: Cursor C_Sel1 is select hr_comments_s.nextval from sys.dual;

98: Procedure pre_insert(p_rec in out nocopy g_rec_type) is
99: --
100: l_proc varchar2(72) := g_package||'pre_insert';
101: --
102: Cursor C_Sel1 is select hr_comments_s.nextval from sys.dual;
103: --
104: Begin
105: hr_utility.set_location('Entering:'||l_proc, 5);
106: --

Line 221: from hr_comments

217: Cursor C_Sel1 is
218: select comment_id,
219: source_table_name,
220: comment_text
221: from hr_comments
222: where comment_id = p_comment_id
223: for update nowait;
224: --
225: l_proc varchar2(72) := g_package||'lck';

Line 242: hr_utility.set_message_token('TABLE_NAME', 'hr_comments');

238: -- a) The row does NOT exist.
239: --
240: Close C_Sel1;
241: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
242: hr_utility.set_message_token('TABLE_NAME', 'hr_comments');
243: hr_utility.raise_error;
244: End If;
245: Close C_Sel1;
246: --

Line 258: hr_utility.set_message_token('TABLE_NAME', 'hr_comments');

254: -- The object is locked therefore we need to supply a meaningful
255: -- error message.
256: --
257: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
258: hr_utility.set_message_token('TABLE_NAME', 'hr_comments');
259: hr_utility.raise_error;
260: End lck;
261: --
262: -- ----------------------------------------------------------------------------