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.PQP_NL_EXT_FUNCTIONS dependencies on FND_DATE

Line 66: ,p_chg_eff_dt => fnd_date.canonical_to_date(p_org_information1)

62:
63: ben_EXT_CHG_EVT_api.create_EXT_CHG_EVT
64: (p_ext_chg_evt_log_id => l_log_id
65: ,p_chg_evt_cd => 'COAPPD'
66: ,p_chg_eff_dt => fnd_date.canonical_to_date(p_org_information1)
67: ,p_prmtr_01 => 'ORG'
68: ,p_prmtr_02 => p_org_information3
69: ,p_prmtr_03 => p_org_information6
70: ,p_prmtr_04 => p_organization_id

Line 75: ,p_effective_date => fnd_date.canonical_to_date(p_org_information1)

71: ,p_prmtr_05 => l_sub_cat
72: ,p_person_id => -1
73: ,p_business_group_id => l_business_group_id
74: ,p_object_version_number => l_ovn
75: ,p_effective_date => fnd_date.canonical_to_date(p_org_information1)
76: ,p_new_val1 => p_org_information1
77: ,p_new_val2 => p_org_information2
78: ,p_old_val1 => null
79: ,p_old_val2 => null

Line 106: AND new_val2 = nvl(p_org_information2_o,fnd_date.date_to_canonical(hr_api.g_eot))

102: SELECT ext_chg_evt_log_id,chg_evt_cd,chg_eff_dt,prmtr_01,
103: prmtr_02,prmtr_04,prmtr_05,business_group_id,object_version_number
104: FROM ben_ext_chg_evt_log
105: WHERE new_val1 = p_org_information1_o
106: AND new_val2 = nvl(p_org_information2_o,fnd_date.date_to_canonical(hr_api.g_eot))
107: AND prmtr_01 = 'ORG'
108: AND prmtr_02 = p_org_information3_o
109: AND prmtr_04 = p_organization_id
110: AND chg_evt_cd = 'COAPPD';

Line 160: ,p_chg_eff_dt => fnd_date.canonical_to_date(p_org_information1)

156:
157: ben_EXT_CHG_EVT_api.create_EXT_CHG_EVT
158: (p_ext_chg_evt_log_id => l_log_id
159: ,p_chg_evt_cd => 'COAPPD'
160: ,p_chg_eff_dt => fnd_date.canonical_to_date(p_org_information1)
161: ,p_prmtr_01 => 'ORG'
162: ,p_prmtr_02 => p_org_information3
163: ,p_prmtr_03 => p_org_information6
164: ,p_prmtr_04 => p_organization_id

Line 169: ,p_effective_date => fnd_date.canonical_to_date(p_org_information1)

165: ,p_prmtr_05 => l_sub_cat
166: ,p_person_id => -1
167: ,p_business_group_id => l_bgid
168: ,p_object_version_number => l_ovn
169: ,p_effective_date => fnd_date.canonical_to_date(p_org_information1)
170: ,p_new_val1 => p_org_information1
171: ,p_new_val2 => p_org_information2
172: ,p_old_val1 => null
173: ,p_old_val2 => null

Line 197: ,p_effective_date => fnd_date.canonical_to_date(p_org_information1)

193: ,p_prmtr_05 => l_prmtr5
194: ,p_person_id => -1
195: ,p_business_group_id => l_bgid
196: ,p_object_version_number => l_ovn
197: ,p_effective_date => fnd_date.canonical_to_date(p_org_information1)
198: );
199:
200: ELSIF (p_org_information1 <> p_org_information1_o) THEN
201:

Line 211: ,p_chg_eff_dt => fnd_date.canonical_to_date(p_org_information1)

207: --if start date has been changed,insert a new row effective the new start date
208: ben_EXT_CHG_EVT_api.create_EXT_CHG_EVT
209: (p_ext_chg_evt_log_id => l_log_id
210: ,p_chg_evt_cd => 'COAPPD'
211: ,p_chg_eff_dt => fnd_date.canonical_to_date(p_org_information1)
212: ,p_prmtr_01 => 'ORG'
213: ,p_prmtr_02 => p_org_information3_o
214: ,p_prmtr_03 => p_org_information6
215: ,p_prmtr_04 => p_organization_id

Line 220: ,p_effective_date => fnd_date.canonical_to_date(p_org_information1)

216: ,p_prmtr_05 => l_sub_cat
217: ,p_person_id => -1
218: ,p_business_group_id => l_bgid
219: ,p_object_version_number => l_ovn
220: ,p_effective_date => fnd_date.canonical_to_date(p_org_information1)
221: ,p_new_val1 => p_org_information1
222: ,p_new_val2 => p_org_information2
223: ,p_old_val1 => p_org_information1_o
224: ,p_old_val2 => p_org_information2_o

Line 246: ,p_effective_date => fnd_date.canonical_to_date(p_org_information1)

242: ,p_prmtr_04 => l_prmtr4
243: ,p_person_id => -1
244: ,p_business_group_id => l_bgid
245: ,p_object_version_number => l_ovn
246: ,p_effective_date => fnd_date.canonical_to_date(p_org_information1)
247: ); */
248:
249: ELSIF nvl(p_org_information2,fnd_date.date_to_canonical(hr_api.g_eot)) <>
250: nvl(p_org_information2_o,fnd_date.date_to_canonical(hr_api.g_eot)) THEN

Line 249: ELSIF nvl(p_org_information2,fnd_date.date_to_canonical(hr_api.g_eot)) <>

245: ,p_object_version_number => l_ovn
246: ,p_effective_date => fnd_date.canonical_to_date(p_org_information1)
247: ); */
248:
249: ELSIF nvl(p_org_information2,fnd_date.date_to_canonical(hr_api.g_eot)) <>
250: nvl(p_org_information2_o,fnd_date.date_to_canonical(hr_api.g_eot)) THEN
251:
252: --fetch the sub category for the pension type
253: OPEN c_get_subcat(p_org_information3_o);

Line 250: nvl(p_org_information2_o,fnd_date.date_to_canonical(hr_api.g_eot)) THEN

246: ,p_effective_date => fnd_date.canonical_to_date(p_org_information1)
247: ); */
248:
249: ELSIF nvl(p_org_information2,fnd_date.date_to_canonical(hr_api.g_eot)) <>
250: nvl(p_org_information2_o,fnd_date.date_to_canonical(hr_api.g_eot)) THEN
251:
252: --fetch the sub category for the pension type
253: OPEN c_get_subcat(p_org_information3_o);
254: FETCH c_get_subcat INTO l_sub_cat;

Line 366: ,p_prmtr_09 => fnd_date.date_to_canonical(p_abp_reporting_date)

362: ,p_prmtr_05 => NULL
363: ,p_prmtr_06 => NULL
364: ,p_prmtr_07 => NULL
365: ,p_prmtr_08 => NULL
366: ,p_prmtr_09 => fnd_date.date_to_canonical(p_abp_reporting_date)
367: ,p_prmtr_10 => fnd_number.number_to_canonical(p_assignment_id)
368: ,p_person_id => l_person_id
369: ,p_business_group_id => l_business_group_id
370: ,p_object_version_number => l_ovn

Line 688: AND new_val2 = nvl(p_aei_information2_o,fnd_date.date_to_canonical(hr_api.g_eot))

684: SELECT ext_chg_evt_log_id,chg_evt_cd,chg_eff_dt,prmtr_01,
685: prmtr_02,business_group_id,object_version_number
686: FROM ben_ext_chg_evt_log
687: WHERE new_val1 = p_aei_information1_o
688: AND new_val2 = nvl(p_aei_information2_o,fnd_date.date_to_canonical(hr_api.g_eot))
689: AND prmtr_01 = 'ASG'
690: AND prmtr_02 = p_aei_information3_o
691: AND person_id = c_person_id
692: AND chg_evt_cd = 'COSIPD';

Line 722: ,p_chg_eff_dt => fnd_date.canonical_to_date(p_aei_information1)

718:
719: ben_EXT_CHG_EVT_api.create_EXT_CHG_EVT
720: (p_ext_chg_evt_log_id => l_log_id
721: ,p_chg_evt_cd => 'COSIPD'
722: ,p_chg_eff_dt => fnd_date.canonical_to_date(p_aei_information1)
723: ,p_prmtr_01 => fnd_number.number_to_canonical(p_assignment_id)
724: ,p_person_id => l_person_id
725: ,p_business_group_id => l_business_group_id
726: ,p_object_version_number => l_ovn

Line 727: ,p_effective_date => fnd_date.canonical_to_date(p_aei_information1)

723: ,p_prmtr_01 => fnd_number.number_to_canonical(p_assignment_id)
724: ,p_person_id => l_person_id
725: ,p_business_group_id => l_business_group_id
726: ,p_object_version_number => l_ovn
727: ,p_effective_date => fnd_date.canonical_to_date(p_aei_information1)
728: ,p_new_val1 => p_aei_information1
729: ,p_new_val2 => p_aei_information2
730: ,p_old_val1 => p_aei_information1_o
731: ,p_old_val2 => p_aei_information2_o

Line 734: ELSIF fnd_date.canonical_to_date(nvl(p_aei_information2_o,fnd_date.date_to_canonical(hr_api.g_eot))) <>

730: ,p_old_val1 => p_aei_information1_o
731: ,p_old_val2 => p_aei_information2_o
732: );
733:
734: ELSIF fnd_date.canonical_to_date(nvl(p_aei_information2_o,fnd_date.date_to_canonical(hr_api.g_eot))) <>
735: fnd_date.canonical_to_date(nvl(p_aei_information2,fnd_date.date_to_canonical(hr_api.g_eot))) THEN
736:
737: ben_EXT_CHG_EVT_api.create_EXT_CHG_EVT
738: (p_ext_chg_evt_log_id => l_log_id

Line 735: fnd_date.canonical_to_date(nvl(p_aei_information2,fnd_date.date_to_canonical(hr_api.g_eot))) THEN

731: ,p_old_val2 => p_aei_information2_o
732: );
733:
734: ELSIF fnd_date.canonical_to_date(nvl(p_aei_information2_o,fnd_date.date_to_canonical(hr_api.g_eot))) <>
735: fnd_date.canonical_to_date(nvl(p_aei_information2,fnd_date.date_to_canonical(hr_api.g_eot))) THEN
736:
737: ben_EXT_CHG_EVT_api.create_EXT_CHG_EVT
738: (p_ext_chg_evt_log_id => l_log_id
739: ,p_chg_evt_cd => 'COSIPD'

Line 874: fnd_date.canonical_to_date(p_aei_information1))

870: (p_validate => true
871: ,p_ext_chg_evt_log_id => l_log_id
872: ,p_chg_evt_cd => 'COAPS'
873: ,p_chg_eff_dt => nvl(l_eff_date,
874: fnd_date.canonical_to_date(p_aei_information1))
875: ,p_prmtr_01 => p_assignment_id
876: ,p_prmtr_02 => p_aei_information1
877: ,p_person_id => l_person_id
878: ,p_business_group_id => l_business_group_id

Line 881: fnd_date.canonical_to_date(p_aei_information1))

877: ,p_person_id => l_person_id
878: ,p_business_group_id => l_business_group_id
879: ,p_object_version_number => l_ovn
880: ,p_effective_date => nvl(l_eff_date,
881: fnd_date.canonical_to_date(p_aei_information1))
882: ,p_new_val1 => p_aei_information6
883: ,p_old_val1 => null
884: );
885: END IF;

Line 896: fnd_date.canonical_to_date(p_aei_information1))

892: (p_validate => FALSE
893: ,p_ext_chg_evt_log_id => l_log_id
894: ,p_chg_evt_cd => 'COAPKOP'
895: ,p_chg_eff_dt => nvl(l_eff_date,
896: fnd_date.canonical_to_date(p_aei_information1))
897: ,p_prmtr_01 => p_aei_information1
898: ,p_prmtr_02 => p_aei_information2
899: ,p_prmtr_03 => fnd_number.number_to_canonical(p_assignment_extra_info_id)
900: ,p_prmtr_09 => fnd_date.date_to_canonical(p_abp_reporting_date)

Line 900: ,p_prmtr_09 => fnd_date.date_to_canonical(p_abp_reporting_date)

896: fnd_date.canonical_to_date(p_aei_information1))
897: ,p_prmtr_01 => p_aei_information1
898: ,p_prmtr_02 => p_aei_information2
899: ,p_prmtr_03 => fnd_number.number_to_canonical(p_assignment_extra_info_id)
900: ,p_prmtr_09 => fnd_date.date_to_canonical(p_abp_reporting_date)
901: ,p_prmtr_10 => p_assignment_id
902: ,p_person_id => l_person_id
903: ,p_business_group_id => l_business_group_id
904: ,p_object_version_number => l_ovn

Line 906: fnd_date.canonical_to_date(p_aei_information1))

902: ,p_person_id => l_person_id
903: ,p_business_group_id => l_business_group_id
904: ,p_object_version_number => l_ovn
905: ,p_effective_date => nvl(l_eff_date,
906: fnd_date.canonical_to_date(p_aei_information1))
907: ,p_new_val1 => p_aei_information4
908: ,p_old_val1 => NULL
909: ,p_new_val2 => p_aei_information5
910: ,p_old_val2 => NULL

Line 1045: IF (fnd_date.canonical_to_date(p_aei_information1) <>

1041: CLOSE chk_if_enabled;
1042:
1043: IF l_enabled = 'Y' THEN
1044:
1045: IF (fnd_date.canonical_to_date(p_aei_information1) <>
1046: fnd_date.canonical_to_date(p_aei_information1_o))
1047: AND p_aei_information6 IS NOT NULL THEN
1048:
1049: --Insert a row in the ben_chg_evt_log table

Line 1046: fnd_date.canonical_to_date(p_aei_information1_o))

1042:
1043: IF l_enabled = 'Y' THEN
1044:
1045: IF (fnd_date.canonical_to_date(p_aei_information1) <>
1046: fnd_date.canonical_to_date(p_aei_information1_o))
1047: AND p_aei_information6 IS NOT NULL THEN
1048:
1049: --Insert a row in the ben_chg_evt_log table
1050: ben_EXT_CHG_EVT_api.create_EXT_CHG_EVT

Line 1055: fnd_date.canonical_to_date(p_aei_information1))

1051: (p_validate => true
1052: ,p_ext_chg_evt_log_id => l_log_id
1053: ,p_chg_evt_cd => 'COAPS'
1054: ,p_chg_eff_dt => nvl(l_eff_date,
1055: fnd_date.canonical_to_date(p_aei_information1))
1056: ,p_prmtr_01 => p_assignment_id
1057: ,p_prmtr_02 => p_aei_information1
1058: ,p_person_id => l_person_id
1059: ,p_business_group_id => l_business_group_id

Line 1062: fnd_date.canonical_to_date(p_aei_information1))

1058: ,p_person_id => l_person_id
1059: ,p_business_group_id => l_business_group_id
1060: ,p_object_version_number => l_ovn
1061: ,p_effective_date => nvl(l_eff_date,
1062: fnd_date.canonical_to_date(p_aei_information1))
1063: ,p_new_val1 => p_aei_information6
1064: ,p_old_val1 => null
1065: );
1066:

Line 1077: fnd_date.canonical_to_date(p_aei_information1))

1073: (p_validate => true
1074: ,p_ext_chg_evt_log_id => l_log_id
1075: ,p_chg_evt_cd => 'COAPS'
1076: ,p_chg_eff_dt => nvl(l_eff_date,
1077: fnd_date.canonical_to_date(p_aei_information1))
1078: ,p_prmtr_01 => p_assignment_id
1079: ,p_prmtr_02 => p_aei_information1
1080: ,p_person_id => l_person_id
1081: ,p_business_group_id => l_business_group_id

Line 1084: fnd_date.canonical_to_date(p_aei_information1))

1080: ,p_person_id => l_person_id
1081: ,p_business_group_id => l_business_group_id
1082: ,p_object_version_number => l_ovn
1083: ,p_effective_date => nvl(l_eff_date,
1084: fnd_date.canonical_to_date(p_aei_information1))
1085: ,p_new_val1 => p_aei_information6
1086: ,p_old_val1 => p_aei_information6_o
1087: );
1088:

Line 1089: ELSIF (fnd_date.canonical_to_date(p_aei_information1) <>

1085: ,p_new_val1 => p_aei_information6
1086: ,p_old_val1 => p_aei_information6_o
1087: );
1088:
1089: ELSIF (fnd_date.canonical_to_date(p_aei_information1) <>
1090: fnd_date.canonical_to_date(p_aei_information1_o))
1091: AND p_aei_information4 <> p_aei_information4_o
1092: OR
1093: (fnd_date.canonical_to_date(p_aei_information2) <>

Line 1090: fnd_date.canonical_to_date(p_aei_information1_o))

1086: ,p_old_val1 => p_aei_information6_o
1087: );
1088:
1089: ELSIF (fnd_date.canonical_to_date(p_aei_information1) <>
1090: fnd_date.canonical_to_date(p_aei_information1_o))
1091: AND p_aei_information4 <> p_aei_information4_o
1092: OR
1093: (fnd_date.canonical_to_date(p_aei_information2) <>
1094: fnd_date.canonical_to_date(p_aei_information2_o))

Line 1093: (fnd_date.canonical_to_date(p_aei_information2) <>

1089: ELSIF (fnd_date.canonical_to_date(p_aei_information1) <>
1090: fnd_date.canonical_to_date(p_aei_information1_o))
1091: AND p_aei_information4 <> p_aei_information4_o
1092: OR
1093: (fnd_date.canonical_to_date(p_aei_information2) <>
1094: fnd_date.canonical_to_date(p_aei_information2_o))
1095: AND p_aei_information4 <> p_aei_information4_o
1096: OR
1097: (fnd_date.canonical_to_date(p_aei_information1) <>

Line 1094: fnd_date.canonical_to_date(p_aei_information2_o))

1090: fnd_date.canonical_to_date(p_aei_information1_o))
1091: AND p_aei_information4 <> p_aei_information4_o
1092: OR
1093: (fnd_date.canonical_to_date(p_aei_information2) <>
1094: fnd_date.canonical_to_date(p_aei_information2_o))
1095: AND p_aei_information4 <> p_aei_information4_o
1096: OR
1097: (fnd_date.canonical_to_date(p_aei_information1) <>
1098: fnd_date.canonical_to_date(p_aei_information1_o))

Line 1097: (fnd_date.canonical_to_date(p_aei_information1) <>

1093: (fnd_date.canonical_to_date(p_aei_information2) <>
1094: fnd_date.canonical_to_date(p_aei_information2_o))
1095: AND p_aei_information4 <> p_aei_information4_o
1096: OR
1097: (fnd_date.canonical_to_date(p_aei_information1) <>
1098: fnd_date.canonical_to_date(p_aei_information1_o))
1099: AND (fnd_date.canonical_to_date(p_aei_information2) <>
1100: fnd_date.canonical_to_date(p_aei_information2_o))
1101: AND p_aei_information4 <> p_aei_information4_o

Line 1098: fnd_date.canonical_to_date(p_aei_information1_o))

1094: fnd_date.canonical_to_date(p_aei_information2_o))
1095: AND p_aei_information4 <> p_aei_information4_o
1096: OR
1097: (fnd_date.canonical_to_date(p_aei_information1) <>
1098: fnd_date.canonical_to_date(p_aei_information1_o))
1099: AND (fnd_date.canonical_to_date(p_aei_information2) <>
1100: fnd_date.canonical_to_date(p_aei_information2_o))
1101: AND p_aei_information4 <> p_aei_information4_o
1102: OR

Line 1099: AND (fnd_date.canonical_to_date(p_aei_information2) <>

1095: AND p_aei_information4 <> p_aei_information4_o
1096: OR
1097: (fnd_date.canonical_to_date(p_aei_information1) <>
1098: fnd_date.canonical_to_date(p_aei_information1_o))
1099: AND (fnd_date.canonical_to_date(p_aei_information2) <>
1100: fnd_date.canonical_to_date(p_aei_information2_o))
1101: AND p_aei_information4 <> p_aei_information4_o
1102: OR
1103: p_aei_information4 <> p_aei_information4_o

Line 1100: fnd_date.canonical_to_date(p_aei_information2_o))

1096: OR
1097: (fnd_date.canonical_to_date(p_aei_information1) <>
1098: fnd_date.canonical_to_date(p_aei_information1_o))
1099: AND (fnd_date.canonical_to_date(p_aei_information2) <>
1100: fnd_date.canonical_to_date(p_aei_information2_o))
1101: AND p_aei_information4 <> p_aei_information4_o
1102: OR
1103: p_aei_information4 <> p_aei_information4_o
1104: OR

Line 1105: (fnd_date.canonical_to_date(p_aei_information1) <>

1101: AND p_aei_information4 <> p_aei_information4_o
1102: OR
1103: p_aei_information4 <> p_aei_information4_o
1104: OR
1105: (fnd_date.canonical_to_date(p_aei_information1) <>
1106: fnd_date.canonical_to_date(p_aei_information1_o))
1107: AND p_aei_information4 = p_aei_information4_o
1108: OR
1109: (fnd_date.canonical_to_date(p_aei_information2) <>

Line 1106: fnd_date.canonical_to_date(p_aei_information1_o))

1102: OR
1103: p_aei_information4 <> p_aei_information4_o
1104: OR
1105: (fnd_date.canonical_to_date(p_aei_information1) <>
1106: fnd_date.canonical_to_date(p_aei_information1_o))
1107: AND p_aei_information4 = p_aei_information4_o
1108: OR
1109: (fnd_date.canonical_to_date(p_aei_information2) <>
1110: fnd_date.canonical_to_date(p_aei_information2_o))

Line 1109: (fnd_date.canonical_to_date(p_aei_information2) <>

1105: (fnd_date.canonical_to_date(p_aei_information1) <>
1106: fnd_date.canonical_to_date(p_aei_information1_o))
1107: AND p_aei_information4 = p_aei_information4_o
1108: OR
1109: (fnd_date.canonical_to_date(p_aei_information2) <>
1110: fnd_date.canonical_to_date(p_aei_information2_o))
1111: AND p_aei_information4 = p_aei_information4_o
1112: THEN
1113: --

Line 1110: fnd_date.canonical_to_date(p_aei_information2_o))

1106: fnd_date.canonical_to_date(p_aei_information1_o))
1107: AND p_aei_information4 = p_aei_information4_o
1108: OR
1109: (fnd_date.canonical_to_date(p_aei_information2) <>
1110: fnd_date.canonical_to_date(p_aei_information2_o))
1111: AND p_aei_information4 = p_aei_information4_o
1112: THEN
1113: --
1114: -- Check if an existing log row can be updated with the same information