DBA Data[Home] [Help]

APPS.PAY_GB_P11D_CAR_EXTRACT dependencies on BEN_EXT_RSLT_DTL_API

Line 1229: ben_ext_rslt_dtl_api.create_ext_rslt_dtl( p_ext_rslt_dtl_id => l_ext_rslt_dtl_id

1225: -- Record does not exist
1226: -- Call API to create extract details record
1227: BEGIN
1228: hr_utility.trace('CREATE_EXT_RSLT_DTL: Insert result details.');
1229: ben_ext_rslt_dtl_api.create_ext_rslt_dtl( p_ext_rslt_dtl_id => l_ext_rslt_dtl_id
1230: ,p_ext_rslt_id => g_ext_rslt_id
1231: ,p_ext_rcd_id => g_veh_rcd_id
1232: ,p_person_id => g_person_id
1233: ,p_business_group_id => g_bg_id

Line 1632: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => l_prim_veh_dtl.ext_rslt_dtl_id,

1628: hr_utility.trace('POST_PROCESS_RULE: l_prim_veh_dtl.val_29='||l_prim_veh_dtl.val_29);
1629: IF l_prim_veh_dtl.ext_rslt_dtl_id IS NOT NULL AND l_prim_veh_dtl.val_29 IS NULL THEN
1630: -- Delete this extract rslt details because primary vehicle details
1631: -- do not exist for this assignment as of the start date parameter
1632: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => l_prim_veh_dtl.ext_rslt_dtl_id,
1633: p_object_version_number => l_prim_veh_dtl.object_version_number);
1634: --
1635: ELSIF l_prim_veh_dtl.ext_rslt_dtl_id IS NOT NULL AND l_asg_include = 'N' THEN
1636: -- Primary assignment does not qualify for extract

Line 1638: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => l_prim_veh_dtl.ext_rslt_dtl_id,

1634: --
1635: ELSIF l_prim_veh_dtl.ext_rslt_dtl_id IS NOT NULL AND l_asg_include = 'N' THEN
1636: -- Primary assignment does not qualify for extract
1637: -- Delete this extract rslt details
1638: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => l_prim_veh_dtl.ext_rslt_dtl_id,
1639: p_object_version_number => l_prim_veh_dtl.object_version_number);
1640: --
1641: ELSIF l_asg_include = 'Y' THEN
1642: -- Include this Assignment

Line 1653: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => ext_asg_rec.ext_rslt_dtl_id,

1649: --
1650: hr_utility.trace('POST_PROCESS_RULE: Assignment processed, remove it from the extract details table.');
1651: l_obj_no := ext_asg_rec.object_version_number;
1652: -- Delete this assignment details record
1653: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => ext_asg_rec.ext_rslt_dtl_id,
1654: p_object_version_number => l_obj_no);
1655: --
1656: END LOOP;
1657: --

Line 2746: ben_ext_rslt_dtl_api.create_ext_rslt_dtl( p_ext_rslt_dtl_id => l_ext_rslt_dtl_id

2742: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: Insert result details.');
2743: /* added below variables for bug 6154257 */
2744: l_asg_start_date := fnd_date.displaydate_to_date(get_prim_asg_start_date(p_asg_id));
2745: l_asg_end_date := fnd_date.displaydate_to_date(get_prim_asg_end_date(p_asg_id));
2746: ben_ext_rslt_dtl_api.create_ext_rslt_dtl( p_ext_rslt_dtl_id => l_ext_rslt_dtl_id
2747: ,p_ext_rslt_id => g_ext_rslt_id
2748: ,p_ext_rcd_id => g_veh_rcd_id
2749: ,p_person_id => g_person_id
2750: ,p_business_group_id => g_bg_id

Line 3270: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => l_prim_veh_dtl.ext_rslt_dtl_id,

3266: --
3267: IF l_prim_veh_dtl.ext_rslt_dtl_id IS NOT NULL AND l_asg_include = 'N' THEN
3268: -- Primary assignment does not qualify for extract
3269: -- Delete this extract rslt details
3270: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => l_prim_veh_dtl.ext_rslt_dtl_id,
3271: p_object_version_number => l_prim_veh_dtl.object_version_number);
3272: --
3273: ELSIF l_asg_include = 'Y' THEN
3274: -- Include this Assignment

Line 3277: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => l_prim_veh_dtl.ext_rslt_dtl_id,

3273: ELSIF l_asg_include = 'Y' THEN
3274: -- Include this Assignment
3275: process_prim_veh_04(ext_asg_rec.asg_id);
3276: process_sec_veh_04(ext_asg_rec.asg_id);
3277: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => l_prim_veh_dtl.ext_rslt_dtl_id,
3278: p_object_version_number => l_prim_veh_dtl.object_version_number);
3279: END IF;
3280: --
3281: process_term_primary_asg_04(ext_asg_rec.asg_id);

Line 3287: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => ext_asg_rec.ext_rslt_dtl_id,

3283: --
3284: hr_utility.trace('POST_PROCESS_RULE_04: Assignment processed, remove it from the extract details table.');
3285: l_obj_no := ext_asg_rec.object_version_number;
3286: -- Delete this assignment details record
3287: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => ext_asg_rec.ext_rslt_dtl_id,
3288: p_object_version_number => l_obj_no);
3289: --
3290: END LOOP;
3291: --