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.PER_QH_TIMELINE dependencies on HR_UTILITY

Line 40: hr_utility.set_location('Entering: '||l_proc,10);

36: l_proc varchar2(72):=g_package||'get_dates';
37: --
38: begin
39: --
40: hr_utility.set_location('Entering: '||l_proc,10);
41: --
42: l_date_string:='to_date('''
43: ||to_char(p_effective_date,'DDMMYYYY')||
44: ''',''DDMMYYYY'')';

Line 46: hr_utility.set_location(l_proc,20);

42: l_date_string:='to_date('''
43: ||to_char(p_effective_date,'DDMMYYYY')||
44: ''',''DDMMYYYY'')';
45: --
46: hr_utility.set_location(l_proc,20);
47: --
48: -- look for the column name.
49: --
50: if P_FIELD='MAINTAIN.PERSON_TYPE' then

Line 929: hr_utility.set_location(l_proc,100);

925: l_type:='V';
926: l_sub_query:=null;
927: END IF;
928: --
929: hr_utility.set_location(l_proc,100);
930: --
931: if(l_type='V') then
932: l_select_stmt:='select '||l_column;
933: elsif(l_type='N') then

Line 939: hr_utility.set_location(l_proc,110);

935: elsif(l_type='D') then
936: l_select_stmt:='select fnd_date.date_to_display_date('||l_column||')';
937: end if;
938: --
939: hr_utility.set_location(l_proc,110);
940: --
941: if ((l_table='PER_ALL_PEOPLE_F') or (l_table='PER_PERSON_TYPE_USAGES_F')) then
942: l_primary_key_name:='PERSON_ID';
943: l_primary_key:=NVL(p_person_id,hr_api.g_number);

Line 972: hr_utility.set_location(l_proc,120);

968: end if;
969: --
970: l_select_stmt:=l_select_stmt||' order by effective_start_date';
971: --
972: hr_utility.set_location(l_proc,120);
973: --
974: i:=1;
975: OPEN date_cv FOR l_select_stmt;
976: FETCH date_cv into l_date_rec;

Line 979: hr_utility.set_location(l_proc,130);

975: OPEN date_cv FOR l_select_stmt;
976: FETCH date_cv into l_date_rec;
977: if date_cv%FOUND then
978: --
979: hr_utility.set_location(l_proc,130);
980: --
981: date_start:=l_date_rec.start_date;
982: date_end:=l_date_rec.end_date;
983: val_old:=l_date_rec.value;

Line 989: hr_utility.set_location(l_proc,140);

985: FETCH date_cv into l_date_rec;
986: EXIT when date_cv%NOTFOUND;
987: val_new:=l_date_rec.value;
988: --
989: hr_utility.set_location(l_proc,140);
990: --
991: if( nvl(val_new,hr_api.g_varchar2)<>nvl(val_old,hr_api.g_varchar2) ) then
992: --
993: hr_utility.set_location(l_proc,150);

Line 993: hr_utility.set_location(l_proc,150);

989: hr_utility.set_location(l_proc,140);
990: --
991: if( nvl(val_new,hr_api.g_varchar2)<>nvl(val_old,hr_api.g_varchar2) ) then
992: --
993: hr_utility.set_location(l_proc,150);
994: --
995: records(i).start_date:=date_start;
996: records(i).end_date:=date_end;
997: if l_sub_query is not null and val_old is not null then

Line 1011: hr_utility.set_location(l_proc,160);

1007: date_end:=l_date_rec.end_date;
1008: val_old:=val_new;
1009: END LOOP;
1010: --
1011: hr_utility.set_location(l_proc,160);
1012: --
1013: records(i).start_date:=date_start;
1014: records(i).end_date:=date_end;
1015: if l_sub_query is not null and val_old is not null then

Line 1025: hr_utility.set_location('Leaving '||l_proc,200);

1021: end if;
1022: end if;
1023: CLOSE date_cv;
1024: --
1025: hr_utility.set_location('Leaving '||l_proc,200);
1026: --
1027: end get_dates;
1028:
1029: procedure get_first_date

Line 1047: hr_utility.set_location('Entering: '||l_proc,10);

1043: l_proc varchar2(72):=g_package||'get_first_date';
1044: --
1045: begin
1046: --
1047: hr_utility.set_location('Entering: '||l_proc,10);
1048: --
1049: get_dates(p_field => p_field
1050: ,p_security_mode => ''
1051: ,p_effective_date => p_effective_date

Line 1058: hr_utility.set_location(l_proc,20);

1054: ,p_assignment_id => p_assignment_id
1055: ,p_business_group_id => p_business_group_id
1056: ,records => l_records);
1057: --
1058: hr_utility.set_location(l_proc,20);
1059: --
1060: if p_security_mode='FUTURE' then
1061: if to_date(l_records(1).start_date,'J')>p_datetrack_date then
1062: l_new_date:=to_date(l_records(1).start_date,'J');

Line 1072: hr_utility.set_location(l_proc,30);

1068: else
1069: l_new_date:=to_date(l_records(1).start_date,'J');
1070: end if;
1071: --
1072: hr_utility.set_location(l_proc,30);
1073: --
1074: p_new_date:=l_new_date;
1075: --
1076: hr_utility.set_location('Leaving '||l_proc,40);

Line 1076: hr_utility.set_location('Leaving '||l_proc,40);

1072: hr_utility.set_location(l_proc,30);
1073: --
1074: p_new_date:=l_new_date;
1075: --
1076: hr_utility.set_location('Leaving '||l_proc,40);
1077: --
1078: end get_first_date;
1079:
1080: procedure get_previous_date

Line 1098: hr_utility.set_location('Entering: '||l_proc,10);

1094: l_proc varchar2(72):=g_package||'get_previous_date';
1095: --
1096: begin
1097: --
1098: hr_utility.set_location('Entering: '||l_proc,10);
1099: --
1100: get_dates(p_field => p_field
1101: ,p_security_mode => ''
1102: ,p_effective_date => p_effective_date

Line 1109: hr_utility.set_location(l_proc,20);

1105: ,p_assignment_id => p_assignment_id
1106: ,p_business_group_id => p_business_group_id
1107: ,records => l_records);
1108: --
1109: hr_utility.set_location(l_proc,20);
1110: --
1111: if p_security_mode='PRESENT' then
1112: l_new_date:=p_effective_date;
1113: else

Line 1126: hr_utility.set_location(l_proc,30);

1122: l_new_date:=p_datetrack_date;
1123: end if;
1124: end if;
1125: --
1126: hr_utility.set_location(l_proc,30);
1127: --
1128: p_new_date:=l_new_date;
1129: --
1130: hr_utility.set_location('Leaving '||l_proc,40);

Line 1130: hr_utility.set_location('Leaving '||l_proc,40);

1126: hr_utility.set_location(l_proc,30);
1127: --
1128: p_new_date:=l_new_date;
1129: --
1130: hr_utility.set_location('Leaving '||l_proc,40);
1131: --
1132: end get_previous_date;
1133:
1134: procedure get_next_date

Line 1152: hr_utility.set_location('Entering: '||l_proc,10);

1148: l_proc varchar2(72):=g_package||'get_next_date';
1149: --
1150: begin
1151: --
1152: hr_utility.set_location('Entering: '||l_proc,10);
1153: --
1154: get_dates(p_field => p_field
1155: ,p_security_mode => ''
1156: ,p_effective_date => p_effective_date

Line 1163: hr_utility.set_location(l_proc,20);

1159: ,p_assignment_id => p_assignment_id
1160: ,p_business_group_id => p_business_group_id
1161: ,records => l_records);
1162: --
1163: hr_utility.set_location(l_proc,20);
1164: --
1165: if p_security_mode='PRESENT' then
1166: l_new_date:=p_effective_date;
1167: else

Line 1180: hr_utility.set_location(l_proc,30);

1176: l_new_date:=p_datetrack_date;
1177: end if;
1178: end if;
1179: --
1180: hr_utility.set_location(l_proc,30);
1181: --
1182: if l_new_date>p_effective_date then
1183: p_new_date:=l_new_date;
1184: else

Line 1188: hr_utility.set_location('Leaving '||l_proc,40);

1184: else
1185: p_new_date:=p_effective_date;
1186: end if;
1187: --
1188: hr_utility.set_location('Leaving '||l_proc,40);
1189: --
1190: end get_next_date;
1191:
1192: procedure get_last_date

Line 1210: hr_utility.set_location('Entering: '||l_proc,10);

1206: l_proc varchar2(72):=g_package||'get_last_date';
1207: --
1208: begin
1209: --
1210: hr_utility.set_location('Entering: '||l_proc,10);
1211: --
1212: get_dates(p_field => p_field
1213: ,p_security_mode => ''
1214: ,p_effective_date => p_effective_date

Line 1221: hr_utility.set_location(l_proc,20);

1217: ,p_assignment_id => p_assignment_id
1218: ,p_business_group_id => p_business_group_id
1219: ,records => l_records);
1220: --
1221: hr_utility.set_location(l_proc,20);
1222: --
1223: if p_security_mode='PRESENT' then
1224: l_new_date:=p_effective_date;
1225: else

Line 1232: hr_utility.set_location(l_proc,30);

1228: l_new_date:=p_datetrack_date;
1229: end if;
1230: end if;
1231: --
1232: hr_utility.set_location(l_proc,30);
1233: --
1234: if l_new_date>p_effective_date then
1235: p_new_date:=l_new_date;
1236: else

Line 1240: hr_utility.set_location('Leaving '||l_proc,40);

1236: else
1237: p_new_date:=p_effective_date;
1238: end if;
1239: --
1240: hr_utility.set_location('Leaving '||l_proc,40);
1241: --
1242: end get_last_date;
1243:
1244: