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

Line 739: Fnd_Date.Canonical_To_Date

735: IF (p_pei_info_rec_new.pei_information5 =
736: p_pei_info_rec_old.pei_information5 AND
737: p_pei_info_rec_new.pei_information6 =
738: p_pei_info_rec_old.pei_information6 AND
739: Fnd_Date.Canonical_To_Date
740: (p_pei_info_rec_new.pei_information8) =
741: Fnd_Date.Canonical_To_Date
742: (p_pei_info_rec_old.pei_information8))
743: THEN

Line 741: Fnd_Date.Canonical_To_Date

737: p_pei_info_rec_new.pei_information6 =
738: p_pei_info_rec_old.pei_information6 AND
739: Fnd_Date.Canonical_To_Date
740: (p_pei_info_rec_new.pei_information8) =
741: Fnd_Date.Canonical_To_Date
742: (p_pei_info_rec_old.pei_information8))
743: THEN
744: RETURN;
745: END IF;

Line 770: l_oss_pp_rec.passport_expiry_date:= Fnd_Date.Canonical_To_Date

766: -- ===========================================================================
767: IF p_action = 'INSERT' THEN
768: l_oss_pp_rec.passport_cntry_code := p_pei_info_rec_new.pei_information5;
769: l_oss_pp_rec.passport_number := p_pei_info_rec_new.pei_information6;
770: l_oss_pp_rec.passport_expiry_date:= Fnd_Date.Canonical_To_Date
771: (p_pei_info_rec_new.pei_information8);
772: l_Insert_OSS_Rec := TRUE;
773: -- If expiry date is null then raise a warning that Passport was not
774: -- created in OSS for the student employee as its a required field in OSS

Line 823: l_oss_pp_rec.passport_expiry_date:= Fnd_Date.Canonical_To_Date

819: END IF;
820:
821: l_oss_pp_rec.passport_cntry_code := p_pei_info_rec_new.pei_information5;
822: l_oss_pp_rec.passport_number := p_pei_info_rec_new.pei_information6;
823: l_oss_pp_rec.passport_expiry_date:= Fnd_Date.Canonical_To_Date
824: (p_pei_info_rec_new.pei_information8);
825:
826: -- If expiry date is null then raise a warning that Passport was not
827: -- created in OSS for the student employee

Line 967: l_dft_date := Fnd_Date.Date_To_Canonical(sysdate);

963: l_proc_name CONSTANT Varchar2(150) := g_pkg ||'InsUpd_OSS_Visa';
964: l_dft_date Varchar2(150);
965: BEGIN
966: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
967: l_dft_date := Fnd_Date.Date_To_Canonical(sysdate);
968: Hr_Utility.set_location('..p_party_id: '||p_party_id, 5);
969: l_Update_OSS_Rec := FALSE; l_Insert_OSS_Rec := FALSE;
970:
971: SQLstmt:='SELECT '||

Line 1014: Fnd_Date.Canonical_To_Date

1010: IF (p_pei_info_rec_new.pei_information5 =
1011: p_pei_info_rec_old.pei_information5 AND
1012: p_pei_info_rec_new.pei_information6 =
1013: p_pei_info_rec_old.pei_information6 AND
1014: Fnd_Date.Canonical_To_Date
1015: (p_pei_info_rec_new.pei_information7) =
1016: Fnd_Date.Canonical_To_Date
1017: (p_pei_info_rec_old.pei_information7) AND
1018: Fnd_Date.Canonical_To_Date

Line 1016: Fnd_Date.Canonical_To_Date

1012: p_pei_info_rec_new.pei_information6 =
1013: p_pei_info_rec_old.pei_information6 AND
1014: Fnd_Date.Canonical_To_Date
1015: (p_pei_info_rec_new.pei_information7) =
1016: Fnd_Date.Canonical_To_Date
1017: (p_pei_info_rec_old.pei_information7) AND
1018: Fnd_Date.Canonical_To_Date
1019: (nvl(p_pei_info_rec_new.pei_information8,l_dft_date)) =
1020: Fnd_Date.Canonical_To_Date

Line 1018: Fnd_Date.Canonical_To_Date

1014: Fnd_Date.Canonical_To_Date
1015: (p_pei_info_rec_new.pei_information7) =
1016: Fnd_Date.Canonical_To_Date
1017: (p_pei_info_rec_old.pei_information7) AND
1018: Fnd_Date.Canonical_To_Date
1019: (nvl(p_pei_info_rec_new.pei_information8,l_dft_date)) =
1020: Fnd_Date.Canonical_To_Date
1021: (nvl(p_pei_info_rec_old.pei_information8,l_dft_date))
1022: )

Line 1020: Fnd_Date.Canonical_To_Date

1016: Fnd_Date.Canonical_To_Date
1017: (p_pei_info_rec_old.pei_information7) AND
1018: Fnd_Date.Canonical_To_Date
1019: (nvl(p_pei_info_rec_new.pei_information8,l_dft_date)) =
1020: Fnd_Date.Canonical_To_Date
1021: (nvl(p_pei_info_rec_old.pei_information8,l_dft_date))
1022: )
1023: THEN
1024: RETURN;

Line 1030: (Fnd_Date.Canonical_To_Date

1026: IF (p_pei_info_rec_new.pei_information5 <>
1027: p_pei_info_rec_old.pei_information5) or
1028: (p_pei_info_rec_new.pei_information6 <>
1029: p_pei_info_rec_old.pei_information6)or
1030: (Fnd_Date.Canonical_To_Date
1031: (nvl(p_pei_info_rec_new.pei_information7,l_dft_date)) <>
1032: Fnd_Date.Canonical_To_Date
1033: (nvl(p_pei_info_rec_old.pei_information7,l_dft_date))
1034: )

Line 1032: Fnd_Date.Canonical_To_Date

1028: (p_pei_info_rec_new.pei_information6 <>
1029: p_pei_info_rec_old.pei_information6)or
1030: (Fnd_Date.Canonical_To_Date
1031: (nvl(p_pei_info_rec_new.pei_information7,l_dft_date)) <>
1032: Fnd_Date.Canonical_To_Date
1033: (nvl(p_pei_info_rec_old.pei_information7,l_dft_date))
1034: )
1035: THEN
1036: l_msg_data := 'For a student you cannot update the unique combination of '||

Line 1053: l_oss_visa_rec.visa_issue_date := Fnd_Date.Canonical_To_Date

1049: Hr_Utility.set_location('..Visa Number: '||p_pei_info_rec_new.pei_information6, 6);
1050: IF p_action = 'INSERT' THEN
1051: l_oss_visa_rec.visa_type := p_pei_info_rec_new.pei_information5;
1052: l_oss_visa_rec.visa_number := p_pei_info_rec_new.pei_information6;
1053: l_oss_visa_rec.visa_issue_date := Fnd_Date.Canonical_To_Date
1054: (p_pei_info_rec_new.pei_information7);
1055: l_oss_visa_rec.visa_expiry_date:= Fnd_Date.Canonical_To_Date
1056: (p_pei_info_rec_new.pei_information8);
1057: l_Insert_OSS_Rec := TRUE;

Line 1055: l_oss_visa_rec.visa_expiry_date:= Fnd_Date.Canonical_To_Date

1051: l_oss_visa_rec.visa_type := p_pei_info_rec_new.pei_information5;
1052: l_oss_visa_rec.visa_number := p_pei_info_rec_new.pei_information6;
1053: l_oss_visa_rec.visa_issue_date := Fnd_Date.Canonical_To_Date
1054: (p_pei_info_rec_new.pei_information7);
1055: l_oss_visa_rec.visa_expiry_date:= Fnd_Date.Canonical_To_Date
1056: (p_pei_info_rec_new.pei_information8);
1057: l_Insert_OSS_Rec := TRUE;
1058: -- If expiry date is null then raise a warning that Passport was not
1059: -- created in OSS for the student employee

Line 1072: (Fnd_Date.Canonical_To_Date

1068: Hr_Utility.set_location('..After Dynamic SQL cursor ', 11);
1069: IF csr_Visa%FOUND THEN
1070: IF (p_pei_info_rec_old.pei_information5 =
1071: p_pei_info_rec_new.pei_information5) AND
1072: (Fnd_Date.Canonical_To_Date
1073: (nvl(p_pei_info_rec_new.pei_information8,l_dft_date)) <>
1074: Fnd_Date.Canonical_To_Date
1075: (nvl(p_pei_info_rec_old.pei_information8,l_dft_date))
1076: )

Line 1074: Fnd_Date.Canonical_To_Date

1070: IF (p_pei_info_rec_old.pei_information5 =
1071: p_pei_info_rec_new.pei_information5) AND
1072: (Fnd_Date.Canonical_To_Date
1073: (nvl(p_pei_info_rec_new.pei_information8,l_dft_date)) <>
1074: Fnd_Date.Canonical_To_Date
1075: (nvl(p_pei_info_rec_old.pei_information8,l_dft_date))
1076: )
1077: THEN
1078: Hr_Utility.set_location('..Visa Number found. ', 12);

Line 1105: (Fnd_Date.Canonical_To_Date

1101: Hr_Utility.set_location('..Visa Number NOT found. ', 14);
1102: l_Insert_OSS_Rec := TRUE;
1103: ELSIF (p_pei_info_rec_new.pei_information5 =
1104: p_pei_info_rec_old.pei_information5) OR
1105: (Fnd_Date.Canonical_To_Date
1106: (nvl(p_pei_info_rec_new.pei_information8,l_dft_date)) <>
1107: Fnd_Date.Canonical_To_Date
1108: (nvl(p_pei_info_rec_old.pei_information8,l_dft_date))
1109: ) THEN

Line 1107: Fnd_Date.Canonical_To_Date

1103: ELSIF (p_pei_info_rec_new.pei_information5 =
1104: p_pei_info_rec_old.pei_information5) OR
1105: (Fnd_Date.Canonical_To_Date
1106: (nvl(p_pei_info_rec_new.pei_information8,l_dft_date)) <>
1107: Fnd_Date.Canonical_To_Date
1108: (nvl(p_pei_info_rec_old.pei_information8,l_dft_date))
1109: ) THEN
1110: Hr_Utility.set_location('..Visa Number found. ', 15);
1111: l_Update_OSS_Rec := TRUE;

Line 1119: l_oss_visa_rec.visa_issue_date := Fnd_Date.Canonical_To_Date

1115: END IF;
1116:
1117: l_oss_visa_rec.visa_type := p_pei_info_rec_new.pei_information5;
1118: l_oss_visa_rec.visa_number := p_pei_info_rec_new.pei_information6;
1119: l_oss_visa_rec.visa_issue_date := Fnd_Date.Canonical_To_Date
1120: (p_pei_info_rec_new.pei_information7);
1121: l_oss_visa_rec.visa_expiry_date:= Fnd_Date.Canonical_To_Date
1122: (p_pei_info_rec_new.pei_information8);
1123:

Line 1121: l_oss_visa_rec.visa_expiry_date:= Fnd_Date.Canonical_To_Date

1117: l_oss_visa_rec.visa_type := p_pei_info_rec_new.pei_information5;
1118: l_oss_visa_rec.visa_number := p_pei_info_rec_new.pei_information6;
1119: l_oss_visa_rec.visa_issue_date := Fnd_Date.Canonical_To_Date
1120: (p_pei_info_rec_new.pei_information7);
1121: l_oss_visa_rec.visa_expiry_date:= Fnd_Date.Canonical_To_Date
1122: (p_pei_info_rec_new.pei_information8);
1123:
1124: END IF;
1125:

Line 1266: l_dft_date := Fnd_Date.Date_To_Canonical(sysdate);

1262: l_Insert_OSS_rec Boolean;
1263: l_dft_date Varchar2(150);
1264: BEGIN
1265: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1266: l_dft_date := Fnd_Date.Date_To_Canonical(sysdate);
1267: l_Update_OSS_Rec := FALSE; l_Insert_OSS_Rec := FALSE;
1268: SQLstmt := ' SELECT row_id
1269: ,port_of_entry
1270: ,port_of_entry_m

Line 1290: Fnd_Date.Canonical_To_Date

1286: IF p_action = 'UPDATE' THEN
1287: IF (nvl(p_pei_info_rec_new.pei_information11,'$$') =
1288: nvl(p_pei_info_rec_old.pei_information11,'$$') AND
1289:
1290: Fnd_Date.Canonical_To_Date
1291: (p_pei_info_rec_new.pei_information7) =
1292: Fnd_Date.Canonical_To_Date
1293: (p_pei_info_rec_old.pei_information7) AND
1294:

Line 1292: Fnd_Date.Canonical_To_Date

1288: nvl(p_pei_info_rec_old.pei_information11,'$$') AND
1289:
1290: Fnd_Date.Canonical_To_Date
1291: (p_pei_info_rec_new.pei_information7) =
1292: Fnd_Date.Canonical_To_Date
1293: (p_pei_info_rec_old.pei_information7) AND
1294:
1295: Fnd_Date.Canonical_To_Date
1296: (nvl(p_pei_info_rec_new.pei_information8,l_dft_date)) =

Line 1295: Fnd_Date.Canonical_To_Date

1291: (p_pei_info_rec_new.pei_information7) =
1292: Fnd_Date.Canonical_To_Date
1293: (p_pei_info_rec_old.pei_information7) AND
1294:
1295: Fnd_Date.Canonical_To_Date
1296: (nvl(p_pei_info_rec_new.pei_information8,l_dft_date)) =
1297: Fnd_Date.Canonical_To_Date
1298: (nvl(p_pei_info_rec_old.pei_information8,l_dft_date)) AND
1299:

Line 1297: Fnd_Date.Canonical_To_Date

1293: (p_pei_info_rec_old.pei_information7) AND
1294:
1295: Fnd_Date.Canonical_To_Date
1296: (nvl(p_pei_info_rec_new.pei_information8,l_dft_date)) =
1297: Fnd_Date.Canonical_To_Date
1298: (nvl(p_pei_info_rec_old.pei_information8,l_dft_date)) AND
1299:
1300: nvl(p_pei_info_rec_new.pei_information12,'$$') =
1301: nvl(p_pei_info_rec_old.pei_information12,'$$') AND

Line 1336: := Fnd_Date.Canonical_To_Date(p_pei_info_rec_new.pei_information7);

1332: -- ================================================================================
1333: IF p_action = 'INSERT' THEN
1334: Hr_Utility.set_location(' p_action: '||p_action, 10);
1335: l_oss_vvhist_rec_new.visit_start_date
1336: := Fnd_Date.Canonical_To_Date(p_pei_info_rec_new.pei_information7);
1337: l_oss_vvhist_rec_new.visit_end_date
1338: := Fnd_Date.Canonical_To_Date(p_pei_info_rec_new.pei_information8);
1339: l_oss_vvhist_rec_new.cntry_entry_form_num
1340: := p_pei_info_rec_new.pei_information12;

Line 1338: := Fnd_Date.Canonical_To_Date(p_pei_info_rec_new.pei_information8);

1334: Hr_Utility.set_location(' p_action: '||p_action, 10);
1335: l_oss_vvhist_rec_new.visit_start_date
1336: := Fnd_Date.Canonical_To_Date(p_pei_info_rec_new.pei_information7);
1337: l_oss_vvhist_rec_new.visit_end_date
1338: := Fnd_Date.Canonical_To_Date(p_pei_info_rec_new.pei_information8);
1339: l_oss_vvhist_rec_new.cntry_entry_form_num
1340: := p_pei_info_rec_new.pei_information12;
1341: l_oss_vvhist_rec_new.port_of_entry
1342: := p_pei_info_rec_new.pei_information13;

Line 1362: IF Fnd_Date.Canonical_To_Date

1358: IF csr_visit%FOUND THEN
1359: Hr_Utility.set_location(' Visit History record found in OSS ', 11);
1360: Hr_Utility.set_location(' Old End Date: '||p_pei_info_rec_old.pei_information8, 11);
1361: Hr_Utility.set_location(' New End Date: '||p_pei_info_rec_new.pei_information8, 11);
1362: IF Fnd_Date.Canonical_To_Date
1363: (NVL(p_pei_info_rec_old.pei_information8,l_dft_date)) <>
1364: Fnd_Date.Canonical_To_Date
1365: (NVL(p_pei_info_rec_new.pei_information8,l_dft_date))
1366: THEN

Line 1364: Fnd_Date.Canonical_To_Date

1360: Hr_Utility.set_location(' Old End Date: '||p_pei_info_rec_old.pei_information8, 11);
1361: Hr_Utility.set_location(' New End Date: '||p_pei_info_rec_new.pei_information8, 11);
1362: IF Fnd_Date.Canonical_To_Date
1363: (NVL(p_pei_info_rec_old.pei_information8,l_dft_date)) <>
1364: Fnd_Date.Canonical_To_Date
1365: (NVL(p_pei_info_rec_new.pei_information8,l_dft_date))
1366: THEN
1367: Hr_Utility.set_location(' New End Date <> Old End Date ', 11);
1368: -- The Visa Visit History being updated exists in OSS

Line 1392: IF Fnd_Date.Canonical_To_Date

1388: ,p_pei_info_rec_new.pei_information11;
1389: FETCH csr_visit INTO l_oss_vvhist_rec_old ;
1390: IF csr_visit%NOTFOUND THEN
1391: l_Insert_OSS_Rec := TRUE;
1392: IF Fnd_Date.Canonical_To_Date
1393: (NVL(p_pei_info_rec_old.pei_information8,l_dft_date)) <>
1394: Fnd_Date.Canonical_To_Date
1395: (NVL(p_pei_info_rec_new.pei_information8,l_dft_date))
1396: THEN

Line 1394: Fnd_Date.Canonical_To_Date

1390: IF csr_visit%NOTFOUND THEN
1391: l_Insert_OSS_Rec := TRUE;
1392: IF Fnd_Date.Canonical_To_Date
1393: (NVL(p_pei_info_rec_old.pei_information8,l_dft_date)) <>
1394: Fnd_Date.Canonical_To_Date
1395: (NVL(p_pei_info_rec_new.pei_information8,l_dft_date))
1396: THEN
1397: l_Update_OSS_Rec := TRUE;
1398: l_oss_vvhist_rec_new := l_oss_vvhist_rec_old;

Line 1403: l_oss_vvhist_rec_new.visit_start_date := Fnd_Date.Canonical_To_Date

1399: END IF;
1400: END IF;
1401: CLOSE csr_visit;
1402: END IF;
1403: l_oss_vvhist_rec_new.visit_start_date := Fnd_Date.Canonical_To_Date
1404: (p_pei_info_rec_new.pei_information7);
1405: l_oss_vvhist_rec_new.visit_end_date := Fnd_Date.Canonical_To_Date
1406: (p_pei_info_rec_new.pei_information8);
1407: l_oss_vvhist_rec_new.cntry_entry_form_num:= p_pei_info_rec_new.pei_information12;

Line 1405: l_oss_vvhist_rec_new.visit_end_date := Fnd_Date.Canonical_To_Date

1401: CLOSE csr_visit;
1402: END IF;
1403: l_oss_vvhist_rec_new.visit_start_date := Fnd_Date.Canonical_To_Date
1404: (p_pei_info_rec_new.pei_information7);
1405: l_oss_vvhist_rec_new.visit_end_date := Fnd_Date.Canonical_To_Date
1406: (p_pei_info_rec_new.pei_information8);
1407: l_oss_vvhist_rec_new.cntry_entry_form_num:= p_pei_info_rec_new.pei_information12;
1408: l_oss_vvhist_rec_new.port_of_entry := p_pei_info_rec_new.pei_information13;
1409:

Line 1632: := Fnd_Date.date_to_canonical(l_oss_pp_rec.passport_expiry_date);

1628: l_person_extra_info_rec.pei_information6
1629: := l_oss_pp_rec.passport_number;
1630: l_person_extra_info_rec.pei_information7 := NULL;
1631: l_person_extra_info_rec.pei_information8
1632: := Fnd_Date.date_to_canonical(l_oss_pp_rec.passport_expiry_date);
1633: -- Check if the passport no. already exists in HRMS, if yes the update
1634: -- that passport number.
1635: OPEN csr_pe_pass (c_person_id => p_person_id
1636: ,c_pp_number => l_oss_pp_rec.passport_number

Line 1783: := Fnd_Date.date_to_canonical(l_visa_rec.visa_issue_date);

1779: EXIT WHEN csr_visa%NOTFOUND;
1780: l_person_extra_info_rec.pei_information5 := l_visa_rec.visa_type;
1781: l_person_extra_info_rec.pei_information6 := l_visa_rec.visa_number;
1782: l_person_extra_info_rec.pei_information7
1783: := Fnd_Date.date_to_canonical(l_visa_rec.visa_issue_date);
1784: l_person_extra_info_rec.pei_information8
1785: := Fnd_Date.date_to_canonical(l_visa_rec.visa_expiry_date);
1786: l_person_extra_info_rec.pei_information9 := '99';
1787: l_person_extra_info_rec.pei_information10 := 'N';

Line 1785: := Fnd_Date.date_to_canonical(l_visa_rec.visa_expiry_date);

1781: l_person_extra_info_rec.pei_information6 := l_visa_rec.visa_number;
1782: l_person_extra_info_rec.pei_information7
1783: := Fnd_Date.date_to_canonical(l_visa_rec.visa_issue_date);
1784: l_person_extra_info_rec.pei_information8
1785: := Fnd_Date.date_to_canonical(l_visa_rec.visa_expiry_date);
1786: l_person_extra_info_rec.pei_information9 := '99';
1787: l_person_extra_info_rec.pei_information10 := 'N';
1788: -- Check if the existing visa is already existing, if yes then update it.
1789: OPEN csr_pe_visa (c_person_id => p_person_id

Line 1913: Fnd_Date.date_to_canonical(l_vv_rec.visit_start_date);

1909: EXIT WHEN csr_visit%NOTFOUND;
1910: l_person_extra_info_rec.pei_information5 := '01';
1911: l_person_extra_info_rec.pei_information11 := l_vv_rec.visa_number;
1912: l_person_extra_info_rec.pei_information7 :=
1913: Fnd_Date.date_to_canonical(l_vv_rec.visit_start_date);
1914: l_person_extra_info_rec.pei_information8 :=
1915: Fnd_Date.date_to_canonical(l_vv_rec.visit_end_date);
1916: l_person_extra_info_rec.pei_information9 := 'N';
1917: l_person_extra_info_rec.pei_information10 := 'N';

Line 1915: Fnd_Date.date_to_canonical(l_vv_rec.visit_end_date);

1911: l_person_extra_info_rec.pei_information11 := l_vv_rec.visa_number;
1912: l_person_extra_info_rec.pei_information7 :=
1913: Fnd_Date.date_to_canonical(l_vv_rec.visit_start_date);
1914: l_person_extra_info_rec.pei_information8 :=
1915: Fnd_Date.date_to_canonical(l_vv_rec.visit_end_date);
1916: l_person_extra_info_rec.pei_information9 := 'N';
1917: l_person_extra_info_rec.pei_information10 := 'N';
1918: l_person_extra_info_rec.pei_information12 := l_vv_rec.cntry_entry_form_num;
1919: l_person_extra_info_rec.pei_information13 := l_vv_rec.port_of_entry;

Line 2716: p_HR_Address_Rec.Date_From := Fnd_Date.Canonical_To_Date(l_valid_col_value);

2712: ,p_style => p_HR_Address_Rec.Style
2713: ,p_col_lookup_type => p_col_lookup_type
2714: ,p_valid_col_value => l_valid_col_value);
2715:
2716: p_HR_Address_Rec.Date_From := Fnd_Date.Canonical_To_Date(l_valid_col_value);
2717:
2718: ELSIF p_column_name = 'DATE_TO' THEN
2719: Check_HR_Validations
2720: (p_column_name => p_column_name

Line 2726: p_HR_Address_Rec.Date_To := Fnd_Date.Canonical_To_Date(l_valid_col_value);

2722: ,p_style => p_HR_Address_Rec.Style
2723: ,p_col_lookup_type => p_col_lookup_type
2724: ,p_valid_col_value => l_valid_col_value);
2725:
2726: p_HR_Address_Rec.Date_To := Fnd_Date.Canonical_To_Date(l_valid_col_value);
2727:
2728: ELSIF p_column_name = 'TELEPHONE_NUMBER_1' THEN
2729: Check_HR_Validations
2730: (p_column_name => p_column_name