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_QPQ_API dependencies on PER_TIME_PERIODS

Line 647: -- p_time_period_id is set to per_time_periods.time_period_id and

643: -- p_message is set to message_name to be raised if a period does
644: -- not exist.
645: --
646: -- Post Success:
647: -- p_time_period_id is set to per_time_periods.time_period_id and
648: -- p_period_name is set to per_time_periods.period_name for the period
649: -- which exists as of p_date for the payroll p_payroll_id.
650: --
651: -- Post Failure:

Line 648: -- p_period_name is set to per_time_periods.period_name for the period

644: -- not exist.
645: --
646: -- Post Success:
647: -- p_time_period_id is set to per_time_periods.time_period_id and
648: -- p_period_name is set to per_time_periods.period_name for the period
649: -- which exists as of p_date for the payroll p_payroll_id.
650: --
651: -- Post Failure:
652: -- The application error p_message is raised if a time period does not

Line 663: ,p_payroll_id in per_time_periods.payroll_id%TYPE

659: -- {End Of Comments}
660: --
661: procedure chk_period_exists
662: (p_date in date
663: ,p_payroll_id in per_time_periods.payroll_id%TYPE
664: ,p_message in varchar2
665: ,p_time_period_id out nocopy per_time_periods.time_period_id%TYPE
666: ,p_period_name out nocopy per_time_periods.period_name%TYPE
667: ) is

Line 665: ,p_time_period_id out nocopy per_time_periods.time_period_id%TYPE

661: procedure chk_period_exists
662: (p_date in date
663: ,p_payroll_id in per_time_periods.payroll_id%TYPE
664: ,p_message in varchar2
665: ,p_time_period_id out nocopy per_time_periods.time_period_id%TYPE
666: ,p_period_name out nocopy per_time_periods.period_name%TYPE
667: ) is
668: --
669: v_time_period_id per_time_periods.time_period_id%TYPE;

Line 666: ,p_period_name out nocopy per_time_periods.period_name%TYPE

662: (p_date in date
663: ,p_payroll_id in per_time_periods.payroll_id%TYPE
664: ,p_message in varchar2
665: ,p_time_period_id out nocopy per_time_periods.time_period_id%TYPE
666: ,p_period_name out nocopy per_time_periods.period_name%TYPE
667: ) is
668: --
669: v_time_period_id per_time_periods.time_period_id%TYPE;
670: v_period_name per_time_periods.period_name%TYPE;

Line 669: v_time_period_id per_time_periods.time_period_id%TYPE;

665: ,p_time_period_id out nocopy per_time_periods.time_period_id%TYPE
666: ,p_period_name out nocopy per_time_periods.period_name%TYPE
667: ) is
668: --
669: v_time_period_id per_time_periods.time_period_id%TYPE;
670: v_period_name per_time_periods.period_name%TYPE;
671: v_proc varchar2(72) := g_package||'chk_period_exists';
672: --
673: cursor sel_tim is

Line 670: v_period_name per_time_periods.period_name%TYPE;

666: ,p_period_name out nocopy per_time_periods.period_name%TYPE
667: ) is
668: --
669: v_time_period_id per_time_periods.time_period_id%TYPE;
670: v_period_name per_time_periods.period_name%TYPE;
671: v_proc varchar2(72) := g_package||'chk_period_exists';
672: --
673: cursor sel_tim is
674: select time_period_id

Line 676: from per_time_periods

672: --
673: cursor sel_tim is
674: select time_period_id
675: , period_name
676: from per_time_periods
677: where payroll_id = p_payroll_id
678: and p_date between start_date
679: and end_date;
680: --

Line 688: -- Could not find a row in per_time_periods which matches

684: open sel_tim;
685: fetch sel_tim into v_time_period_id, v_period_name;
686: if sel_tim%notfound then
687: --
688: -- Could not find a row in per_time_periods which matches
689: -- p_date and p_payroll_id. So need to raise the error p_message.
690: --
691: close sel_tim;
692: hr_utility.set_message(801, p_message);

Line 724: -- p_time_period_id is set to per_time_periods.time_period_id and

720: -- p_message is set to message_name to be raised if a period does
721: -- not exist.
722: --
723: -- Post Success:
724: -- p_time_period_id is set to per_time_periods.time_period_id and
725: -- p_period_name is set to per_time_periods.period_name for the period
726: -- which exists as of p_date for the payroll p_payroll_id.
727: --
728: -- Post Failure:

Line 725: -- p_period_name is set to per_time_periods.period_name for the period

721: -- not exist.
722: --
723: -- Post Success:
724: -- p_time_period_id is set to per_time_periods.time_period_id and
725: -- p_period_name is set to per_time_periods.period_name for the period
726: -- which exists as of p_date for the payroll p_payroll_id.
727: --
728: -- Post Failure:
729: -- The application error p_message is raised if a time period does not

Line 740: ,p_payroll_id in per_time_periods.payroll_id%TYPE

736: -- {End Of Comments}
737: --
738: procedure chk_period_exists_eff_for_gb
739: (p_date in date
740: ,p_payroll_id in per_time_periods.payroll_id%TYPE
741: ,p_message in varchar2
742: ,p_time_period_id out nocopy per_time_periods.time_period_id%TYPE
743: ,p_period_name out nocopy per_time_periods.period_name%TYPE
744: ) is

Line 742: ,p_time_period_id out nocopy per_time_periods.time_period_id%TYPE

738: procedure chk_period_exists_eff_for_gb
739: (p_date in date
740: ,p_payroll_id in per_time_periods.payroll_id%TYPE
741: ,p_message in varchar2
742: ,p_time_period_id out nocopy per_time_periods.time_period_id%TYPE
743: ,p_period_name out nocopy per_time_periods.period_name%TYPE
744: ) is
745: --
746: v_time_period_id per_time_periods.time_period_id%TYPE;

Line 743: ,p_period_name out nocopy per_time_periods.period_name%TYPE

739: (p_date in date
740: ,p_payroll_id in per_time_periods.payroll_id%TYPE
741: ,p_message in varchar2
742: ,p_time_period_id out nocopy per_time_periods.time_period_id%TYPE
743: ,p_period_name out nocopy per_time_periods.period_name%TYPE
744: ) is
745: --
746: v_time_period_id per_time_periods.time_period_id%TYPE;
747: v_period_name per_time_periods.period_name%TYPE;

Line 746: v_time_period_id per_time_periods.time_period_id%TYPE;

742: ,p_time_period_id out nocopy per_time_periods.time_period_id%TYPE
743: ,p_period_name out nocopy per_time_periods.period_name%TYPE
744: ) is
745: --
746: v_time_period_id per_time_periods.time_period_id%TYPE;
747: v_period_name per_time_periods.period_name%TYPE;
748: v_proc varchar2(72) := g_package||'chk_period_exists';
749: --
750: cursor sel_tim is

Line 747: v_period_name per_time_periods.period_name%TYPE;

743: ,p_period_name out nocopy per_time_periods.period_name%TYPE
744: ) is
745: --
746: v_time_period_id per_time_periods.time_period_id%TYPE;
747: v_period_name per_time_periods.period_name%TYPE;
748: v_proc varchar2(72) := g_package||'chk_period_exists';
749: --
750: cursor sel_tim is
751: select time_period_id

Line 753: from per_time_periods

749: --
750: cursor sel_tim is
751: select time_period_id
752: , period_name
753: from per_time_periods
754: where payroll_id = p_payroll_id
755: and p_date = regular_payment_date;
756: --
757: begin

Line 764: -- Could not find a row in per_time_periods which matches

760: open sel_tim;
761: fetch sel_tim into v_time_period_id, v_period_name;
762: if sel_tim%notfound then
763: --
764: -- Could not find a row in per_time_periods which matches
765: -- p_date and p_payroll_id. So need to raise the error p_message.
766: --
767: close sel_tim;
768: hr_utility.set_message(801, p_message);

Line 820: from per_time_periods p

816: cursor csr_per_dat is
817: select p.start_date
818: , p.end_date
819: , a.payroll_id
820: from per_time_periods p
821: , per_assignments_f a
822: where a.assignment_id = p_assignment_id
823: and p_effective_date between a.effective_start_date
824: and a.effective_end_date

Line 952: from per_time_periods

948: v_proc varchar2(72) := g_package||'chk_eff_date_for_gb';
949: --
950: cursor sel_tim is
951: select 'Y'
952: from per_time_periods
953: where time_period_id = p_time_period_id
954: and regular_payment_date = p_effective_date;
955: begin
956: hr_utility.set_location('Entering:'|| v_proc, 5);

Line 983: ,p_period_name out nocopy per_time_periods.period_name%TYPE

979: ,p_legislation_code in per_business_groups.legislation_code%TYPE
980: ,p_recal_date_earned in boolean
981: ,p_payroll_id out nocopy pay_payroll_actions.payroll_id%TYPE
982: ,p_time_period_id out nocopy pay_payroll_actions.time_period_id%TYPE
983: ,p_period_name out nocopy per_time_periods.period_name%TYPE
984: ,p_new_date_earned out nocopy pay_payroll_actions.date_earned%TYPE
985: ) is
986: --
987: v_payroll_id pay_payroll_actions.payroll_id%TYPE;

Line 988: v_eff_time_period_id per_time_periods.time_period_id%TYPE;

984: ,p_new_date_earned out nocopy pay_payroll_actions.date_earned%TYPE
985: ) is
986: --
987: v_payroll_id pay_payroll_actions.payroll_id%TYPE;
988: v_eff_time_period_id per_time_periods.time_period_id%TYPE;
989: v_eff_time_period_name per_time_periods.period_name%TYPE;
990: v_new_date_earned pay_payroll_actions.date_earned%TYPE;
991: v_proc varchar2(72) := g_package||'chk_eff_date';
992: v_rule_mode pay_legislation_rules.rule_mode%type;

Line 989: v_eff_time_period_name per_time_periods.period_name%TYPE;

985: ) is
986: --
987: v_payroll_id pay_payroll_actions.payroll_id%TYPE;
988: v_eff_time_period_id per_time_periods.time_period_id%TYPE;
989: v_eff_time_period_name per_time_periods.period_name%TYPE;
990: v_new_date_earned pay_payroll_actions.date_earned%TYPE;
991: v_proc varchar2(72) := g_package||'chk_eff_date';
992: v_rule_mode pay_legislation_rules.rule_mode%type;
993: --

Line 1186: ,p_period_name in out nocopy per_time_periods.period_name%TYPE

1182: ,p_legislation_code in per_business_groups.legislation_code%TYPE
1183: ,p_effective_date in pay_payroll_actions.effective_date%TYPE
1184: ,p_payroll_id in out nocopy pay_payroll_actions.payroll_id%TYPE
1185: ,p_time_period_id in out nocopy pay_payroll_actions.time_period_id%TYPE
1186: ,p_period_name in out nocopy per_time_periods.period_name%TYPE
1187: ) is
1188: --
1189: v_payroll_id pay_payroll_actions.payroll_id%TYPE;
1190: v_time_period_id per_time_periods.time_period_id%TYPE;

Line 1190: v_time_period_id per_time_periods.time_period_id%TYPE;

1186: ,p_period_name in out nocopy per_time_periods.period_name%TYPE
1187: ) is
1188: --
1189: v_payroll_id pay_payroll_actions.payroll_id%TYPE;
1190: v_time_period_id per_time_periods.time_period_id%TYPE;
1191: v_time_period_name per_time_periods.period_name%TYPE;
1192: v_proc varchar2(72) := g_package||'chk_date_earned';
1193: v_argument varchar2(30);
1194: v_rule_mode pay_legislation_rules.rule_mode%type;

Line 1191: v_time_period_name per_time_periods.period_name%TYPE;

1187: ) is
1188: --
1189: v_payroll_id pay_payroll_actions.payroll_id%TYPE;
1190: v_time_period_id per_time_periods.time_period_id%TYPE;
1191: v_time_period_name per_time_periods.period_name%TYPE;
1192: v_proc varchar2(72) := g_package||'chk_date_earned';
1193: v_argument varchar2(30);
1194: v_rule_mode pay_legislation_rules.rule_mode%type;
1195: --

Line 3154: v_unused_return_nam per_time_periods.period_name%TYPE;

3150: --
3151: v_unused_return_b boolean;
3152: v_unused_return_d date;
3153: v_legislation_code per_business_groups.legislation_code%TYPE;
3154: v_unused_return_nam per_time_periods.period_name%TYPE;
3155: v_payroll_id pay_payroll_actions.payroll_id%TYPE;
3156: v_time_period_id pay_payroll_actions.time_period_id%TYPE;
3157: v_proc varchar2(72) := g_package||'insert_validate';
3158: --

Line 3833: ,p_period_name out nocopy per_time_periods.period_name%TYPE

3829: (p_assignment_id in pay_assignment_actions.assignment_id%TYPE
3830: ,p_df_effective_date out nocopy pay_payroll_actions.
3831: effective_date%TYPE
3832: ,p_df_date_earned out nocopy pay_payroll_actions.date_earned%TYPE
3833: ,p_period_name out nocopy per_time_periods.period_name%TYPE
3834: ,p_consolidation_set_id out nocopy pay_consolidation_sets.
3835: consolidation_set_id%TYPE
3836: ,p_consolidation_set_name out nocopy pay_consolidation_sets.
3837: consolidation_set_name%TYPE

Line 3890: from per_time_periods tim

3886: ,v_cur_date date
3887: ) is
3888: select tim.regular_payment_date
3889: , tim.period_name
3890: from per_time_periods tim
3891: where tim.payroll_id = v_pay_id
3892: and v_cur_date between tim.start_date
3893: and tim.end_date;
3894: --

Line 3905: v_period_name per_time_periods.period_name%TYPE;

3901: -- The assignment's payroll as of the session effective or trunc(sysdate).
3902: v_payroll_id per_assignments_f.payroll_id%TYPE;
3903: --
3904: -- Period name which exists as of v_eff_date.
3905: v_period_name per_time_periods.period_name%TYPE;
3906: --
3907: -- Period regular payment date.
3908: v_period_reg_date per_time_periods.regular_payment_date%TYPE;
3909: --

Line 3908: v_period_reg_date per_time_periods.regular_payment_date%TYPE;

3904: -- Period name which exists as of v_eff_date.
3905: v_period_name per_time_periods.period_name%TYPE;
3906: --
3907: -- Period regular payment date.
3908: v_period_reg_date per_time_periods.regular_payment_date%TYPE;
3909: --
3910: -- The Form or Database session effective date.
3911: v_eff_date date;
3912: --

Line 3920: v_df_period_name per_time_periods.period_name%TYPE;

3916: -- Working value which is used to set the out argument p_df_date_earned.
3917: v_df_date_earned pay_payroll_actions.date_earned%TYPE;
3918: --
3919: -- Working value which is used to set the out argument p_period_name;
3920: v_df_period_name per_time_periods.period_name%TYPE;
3921: --
3922: -- Shows if the assignment is on the same payroll as of two dates.
3923: v_same_payroll boolean;
3924: --

Line 4327: per_time_periods ptp,

4323: EE.effective_end_date)
4324: AND ET.processing_type = 'R'
4325: AND EXISTS ( select ''
4326: from pay_payroll_actions ppa,
4327: per_time_periods ptp,
4328: pay_element_entries_f pee
4329: where pee.element_entry_id = EE.element_entry_id
4330: and ppa.payroll_action_id = ACT.payroll_action_id
4331: and ppa.payroll_id = ptp.payroll_id