DBA Data[Home] [Help]

APPS.PQP_GB_PSI_SERVICE_HISTORY dependencies on HR_GENERAL

Line 645: hr_general.decode_lookup(

641: DEBUG('Raise data error..Leave reason map is missing');
642: END IF;
643:
644: l_meaning :=
645: hr_general.decode_lookup(
646: p_lookup_type => 'LEAV_REAS'
647: ,p_lookup_code => p_leave_reason
648: );
649:

Line 1128: hr_general.decode_lookup(

1124: g_tab_abs_types(i) :=
1125: fnd_number.canonical_to_number(g_tab_event_map_cv(i).pcv_information7);
1126: ELSE
1127: l_meaning :=
1128: hr_general.decode_lookup(
1129: p_lookup_type => 'PQP_PENSERVER_EVENT_DESC'
1130: ,p_lookup_code => g_tab_event_map_cv(i).pcv_information1
1131: );
1132:

Line 1158: hr_general.decode_lookup(

1154: g_tab_asg_status(i) :=
1155: fnd_number.canonical_to_number(g_tab_event_map_cv(i).pcv_information8);
1156: ELSE
1157: l_meaning :=
1158: hr_general.decode_lookup(
1159: p_lookup_type => 'PQP_PENSERVER_EVENT_DESC'
1160: ,p_lookup_code => g_tab_event_map_cv(i).pcv_information1
1161: );
1162:

Line 1364: hr_general.decode_lookup(

1360: -- Get the absence type name
1361: l_abs_type_name :=
1362: get_abs_type_name(p_absence_type_id => g_tab_abs_types(i));
1363: l_meaning :=
1364: hr_general.decode_lookup(
1365: p_lookup_type => 'PQP_PENSERVER_EVENT_DESC'
1366: ,p_lookup_code => g_tab_event_map_cv(i).pcv_information1
1367: );
1368:

Line 1377: || hr_general.decode_lookup(

1373:
1374: l_meaning :=
1375: l_meaning
1376: || ', '
1377: || hr_general.decode_lookup(
1378: p_lookup_type => 'PQP_PENSERVER_EVENT_DESC'
1379: ,p_lookup_code => g_tab_event_map_cv(j).pcv_information1
1380: );
1381:

Line 1464: hr_general.decode_lookup(

1460: THEN
1461: l_asg_status :=
1462: get_asg_status_type(p_asg_sts_type_id => g_tab_asg_status(i));
1463: l_meaning :=
1464: hr_general.decode_lookup(
1465: p_lookup_type => 'PQP_PENSERVER_EVENT_DESC'
1466: ,p_lookup_code => g_tab_event_map_cv(i).pcv_information1
1467: );
1468:

Line 1477: || hr_general.decode_lookup(

1473:
1474: l_meaning :=
1475: l_meaning
1476: || ', '
1477: || hr_general.decode_lookup(
1478: p_lookup_type => 'PQP_PENSERVER_EVENT_DESC'
1479: ,p_lookup_code => g_tab_event_map_cv(j).pcv_information1
1480: );
1481: