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_GSP_RATES dependencies on PQH_GSP_HR_TO_STAGE

Line 101: pqh_gsp_hr_to_stage.get_table_route_details(p_table_alias => 'GRRATE',

97: l_point4_old_value number default null;
98: l_point5_old_value number default null;
99:
100: begin
101: pqh_gsp_hr_to_stage.get_table_route_details(p_table_alias => 'GRRATE',
102: p_table_route_id => l_grr_tr_id,
103: p_table_name => l_grr_tr_name);
104: for i in 1..p_gr_rate_matx.count loop
105: hr_utility.set_location('crset id is '||p_gr_rate_matx(i).crset_id,1);

Line 229: pqh_gsp_hr_to_stage.get_table_route_details(p_table_alias => 'GSRATE',

225: l_point3_old_value number default null;
226: l_point4_old_value number default null;
227: l_point5_old_value number default null;
228: begin
229: pqh_gsp_hr_to_stage.get_table_route_details(p_table_alias => 'GSRATE',
230: p_table_route_id => l_gsr_tr_id,
231: p_table_name => l_gsr_tr_name);
232: for i in 1..p_gs_rate_matx.count loop
233: if p_gs_rate_matx(i).point1_cer_id is not null then

Line 436: pqh_gsp_hr_to_stage.create_abr_row

432: and table_alias = 'HRRATE' -- check hrr row
433: and information278 = p_point_cer_id;
434: if nvl(l_num_pt_rates,0) = 0 then
435: hr_utility.set_location('creating abr for pt',5);
436: pqh_gsp_hr_to_stage.create_abr_row
437: (p_copy_entity_txn_id => p_copy_entity_txn_id,
438: p_start_date => l_rate_st_dt,
439: p_opt_cer_id => p_point_cer_id,
440: p_business_group_id => p_business_group_id,

Line 446: pqh_gsp_hr_to_stage.create_hrrate_row

442: p_abr_cer_id => l_abr_cer_id,
443: p_dml_oper => '');
444: if l_abr_cer_id is not null then
445: hr_utility.set_location('creating hrr for pt',5);
446: pqh_gsp_hr_to_stage.create_hrrate_row
447: (p_copy_entity_txn_id => p_copy_entity_txn_id,
448: p_effective_date => p_effective_date,
449: p_start_date => l_rate_st_dt,
450: p_business_group_id => p_business_group_id,

Line 506: pqh_gsp_hr_to_stage.create_abr_row

502: and information160 = p_crset_id
503: and information278 = p_point_cer_id;
504: if nvl(l_num_pt_rates,0) = 0 then
505: hr_utility.set_location('creating abr for pt',5);
506: pqh_gsp_hr_to_stage.create_abr_row
507: (p_copy_entity_txn_id => p_copy_entity_txn_id,
508: p_start_date => l_rate_st_dt,
509: p_opt_cer_id => p_point_cer_id,
510: p_business_group_id => p_business_group_id,

Line 516: pqh_gsp_hr_to_stage.create_hrrate_row

512: p_abr_cer_id => l_abr_cer_id,
513: p_dml_oper => '');
514: if l_abr_cer_id is not null then
515: hr_utility.set_location('creating hrr for pt',5);
516: pqh_gsp_hr_to_stage.create_hrrate_row
517: (p_copy_entity_txn_id => p_copy_entity_txn_id,
518: p_effective_date => p_effective_date,
519: p_start_date => l_rate_st_dt,
520: p_business_group_id => p_business_group_id,

Line 528: pqh_gsp_hr_to_stage.create_crrate_row

524: p_dml_oper => '',
525: p_hrrate_cer_id => l_hrr_cer_id);
526: if l_hrr_cer_id is not null then
527: hr_utility.set_location('creating crr for pt',5);
528: pqh_gsp_hr_to_stage.create_crrate_row
529: (p_point_cer_id => p_point_cer_id,
530: p_copy_entity_txn_id => p_copy_entity_txn_id,
531: p_business_group_id => p_business_group_id,
532: p_effective_date => l_rate_st_dt,

Line 667: pqh_gsp_hr_to_stage.g_master_txn_id := p_copy_entity_txn_id;

663: PQH_GSP_PROCESS_LOG.START_LOG
664: (P_TXN_ID => p_copy_entity_txn_id,
665: P_TXN_NAME => 'CET_gs_matx : '||p_copy_entity_txn_id,
666: P_MODULE_CD => 'PQH_GSP_BENSTG');
667: pqh_gsp_hr_to_stage.g_master_txn_id := p_copy_entity_txn_id;
668: pqh_gsp_hr_to_stage.g_txn_id := p_copy_entity_txn_id;
669: build_gs_matx(p_copy_entity_txn_id => p_copy_entity_txn_id,
670: p_effective_date => p_effective_date,
671: p_business_group_id => p_business_group_id,

Line 668: pqh_gsp_hr_to_stage.g_txn_id := p_copy_entity_txn_id;

664: (P_TXN_ID => p_copy_entity_txn_id,
665: P_TXN_NAME => 'CET_gs_matx : '||p_copy_entity_txn_id,
666: P_MODULE_CD => 'PQH_GSP_BENSTG');
667: pqh_gsp_hr_to_stage.g_master_txn_id := p_copy_entity_txn_id;
668: pqh_gsp_hr_to_stage.g_txn_id := p_copy_entity_txn_id;
669: build_gs_matx(p_copy_entity_txn_id => p_copy_entity_txn_id,
670: p_effective_date => p_effective_date,
671: p_business_group_id => p_business_group_id,
672: p_context => 'HRR',

Line 703: pqh_gsp_hr_to_stage.g_master_txn_id := p_copy_entity_txn_id;

699: PQH_GSP_PROCESS_LOG.START_LOG
700: (P_TXN_ID => p_copy_entity_txn_id,
701: P_TXN_NAME => 'CET_gr_matx : '||p_copy_entity_txn_id,
702: P_MODULE_CD => 'PQH_GSP_BENSTG');
703: pqh_gsp_hr_to_stage.g_master_txn_id := p_copy_entity_txn_id;
704: pqh_gsp_hr_to_stage.g_txn_id := p_copy_entity_txn_id;
705: build_gs_matx(p_copy_entity_txn_id => p_copy_entity_txn_id,
706: p_effective_date => p_effective_date,
707: p_business_group_id => p_business_group_id,

Line 704: pqh_gsp_hr_to_stage.g_txn_id := p_copy_entity_txn_id;

700: (P_TXN_ID => p_copy_entity_txn_id,
701: P_TXN_NAME => 'CET_gr_matx : '||p_copy_entity_txn_id,
702: P_MODULE_CD => 'PQH_GSP_BENSTG');
703: pqh_gsp_hr_to_stage.g_master_txn_id := p_copy_entity_txn_id;
704: pqh_gsp_hr_to_stage.g_txn_id := p_copy_entity_txn_id;
705: build_gs_matx(p_copy_entity_txn_id => p_copy_entity_txn_id,
706: p_effective_date => p_effective_date,
707: p_business_group_id => p_business_group_id,
708: p_context => 'CRR',

Line 1050: l_start_date := pqh_gsp_hr_to_stage.get_grd_start_date(p_grade_cer_id);

1046: -- hrrate doesnot exist, we have to create it, check abr for the Grade whether that exists or not
1047: hr_utility.set_location('hrrate doesnot exist ',10);
1048: if p_grade_cer_id is not null then
1049: hr_utility.set_location('grade cer is '||p_grade_cer_id,20);
1050: l_start_date := pqh_gsp_hr_to_stage.get_grd_start_date(p_grade_cer_id);
1051: l_abr_cer_id := pqh_gsp_hr_to_stage.get_abr_cer
1052: (p_copy_entity_txn_id => p_copy_entity_txn_id,
1053: p_pl_cer_id => p_grade_cer_id,
1054: p_effective_date => p_rt_effective_date);

Line 1051: l_abr_cer_id := pqh_gsp_hr_to_stage.get_abr_cer

1047: hr_utility.set_location('hrrate doesnot exist ',10);
1048: if p_grade_cer_id is not null then
1049: hr_utility.set_location('grade cer is '||p_grade_cer_id,20);
1050: l_start_date := pqh_gsp_hr_to_stage.get_grd_start_date(p_grade_cer_id);
1051: l_abr_cer_id := pqh_gsp_hr_to_stage.get_abr_cer
1052: (p_copy_entity_txn_id => p_copy_entity_txn_id,
1053: p_pl_cer_id => p_grade_cer_id,
1054: p_effective_date => p_rt_effective_date);
1055: hr_utility.set_location('abr cer is '||l_abr_cer_id,30);

Line 1058: pqh_gsp_hr_to_stage.create_abr_row

1054: p_effective_date => p_rt_effective_date);
1055: hr_utility.set_location('abr cer is '||l_abr_cer_id,30);
1056: if l_abr_cer_id is null then
1057: hr_utility.set_location('going for abr row create ',40);
1058: pqh_gsp_hr_to_stage.create_abr_row
1059: (p_copy_entity_txn_id => p_copy_entity_txn_id,
1060: p_pl_cer_id => p_grade_cer_id,
1061: p_business_group_id => p_business_group_id,
1062: p_effective_date => p_rt_effective_date,

Line 1069: pqh_gsp_hr_to_stage.create_hrrate_row

1065: p_dml_oper => 'INSERT');
1066: hr_utility.set_location('abr cer is '||l_abr_cer_id,50);
1067: end if;
1068: hr_utility.set_location('going for hrrate row create ',60);
1069: pqh_gsp_hr_to_stage.create_hrrate_row
1070: (p_copy_entity_txn_id => p_copy_entity_txn_id,
1071: p_effective_date => p_rt_effective_date,
1072: p_start_date => l_start_date,
1073: p_business_group_id => p_business_group_id,

Line 1139: l_abr_cer_id := pqh_gsp_hr_to_stage.get_abr_cer

1135: -- hrrate doesnot exist, we have to create it, check abr for the Grade whether that exists or not
1136: hr_utility.set_location('hrrate doesnot exist ',10);
1137: if p_point_cer_id is not null then
1138: hr_utility.set_location('grade cer is '||p_point_cer_id,20);
1139: l_abr_cer_id := pqh_gsp_hr_to_stage.get_abr_cer
1140: (p_copy_entity_txn_id => p_copy_entity_txn_id,
1141: p_opt_cer_id => p_point_cer_id,
1142: p_effective_date => p_rt_effective_date);
1143: hr_utility.set_location('abr cer is '||l_abr_cer_id,30);

Line 1146: pqh_gsp_hr_to_stage.create_abr_row

1142: p_effective_date => p_rt_effective_date);
1143: hr_utility.set_location('abr cer is '||l_abr_cer_id,30);
1144: if l_abr_cer_id is null then
1145: hr_utility.set_location('going for abr row create ',40);
1146: pqh_gsp_hr_to_stage.create_abr_row
1147: (p_copy_entity_txn_id => p_copy_entity_txn_id,
1148: p_start_date => l_start_date,
1149: p_opt_cer_id => p_point_cer_id,
1150: p_business_group_id => p_business_group_id,

Line 1157: pqh_gsp_hr_to_stage.create_hrrate_row

1153: p_dml_oper => 'INSERT');
1154: hr_utility.set_location('abr cer is '||l_abr_cer_id,50);
1155: end if;
1156: hr_utility.set_location('going for hrrate row create ',60);
1157: pqh_gsp_hr_to_stage.create_hrrate_row
1158: (p_copy_entity_txn_id => p_copy_entity_txn_id,
1159: p_start_date => l_start_date,
1160: p_effective_date => p_rt_effective_date,
1161: p_business_group_id => p_business_group_id,

Line 1216: l_hrrate_exists := pqh_gsp_hr_to_stage.is_hrrate_for_abr_exists

1212: l_hrr_cer_ovn number;
1213: l_grd_cer_id number;
1214: l_continue boolean := TRUE;
1215: begin
1216: l_hrrate_exists := pqh_gsp_hr_to_stage.is_hrrate_for_abr_exists
1217: (p_copy_entity_txn_id => p_copy_entity_txn_id,
1218: p_abr_id => p_abr_id);
1219: if not l_hrrate_exists then
1220: hr_utility.set_location('hrrate doesnot exist for abr'||p_abr_id,10);

Line 1222: pqh_gsp_hr_to_stage.get_table_route_details

1218: p_abr_id => p_abr_id);
1219: if not l_hrrate_exists then
1220: hr_utility.set_location('hrrate doesnot exist for abr'||p_abr_id,10);
1221: -- get the table route id and table alias
1222: pqh_gsp_hr_to_stage.get_table_route_details
1223: (p_table_alias => 'HRRATE',
1224: p_table_route_id => l_hrr_tr_id,
1225: p_table_name => l_hrr_tr_name);
1226: hr_utility.set_location('hrrate tr name'||l_hrr_tr_name,20);

Line 1227: l_grd_cer_id := pqh_gsp_hr_to_stage.is_grd_exists_in_txn

1223: (p_table_alias => 'HRRATE',
1224: p_table_route_id => l_hrr_tr_id,
1225: p_table_name => l_hrr_tr_name);
1226: hr_utility.set_location('hrrate tr name'||l_hrr_tr_name,20);
1227: l_grd_cer_id := pqh_gsp_hr_to_stage.is_grd_exists_in_txn
1228: (p_copy_entity_txn_id => p_copy_entity_txn_id,
1229: p_grd_id => p_grade_id);
1230: if l_grd_cer_id is null then
1231: hr_utility.set_location('grade doesnot exist in stage'||p_grade_id,30);

Line 1310: l_hrrate_exists := pqh_gsp_hr_to_stage.is_hrrate_for_abr_exists

1306: l_hrr_cer_ovn number;
1307: l_continue boolean := TRUE;
1308: l_point_cer_id number;
1309: begin
1310: l_hrrate_exists := pqh_gsp_hr_to_stage.is_hrrate_for_abr_exists
1311: (p_copy_entity_txn_id => p_copy_entity_txn_id,
1312: p_abr_id => p_abr_id);
1313: if not l_hrrate_exists then
1314: -- get the table route id and table alias

Line 1315: pqh_gsp_hr_to_stage.get_table_route_details

1311: (p_copy_entity_txn_id => p_copy_entity_txn_id,
1312: p_abr_id => p_abr_id);
1313: if not l_hrrate_exists then
1314: -- get the table route id and table alias
1315: pqh_gsp_hr_to_stage.get_table_route_details
1316: (p_table_alias => 'HRRATE',
1317: p_table_route_id => l_hrr_tr_id,
1318: p_table_name => l_hrr_tr_name);
1319: hr_utility.set_location('hrrate tr name'||l_hrr_tr_name,50);

Line 1320: l_point_cer_id := pqh_gsp_hr_to_stage.is_point_exists_in_txn

1316: (p_table_alias => 'HRRATE',
1317: p_table_route_id => l_hrr_tr_id,
1318: p_table_name => l_hrr_tr_name);
1319: hr_utility.set_location('hrrate tr name'||l_hrr_tr_name,50);
1320: l_point_cer_id := pqh_gsp_hr_to_stage.is_point_exists_in_txn
1321: (p_copy_entity_txn_id => p_copy_entity_txn_id,
1322: p_point_id => p_point_id);
1323: if l_point_cer_id is null then
1324: hr_utility.set_location('point doesnot exist in stage'||p_point_id,30);

Line 1484: pqh_gsp_hr_to_stage.create_crrate_row

1480:
1481: end if;
1482: if l_ins_row ='Y' then
1483: hr_utility.set_location('eot is '||to_char(l_eot,'dd-mm-RRRR'),14);
1484: pqh_gsp_hr_to_stage.create_crrate_row
1485: (p_effective_date => p_effective_date,
1486: p_copy_entity_txn_id => p_copy_entity_txn_id,
1487: p_grade_cer_id => p_grade_cer_id,
1488: p_point_cer_id => p_point_cer_id,

Line 1530: pqh_gsp_hr_to_stage.get_table_route_details

1526: l_gsr_tr_name varchar2(30);
1527: l_gsr_cer_ovn number;
1528: l_continue boolean := TRUE;
1529: begin
1530: pqh_gsp_hr_to_stage.get_table_route_details
1531: (p_table_alias => 'GSRATE',
1532: p_table_route_id => l_gsr_tr_id,
1533: p_table_name => l_gsr_tr_name);
1534: hr_utility.set_location('gsr tr name'||l_gsr_tr_name,20);

Line 1612: pqh_gsp_hr_to_stage.get_table_route_details

1608: l_grr_tr_name varchar2(30);
1609: l_grr_cer_ovn number;
1610: l_continue boolean := TRUE;
1611: begin
1612: pqh_gsp_hr_to_stage.get_table_route_details
1613: (p_table_alias => 'GRRATE',
1614: p_table_route_id => l_grr_tr_id,
1615: p_table_name => l_grr_tr_name);
1616: hr_utility.set_location('grr tr name'||l_grr_tr_name,20);