APPS.HR_ASSIGNMENT_SET_CRITERIA_PKG dependencies on HR_ASSIGNMENT_SET_CRITERIA

Line 1: package body HR_ASSIGNMENT_SET_CRITERIA_PKG as

1: package body HR_ASSIGNMENT_SET_CRITERIA_PKG as
2: /* $Header: pyasc01t.pkb 115.0 99/07/17 05:42:46 porting ship $ */
3: --
4: procedure insert_row(p_rowid in out varchar2,
5: p_line_no in number,

Line 15: insert into HR_ASSIGNMENT_SET_CRITERIA

11:
12: --
13: begin
14: --
15: insert into HR_ASSIGNMENT_SET_CRITERIA
16: ( LINE_NO,
17: ASSIGNMENT_SET_ID,
18: LEFT_OPERAND,
19: OPERATOR,

Line 33: from HR_ASSIGNMENT_SET_CRITERIA

29: --
30: --
31: select rowid
32: into p_rowid
33: from HR_ASSIGNMENT_SET_CRITERIA
34: where ASSIGNMENT_SET_ID = p_assignment_set_id
35: and LINE_NO = p_line_no;
36: --
37: end insert_row;

Line 49: update HR_ASSIGNMENT_SET_CRITERIA

45: p_logical in varchar2) is
46:
47: begin
48: --
49: update HR_ASSIGNMENT_SET_CRITERIA
50: set LINE_NO = p_line_no,
51: ASSIGNMENT_SET_ID = p_assignment_set_id,
52: LEFT_OPERAND = p_left_operand,
53: OPERATOR = p_operator,

Line 64: delete from HR_ASSIGNMENT_SET_CRITERIA

60: procedure delete_row(p_rowid in varchar2) is
61: --
62: begin
63: --
64: delete from HR_ASSIGNMENT_SET_CRITERIA
65: where ROWID = p_rowid;
66: --
67: end delete_row;
68: --

Line 79: from HR_ASSIGNMENT_SET_CRITERIA

75: p_logical in varchar2) is
76:
77: --
78: cursor C is select *
79: from HR_ASSIGNMENT_SET_CRITERIA
80: where rowid = p_rowid
81: for update of ASSIGNMENT_SET_ID nowait;
82: --
83: rowinfo C%rowtype;

Line 114: end HR_ASSIGNMENT_SET_CRITERIA_PKG;

110: app_exception.raise_exception;
111: end if;
112: end lock_row;
113: --
114: end HR_ASSIGNMENT_SET_CRITERIA_PKG;