eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_ASG_PROCESS_GRP_PKG dependencies on PAY_OBJECT_GROUPS

Line 129: l_object_group_id pay_object_groups.object_group_id%type;

125: p_update_row in varchar2 default 'Y'
126: )
127: return number
128: is
129: l_object_group_id pay_object_groups.object_group_id%type;
130: l_start_date pay_object_groups.start_date%type;
131: l_end_date pay_object_groups.end_date%type;
132: l_cnt number;
133: begin

Line 130: l_start_date pay_object_groups.start_date%type;

126: )
127: return number
128: is
129: l_object_group_id pay_object_groups.object_group_id%type;
130: l_start_date pay_object_groups.start_date%type;
131: l_end_date pay_object_groups.end_date%type;
132: l_cnt number;
133: begin
134: --

Line 131: l_end_date pay_object_groups.end_date%type;

127: return number
128: is
129: l_object_group_id pay_object_groups.object_group_id%type;
130: l_start_date pay_object_groups.start_date%type;
131: l_end_date pay_object_groups.end_date%type;
132: l_cnt number;
133: begin
134: --
135: if g_debug then

Line 153: from pay_object_groups

149: end_date
150: into l_object_group_id,
151: l_start_date,
152: l_end_date
153: from pay_object_groups
154: where source_id = p_assignment_id
155: and source_type = 'PAF'
156: and start_date = p_effective_start_date
157: and end_date = p_effective_end_date

Line 174: from pay_object_groups

170: -- from one processing group to another
171: --
172: select count(*)
173: into l_cnt
174: from pay_object_groups
175: where source_id = p_assignment_id
176: and source_type = 'PAF'
177: and parent_object_group_id <> p_person_group_id;
178: --

Line 186: select pay_object_groups_s.nextval

182: end if;
183: --
184: if (p_update_row = 'Y') then
185: --
186: select pay_object_groups_s.nextval
187: into l_object_group_id
188: from dual;
189: --
190: if g_debug then

Line 196: insert into pay_object_groups

192: hr_utility.trace('Object_group_id ' || l_object_group_id );
193: hr_utility.trace('p_effective_start_date ' || p_effective_start_date );
194: hr_utility.trace('p_effective_start_date ' || p_effective_end_date );
195: end if;
196: insert into pay_object_groups
197: (object_group_id,
198: source_id,
199: source_type,
200: start_date,

Line 247: l_object_group_id pay_object_groups.object_group_id%type;

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;
251: l_upd_start_date date;

Line 248: l_start_date pay_object_groups.start_date%type;

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;
251: l_upd_start_date date;
252: l_upd_end_date date;

Line 249: l_end_date pay_object_groups.end_date%type;

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;
251: l_upd_start_date date;
252: l_upd_end_date date;
253: begin

Line 266: from pay_object_groups

262: end_date
263: into l_object_group_id,
264: l_start_date,
265: l_end_date
266: from pay_object_groups
267: where source_id = p_person_id
268: and source_type = 'PPF'
269: -- bug 9354495
270: -- and start_date <= p_effective_end_date

Line 304: update pay_object_groups

300: hr_utility.trace('object group id = '|| l_object_group_id);
301: hr_utility.trace('start date = '|| l_upd_start_date);
302: hr_utility.trace('end date = '|| l_upd_end_date);
303: end if;
304: update pay_object_groups
305: set start_date = l_upd_start_date,
306: end_date = l_upd_end_date
307: where object_group_id = l_object_group_id;
308: end if;

Line 318: select pay_object_groups_s.nextval

314: when no_data_found then
315: --
316: if (p_update_row = 'Y') then
317: --
318: select pay_object_groups_s.nextval
319: into l_object_group_id
320: from dual;
321: --
322: insert into pay_object_groups

Line 322: insert into pay_object_groups

318: select pay_object_groups_s.nextval
319: into l_object_group_id
320: from dual;
321: --
322: insert into pay_object_groups
323: (object_group_id,
324: source_id,
325: source_type,
326: start_date,

Line 454: l_person_group_id pay_object_groups.object_group_id%type;

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: --
458: if g_debug then

Line 455: l_asg_group_id pay_object_groups.object_group_id%type;

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: --
458: if g_debug then
459: hr_utility.trace('In generate_asg_group()');

Line 538: l_parent_object_group_id pay_object_groups.parent_object_group_id%type;

534: */
535:
536: procedure zap_object_group(p_object_group_id in number)
537: is
538: l_parent_object_group_id pay_object_groups.parent_object_group_id%type;
539: l_cnt number;
540: begin
541: --
542: if g_debug then

Line 547: from pay_object_groups

543: hr_utility.trace('In zap_object_group()');
544: end if;
545: select parent_object_group_id
546: into l_parent_object_group_id
547: from pay_object_groups
548: where object_group_id = p_object_group_id;
549: --
550: if (l_parent_object_group_id is not null) then
551: --

Line 558: from pay_object_groups

554: -- Since its the current object group.
555: --
556: select count(*)
557: into l_cnt
558: from pay_object_groups
559: where parent_object_group_id = l_parent_object_group_id;
560: --
561: if (l_cnt = 1) then
562: delete from pay_object_groups

Line 562: delete from pay_object_groups

558: from pay_object_groups
559: where parent_object_group_id = l_parent_object_group_id;
560: --
561: if (l_cnt = 1) then
562: delete from pay_object_groups
563: where object_group_id = l_parent_object_group_id;
564: end if;
565: end if;
566: --

Line 567: delete from pay_object_groups

563: where object_group_id = l_parent_object_group_id;
564: end if;
565: end if;
566: --
567: delete from pay_object_groups
568: where object_group_id = p_object_group_id;
569: --
570: if g_debug then
571: hr_utility.trace('Out zap_object_group()');

Line 593: update pay_object_groups

589: hr_utility.trace('In end_date_object_group()');
590: hr_utility.trace('Object group id = '|| p_object_group_id);
591: hr_utility.trace('Effective date = '|| p_effective_end_date);
592: end if;
593: update pay_object_groups
594: set end_date = p_effective_end_date
595: where object_group_id = p_object_group_id;
596: --
597: if g_debug then

Line 623: from pay_object_groups pog_paf

619: select object_group_id,
620: parent_object_group_id,
621: start_date,
622: end_date
623: from pay_object_groups pog_paf
624: where pog_paf.source_id = p_assignment_id
625: and pog_paf.source_type = 'PAF'
626: and pog_paf.end_date = p_effective_end_date_o;
627: --

Line 634: from pay_object_groups pog_paf

630: is
631: select object_group_id,
632: start_date,
633: end_date
634: from pay_object_groups pog_paf
635: where object_group_id = p_par_object_group_id
636: and pog_paf.end_date = p_effective_end_date_o;
637: begin
638: --

Line 649: update pay_object_groups

645: hr_utility.trace('Object group id = '|| pogrec.object_group_id);
646: hr_utility.trace('Effective date = '|| p_effective_end_date);
647: hr_utility.trace('p_effective_end_date_o = ' || p_effective_end_date_o);
648: end if;
649: update pay_object_groups
650: set end_date = p_val_end_date --Bug 14585781 ,Case delete_next/future
651: where object_group_id = pogrec.object_group_id;
652: --
653:

Line 655: delete from pay_object_groups where source_id = p_assignment_id and source_type = 'PAF'

651: where object_group_id = pogrec.object_group_id;
652: --
653:
654: -- Bug 14585781, perform the delete of the next record
655: delete from pay_object_groups where source_id = p_assignment_id and source_type = 'PAF'
656: and start_date > = p_effective_end_date_o
657: and end_date <= p_val_end_date;
658:
659: for ppfrec in get_pogppf(pogrec.parent_object_group_id,

Line 667: update pay_object_groups

663: if g_debug then
664: hr_utility.trace('Object group id = '|| ppfrec.object_group_id);
665: hr_utility.trace('Effective date = '|| p_effective_end_date);
666: end if;
667: update pay_object_groups
668: set end_date = p_effective_end_date
669: where object_group_id = ppfrec.object_group_id;
670: --
671: end loop;

Line 700: from pay_object_groups pog_paf

696: is
697: select object_group_id,
698: start_date,
699: end_date
700: from pay_object_groups pog_paf
701: where pog_paf.source_id = p_assignment_id
702: and pog_paf.source_type = 'PAF'
703: and pog_paf.end_date > p_effective_end_date
704: order by start_date;

Line 752: pay_object_groups pog_ppf,

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'
756: and pog_paf.payroll_id = p_payroll_id

Line 753: pay_object_groups pog_paf

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'
756: and pog_paf.payroll_id = p_payroll_id
757: and p_effective_date between pog_paf.start_date

Line 789: l_object_group_id pay_object_groups.object_group_id%type;

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
793: select object_group_id into l_object_group_id

Line 794: from pay_object_groups pog_paf

790:
791: procedure purge_curr_obj_group is
792: begin
793: select object_group_id into l_object_group_id
794: from pay_object_groups pog_paf
795: where pog_paf.source_id = p_assignment_id
796: and pog_paf.source_type = 'PAF'
797: and pog_paf.payroll_id = p_old_payroll_id
798: and pog_paf.start_date = p_old_effective_start_date

Line 924: update pay_object_groups

920: );
921: elsif ( p_old_payroll_id is not null
922: and p_new_payroll_id is null) then
923: --
924: update pay_object_groups
925: set end_date = p_new_effective_start_date -1
926: where source_id = p_assignment_id
927: and source_type = 'PAF'
928: and payroll_id = p_old_payroll_id

Line 968: update pay_object_groups

964: end if;
965: --
966: else
967:
968: update pay_object_groups
969: set end_date = p_new_effective_start_date -1
970:
971: where source_id = p_assignment_id
972: and source_type = 'PAF'

Line 1023: update pay_object_groups

1019: hr_utility.trace('Start date = '|| p_new_effective_start_date);
1020: hr_utility.trace('Source id = '|| p_assignment_id);
1021: hr_utility.trace('Old start date = '|| p_old_effective_start_date);
1022: end if;
1023: update pay_object_groups
1024: set start_date = p_new_effective_start_date
1025: where source_id = p_assignment_id
1026: and source_type = 'PAF'
1027: and start_date = p_old_effective_start_date;

Line 1040: update pay_object_groups

1036: ,per_periods_of_service pos
1037: where asg.assignment_id = p_assignment_id
1038: and asg.period_of_service_id = pos.period_of_service_id;
1039:
1040: update pay_object_groups
1041: set start_date = p_new_effective_start_date
1042: where source_type = 'PPF'
1043: and period_of_service_id = l_period_of_service_id;
1044: exception

Line 1086: update pay_object_groups

1082: hr_utility.trace('Start date = '|| p_new_effective_start_date);
1083: hr_utility.trace('Source id = '|| p_assignment_id);
1084: hr_utility.trace('Old start date = '|| p_old_effective_start_date);
1085: end if;
1086: update pay_object_groups
1087: set start_date = p_new_effective_start_date
1088: where source_id = p_assignment_id
1089: and source_type = 'PAF'
1090: and start_date = p_old_effective_start_date;

Line 1102: update pay_object_groups

1098: ,per_periods_of_service pos
1099: where asg.assignment_id = p_assignment_id
1100: and asg.period_of_service_id = pos.period_of_service_id;
1101:
1102: update pay_object_groups
1103: set start_date = p_new_effective_start_date
1104: where source_type = 'PPF'
1105: and period_of_service_id = l_period_of_service_id
1106: and start_date = p_old_effective_start_date;

Line 1146: from pay_object_groups pog_paf

1142: is
1143: select object_group_id,
1144: start_date,
1145: end_date
1146: from pay_object_groups pog_paf
1147: where pog_paf.source_id = p_assignment_id
1148: and pog_paf.source_type = 'PAF';
1149: --Bug 14585781,changed the cur,Case C
1150: begin

Line 1202: from pay_object_groups pog_paf

1198: is
1199: select object_group_id,
1200: start_date,
1201: end_date
1202: from pay_object_groups pog_paf
1203: where pog_paf.source_id = p_assignment_id
1204: and pog_paf.source_type = 'PAF';
1205: begin
1206: --