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 1134: hr_general.decode_lookup(

1130: g_tab_abs_types(i) :=
1131: fnd_number.canonical_to_number(g_tab_event_map_cv(i).pcv_information7);
1132: ELSE
1133: l_meaning :=
1134: hr_general.decode_lookup(
1135: p_lookup_type => 'PQP_PENSERVER_EVENT_DESC'
1136: ,p_lookup_code => g_tab_event_map_cv(i).pcv_information1
1137: );
1138:

Line 1164: hr_general.decode_lookup(

1160: g_tab_asg_status(i) :=
1161: fnd_number.canonical_to_number(g_tab_event_map_cv(i).pcv_information8);
1162: ELSE
1163: l_meaning :=
1164: hr_general.decode_lookup(
1165: p_lookup_type => 'PQP_PENSERVER_EVENT_DESC'
1166: ,p_lookup_code => g_tab_event_map_cv(i).pcv_information1
1167: );
1168:

Line 1372: hr_general.decode_lookup(

1368: -- Get the absence type name
1369: l_abs_type_name :=
1370: get_abs_type_name(p_absence_type_id => g_tab_abs_types(i));
1371: l_meaning :=
1372: hr_general.decode_lookup(
1373: p_lookup_type => 'PQP_PENSERVER_EVENT_DESC'
1374: ,p_lookup_code => g_tab_event_map_cv(i).pcv_information1
1375: );
1376:

Line 1385: || hr_general.decode_lookup(

1381:
1382: l_meaning :=
1383: l_meaning
1384: || ', '
1385: || hr_general.decode_lookup(
1386: p_lookup_type => 'PQP_PENSERVER_EVENT_DESC'
1387: ,p_lookup_code => g_tab_event_map_cv(j).pcv_information1
1388: );
1389:

Line 1472: hr_general.decode_lookup(

1468: THEN
1469: l_asg_status :=
1470: get_asg_status_type(p_asg_sts_type_id => g_tab_asg_status(i));
1471: l_meaning :=
1472: hr_general.decode_lookup(
1473: p_lookup_type => 'PQP_PENSERVER_EVENT_DESC'
1474: ,p_lookup_code => g_tab_event_map_cv(i).pcv_information1
1475: );
1476:

Line 1485: || hr_general.decode_lookup(

1481:
1482: l_meaning :=
1483: l_meaning
1484: || ', '
1485: || hr_general.decode_lookup(
1486: p_lookup_type => 'PQP_PENSERVER_EVENT_DESC'
1487: ,p_lookup_code => g_tab_event_map_cv(j).pcv_information1
1488: );
1489: