APPS.PQH_CPD_HR_TO_STAGE dependencies on PQH_CORPS_EXTRA_INFO_API

Line 833: pqh_corps_extra_info_api.create_corps_extra_info

829: end if;
830: if cdd_rec.dml_operation ='INSERT'
831: and l_cdd_id is null
832: and l_cpd_id is not null then
833: pqh_corps_extra_info_api.create_corps_extra_info
834: (p_effective_date => p_effective_date
835: ,p_corps_extra_info_id => l_cdd_id
836: ,p_corps_definition_id => l_cpd_id
837: ,p_information_type => 'DOCUMENT'

Line 861: pqh_corps_extra_info_api.update_corps_extra_info

857: fnd_message.set_token('OBJECT ',l_object);
858: fnd_message.set_token('OBJECT_NAME ',substr(cdd_rec.information113,1,30));
859: fnd_message.raise_error;
860: else
861: pqh_corps_extra_info_api.update_corps_extra_info
862: (p_effective_date => p_effective_date
863: ,p_corps_extra_info_id => l_cdd_id
864: ,p_corps_definition_id => l_cpd_id
865: ,p_information3 => cdd_rec.information111

Line 876: pqh_corps_extra_info_api.delete_corps_extra_info

872: end if;
873: elsif cdd_rec.dml_operation ='DELETE'
874: and l_cdd_id is not null
875: and l_cdd_ovn is not null then
876: pqh_corps_extra_info_api.delete_corps_extra_info
877: (p_corps_extra_info_id => l_cdd_id
878: ,p_object_version_number => l_cdd_ovn);
879: else
880: l_message_text := 'invalid dml_oper'||cdd_rec.dml_operation

Line 968: pqh_corps_extra_info_api.create_corps_extra_info(

964: begin
965: open c1;
966: fetch c1 into l_cei_id;
967: if c1%notfound then
968: pqh_corps_extra_info_api.create_corps_extra_info(
969: p_effective_date => p_effective_date
970: ,p_corps_extra_info_id => l_cei_id
971: ,p_corps_definition_id => p_corps_definition_id
972: ,p_information_type => 'FILERE'

Line 1393: pqh_corps_extra_info_api.create_corps_extra_info(

1389: l_comp_grd := build_comb_for_grd(p_comb_plip => p_comb_grades);
1390: end if;
1391: if p_corps_extra_info_id is null then
1392: hr_utility.set_location('insert grd quota ',10);
1393: pqh_corps_extra_info_api.create_corps_extra_info(
1394: p_effective_date => p_effective_date
1395: ,p_corps_extra_info_id => l_cei_id
1396: ,p_corps_definition_id => p_corps_definition_id
1397: ,p_information_type => 'GRADE'

Line 1412: pqh_corps_extra_info_api.update_corps_extra_info(

1408: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'PQH_CORPS_EXTRA_INFO',
1409: p_key_column_name => 'CORPS_EXTRA_INFO_ID',
1410: p_key_column_value => p_corps_extra_info_id);
1411: hr_utility.set_location(' ovn is '||l_db_ovn,30);
1412: pqh_corps_extra_info_api.update_corps_extra_info(
1413: p_effective_date => p_effective_date
1414: ,p_corps_extra_info_id => p_corps_extra_info_id
1415: ,p_corps_definition_id => p_corps_definition_id
1416: ,p_information_type => 'GRADE'