APPS.PAY_ASG_PROCESS_GRP_PKG dependencies on PAY_GROUP_DEFINITIONS

Line 68: from pay_group_definitions

64: hr_utility.trace('In get_group_definition()');
65: end if;
66: select group_definition_id
67: into l_definition_id
68: from pay_group_definitions
69: where name = p_definition_name;
70: --
71: return l_definition_id;
72: --

Line 80: lock table pay_group_definitions in share mode;

76: --
77: -- Need to lock the table to esnure only
78: -- one thread creates the group row.
79: --
80: lock table pay_group_definitions in share mode;
81: --
82: -- Ensure that nothing has created
83: -- the row in the meantime
84: select group_definition_id

Line 86: from pay_group_definitions

82: -- Ensure that nothing has created
83: -- the row in the meantime
84: select group_definition_id
85: into l_definition_id
86: from pay_group_definitions
87: where name = p_definition_name;
88: --
89: return l_definition_id;
90: --

Line 94: select pay_group_definitions_s.nextval

90: --
91: exception
92: when no_data_found then
93: --
94: select pay_group_definitions_s.nextval
95: into l_definition_id
96: from dual;
97: --
98: insert into pay_group_definitions

Line 98: insert into pay_group_definitions

94: select pay_group_definitions_s.nextval
95: into l_definition_id
96: from dual;
97: --
98: insert into pay_group_definitions
99: (group_definition_id,
100: name)
101: values
102: (l_definition_id,

Line 246: l_definition_id pay_group_definitions.group_definition_id%type;

242: p_update_row in varchar2 default 'Y'
243: )
244: return number
245: is
246: l_definition_id pay_group_definitions.group_definition_id%type;
247: l_object_group_id pay_object_groups.object_group_id%type;
248: l_start_date pay_object_groups.start_date%type;
249: l_end_date pay_object_groups.end_date%type;
250: l_update boolean;

Line 453: l_group_name pay_group_definitions.name%type;

449: p_effective_end_date in date,
450: p_payroll_id in number
451: )
452: is
453: l_group_name pay_group_definitions.name%type;
454: l_person_group_id pay_object_groups.object_group_id%type;
455: l_asg_group_id pay_object_groups.object_group_id%type;
456: begin
457: --

Line 751: from pay_group_definitions pgd,

747: hr_utility.trace('In find_asg_group_definition()');
748: end if;
749: select pgd.name
750: into p_definition_name
751: from pay_group_definitions pgd,
752: pay_object_groups pog_ppf,
753: pay_object_groups pog_paf
754: where pog_paf.source_id = p_assignment_id
755: and pog_paf.source_type = 'PAF'

Line 787: l_old_group_name pay_group_definitions.name%type;

783: p_old_payroll_id in number,
784: p_new_payroll_id in number
785: )
786: is
787: l_old_group_name pay_group_definitions.name%type;
788: l_new_group_name pay_group_definitions.name%type;
789: l_object_group_id pay_object_groups.object_group_id%type;
790:
791: procedure purge_curr_obj_group is

Line 788: l_new_group_name pay_group_definitions.name%type;

784: p_new_payroll_id in number
785: )
786: is
787: l_old_group_name pay_group_definitions.name%type;
788: l_new_group_name pay_group_definitions.name%type;
789: l_object_group_id pay_object_groups.object_group_id%type;
790:
791: procedure purge_curr_obj_group is
792: begin

Line 899: l_old_group_name pay_group_definitions.name%type;

895: p_old_payroll_id in number,
896: p_new_payroll_id in number
897: )
898: is
899: l_old_group_name pay_group_definitions.name%type;
900: l_new_group_name pay_group_definitions.name%type;
901: begin
902: --
903: if g_debug then

Line 900: l_new_group_name pay_group_definitions.name%type;

896: p_new_payroll_id in number
897: )
898: is
899: l_old_group_name pay_group_definitions.name%type;
900: l_new_group_name pay_group_definitions.name%type;
901: begin
902: --
903: if g_debug then
904: hr_utility.trace('In asg_datetracked_update()');