APPS.PQP_GB_CPX_EXTRACT_FUNCTIONS dependencies on HR_API

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

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

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

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

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

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

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

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

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

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

Line 4207: hr_api.g_varchar2, hr_api.g_varchar2,

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

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

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