APPS.PQP_GB_CPX_EXTRACT_FUNCTIONS dependencies on HR_API

Line 3199: -- IF NVL (l_min_start_date, hr_api.g_eot) <

3195: -- CLOSE csr_get_ele_ent_min_start_dt;
3196: DEBUG ( 'Min start date: '
3197: || l_min_start_date);
3198:
3199: -- IF NVL (l_min_start_date, hr_api.g_eot) <
3200: -- NVL (l_dt_cont_out, hr_api.g_eot)
3201: -- -- hr_api.g_eot = 31/12/4712
3202: -- THEN
3203: -- l_dt_cont_out := l_min_start_date;

Line 3200: -- NVL (l_dt_cont_out, hr_api.g_eot)

3196: DEBUG ( 'Min start date: '
3197: || l_min_start_date);
3198:
3199: -- IF NVL (l_min_start_date, hr_api.g_eot) <
3200: -- NVL (l_dt_cont_out, hr_api.g_eot)
3201: -- -- hr_api.g_eot = 31/12/4712
3202: -- THEN
3203: -- l_dt_cont_out := l_min_start_date;
3204: -- END IF; -- End if of min start date check ...

Line 3201: -- -- hr_api.g_eot = 31/12/4712

3197: || l_min_start_date);
3198:
3199: -- IF NVL (l_min_start_date, hr_api.g_eot) <
3200: -- NVL (l_dt_cont_out, hr_api.g_eot)
3201: -- -- hr_api.g_eot = 31/12/4712
3202: -- THEN
3203: -- l_dt_cont_out := l_min_start_date;
3204: -- END IF; -- End if of min start date check ...
3205:

Line 3750: -- NVL (l_max_start_date, hr_api.g_date)

3746: -- -- the previous NI element entry start date (effective)
3747: --
3748: -- IF l_asg_ni_ele_details.start_date IS NOT NULL
3749: -- AND l_asg_ni_ele_details.start_date >
3750: -- NVL (l_max_start_date, hr_api.g_date)
3751: -- THEN
3752: -- -- If this date is greater then store the NI attributes
3753: -- -- Get the NI Table Letter
3754: -- l_ni_table_letter :=

Line 4207: NVL (TRIM (p_type), hr_api.g_varchar2),

4203: AND dtl.ext_rcd_id = p_ext_rcd_id
4204: -- AND rcd.ext_rcd_id = dtl.ext_rcd_id
4205: -- AND rcd.rcd_type_cd = 'D'
4206: AND DECODE (
4207: NVL (TRIM (p_type), hr_api.g_varchar2),
4208: hr_api.g_varchar2, hr_api.g_varchar2,
4209: dtl.val_01
4210: ) = NVL (TRIM (p_type), hr_api.g_varchar2)
4211: AND dtl.val_01 <> 'DELETE';

Line 4208: hr_api.g_varchar2, hr_api.g_varchar2,

4204: -- AND rcd.ext_rcd_id = dtl.ext_rcd_id
4205: -- AND rcd.rcd_type_cd = 'D'
4206: AND DECODE (
4207: NVL (TRIM (p_type), hr_api.g_varchar2),
4208: hr_api.g_varchar2, hr_api.g_varchar2,
4209: dtl.val_01
4210: ) = NVL (TRIM (p_type), hr_api.g_varchar2)
4211: AND dtl.val_01 <> 'DELETE';
4212:

Line 4210: ) = NVL (TRIM (p_type), hr_api.g_varchar2)

4206: AND DECODE (
4207: NVL (TRIM (p_type), hr_api.g_varchar2),
4208: hr_api.g_varchar2, hr_api.g_varchar2,
4209: dtl.val_01
4210: ) = NVL (TRIM (p_type), hr_api.g_varchar2)
4211: AND dtl.val_01 <> 'DELETE';
4212:
4213: l_count NUMBER := 0;
4214: l_count_099999 VARCHAR2 (6) := '000000';