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 2738: ben_ext_rslt_dtl_api.create_ext_rslt_dtl( p_ext_rslt_dtl_id => l_ext_rslt_dtl_id

2734: -- Record does not exist
2735: -- Call API to create extract details record
2736: BEGIN
2737: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: Insert result details.');
2738: ben_ext_rslt_dtl_api.create_ext_rslt_dtl( p_ext_rslt_dtl_id => l_ext_rslt_dtl_id
2739: ,p_ext_rslt_id => g_ext_rslt_id
2740: ,p_ext_rcd_id => g_veh_rcd_id
2741: ,p_person_id => g_person_id
2742: ,p_business_group_id => g_bg_id

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

3157: --
3158: IF l_prim_veh_dtl.ext_rslt_dtl_id IS NOT NULL AND l_asg_include = 'N' THEN
3159: -- Primary assignment does not qualify for extract
3160: -- Delete this extract rslt details
3161: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => l_prim_veh_dtl.ext_rslt_dtl_id,
3162: p_object_version_number => l_prim_veh_dtl.object_version_number);
3163: --
3164: ELSIF l_asg_include = 'Y' THEN
3165: -- Include this Assignment

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

3164: ELSIF l_asg_include = 'Y' THEN
3165: -- Include this Assignment
3166: process_prim_veh_04(ext_asg_rec.asg_id);
3167: process_sec_veh_04(ext_asg_rec.asg_id);
3168: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => l_prim_veh_dtl.ext_rslt_dtl_id,
3169: p_object_version_number => l_prim_veh_dtl.object_version_number);
3170: END IF;
3171: --
3172: process_term_primary_asg_04(ext_asg_rec.asg_id);

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

3174: --
3175: hr_utility.trace('POST_PROCESS_RULE_04: Assignment processed, remove it from the extract details table.');
3176: l_obj_no := ext_asg_rec.object_version_number;
3177: -- Delete this assignment details record
3178: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => ext_asg_rec.ext_rslt_dtl_id,
3179: p_object_version_number => l_obj_no);
3180: --
3181: END LOOP;
3182: --