DBA Data[Home] [Help]

APPS.PQP_HROSS_INTEGRATION dependencies on PQP_HRTCA_INTEGRATION

Line 1007: Pqp_Hrtca_Integration.Person_Address_Api

1003: FETCH csr_add INTO l_cur_add_rec;
1004:
1005: IF csr_add%NOTFOUND THEN
1006: hr_utility.set_location(' Primary Address Not found', 20);
1007: Pqp_Hrtca_Integration.Person_Address_Api
1008: (p_HR_Address_Rec => l_add_rec
1009: ,p_validate => FALSE
1010: ,p_action => 'CREATE'
1011: ,p_effective_date => p_effective_date

Line 1025: Pqp_Hrtca_Integration.Person_Address_Api

1021: IF Trunc(l_cur_add_rec.date_from) = Trunc(p_effective_date) THEN
1022: l_add_rec.address_id := l_cur_add_rec.address_id;
1023: l_add_rec.object_version_number := l_cur_add_rec.object_version_number;
1024: l_add_rec.style := l_cur_add_rec.style;
1025: Pqp_Hrtca_Integration.Person_Address_Api
1026: (p_HR_Address_Rec => l_add_rec
1027: ,p_validate => FALSE
1028: ,p_action => 'UPDATE'
1029: ,p_effective_date => p_effective_date

Line 1041: Pqp_Hrtca_Integration.Person_Address_Api

1037: hr_utility.set_location(' l_add_rec.date_from: ' ||
1038: l_add_rec.date_from, 40);
1039: hr_utility.set_location(' l_add_rec.date_to: ' ||
1040: l_add_rec.date_to, 40);
1041: Pqp_Hrtca_Integration.Person_Address_Api
1042: (p_HR_Address_Rec => l_add_rec
1043: ,p_validate => FALSE
1044: ,p_action => 'CREATE'
1045: ,p_effective_date => p_effective_date

Line 6254: Pqp_Hrtca_Integration.InsUpd_InHR_PassPort

6250: , p_crt_cntct_out=>l_crt_emp_api_out);
6251: END IF; -- }
6252: IF g_leg_code = 'US' THEN
6253: -- Get Passport details from OSS
6254: Pqp_Hrtca_Integration.InsUpd_InHR_PassPort
6255: (p_business_group_id => l_per_rec.business_group_id
6256: ,p_person_id => l_per_rec.person_id
6257: ,p_party_id => l_per_rec.party_id
6258: ,p_effective_date => l_per_rec.start_date

Line 6263: Pqp_Hrtca_Integration.InsUpd_InHR_Visa

6259: ,p_pp_error_code => l_pp_error_code
6260: ,p_passport_warning => l_passport_warning
6261: );
6262: -- Get Visa Details from OSS
6263: Pqp_Hrtca_Integration.InsUpd_InHR_Visa
6264: (p_business_group_id => l_per_rec.business_group_id
6265: ,p_person_id => l_per_rec.person_id
6266: ,p_party_id => l_per_rec.party_id
6267: ,p_effective_date => l_per_rec.start_date

Line 6272: Pqp_Hrtca_Integration.InsUpd_InHR_Visit

6268: ,p_visa_error_code => l_visa_error_code
6269: ,p_visa_warning => l_visa_warning
6270: );
6271: -- Get Visit History details from OSS
6272: Pqp_Hrtca_Integration.InsUpd_InHR_Visit
6273: (p_business_group_id => l_per_rec.business_group_id
6274: ,p_person_id => l_per_rec.person_id
6275: ,p_party_id => l_per_rec.party_id
6276: ,p_effective_date => l_per_rec.start_date

Line 6286: Pqp_Hrtca_Integration.InsUpd_InHR_OSSPerDtls

6282: IF l_student_number IS NOT NULL THEN -- {
6283: hr_utility.set_location('Updating Extra Info', 250);
6284: hr_utility.set_location('Error Code ' ||
6285: l_oss_error_code, 255);
6286: Pqp_Hrtca_Integration.InsUpd_InHR_OSSPerDtls
6287: (p_business_group_id => l_per_rec.business_group_id
6288: ,p_person_id => l_per_rec.person_id
6289: ,p_party_id => l_per_rec.party_id
6290: ,p_effective_date => l_per_rec.start_date

Line 6379: Pqp_Hrtca_Integration.InsUpd_InHR_PassPort

6375: ,p_crt_cntct_out => l_crt_emp_api_out);
6376: END IF; -- }
6377: IF g_leg_code = 'US' THEN
6378: -- Get Passport details from OSS
6379: Pqp_Hrtca_Integration.InsUpd_InHR_PassPort
6380: (p_business_group_id => l_per_rec.business_group_id
6381: ,p_person_id => l_per_rec.person_id
6382: ,p_party_id => l_per_rec.party_id
6383: ,p_effective_date => l_per_rec.start_date

Line 6388: Pqp_Hrtca_Integration.InsUpd_InHR_Visa

6384: ,p_pp_error_code => l_pp_error_code
6385: ,p_passport_warning => l_passport_warning
6386: );
6387: -- Get Visa Details from OSS
6388: Pqp_Hrtca_Integration.InsUpd_InHR_Visa
6389: (p_business_group_id => l_per_rec.business_group_id
6390: ,p_person_id => l_per_rec.person_id
6391: ,p_party_id => l_per_rec.party_id
6392: ,p_effective_date => l_per_rec.start_date

Line 6397: Pqp_Hrtca_Integration.InsUpd_InHR_Visit

6393: ,p_visa_error_code => l_visa_error_code
6394: ,p_visa_warning => l_visa_warning
6395: );
6396: -- Get Visit History details from OSS
6397: Pqp_Hrtca_Integration.InsUpd_InHR_Visit
6398: (p_business_group_id => l_per_rec.business_group_id
6399: ,p_person_id => l_per_rec.person_id
6400: ,p_party_id => l_per_rec.party_id
6401: ,p_effective_date => l_per_rec.start_date

Line 6409: Pqp_Hrtca_Integration.InsUpd_InHR_OSSPerDtls

6405: END IF;
6406: IF l_student_number IS NOT NULL THEN -- {
6407: -- Create People Exra Information
6408: hr_utility.set_location('Updating Extra Info' , 330);
6409: Pqp_Hrtca_Integration.InsUpd_InHR_OSSPerDtls
6410: (p_business_group_id => l_per_rec.business_group_id
6411: ,p_person_id => l_per_rec.person_id
6412: ,p_party_id => l_per_rec.party_id
6413: ,p_effective_date => l_per_rec.start_date

Line 6520: Pqp_Hrtca_Integration.InsUpd_InHR_PassPort

6516: hr_utility.set_location('Updated Asg criteria' , 310);
6517:
6518: IF g_leg_code = 'US' THEN
6519: -- Get Passport details from OSS
6520: Pqp_Hrtca_Integration.InsUpd_InHR_PassPort
6521: (p_business_group_id => l_per_rec.business_group_id
6522: ,p_person_id => l_per_rec.person_id
6523: ,p_party_id => l_per_rec.party_id
6524: ,p_effective_date => l_per_rec.start_date

Line 6529: Pqp_Hrtca_Integration.InsUpd_InHR_Visa

6525: ,p_pp_error_code => l_pp_error_code
6526: ,p_passport_warning => l_passport_warning
6527: );
6528: -- Get Visa Details from OSS
6529: Pqp_Hrtca_Integration.InsUpd_InHR_Visa
6530: (p_business_group_id => l_per_rec.business_group_id
6531: ,p_person_id => l_per_rec.person_id
6532: ,p_party_id => l_per_rec.party_id
6533: ,p_effective_date => l_per_rec.start_date

Line 6538: Pqp_Hrtca_Integration.InsUpd_InHR_Visit

6534: ,p_visa_error_code => l_visa_error_code
6535: ,p_visa_warning => l_visa_warning
6536: );
6537: -- Get Visit History details from OSS
6538: Pqp_Hrtca_Integration.InsUpd_InHR_Visit
6539: (p_business_group_id => l_per_rec.business_group_id
6540: ,p_person_id => l_per_rec.person_id
6541: ,p_party_id => l_per_rec.party_id
6542: ,p_effective_date => l_per_rec.start_date

Line 6550: Pqp_Hrtca_Integration.InsUpd_InHR_OSSPerDtls

6546: END IF;
6547: IF l_student_number IS NOT NULL THEN
6548: -- Create People Exra Information
6549: hr_utility.set_location('Updating Extra Info' , 330);
6550: Pqp_Hrtca_Integration.InsUpd_InHR_OSSPerDtls
6551: (p_business_group_id => l_per_rec.business_group_id
6552: ,p_person_id => l_per_rec.person_id
6553: ,p_party_id => l_per_rec.party_id
6554: ,p_effective_date => l_per_rec.start_date

Line 6631: Pqp_Hrtca_Integration.InsUpd_InHR_PassPort

6627: hr_utility.set_location('Updated Asg criteria' , 310);
6628:
6629: IF g_leg_code = 'US' THEN
6630: -- Get Passport details from OSS
6631: Pqp_Hrtca_Integration.InsUpd_InHR_PassPort
6632: (p_business_group_id => l_per_rec.business_group_id
6633: ,p_person_id => l_per_rec.person_id
6634: ,p_party_id => l_per_rec.party_id
6635: ,p_effective_date => l_per_rec.start_date

Line 6640: Pqp_Hrtca_Integration.InsUpd_InHR_Visa

6636: ,p_pp_error_code => l_pp_error_code
6637: ,p_passport_warning => l_passport_warning
6638: );
6639: -- Get Visa Details from OSS
6640: Pqp_Hrtca_Integration.InsUpd_InHR_Visa
6641: (p_business_group_id => l_per_rec.business_group_id
6642: ,p_person_id => l_per_rec.person_id
6643: ,p_party_id => l_per_rec.party_id
6644: ,p_effective_date => l_per_rec.start_date

Line 6649: Pqp_Hrtca_Integration.InsUpd_InHR_Visit

6645: ,p_visa_error_code => l_visa_error_code
6646: ,p_visa_warning => l_visa_warning
6647: );
6648: -- Get Visit History details from OSS
6649: Pqp_Hrtca_Integration.InsUpd_InHR_Visit
6650: (p_business_group_id => l_per_rec.business_group_id
6651: ,p_person_id => l_per_rec.person_id
6652: ,p_party_id => l_per_rec.party_id
6653: ,p_effective_date => l_per_rec.start_date

Line 6661: Pqp_Hrtca_Integration.InsUpd_InHR_OSSPerDtls

6657: END IF;
6658: IF l_student_number IS NOT NULL THEN -- {
6659: -- Create People Exra Information
6660: hr_utility.set_location('Updating Extra Info' , 330);
6661: Pqp_Hrtca_Integration.InsUpd_InHR_OSSPerDtls
6662: (p_business_group_id => l_per_rec.business_group_id
6663: ,p_person_id => l_per_rec.person_id
6664: ,p_party_id => l_per_rec.party_id
6665: ,p_effective_date => l_per_rec.start_date

Line 7266: Pqp_Hrtca_Integration.InsUpd_InHR_PassPort

7262: );
7263: END IF;
7264: IF g_leg_code = 'US' THEN
7265: -- Get Passport details from OSS
7266: Pqp_Hrtca_Integration.InsUpd_InHR_PassPort
7267: (p_business_group_id => p_business_group_id
7268: ,p_person_id => l_per_rec.person_id
7269: ,p_party_id => p_party_id
7270: ,p_effective_date => l_effective_date

Line 7275: Pqp_Hrtca_Integration.InsUpd_InHR_Visa

7271: ,p_pp_error_code => l_pp_error_code
7272: ,p_passport_warning => l_passport_warning
7273: );
7274: -- Get Visa Details from OSS
7275: Pqp_Hrtca_Integration.InsUpd_InHR_Visa
7276: (p_business_group_id => p_business_group_id
7277: ,p_person_id => l_per_rec.person_id
7278: ,p_party_id => p_party_id
7279: ,p_effective_date => l_effective_date

Line 7284: Pqp_Hrtca_Integration.InsUpd_InHR_Visit

7280: ,p_visa_error_code => l_visa_error_code
7281: ,p_visa_warning => l_visa_warning
7282: );
7283: -- Get Visit History details from OSS
7284: Pqp_Hrtca_Integration.InsUpd_InHR_Visit
7285: (p_business_group_id => p_business_group_id
7286: ,p_person_id => l_per_rec.person_id
7287: ,p_party_id => p_party_id
7288: ,p_effective_date => l_effective_date

Line 7295: Pqp_Hrtca_Integration.InsUpd_InHR_OSSPerDtls

7291: );
7292: END IF;
7293: -- Create the Person EIT to specify the person as an
7294: -- OSS Person along with the Person number, party id.
7295: Pqp_Hrtca_Integration.InsUpd_InHR_OSSPerDtls
7296: (p_business_group_id => p_business_group_id
7297: ,p_person_id => l_per_rec.person_id
7298: ,p_party_id => p_party_id
7299: ,p_effective_date => l_effective_date

Line 7373: Pqp_Hrtca_Integration.InsUpd_InHR_PassPort

7369: );
7370: END IF;
7371: IF g_leg_code = 'US' THEN
7372: -- Get Passport details from OSS
7373: Pqp_Hrtca_Integration.InsUpd_InHR_PassPort
7374: (p_business_group_id => p_business_group_id
7375: ,p_person_id => l_per_rec.person_id
7376: ,p_party_id => p_party_id
7377: ,p_effective_date => l_effective_date

Line 7382: Pqp_Hrtca_Integration.InsUpd_InHR_Visa

7378: ,p_pp_error_code => l_pp_error_code
7379: ,p_passport_warning => l_passport_warning
7380: );
7381: -- Get Visa Details from OSS
7382: Pqp_Hrtca_Integration.InsUpd_InHR_Visa
7383: (p_business_group_id => p_business_group_id
7384: ,p_person_id => l_per_rec.person_id
7385: ,p_party_id => p_party_id
7386: ,p_effective_date => l_effective_date

Line 7391: Pqp_Hrtca_Integration.InsUpd_InHR_Visit

7387: ,p_visa_error_code => l_visa_error_code
7388: ,p_visa_warning => l_visa_warning
7389: );
7390: -- Get Visit History details from OSS
7391: Pqp_Hrtca_Integration.InsUpd_InHR_Visit
7392: (p_business_group_id => p_business_group_id
7393: ,p_person_id => l_per_rec.person_id
7394: ,p_party_id => p_party_id
7395: ,p_effective_date => l_effective_date

Line 7402: Pqp_Hrtca_Integration.InsUpd_InHR_OSSPerDtls

7398: );
7399: END IF;
7400: -- Create the Person EIT to specify the person as an
7401: -- OSS Person along with the Person number, party id.
7402: Pqp_Hrtca_Integration.InsUpd_InHR_OSSPerDtls
7403: (p_business_group_id => p_business_group_id
7404: ,p_person_id => l_per_rec.person_id
7405: ,p_party_id => p_party_id
7406: ,p_effective_date => l_effective_date

Line 7483: Pqp_Hrtca_Integration.InsUpd_InHR_PassPort

7479: END IF;
7480:
7481: IF g_leg_code = 'US' THEN
7482: -- Get Passport details from OSS
7483: Pqp_Hrtca_Integration.InsUpd_InHR_PassPort
7484: (p_business_group_id => p_business_group_id
7485: ,p_person_id => l_per_rec.person_id
7486: ,p_party_id => p_party_id
7487: ,p_effective_date => l_effective_date

Line 7492: Pqp_Hrtca_Integration.InsUpd_InHR_Visa

7488: ,p_pp_error_code => l_pp_error_code
7489: ,p_passport_warning => l_passport_warning
7490: );
7491: -- Get Visa Details from OSS
7492: Pqp_Hrtca_Integration.InsUpd_InHR_Visa
7493: (p_business_group_id => p_business_group_id
7494: ,p_person_id => l_per_rec.person_id
7495: ,p_party_id => p_party_id
7496: ,p_effective_date => l_effective_date

Line 7501: Pqp_Hrtca_Integration.InsUpd_InHR_Visit

7497: ,p_visa_error_code => l_visa_error_code
7498: ,p_visa_warning => l_visa_warning
7499: );
7500: -- Get Visit History details from OSS
7501: Pqp_Hrtca_Integration.InsUpd_InHR_Visit
7502: (p_business_group_id => p_business_group_id
7503: ,p_person_id => l_per_rec.person_id
7504: ,p_party_id => p_party_id
7505: ,p_effective_date => l_effective_date

Line 7513: Pqp_Hrtca_Integration.InsUpd_InHR_OSSPerDtls

7509: END IF;
7510:
7511: -- Create the Person EIT to specify the person as an
7512: -- OSS Person along with the Person number, party id.
7513: Pqp_Hrtca_Integration.InsUpd_InHR_OSSPerDtls
7514: (p_business_group_id => p_business_group_id
7515: ,p_person_id => l_per_rec.person_id
7516: ,p_party_id => p_party_id
7517: ,p_effective_date => l_effective_date

Line 7568: Pqp_Hrtca_Integration.InsUpd_InHR_PassPort

7564:
7565: IF g_leg_code = 'US' AND
7566: p_mode_type <> 'UPDATE' THEN
7567: -- Get Passport details from OSS
7568: Pqp_Hrtca_Integration.InsUpd_InHR_PassPort
7569: (p_business_group_id => p_business_group_id
7570: ,p_person_id => l_per_rec.person_id
7571: ,p_party_id => p_party_id
7572: ,p_effective_date => l_effective_date

Line 7577: Pqp_Hrtca_Integration.InsUpd_InHR_Visa

7573: ,p_pp_error_code => l_pp_error_code
7574: ,p_passport_warning => l_passport_warning
7575: );
7576: -- Get Visa Details from OSS
7577: Pqp_Hrtca_Integration.InsUpd_InHR_Visa
7578: (p_business_group_id => p_business_group_id
7579: ,p_person_id => l_per_rec.person_id
7580: ,p_party_id => p_party_id
7581: ,p_effective_date => l_effective_date

Line 7586: Pqp_Hrtca_Integration.InsUpd_InHR_Visit

7582: ,p_visa_error_code => l_visa_error_code
7583: ,p_visa_warning => l_visa_warning
7584: );
7585: -- Get Visit History details from OSS
7586: Pqp_Hrtca_Integration.InsUpd_InHR_Visit
7587: (p_business_group_id => p_business_group_id
7588: ,p_person_id => l_per_rec.person_id
7589: ,p_party_id => p_party_id
7590: ,p_effective_date => l_effective_date

Line 7597: Pqp_Hrtca_Integration.InsUpd_InHR_OSSPerDtls

7593: );
7594:
7595: -- Create the Person EIT to specify the person as an
7596: -- OSS Person along with the Person number, party id.
7597: Pqp_Hrtca_Integration.InsUpd_InHR_OSSPerDtls
7598: (p_business_group_id => p_business_group_id
7599: ,p_person_id => l_per_rec.person_id
7600: ,p_party_id => p_party_id
7601: ,p_effective_date => l_effective_date