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 74: FND_DATE.CANONICAL_TO_DATE(paei.AEI_INFORMATION1)

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

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

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

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

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

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

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

Line 178: FND_DATE.CANONICAL_TO_DATE(paei.AEI_INFORMATION1)

174: WHERE
175: assignment_id = p_assignment_id
176: and paei.aei_information_category='NL_SII'
177: and p_date_earned between
178: FND_DATE.CANONICAL_TO_DATE(paei.AEI_INFORMATION1)
179: and nvl(FND_DATE.CANONICAL_TO_DATE(paei.AEI_INFORMATION2),hr_general.END_OF_TIME)
180: order by si_class_order desc;
181: vCur_SI_AMI Cur_SI_AMI%ROWTYPE;
182: l_proc varchar2(100) := g_package||'get_si_status';

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

175: assignment_id = p_assignment_id
176: and paei.aei_information_category='NL_SII'
177: and p_date_earned between
178: FND_DATE.CANONICAL_TO_DATE(paei.AEI_INFORMATION1)
179: and nvl(FND_DATE.CANONICAL_TO_DATE(paei.AEI_INFORMATION2),hr_general.END_OF_TIME)
180: order by si_class_order desc;
181: vCur_SI_AMI Cur_SI_AMI%ROWTYPE;
182: l_proc varchar2(100) := g_package||'get_si_status';
183: BEGIN

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

560: --
561: l_inputs(1).name := 'ASSIGNMENT_ID';
562: l_inputs(1).value := p_assignment_id;
563: l_inputs(2).name := 'DATE_EARNED';
564: l_inputs(2).value := fnd_date.date_to_canonical(p_date_earned);
565: l_inputs(3).name := 'BUSINESS_GROUP_ID';
566: l_inputs(3).value := p_business_group_id;
567: l_inputs(4).name := 'ASSIGNMENT_ACTION_ID';
568: l_inputs(4).value := p_assignment_action_id;

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

568: l_inputs(4).value := p_assignment_action_id;
569: l_inputs(5).name := 'PAYROLL_ACTION_ID';
570: l_inputs(5).value := l_payroll_action_id;
571: l_inputs(6).name := 'BALANCE_DATE';
572: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);
573: --
574: l_outputs(1).name := 'PART_TIME_PERCENTAGE';
575: --
576: pay_nl_general.run_formula(p_formula_id => g_ptp_formula_id,

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

634: --
635: l_inputs(1).name := 'ASSIGNMENT_ID';
636: l_inputs(1).value := p_assignment_id;
637: l_inputs(2).name := 'DATE_EARNED';
638: l_inputs(2).value := fnd_date.date_to_canonical(p_date_earned);
639: l_inputs(3).name := 'BUSINESS_GROUP_ID';
640: l_inputs(3).value := p_business_group_id;
641: l_inputs(4).name := 'ASSIGNMENT_ACTION_ID';
642: l_inputs(4).value := p_assignment_action_id;

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

642: l_inputs(4).value := p_assignment_action_id;
643: l_inputs(5).name := 'PAYROLL_ACTION_ID';
644: l_inputs(5).value := l_payroll_action_id;
645: l_inputs(6).name := 'BALANCE_DATE';
646: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);
647: --
648: l_outputs(1).name := 'STANDARD_SI_PART_TIME_PERCENTAGE';
649: --
650: pay_nl_general.run_formula(p_formula_id => g_std_ptp_formula_id,

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

708: --
709: l_inputs(1).name := 'ASSIGNMENT_ID';
710: l_inputs(1).value := p_assignment_id;
711: l_inputs(2).name := 'DATE_EARNED';
712: l_inputs(2).value := fnd_date.date_to_canonical(p_date_earned);
713: l_inputs(3).name := 'BUSINESS_GROUP_ID';
714: l_inputs(3).value := p_business_group_id;
715: l_inputs(4).name := 'ASSIGNMENT_ACTION_ID';
716: l_inputs(4).value := p_assignment_action_id;

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

716: l_inputs(4).value := p_assignment_action_id;
717: l_inputs(5).name := 'PAYROLL_ACTION_ID';
718: l_inputs(5).value := l_payroll_action_id;
719: l_inputs(6).name := 'BALANCE_DATE';
720: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);
721: --
722: l_outputs(1).name := 'PSEUDO_SI_PART_TIME_PERCENTAGE';
723: --
724: pay_nl_general.run_formula(p_formula_id => g_pse_ptp_formula_id,

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

781: --
782: l_inputs(1).name := 'ASSIGNMENT_ID';
783: l_inputs(1).value := p_assignment_id;
784: l_inputs(2).name := 'DATE_EARNED';
785: l_inputs(2).value := fnd_date.date_to_canonical(p_date_earned);
786: l_inputs(3).name := 'BUSINESS_GROUP_ID';
787: l_inputs(3).value := p_business_group_id;
788: l_inputs(4).name := 'ASSIGNMENT_ACTION_ID';
789: l_inputs(4).value := p_assignment_action_id;

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

789: l_inputs(4).value := p_assignment_action_id;
790: l_inputs(5).name := 'PAYROLL_ACTION_ID';
791: l_inputs(5).value := l_payroll_action_id;
792: l_inputs(6).name := 'BALANCE_DATE';
793: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);
794: --
795: l_outputs(1).name := 'STANDARD_SI_REPORTING_PART_TIME_PERCENTAGE';
796: --
797: pay_nl_general.run_formula(p_formula_id => g_std_rep_ptp_formula_id,

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

854: --
855: l_inputs(1).name := 'ASSIGNMENT_ID';
856: l_inputs(1).value := p_assignment_id;
857: l_inputs(2).name := 'DATE_EARNED';
858: l_inputs(2).value := fnd_date.date_to_canonical(p_date_earned);
859: l_inputs(3).name := 'BUSINESS_GROUP_ID';
860: l_inputs(3).value := p_business_group_id;
861: l_inputs(4).name := 'ASSIGNMENT_ACTION_ID';
862: l_inputs(4).value := p_assignment_action_id;

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

862: l_inputs(4).value := p_assignment_action_id;
863: l_inputs(5).name := 'PAYROLL_ACTION_ID';
864: l_inputs(5).value := l_payroll_action_id;
865: l_inputs(6).name := 'BALANCE_DATE';
866: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);
867: --
868: l_outputs(1).name := 'PSEUDO_SI_REPORTING_PART_TIME_PERCENTAGE';
869: --
870: pay_nl_general.run_formula(p_formula_id => g_pse_rep_ptp_formula_id,

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

999: --
1000: l_inputs(1).name := 'ASSIGNMENT_ID';
1001: l_inputs(1).value := p_assignment_id;
1002: l_inputs(2).name := 'DATE_EARNED';
1003: l_inputs(2).value := fnd_date.date_to_canonical(p_date_earned);
1004: l_inputs(3).name := 'BUSINESS_GROUP_ID';
1005: l_inputs(3).value := p_business_group_id;
1006: l_inputs(4).name := 'ASSIGNMENT_ACTION_ID';
1007: l_inputs(4).value := p_assignment_action_id;

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

1007: l_inputs(4).value := p_assignment_action_id;
1008: l_inputs(5).name := 'PAYROLL_ACTION_ID';
1009: l_inputs(5).value := p_payroll_action_id;
1010: l_inputs(6).name := 'BALANCE_DATE';
1011: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);
1012: --
1013: l_outputs(1).name := 'REAL_SOCIAL_INSURANCE_DAYS';
1014: --
1015: pay_nl_general.run_formula(p_formula_id => g_real_si_days_formula_id,

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

1740: --
1741: l_inputs(1).name := 'ASSIGNMENT_ID';
1742: l_inputs(1).value := p_assignment_id;
1743: l_inputs(2).name := 'DATE_EARNED';
1744: l_inputs(2).value := fnd_date.date_to_canonical(p_date_earned);
1745: l_inputs(3).name := 'BUSINESS_GROUP_ID';
1746: l_inputs(3).value := p_business_group_id;
1747: l_inputs(4).name := 'ASSIGNMENT_ACTION_ID';
1748: l_inputs(4).value := p_assignment_action_id;

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

1748: l_inputs(4).value := p_assignment_action_id;
1749: l_inputs(5).name := 'PAYROLL_ACTION_ID';
1750: l_inputs(5).value := p_payroll_action_id;
1751: l_inputs(6).name := 'BALANCE_DATE';
1752: l_inputs(6).value := fnd_date.date_to_canonical(p_date_earned);
1753: --
1754: l_outputs(1).name := 'OVERRIDE_SOCIAL_INSURANCE_DAYS';
1755: l_outputs(2).name := 'PRORATION_FLAG';
1756: --