APPS.PAY_RETRO_NOTIF_PKG dependencies on HR_ASSIGNMENT_SETS

Line 12: g_asg_set_id hr_assignment_sets.assignment_set_id%type;

8: g_event_group pay_event_groups.event_group_id%type;
9: g_business_group_id per_business_groups.business_group_id%type;
10: g_payroll_act_id pay_payroll_actions.payroll_action_id%type;
11: g_payroll_id pay_payrolls_f.payroll_id%type;
12: g_asg_set_id hr_assignment_sets.assignment_set_id%type;
13: g_global_env pay_interpreter_pkg.t_global_env_rec;
14: g_adv_flag varchar2(5);
15: g_report_date date;
16:

Line 79: from hr_assignment_sets

75: begin
76: --
77: select assignment_set_id
78: into l_asg_set_id
79: from hr_assignment_sets
80: where assignment_set_name = p_asg_set_name
81: and payroll_id = p_payroll;
82: --
83: p_asg_set_id := l_asg_set_id;

Line 94: FROM hr_assignment_sets

90: procedure validate_asg_set (p_asg_set in varchar2) IS
91: --
92: cursor c_set_check is
93: SELECT 'X'
94: FROM hr_assignment_sets
95: WHERE UPPER(assignment_set_name) = UPPER(p_asg_set);
96: --
97: l_dummy VARCHAR2(1);
98: --

Line 226: SELECT hr_assignment_sets_s.nextval

222: p_business_group_id in number,
223: p_payroll_id in number) is
224: --
225: cursor c_sequence is
226: SELECT hr_assignment_sets_s.nextval
227: FROM dual;
228: --
229: l_rowid VARCHAR2(30);
230: l_asg_set_id NUMBER;

Line 240: hr_assignment_sets_pkg.insert_row(

236: open c_sequence;
237: fetch c_sequence into l_asg_set_id;
238: close c_sequence;
239: --
240: hr_assignment_sets_pkg.insert_row(
241: p_rowid => l_rowid
242: , p_assignment_set_id => l_asg_set_id
243: , p_business_group_id => p_business_group_id
244: , p_payroll_id => p_payroll_id

Line 1186: l_asg_set_name hr_assignment_sets.assignment_set_name%type;

1182: is
1183: l_bus_grp number;
1184: l_evt_grp number;
1185: l_payroll number;
1186: l_asg_set_name hr_assignment_sets.assignment_set_name%type;
1187: l_adv_flag varchar2(1);
1188: l_report_date date;
1189:
1190: begin

Line 1592: DELETE FROM hr_assignment_sets

1588: --
1589: open c_check_retro_set;
1590: fetch c_check_retro_set into l_dummy;
1591: if c_check_retro_set%NOTFOUND then
1592: DELETE FROM hr_assignment_sets
1593: WHERE assignment_set_id = p_asg_set_id;
1594: end if;
1595: close c_check_retro_set;
1596: --

Line 1605: l_asg_set_name hr_assignment_sets.assignment_set_name%type;

1601:
1602: l_bus_grp number;
1603: l_evt_grp number;
1604: l_payroll number;
1605: l_asg_set_name hr_assignment_sets.assignment_set_name%type;
1606: l_asg_set_id number;
1607: l_adv_flag varchar2(1);
1608: l_report_date date;
1609: remove_act varchar2(10);