APPS.HR_ASSIGNMENT_SET_AMDS_PKG dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 11: insert into HR_ASSIGNMENT_SET_AMENDMENTS

7: p_include_or_exclude in varchar2) is
8: --
9: begin
10: --
11: insert into HR_ASSIGNMENT_SET_AMENDMENTS
12: ( ASSIGNMENT_ID,
13: ASSIGNMENT_SET_ID,
14: INCLUDE_OR_EXCLUDE)
15: values

Line 23: from HR_ASSIGNMENT_SET_AMENDMENTS

19: --
20: --
21: select rowid
22: into p_rowid
23: from HR_ASSIGNMENT_SET_AMENDMENTS
24: where ASSIGNMENT_SET_ID = p_assignment_set_id
25: and ASSIGNMENT_ID = p_assignment_id;
26: --
27: end insert_row;

Line 36: update HR_ASSIGNMENT_SET_AMENDMENTS

32: p_include_or_exclude in varchar2) is
33:
34: begin
35: --
36: update HR_ASSIGNMENT_SET_AMENDMENTS
37: set ASSIGNMENT_ID = p_assignment_id,
38: ASSIGNMENT_SET_ID = p_assignment_set_id,
39: INCLUDE_OR_EXCLUDE = p_include_or_exclude
40: where ROWID = p_rowid;

Line 48: delete from HR_ASSIGNMENT_SET_AMENDMENTS

44: procedure delete_row(p_rowid in varchar2) is
45: --
46: begin
47: --
48: delete from HR_ASSIGNMENT_SET_AMENDMENTS
49: where ROWID = p_rowid;
50: --
51: end delete_row;
52: --

Line 59: from HR_ASSIGNMENT_SET_AMENDMENTS

55: p_assignment_set_id in number,
56: p_include_or_exclude in varchar2) is
57: --
58: cursor C is select *
59: from HR_ASSIGNMENT_SET_AMENDMENTS
60: where rowid = p_rowid
61: for update of ASSIGNMENT_SET_ID nowait;
62: --
63: rowinfo C%rowtype;