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.PQH_CPD_HR_TO_STAGE dependencies on PQH_CORPS_EXTRA_INFO

Line 155: l_comb_grade pqh_corps_extra_info.information30%type;

151: p_comb_grade in varchar2) return varchar2 is
152: l_grade_id number;
153: l_plip_cer_id number;
154: l_grade_pos number;
155: l_comb_grade pqh_corps_extra_info.information30%type;
156: l_comb_plip_cer pqh_corps_extra_info.information30%type;
157: cursor get_plip_cer (p_grade_id number)is
158: select plip.copy_entity_result_id
159: from ben_copy_entity_results plip, ben_copy_entity_results pln

Line 156: l_comb_plip_cer pqh_corps_extra_info.information30%type;

152: l_grade_id number;
153: l_plip_cer_id number;
154: l_grade_pos number;
155: l_comb_grade pqh_corps_extra_info.information30%type;
156: l_comb_plip_cer pqh_corps_extra_info.information30%type;
157: cursor get_plip_cer (p_grade_id number)is
158: select plip.copy_entity_result_id
159: from ben_copy_entity_results plip, ben_copy_entity_results pln
160: where plip.table_alias = 'CPP' -- plip row

Line 207: l_comb_grade pqh_corps_extra_info.information30%type;

203: function build_comb_for_grd(p_comb_plip in varchar2) return varchar2 is
204: l_grade_id number;
205: l_plip_cer_id number;
206: l_plip_pos number;
207: l_comb_grade pqh_corps_extra_info.information30%type;
208: l_comb_plip pqh_corps_extra_info.information30%type;
209: cursor get_grade(p_plip_cer_id number)is
210: select information253
211: from ben_copy_entity_results

Line 208: l_comb_plip pqh_corps_extra_info.information30%type;

204: l_grade_id number;
205: l_plip_cer_id number;
206: l_plip_pos number;
207: l_comb_grade pqh_corps_extra_info.information30%type;
208: l_comb_plip pqh_corps_extra_info.information30%type;
209: cursor get_grade(p_plip_cer_id number)is
210: select information253
211: from ben_copy_entity_results
212: where copy_entity_result_id = p_plip_cer_id;

Line 258: l_comb_grade pqh_corps_extra_info.information30%type;

254: p_comb_grade out nocopy varchar2,
255: p_max_speed_quota out nocopy number,
256: p_avg_speed_quota out nocopy number,
257: p_corps_extra_info_id out nocopy number) is
258: l_comb_grade pqh_corps_extra_info.information30%type;
259: cursor c1 is
260: SELECT corps_extra_info_id,information4,information6,information7,information8,information30
261: FROM pqh_corps_extra_info
262: where information_type ='GRADE'

Line 261: FROM pqh_corps_extra_info

257: p_corps_extra_info_id out nocopy number) is
258: l_comb_grade pqh_corps_extra_info.information30%type;
259: cursor c1 is
260: SELECT corps_extra_info_id,information4,information6,information7,information8,information30
261: FROM pqh_corps_extra_info
262: where information_type ='GRADE'
263: and corps_definition_id = p_corps_definition_id
264: and to_number(information3) = p_grade_id;
265: begin

Line 444: from pqh_corps_extra_info

440: l_cdd_cer_ovn number;
441: l_continue boolean := TRUE;
442: cursor csr_cdd_rec is
443: select *
444: from pqh_corps_extra_info
445: where corps_definition_id = p_corps_definition_id
446: and information_type = 'DOCUMENT';
447: begin
448: hr_utility.set_location('inside cdd create',10);

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 850: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'PQH_CORPS_EXTRA_INFO',

846: and l_cdd_id is not null
847: and l_cdd_ovn is not null
848: and l_cpd_id is not null then
849: hr_utility.set_location(' dt mode is '||p_datetrack_mode,30);
850: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'PQH_CORPS_EXTRA_INFO',
851: p_key_column_name => 'CORPS_EXTRA_INFO_ID',
852: p_key_column_value => l_cdd_id);
853: hr_utility.set_location(' ovn is '||l_db_ovn,30);
854: if l_db_ovn <> l_cdd_ovn then

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 958: from pqh_corps_extra_info

954: procedure pop_pri_filiere(p_corps_definition_id in number,
955: p_filiere_id in number,
956: p_effective_date in date) is
957: cursor c1 is select corps_extra_info_id
958: from pqh_corps_extra_info
959: where corps_definition_id = p_corps_definition_id
960: and information4 = p_filiere_id
961: and information_type = 'FILERE';
962: l_cei_id number;

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 1408: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'PQH_CORPS_EXTRA_INFO',

1404: ,p_object_version_number => l_db_ovn
1405: );
1406: else
1407: hr_utility.set_location('update grd quota',10);
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(

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'