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_NL_SI_PKG dependencies on FND_DATE

Line 76: FND_DATE.CANONICAL_TO_DATE(paei.AEI_INFORMATION1)

72: and (paei.AEI_INFORMATION3 = p_si_class or
73: paei.AEI_INFORMATION3 = DECODE(p_si_class,'ZFW','AMI','ZW','AMI','WW','AMI','WAO','AMI',
74: 'ZVW','AMI','ZVWL','AMI','ZVWS','AMI','WGA','AMI','IVA','AMI','UFO','AMI',p_si_class))
75: and p_date_earned between
76: FND_DATE.CANONICAL_TO_DATE(paei.AEI_INFORMATION1)
77: and nvl(FND_DATE.CANONICAL_TO_DATE(paei.AEI_INFORMATION2),hr_general.END_OF_TIME)
78: order by si_class_order desc;
79:
80: CURSOR Cur_ZVW_Excluded(p_dt_earned NUMBER)

Line 77: and nvl(FND_DATE.CANONICAL_TO_DATE(paei.AEI_INFORMATION2),hr_general.END_OF_TIME)

73: paei.AEI_INFORMATION3 = DECODE(p_si_class,'ZFW','AMI','ZW','AMI','WW','AMI','WAO','AMI',
74: 'ZVW','AMI','ZVWL','AMI','ZVWS','AMI','WGA','AMI','IVA','AMI','UFO','AMI',p_si_class))
75: and p_date_earned between
76: FND_DATE.CANONICAL_TO_DATE(paei.AEI_INFORMATION1)
77: and nvl(FND_DATE.CANONICAL_TO_DATE(paei.AEI_INFORMATION2),hr_general.END_OF_TIME)
78: order by si_class_order desc;
79:
80: CURSOR Cur_ZVW_Excluded(p_dt_earned NUMBER)
81: IS

Line 87: and (to_char(fnd_date.canonical_to_date(paei.AEI_INFORMATION1),'RRRR') <= p_dt_earned

83: FROM
84: per_assignment_extra_info paei
85: WHERE assignment_id = p_assignment_id
86: and paei.aei_information_category='NL_EXCL_ZVW'
87: and (to_char(fnd_date.canonical_to_date(paei.AEI_INFORMATION1),'RRRR') <= p_dt_earned
88: AND nvl(to_char(fnd_date.canonical_to_date(paei.AEI_INFORMATION3),'RRRR'),'4712') >= p_dt_earned);
89:
90:
91: vCur_SI_Status Cur_SI_Status%ROWTYPE;

Line 88: AND nvl(to_char(fnd_date.canonical_to_date(paei.AEI_INFORMATION3),'RRRR'),'4712') >= p_dt_earned);

84: per_assignment_extra_info paei
85: WHERE assignment_id = p_assignment_id
86: and paei.aei_information_category='NL_EXCL_ZVW'
87: and (to_char(fnd_date.canonical_to_date(paei.AEI_INFORMATION1),'RRRR') <= p_dt_earned
88: AND nvl(to_char(fnd_date.canonical_to_date(paei.AEI_INFORMATION3),'RRRR'),'4712') >= p_dt_earned);
89:
90:
91: vCur_SI_Status Cur_SI_Status%ROWTYPE;
92: vCur_ZVW_Excluded Cur_ZVW_Excluded%ROWTYPE;

Line 194: FND_DATE.CANONICAL_TO_DATE(paei.AEI_INFORMATION1)

190: WHERE
191: assignment_id = p_assignment_id
192: and paei.aei_information_category='NL_SII'
193: and p_date_earned between
194: FND_DATE.CANONICAL_TO_DATE(paei.AEI_INFORMATION1)
195: and nvl(FND_DATE.CANONICAL_TO_DATE(paei.AEI_INFORMATION2),hr_general.END_OF_TIME)
196: order by si_class_order desc;
197: vCur_SI_AMI Cur_SI_AMI%ROWTYPE;
198: l_proc varchar2(100) := g_package||'get_si_status';

Line 195: and nvl(FND_DATE.CANONICAL_TO_DATE(paei.AEI_INFORMATION2),hr_general.END_OF_TIME)

191: assignment_id = p_assignment_id
192: and paei.aei_information_category='NL_SII'
193: and p_date_earned between
194: FND_DATE.CANONICAL_TO_DATE(paei.AEI_INFORMATION1)
195: and nvl(FND_DATE.CANONICAL_TO_DATE(paei.AEI_INFORMATION2),hr_general.END_OF_TIME)
196: order by si_class_order desc;
197: vCur_SI_AMI Cur_SI_AMI%ROWTYPE;
198: l_proc varchar2(100) := g_package||'get_si_status';
199: BEGIN

Line 581: l_inputs(2).value := fnd_date.date_to_canonical(p_date_earned);

577: --
578: l_inputs(1).name := 'ASSIGNMENT_ID';
579: l_inputs(1).value := p_assignment_id;
580: l_inputs(2).name := 'DATE_EARNED';
581: l_inputs(2).value := fnd_date.date_to_canonical(p_date_earned);
582: l_inputs(3).name := 'BUSINESS_GROUP_ID';
583: l_inputs(3).value := p_business_group_id;
584: l_inputs(4).name := 'ASSIGNMENT_ACTION_ID';
585: l_inputs(4).value := p_assignment_action_id;

Line 589: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);

585: l_inputs(4).value := p_assignment_action_id;
586: l_inputs(5).name := 'PAYROLL_ACTION_ID';
587: l_inputs(5).value := l_payroll_action_id;
588: l_inputs(6).name := 'BALANCE_DATE';
589: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);
590: --
591: l_outputs(1).name := 'PART_TIME_PERCENTAGE';
592: --
593: pay_nl_general.run_formula(p_formula_id => g_ptp_formula_id,

Line 655: l_inputs(2).value := fnd_date.date_to_canonical(p_date_earned);

651: --
652: l_inputs(1).name := 'ASSIGNMENT_ID';
653: l_inputs(1).value := p_assignment_id;
654: l_inputs(2).name := 'DATE_EARNED';
655: l_inputs(2).value := fnd_date.date_to_canonical(p_date_earned);
656: l_inputs(3).name := 'BUSINESS_GROUP_ID';
657: l_inputs(3).value := p_business_group_id;
658: l_inputs(4).name := 'ASSIGNMENT_ACTION_ID';
659: l_inputs(4).value := p_assignment_action_id;

Line 663: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);

659: l_inputs(4).value := p_assignment_action_id;
660: l_inputs(5).name := 'PAYROLL_ACTION_ID';
661: l_inputs(5).value := l_payroll_action_id;
662: l_inputs(6).name := 'BALANCE_DATE';
663: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);
664: --
665: l_outputs(1).name := 'STANDARD_SI_PART_TIME_PERCENTAGE';
666: --
667: pay_nl_general.run_formula(p_formula_id => g_std_ptp_formula_id,

Line 729: l_inputs(2).value := fnd_date.date_to_canonical(p_date_earned);

725: --
726: l_inputs(1).name := 'ASSIGNMENT_ID';
727: l_inputs(1).value := p_assignment_id;
728: l_inputs(2).name := 'DATE_EARNED';
729: l_inputs(2).value := fnd_date.date_to_canonical(p_date_earned);
730: l_inputs(3).name := 'BUSINESS_GROUP_ID';
731: l_inputs(3).value := p_business_group_id;
732: l_inputs(4).name := 'ASSIGNMENT_ACTION_ID';
733: l_inputs(4).value := p_assignment_action_id;

Line 737: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);

733: l_inputs(4).value := p_assignment_action_id;
734: l_inputs(5).name := 'PAYROLL_ACTION_ID';
735: l_inputs(5).value := l_payroll_action_id;
736: l_inputs(6).name := 'BALANCE_DATE';
737: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);
738: --
739: l_outputs(1).name := 'PSEUDO_SI_PART_TIME_PERCENTAGE';
740: --
741: pay_nl_general.run_formula(p_formula_id => g_pse_ptp_formula_id,

Line 802: l_inputs(2).value := fnd_date.date_to_canonical(p_date_earned);

798: --
799: l_inputs(1).name := 'ASSIGNMENT_ID';
800: l_inputs(1).value := p_assignment_id;
801: l_inputs(2).name := 'DATE_EARNED';
802: l_inputs(2).value := fnd_date.date_to_canonical(p_date_earned);
803: l_inputs(3).name := 'BUSINESS_GROUP_ID';
804: l_inputs(3).value := p_business_group_id;
805: l_inputs(4).name := 'ASSIGNMENT_ACTION_ID';
806: l_inputs(4).value := p_assignment_action_id;

Line 810: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);

806: l_inputs(4).value := p_assignment_action_id;
807: l_inputs(5).name := 'PAYROLL_ACTION_ID';
808: l_inputs(5).value := l_payroll_action_id;
809: l_inputs(6).name := 'BALANCE_DATE';
810: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);
811: --
812: l_outputs(1).name := 'STANDARD_SI_REPORTING_PART_TIME_PERCENTAGE';
813: --
814: pay_nl_general.run_formula(p_formula_id => g_std_rep_ptp_formula_id,

Line 875: l_inputs(2).value := fnd_date.date_to_canonical(p_date_earned);

871: --
872: l_inputs(1).name := 'ASSIGNMENT_ID';
873: l_inputs(1).value := p_assignment_id;
874: l_inputs(2).name := 'DATE_EARNED';
875: l_inputs(2).value := fnd_date.date_to_canonical(p_date_earned);
876: l_inputs(3).name := 'BUSINESS_GROUP_ID';
877: l_inputs(3).value := p_business_group_id;
878: l_inputs(4).name := 'ASSIGNMENT_ACTION_ID';
879: l_inputs(4).value := p_assignment_action_id;

Line 883: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);

879: l_inputs(4).value := p_assignment_action_id;
880: l_inputs(5).name := 'PAYROLL_ACTION_ID';
881: l_inputs(5).value := l_payroll_action_id;
882: l_inputs(6).name := 'BALANCE_DATE';
883: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);
884: --
885: l_outputs(1).name := 'PSEUDO_SI_REPORTING_PART_TIME_PERCENTAGE';
886: --
887: pay_nl_general.run_formula(p_formula_id => g_pse_rep_ptp_formula_id,

Line 1020: l_inputs(2).value := fnd_date.date_to_canonical(p_date_earned);

1016: --
1017: l_inputs(1).name := 'ASSIGNMENT_ID';
1018: l_inputs(1).value := p_assignment_id;
1019: l_inputs(2).name := 'DATE_EARNED';
1020: l_inputs(2).value := fnd_date.date_to_canonical(p_date_earned);
1021: l_inputs(3).name := 'BUSINESS_GROUP_ID';
1022: l_inputs(3).value := p_business_group_id;
1023: l_inputs(4).name := 'ASSIGNMENT_ACTION_ID';
1024: l_inputs(4).value := p_assignment_action_id;

Line 1028: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);

1024: l_inputs(4).value := p_assignment_action_id;
1025: l_inputs(5).name := 'PAYROLL_ACTION_ID';
1026: l_inputs(5).value := p_payroll_action_id;
1027: l_inputs(6).name := 'BALANCE_DATE';
1028: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);
1029: --
1030: l_outputs(1).name := 'REAL_SOCIAL_INSURANCE_DAYS';
1031: --
1032: pay_nl_general.run_formula(p_formula_id => g_real_si_days_formula_id,

Line 1761: l_inputs(2).value := fnd_date.date_to_canonical(p_date_earned);

1757: --
1758: l_inputs(1).name := 'ASSIGNMENT_ID';
1759: l_inputs(1).value := p_assignment_id;
1760: l_inputs(2).name := 'DATE_EARNED';
1761: l_inputs(2).value := fnd_date.date_to_canonical(p_date_earned);
1762: l_inputs(3).name := 'BUSINESS_GROUP_ID';
1763: l_inputs(3).value := p_business_group_id;
1764: l_inputs(4).name := 'ASSIGNMENT_ACTION_ID';
1765: l_inputs(4).value := p_assignment_action_id;

Line 1769: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);

1765: l_inputs(4).value := p_assignment_action_id;
1766: l_inputs(5).name := 'PAYROLL_ACTION_ID';
1767: l_inputs(5).value := p_payroll_action_id;
1768: l_inputs(6).name := 'BALANCE_DATE';
1769: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);
1770: --
1771: l_outputs(1).name := 'OVERRIDE_SOCIAL_INSURANCE_DAYS';
1772: l_outputs(2).name := 'PRORATION_FLAG';
1773: l_outputs(3).name := 'OVERRIDE_SOCIAL_INSURANCE_DAYS_ZVW';