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 117: l_object_group_id pay_object_groups.object_group_id%type;

113: p_update_row in varchar2 default 'Y'
114: )
115: return number
116: is
117: l_object_group_id pay_object_groups.object_group_id%type;
118: l_start_date pay_object_groups.start_date%type;
119: l_end_date pay_object_groups.end_date%type;
120: l_cnt number;
121: begin

Line 118: l_start_date pay_object_groups.start_date%type;

114: )
115: return number
116: is
117: l_object_group_id pay_object_groups.object_group_id%type;
118: l_start_date pay_object_groups.start_date%type;
119: l_end_date pay_object_groups.end_date%type;
120: l_cnt number;
121: begin
122: --

Line 119: l_end_date pay_object_groups.end_date%type;

115: return number
116: is
117: l_object_group_id pay_object_groups.object_group_id%type;
118: l_start_date pay_object_groups.start_date%type;
119: l_end_date pay_object_groups.end_date%type;
120: l_cnt number;
121: begin
122: --
123: select object_group_id,

Line 129: from pay_object_groups

125: end_date
126: into l_object_group_id,
127: l_start_date,
128: l_end_date
129: from pay_object_groups
130: where source_id = p_assignment_id
131: and source_type = 'PAF'
132: and start_date <= p_effective_end_date
133: and end_date >= p_effective_start_date

Line 147: from pay_object_groups

143: -- from one processing group to another
144: --
145: select count(*)
146: into l_cnt
147: from pay_object_groups
148: where source_id = p_assignment_id
149: and source_type = 'PAF'
150: and parent_object_group_id <> p_person_group_id;
151: --

Line 159: select pay_object_groups_s.nextval

155: end if;
156: --
157: if (p_update_row = 'Y') then
158: --
159: select pay_object_groups_s.nextval
160: into l_object_group_id
161: from dual;
162: --
163: insert into pay_object_groups

Line 163: insert into pay_object_groups

159: select pay_object_groups_s.nextval
160: into l_object_group_id
161: from dual;
162: --
163: insert into pay_object_groups
164: (object_group_id,
165: source_id,
166: source_type,
167: start_date,

Line 211: l_object_group_id pay_object_groups.object_group_id%type;

207: )
208: return number
209: is
210: l_definition_id pay_group_definitions.group_definition_id%type;
211: l_object_group_id pay_object_groups.object_group_id%type;
212: l_start_date pay_object_groups.start_date%type;
213: l_end_date pay_object_groups.end_date%type;
214: l_update boolean;
215: l_upd_start_date date;

Line 212: l_start_date pay_object_groups.start_date%type;

208: return number
209: is
210: l_definition_id pay_group_definitions.group_definition_id%type;
211: l_object_group_id pay_object_groups.object_group_id%type;
212: l_start_date pay_object_groups.start_date%type;
213: l_end_date pay_object_groups.end_date%type;
214: l_update boolean;
215: l_upd_start_date date;
216: l_upd_end_date date;

Line 213: l_end_date pay_object_groups.end_date%type;

209: is
210: l_definition_id pay_group_definitions.group_definition_id%type;
211: l_object_group_id pay_object_groups.object_group_id%type;
212: l_start_date pay_object_groups.start_date%type;
213: l_end_date pay_object_groups.end_date%type;
214: l_update boolean;
215: l_upd_start_date date;
216: l_upd_end_date date;
217: begin

Line 227: from pay_object_groups

223: end_date
224: into l_object_group_id,
225: l_start_date,
226: l_end_date
227: from pay_object_groups
228: where source_id = p_person_id
229: and source_type = 'PPF'
230: and start_date <= p_effective_end_date
231: and end_date >= p_effective_start_date

Line 252: update pay_object_groups

248: l_update := TRUE;
249: l_upd_end_date := l_end_date;
250: end if;
251: if (l_update = TRUE) then
252: update pay_object_groups
253: set start_date = l_upd_start_date,
254: end_date = l_upd_end_date
255: where object_group_id = l_object_group_id;
256: end if;

Line 266: select pay_object_groups_s.nextval

262: when no_data_found then
263: --
264: if (p_update_row = 'Y') then
265: --
266: select pay_object_groups_s.nextval
267: into l_object_group_id
268: from dual;
269: --
270: insert into pay_object_groups

Line 270: insert into pay_object_groups

266: select pay_object_groups_s.nextval
267: into l_object_group_id
268: from dual;
269: --
270: insert into pay_object_groups
271: (object_group_id,
272: source_id,
273: source_type,
274: start_date,

Line 389: l_person_group_id pay_object_groups.object_group_id%type;

385: p_payroll_id in number
386: )
387: is
388: l_group_name pay_group_definitions.name%type;
389: l_person_group_id pay_object_groups.object_group_id%type;
390: l_asg_group_id pay_object_groups.object_group_id%type;
391: begin
392: --
393: if (p_payroll_id is not null) then

Line 390: l_asg_group_id pay_object_groups.object_group_id%type;

386: )
387: is
388: l_group_name pay_group_definitions.name%type;
389: l_person_group_id pay_object_groups.object_group_id%type;
390: l_asg_group_id pay_object_groups.object_group_id%type;
391: begin
392: --
393: if (p_payroll_id is not null) then
394: --

Line 460: l_parent_object_group_id pay_object_groups.parent_object_group_id%type;

456: */
457:
458: procedure zap_object_group(p_object_group_id in number)
459: is
460: l_parent_object_group_id pay_object_groups.parent_object_group_id%type;
461: l_cnt number;
462: begin
463: --
464: select parent_object_group_id

Line 466: from pay_object_groups

462: begin
463: --
464: select parent_object_group_id
465: into l_parent_object_group_id
466: from pay_object_groups
467: where object_group_id = p_object_group_id;
468: --
469: if (l_parent_object_group_id is not null) then
470: --

Line 477: from pay_object_groups

473: -- Since its the current object group.
474: --
475: select count(*)
476: into l_cnt
477: from pay_object_groups
478: where parent_object_group_id = l_parent_object_group_id;
479: --
480: if (l_cnt = 1) then
481: delete from pay_object_groups

Line 481: delete from pay_object_groups

477: from pay_object_groups
478: where parent_object_group_id = l_parent_object_group_id;
479: --
480: if (l_cnt = 1) then
481: delete from pay_object_groups
482: where object_group_id = l_parent_object_group_id;
483: end if;
484: end if;
485: --

Line 486: delete from pay_object_groups

482: where object_group_id = l_parent_object_group_id;
483: end if;
484: end if;
485: --
486: delete from pay_object_groups
487: where object_group_id = p_object_group_id;
488: --
489: end zap_object_group;
490: --

Line 504: update pay_object_groups

500: p_effective_end_date in date)
501: is
502: begin
503: --
504: update pay_object_groups
505: set end_date = p_effective_end_date
506: where object_group_id = p_object_group_id;
507: --
508: end end_date_object_group;

Line 530: from pay_object_groups pog_paf

526: select object_group_id,
527: parent_object_group_id,
528: start_date,
529: end_date
530: from pay_object_groups pog_paf
531: where pog_paf.source_id = p_assignment_id
532: and pog_paf.source_type = 'PAF'
533: and pog_paf.end_date = p_effective_end_date_o;
534: --

Line 541: from pay_object_groups pog_paf

537: is
538: select object_group_id,
539: start_date,
540: end_date
541: from pay_object_groups pog_paf
542: where object_group_id = p_par_object_group_id
543: and pog_paf.end_date = p_effective_end_date_o;
544: begin
545: --

Line 548: update pay_object_groups

544: begin
545: --
546: for pogrec in get_pogpaf(p_assignment_id, p_effective_end_date_o) loop
547: --
548: update pay_object_groups
549: set end_date = p_effective_end_date
550: where object_group_id = pogrec.object_group_id;
551: --
552: for ppfrec in get_pogppf(pogrec.parent_object_group_id,

Line 556: update pay_object_groups

552: for ppfrec in get_pogppf(pogrec.parent_object_group_id,
553: p_effective_end_date_o)
554: loop
555: --
556: update pay_object_groups
557: set end_date = p_effective_end_date
558: where object_group_id = ppfrec.object_group_id;
559: --
560: end loop;

Line 586: from pay_object_groups pog_paf

582: is
583: select object_group_id,
584: start_date,
585: end_date
586: from pay_object_groups pog_paf
587: where pog_paf.source_id = p_assignment_id
588: and pog_paf.source_type = 'PAF'
589: and pog_paf.end_date > p_effective_end_date
590: order by start_date;

Line 625: pay_object_groups pog_ppf,

621: --
622: select pgd.name
623: into p_definition_name
624: from pay_group_definitions pgd,
625: pay_object_groups pog_ppf,
626: pay_object_groups pog_paf
627: where pog_paf.source_id = p_assignment_id
628: and pog_paf.source_type = 'PAF'
629: and pog_paf.payroll_id = p_payroll_id

Line 626: pay_object_groups pog_paf

622: select pgd.name
623: into p_definition_name
624: from pay_group_definitions pgd,
625: pay_object_groups pog_ppf,
626: pay_object_groups pog_paf
627: where pog_paf.source_id = p_assignment_id
628: and pog_paf.source_type = 'PAF'
629: and pog_paf.payroll_id = p_payroll_id
630: and p_effective_date between pog_paf.start_date

Line 738: update pay_object_groups

734: )
735: is
736: begin
737: --
738: update pay_object_groups
739: set start_date = p_new_effective_start_date
740: where source_id = p_assignment_id
741: and source_type = 'PAF'
742: and start_date = p_old_effective_start_date;

Line 772: from pay_object_groups pog_paf

768: is
769: select object_group_id,
770: start_date,
771: end_date
772: from pay_object_groups pog_paf
773: where pog_paf.source_id = p_assignment_id
774: and pog_paf.source_type = 'PAF'
775: and pog_paf.end_date > p_effective_end_date;
776: begin

Line 818: from pay_object_groups pog_paf

814: is
815: select object_group_id,
816: start_date,
817: end_date
818: from pay_object_groups pog_paf
819: where pog_paf.source_id = p_assignment_id
820: and pog_paf.source_type = 'PAF';
821: begin
822: --