APPS.HR_ASSIGNMENT_SETS_PKG dependencies on HR_ASSIGNMENT_SETS

Line 1: package body HR_ASSIGNMENT_SETS_PKG as

1: package body HR_ASSIGNMENT_SETS_PKG as
2: /* $Header: pyass01t.pkb 115.0 99/07/17 05:43:21 porting ship $ */
3: --
4: procedure insert_row(p_rowid in out varchar2,
5: p_assignment_set_id in number,

Line 14: insert into HR_ASSIGNMENT_SETS

10:
11: --
12: begin
13: --
14: insert into HR_ASSIGNMENT_SETS
15: ( ASSIGNMENT_SET_ID,
16: BUSINESS_GROUP_ID,
17: PAYROLL_ID,
18: ASSIGNMENT_SET_NAME,

Line 30: from HR_ASSIGNMENT_SETS

26:
27: --
28: select rowid
29: into p_rowid
30: from HR_ASSIGNMENT_SETS
31: where ASSIGNMENT_SET_ID = p_assignment_set_id;
32: --
33: end insert_row;
34: --

Line 44: update HR_ASSIGNMENT_SETS

40: p_formula_id in number) is
41:
42: begin
43: --
44: update HR_ASSIGNMENT_SETS
45: set ASSIGNMENT_SET_ID = p_assignment_set_id,
46: BUSINESS_GROUP_ID = p_business_group_id,
47: PAYROLL_ID = p_payroll_id,
48: ASSIGNMENT_SET_NAME = p_assignment_set_name,

Line 58: delete from HR_ASSIGNMENT_SETS

54: procedure delete_row(p_rowid in varchar2) is
55: --
56: begin
57: --
58: delete from HR_ASSIGNMENT_SETS
59: where ROWID = p_rowid;
60: --
61: end delete_row;
62: --

Line 72: from HR_ASSIGNMENT_SETS

68: p_formula_id in number) is
69:
70: --
71: cursor C is select *
72: from HR_ASSIGNMENT_SETS
73: where rowid = p_rowid
74: for update of ASSIGNMENT_SET_ID nowait;
75: --
76: rowinfo C%rowtype;

Line 104: end HR_ASSIGNMENT_SETS_PKG;

100: app_exception.raise_exception;
101: end if;
102: end lock_row;
103: --
104: end HR_ASSIGNMENT_SETS_PKG;