3246: RETURN l_costflex_value;
3247: END costflex_value;
3248:
3249: FUNCTION costflex_concat_segments (
3250: p_cost_allocation_keyflex_id IN pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE
3251: )
3252: RETURN pay_cost_allocation_keyflex.concatenated_segments%TYPE
3253: IS
3254: l_proc proc_name;
3248:
3249: FUNCTION costflex_concat_segments (
3250: p_cost_allocation_keyflex_id IN pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE
3251: )
3252: RETURN pay_cost_allocation_keyflex.concatenated_segments%TYPE
3253: IS
3254: l_proc proc_name;
3255:
3256:
3254: l_proc proc_name;
3255:
3256:
3257: CURSOR csr_costflex_concat_segments (
3258: p_cost_allocation_keyflex_id pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE
3259: )
3260: IS
3261: SELECT concatenated_segments
3262: FROM pay_cost_allocation_keyflex
3258: p_cost_allocation_keyflex_id pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE
3259: )
3260: IS
3261: SELECT concatenated_segments
3262: FROM pay_cost_allocation_keyflex
3263: WHERE cost_allocation_keyflex_id = p_cost_allocation_keyflex_id;
3264:
3265: l_costflex_concat_segments pay_cost_allocation_keyflex.concatenated_segments%TYPE;
3266: l_found_in_cache BOOLEAN := FALSE;
3261: SELECT concatenated_segments
3262: FROM pay_cost_allocation_keyflex
3263: WHERE cost_allocation_keyflex_id = p_cost_allocation_keyflex_id;
3264:
3265: l_costflex_concat_segments pay_cost_allocation_keyflex.concatenated_segments%TYPE;
3266: l_found_in_cache BOOLEAN := FALSE;
3267: BEGIN
3268: g_debug :=hr_utility.debug_enabled;
3269: if g_debug then
3311: RETURN l_costflex_concat_segments;
3312: END costflex_concat_segments;
3313:
3314: FUNCTION cost_segments_all_null (
3315: p_segment_1 IN pay_cost_allocation_keyflex.segment1%TYPE,
3316: p_segment_2 IN pay_cost_allocation_keyflex.segment2%TYPE,
3317: p_segment_3 IN pay_cost_allocation_keyflex.segment3%TYPE,
3318: p_segment_4 IN pay_cost_allocation_keyflex.segment4%TYPE,
3319: p_segment_5 IN pay_cost_allocation_keyflex.segment5%TYPE,
3312: END costflex_concat_segments;
3313:
3314: FUNCTION cost_segments_all_null (
3315: p_segment_1 IN pay_cost_allocation_keyflex.segment1%TYPE,
3316: p_segment_2 IN pay_cost_allocation_keyflex.segment2%TYPE,
3317: p_segment_3 IN pay_cost_allocation_keyflex.segment3%TYPE,
3318: p_segment_4 IN pay_cost_allocation_keyflex.segment4%TYPE,
3319: p_segment_5 IN pay_cost_allocation_keyflex.segment5%TYPE,
3320: p_segment_6 IN pay_cost_allocation_keyflex.segment6%TYPE,
3313:
3314: FUNCTION cost_segments_all_null (
3315: p_segment_1 IN pay_cost_allocation_keyflex.segment1%TYPE,
3316: p_segment_2 IN pay_cost_allocation_keyflex.segment2%TYPE,
3317: p_segment_3 IN pay_cost_allocation_keyflex.segment3%TYPE,
3318: p_segment_4 IN pay_cost_allocation_keyflex.segment4%TYPE,
3319: p_segment_5 IN pay_cost_allocation_keyflex.segment5%TYPE,
3320: p_segment_6 IN pay_cost_allocation_keyflex.segment6%TYPE,
3321: p_segment_7 IN pay_cost_allocation_keyflex.segment7%TYPE,
3314: FUNCTION cost_segments_all_null (
3315: p_segment_1 IN pay_cost_allocation_keyflex.segment1%TYPE,
3316: p_segment_2 IN pay_cost_allocation_keyflex.segment2%TYPE,
3317: p_segment_3 IN pay_cost_allocation_keyflex.segment3%TYPE,
3318: p_segment_4 IN pay_cost_allocation_keyflex.segment4%TYPE,
3319: p_segment_5 IN pay_cost_allocation_keyflex.segment5%TYPE,
3320: p_segment_6 IN pay_cost_allocation_keyflex.segment6%TYPE,
3321: p_segment_7 IN pay_cost_allocation_keyflex.segment7%TYPE,
3322: p_segment_8 IN pay_cost_allocation_keyflex.segment8%TYPE,
3315: p_segment_1 IN pay_cost_allocation_keyflex.segment1%TYPE,
3316: p_segment_2 IN pay_cost_allocation_keyflex.segment2%TYPE,
3317: p_segment_3 IN pay_cost_allocation_keyflex.segment3%TYPE,
3318: p_segment_4 IN pay_cost_allocation_keyflex.segment4%TYPE,
3319: p_segment_5 IN pay_cost_allocation_keyflex.segment5%TYPE,
3320: p_segment_6 IN pay_cost_allocation_keyflex.segment6%TYPE,
3321: p_segment_7 IN pay_cost_allocation_keyflex.segment7%TYPE,
3322: p_segment_8 IN pay_cost_allocation_keyflex.segment8%TYPE,
3323: p_segment_9 IN pay_cost_allocation_keyflex.segment9%TYPE,
3316: p_segment_2 IN pay_cost_allocation_keyflex.segment2%TYPE,
3317: p_segment_3 IN pay_cost_allocation_keyflex.segment3%TYPE,
3318: p_segment_4 IN pay_cost_allocation_keyflex.segment4%TYPE,
3319: p_segment_5 IN pay_cost_allocation_keyflex.segment5%TYPE,
3320: p_segment_6 IN pay_cost_allocation_keyflex.segment6%TYPE,
3321: p_segment_7 IN pay_cost_allocation_keyflex.segment7%TYPE,
3322: p_segment_8 IN pay_cost_allocation_keyflex.segment8%TYPE,
3323: p_segment_9 IN pay_cost_allocation_keyflex.segment9%TYPE,
3324: p_segment_10 IN pay_cost_allocation_keyflex.segment10%TYPE,
3317: p_segment_3 IN pay_cost_allocation_keyflex.segment3%TYPE,
3318: p_segment_4 IN pay_cost_allocation_keyflex.segment4%TYPE,
3319: p_segment_5 IN pay_cost_allocation_keyflex.segment5%TYPE,
3320: p_segment_6 IN pay_cost_allocation_keyflex.segment6%TYPE,
3321: p_segment_7 IN pay_cost_allocation_keyflex.segment7%TYPE,
3322: p_segment_8 IN pay_cost_allocation_keyflex.segment8%TYPE,
3323: p_segment_9 IN pay_cost_allocation_keyflex.segment9%TYPE,
3324: p_segment_10 IN pay_cost_allocation_keyflex.segment10%TYPE,
3325: p_segment_11 IN pay_cost_allocation_keyflex.segment11%TYPE,
3318: p_segment_4 IN pay_cost_allocation_keyflex.segment4%TYPE,
3319: p_segment_5 IN pay_cost_allocation_keyflex.segment5%TYPE,
3320: p_segment_6 IN pay_cost_allocation_keyflex.segment6%TYPE,
3321: p_segment_7 IN pay_cost_allocation_keyflex.segment7%TYPE,
3322: p_segment_8 IN pay_cost_allocation_keyflex.segment8%TYPE,
3323: p_segment_9 IN pay_cost_allocation_keyflex.segment9%TYPE,
3324: p_segment_10 IN pay_cost_allocation_keyflex.segment10%TYPE,
3325: p_segment_11 IN pay_cost_allocation_keyflex.segment11%TYPE,
3326: p_segment_12 IN pay_cost_allocation_keyflex.segment12%TYPE,
3319: p_segment_5 IN pay_cost_allocation_keyflex.segment5%TYPE,
3320: p_segment_6 IN pay_cost_allocation_keyflex.segment6%TYPE,
3321: p_segment_7 IN pay_cost_allocation_keyflex.segment7%TYPE,
3322: p_segment_8 IN pay_cost_allocation_keyflex.segment8%TYPE,
3323: p_segment_9 IN pay_cost_allocation_keyflex.segment9%TYPE,
3324: p_segment_10 IN pay_cost_allocation_keyflex.segment10%TYPE,
3325: p_segment_11 IN pay_cost_allocation_keyflex.segment11%TYPE,
3326: p_segment_12 IN pay_cost_allocation_keyflex.segment12%TYPE,
3327: p_segment_13 IN pay_cost_allocation_keyflex.segment13%TYPE,
3320: p_segment_6 IN pay_cost_allocation_keyflex.segment6%TYPE,
3321: p_segment_7 IN pay_cost_allocation_keyflex.segment7%TYPE,
3322: p_segment_8 IN pay_cost_allocation_keyflex.segment8%TYPE,
3323: p_segment_9 IN pay_cost_allocation_keyflex.segment9%TYPE,
3324: p_segment_10 IN pay_cost_allocation_keyflex.segment10%TYPE,
3325: p_segment_11 IN pay_cost_allocation_keyflex.segment11%TYPE,
3326: p_segment_12 IN pay_cost_allocation_keyflex.segment12%TYPE,
3327: p_segment_13 IN pay_cost_allocation_keyflex.segment13%TYPE,
3328: p_segment_14 IN pay_cost_allocation_keyflex.segment14%TYPE,
3321: p_segment_7 IN pay_cost_allocation_keyflex.segment7%TYPE,
3322: p_segment_8 IN pay_cost_allocation_keyflex.segment8%TYPE,
3323: p_segment_9 IN pay_cost_allocation_keyflex.segment9%TYPE,
3324: p_segment_10 IN pay_cost_allocation_keyflex.segment10%TYPE,
3325: p_segment_11 IN pay_cost_allocation_keyflex.segment11%TYPE,
3326: p_segment_12 IN pay_cost_allocation_keyflex.segment12%TYPE,
3327: p_segment_13 IN pay_cost_allocation_keyflex.segment13%TYPE,
3328: p_segment_14 IN pay_cost_allocation_keyflex.segment14%TYPE,
3329: p_segment_15 IN pay_cost_allocation_keyflex.segment15%TYPE,
3322: p_segment_8 IN pay_cost_allocation_keyflex.segment8%TYPE,
3323: p_segment_9 IN pay_cost_allocation_keyflex.segment9%TYPE,
3324: p_segment_10 IN pay_cost_allocation_keyflex.segment10%TYPE,
3325: p_segment_11 IN pay_cost_allocation_keyflex.segment11%TYPE,
3326: p_segment_12 IN pay_cost_allocation_keyflex.segment12%TYPE,
3327: p_segment_13 IN pay_cost_allocation_keyflex.segment13%TYPE,
3328: p_segment_14 IN pay_cost_allocation_keyflex.segment14%TYPE,
3329: p_segment_15 IN pay_cost_allocation_keyflex.segment15%TYPE,
3330: p_segment_16 IN pay_cost_allocation_keyflex.segment16%TYPE,
3323: p_segment_9 IN pay_cost_allocation_keyflex.segment9%TYPE,
3324: p_segment_10 IN pay_cost_allocation_keyflex.segment10%TYPE,
3325: p_segment_11 IN pay_cost_allocation_keyflex.segment11%TYPE,
3326: p_segment_12 IN pay_cost_allocation_keyflex.segment12%TYPE,
3327: p_segment_13 IN pay_cost_allocation_keyflex.segment13%TYPE,
3328: p_segment_14 IN pay_cost_allocation_keyflex.segment14%TYPE,
3329: p_segment_15 IN pay_cost_allocation_keyflex.segment15%TYPE,
3330: p_segment_16 IN pay_cost_allocation_keyflex.segment16%TYPE,
3331: p_segment_17 IN pay_cost_allocation_keyflex.segment17%TYPE,
3324: p_segment_10 IN pay_cost_allocation_keyflex.segment10%TYPE,
3325: p_segment_11 IN pay_cost_allocation_keyflex.segment11%TYPE,
3326: p_segment_12 IN pay_cost_allocation_keyflex.segment12%TYPE,
3327: p_segment_13 IN pay_cost_allocation_keyflex.segment13%TYPE,
3328: p_segment_14 IN pay_cost_allocation_keyflex.segment14%TYPE,
3329: p_segment_15 IN pay_cost_allocation_keyflex.segment15%TYPE,
3330: p_segment_16 IN pay_cost_allocation_keyflex.segment16%TYPE,
3331: p_segment_17 IN pay_cost_allocation_keyflex.segment17%TYPE,
3332: p_segment_18 IN pay_cost_allocation_keyflex.segment18%TYPE,
3325: p_segment_11 IN pay_cost_allocation_keyflex.segment11%TYPE,
3326: p_segment_12 IN pay_cost_allocation_keyflex.segment12%TYPE,
3327: p_segment_13 IN pay_cost_allocation_keyflex.segment13%TYPE,
3328: p_segment_14 IN pay_cost_allocation_keyflex.segment14%TYPE,
3329: p_segment_15 IN pay_cost_allocation_keyflex.segment15%TYPE,
3330: p_segment_16 IN pay_cost_allocation_keyflex.segment16%TYPE,
3331: p_segment_17 IN pay_cost_allocation_keyflex.segment17%TYPE,
3332: p_segment_18 IN pay_cost_allocation_keyflex.segment18%TYPE,
3333: p_segment_19 IN pay_cost_allocation_keyflex.segment19%TYPE,
3326: p_segment_12 IN pay_cost_allocation_keyflex.segment12%TYPE,
3327: p_segment_13 IN pay_cost_allocation_keyflex.segment13%TYPE,
3328: p_segment_14 IN pay_cost_allocation_keyflex.segment14%TYPE,
3329: p_segment_15 IN pay_cost_allocation_keyflex.segment15%TYPE,
3330: p_segment_16 IN pay_cost_allocation_keyflex.segment16%TYPE,
3331: p_segment_17 IN pay_cost_allocation_keyflex.segment17%TYPE,
3332: p_segment_18 IN pay_cost_allocation_keyflex.segment18%TYPE,
3333: p_segment_19 IN pay_cost_allocation_keyflex.segment19%TYPE,
3334: p_segment_20 IN pay_cost_allocation_keyflex.segment20%TYPE,
3327: p_segment_13 IN pay_cost_allocation_keyflex.segment13%TYPE,
3328: p_segment_14 IN pay_cost_allocation_keyflex.segment14%TYPE,
3329: p_segment_15 IN pay_cost_allocation_keyflex.segment15%TYPE,
3330: p_segment_16 IN pay_cost_allocation_keyflex.segment16%TYPE,
3331: p_segment_17 IN pay_cost_allocation_keyflex.segment17%TYPE,
3332: p_segment_18 IN pay_cost_allocation_keyflex.segment18%TYPE,
3333: p_segment_19 IN pay_cost_allocation_keyflex.segment19%TYPE,
3334: p_segment_20 IN pay_cost_allocation_keyflex.segment20%TYPE,
3335: p_segment_21 IN pay_cost_allocation_keyflex.segment21%TYPE,
3328: p_segment_14 IN pay_cost_allocation_keyflex.segment14%TYPE,
3329: p_segment_15 IN pay_cost_allocation_keyflex.segment15%TYPE,
3330: p_segment_16 IN pay_cost_allocation_keyflex.segment16%TYPE,
3331: p_segment_17 IN pay_cost_allocation_keyflex.segment17%TYPE,
3332: p_segment_18 IN pay_cost_allocation_keyflex.segment18%TYPE,
3333: p_segment_19 IN pay_cost_allocation_keyflex.segment19%TYPE,
3334: p_segment_20 IN pay_cost_allocation_keyflex.segment20%TYPE,
3335: p_segment_21 IN pay_cost_allocation_keyflex.segment21%TYPE,
3336: p_segment_22 IN pay_cost_allocation_keyflex.segment22%TYPE,
3329: p_segment_15 IN pay_cost_allocation_keyflex.segment15%TYPE,
3330: p_segment_16 IN pay_cost_allocation_keyflex.segment16%TYPE,
3331: p_segment_17 IN pay_cost_allocation_keyflex.segment17%TYPE,
3332: p_segment_18 IN pay_cost_allocation_keyflex.segment18%TYPE,
3333: p_segment_19 IN pay_cost_allocation_keyflex.segment19%TYPE,
3334: p_segment_20 IN pay_cost_allocation_keyflex.segment20%TYPE,
3335: p_segment_21 IN pay_cost_allocation_keyflex.segment21%TYPE,
3336: p_segment_22 IN pay_cost_allocation_keyflex.segment22%TYPE,
3337: p_segment_23 IN pay_cost_allocation_keyflex.segment23%TYPE,
3330: p_segment_16 IN pay_cost_allocation_keyflex.segment16%TYPE,
3331: p_segment_17 IN pay_cost_allocation_keyflex.segment17%TYPE,
3332: p_segment_18 IN pay_cost_allocation_keyflex.segment18%TYPE,
3333: p_segment_19 IN pay_cost_allocation_keyflex.segment19%TYPE,
3334: p_segment_20 IN pay_cost_allocation_keyflex.segment20%TYPE,
3335: p_segment_21 IN pay_cost_allocation_keyflex.segment21%TYPE,
3336: p_segment_22 IN pay_cost_allocation_keyflex.segment22%TYPE,
3337: p_segment_23 IN pay_cost_allocation_keyflex.segment23%TYPE,
3338: p_segment_24 IN pay_cost_allocation_keyflex.segment24%TYPE,
3331: p_segment_17 IN pay_cost_allocation_keyflex.segment17%TYPE,
3332: p_segment_18 IN pay_cost_allocation_keyflex.segment18%TYPE,
3333: p_segment_19 IN pay_cost_allocation_keyflex.segment19%TYPE,
3334: p_segment_20 IN pay_cost_allocation_keyflex.segment20%TYPE,
3335: p_segment_21 IN pay_cost_allocation_keyflex.segment21%TYPE,
3336: p_segment_22 IN pay_cost_allocation_keyflex.segment22%TYPE,
3337: p_segment_23 IN pay_cost_allocation_keyflex.segment23%TYPE,
3338: p_segment_24 IN pay_cost_allocation_keyflex.segment24%TYPE,
3339: p_segment_25 IN pay_cost_allocation_keyflex.segment25%TYPE,
3332: p_segment_18 IN pay_cost_allocation_keyflex.segment18%TYPE,
3333: p_segment_19 IN pay_cost_allocation_keyflex.segment19%TYPE,
3334: p_segment_20 IN pay_cost_allocation_keyflex.segment20%TYPE,
3335: p_segment_21 IN pay_cost_allocation_keyflex.segment21%TYPE,
3336: p_segment_22 IN pay_cost_allocation_keyflex.segment22%TYPE,
3337: p_segment_23 IN pay_cost_allocation_keyflex.segment23%TYPE,
3338: p_segment_24 IN pay_cost_allocation_keyflex.segment24%TYPE,
3339: p_segment_25 IN pay_cost_allocation_keyflex.segment25%TYPE,
3340: p_segment_26 IN pay_cost_allocation_keyflex.segment26%TYPE,
3333: p_segment_19 IN pay_cost_allocation_keyflex.segment19%TYPE,
3334: p_segment_20 IN pay_cost_allocation_keyflex.segment20%TYPE,
3335: p_segment_21 IN pay_cost_allocation_keyflex.segment21%TYPE,
3336: p_segment_22 IN pay_cost_allocation_keyflex.segment22%TYPE,
3337: p_segment_23 IN pay_cost_allocation_keyflex.segment23%TYPE,
3338: p_segment_24 IN pay_cost_allocation_keyflex.segment24%TYPE,
3339: p_segment_25 IN pay_cost_allocation_keyflex.segment25%TYPE,
3340: p_segment_26 IN pay_cost_allocation_keyflex.segment26%TYPE,
3341: p_segment_27 IN pay_cost_allocation_keyflex.segment27%TYPE,
3334: p_segment_20 IN pay_cost_allocation_keyflex.segment20%TYPE,
3335: p_segment_21 IN pay_cost_allocation_keyflex.segment21%TYPE,
3336: p_segment_22 IN pay_cost_allocation_keyflex.segment22%TYPE,
3337: p_segment_23 IN pay_cost_allocation_keyflex.segment23%TYPE,
3338: p_segment_24 IN pay_cost_allocation_keyflex.segment24%TYPE,
3339: p_segment_25 IN pay_cost_allocation_keyflex.segment25%TYPE,
3340: p_segment_26 IN pay_cost_allocation_keyflex.segment26%TYPE,
3341: p_segment_27 IN pay_cost_allocation_keyflex.segment27%TYPE,
3342: p_segment_28 IN pay_cost_allocation_keyflex.segment28%TYPE,
3335: p_segment_21 IN pay_cost_allocation_keyflex.segment21%TYPE,
3336: p_segment_22 IN pay_cost_allocation_keyflex.segment22%TYPE,
3337: p_segment_23 IN pay_cost_allocation_keyflex.segment23%TYPE,
3338: p_segment_24 IN pay_cost_allocation_keyflex.segment24%TYPE,
3339: p_segment_25 IN pay_cost_allocation_keyflex.segment25%TYPE,
3340: p_segment_26 IN pay_cost_allocation_keyflex.segment26%TYPE,
3341: p_segment_27 IN pay_cost_allocation_keyflex.segment27%TYPE,
3342: p_segment_28 IN pay_cost_allocation_keyflex.segment28%TYPE,
3343: p_segment_29 IN pay_cost_allocation_keyflex.segment29%TYPE,
3336: p_segment_22 IN pay_cost_allocation_keyflex.segment22%TYPE,
3337: p_segment_23 IN pay_cost_allocation_keyflex.segment23%TYPE,
3338: p_segment_24 IN pay_cost_allocation_keyflex.segment24%TYPE,
3339: p_segment_25 IN pay_cost_allocation_keyflex.segment25%TYPE,
3340: p_segment_26 IN pay_cost_allocation_keyflex.segment26%TYPE,
3341: p_segment_27 IN pay_cost_allocation_keyflex.segment27%TYPE,
3342: p_segment_28 IN pay_cost_allocation_keyflex.segment28%TYPE,
3343: p_segment_29 IN pay_cost_allocation_keyflex.segment29%TYPE,
3344: p_segment_30 IN pay_cost_allocation_keyflex.segment30%TYPE
3337: p_segment_23 IN pay_cost_allocation_keyflex.segment23%TYPE,
3338: p_segment_24 IN pay_cost_allocation_keyflex.segment24%TYPE,
3339: p_segment_25 IN pay_cost_allocation_keyflex.segment25%TYPE,
3340: p_segment_26 IN pay_cost_allocation_keyflex.segment26%TYPE,
3341: p_segment_27 IN pay_cost_allocation_keyflex.segment27%TYPE,
3342: p_segment_28 IN pay_cost_allocation_keyflex.segment28%TYPE,
3343: p_segment_29 IN pay_cost_allocation_keyflex.segment29%TYPE,
3344: p_segment_30 IN pay_cost_allocation_keyflex.segment30%TYPE
3345: )
3338: p_segment_24 IN pay_cost_allocation_keyflex.segment24%TYPE,
3339: p_segment_25 IN pay_cost_allocation_keyflex.segment25%TYPE,
3340: p_segment_26 IN pay_cost_allocation_keyflex.segment26%TYPE,
3341: p_segment_27 IN pay_cost_allocation_keyflex.segment27%TYPE,
3342: p_segment_28 IN pay_cost_allocation_keyflex.segment28%TYPE,
3343: p_segment_29 IN pay_cost_allocation_keyflex.segment29%TYPE,
3344: p_segment_30 IN pay_cost_allocation_keyflex.segment30%TYPE
3345: )
3346: RETURN BOOLEAN
3339: p_segment_25 IN pay_cost_allocation_keyflex.segment25%TYPE,
3340: p_segment_26 IN pay_cost_allocation_keyflex.segment26%TYPE,
3341: p_segment_27 IN pay_cost_allocation_keyflex.segment27%TYPE,
3342: p_segment_28 IN pay_cost_allocation_keyflex.segment28%TYPE,
3343: p_segment_29 IN pay_cost_allocation_keyflex.segment29%TYPE,
3344: p_segment_30 IN pay_cost_allocation_keyflex.segment30%TYPE
3345: )
3346: RETURN BOOLEAN
3347: IS
3340: p_segment_26 IN pay_cost_allocation_keyflex.segment26%TYPE,
3341: p_segment_27 IN pay_cost_allocation_keyflex.segment27%TYPE,
3342: p_segment_28 IN pay_cost_allocation_keyflex.segment28%TYPE,
3343: p_segment_29 IN pay_cost_allocation_keyflex.segment29%TYPE,
3344: p_segment_30 IN pay_cost_allocation_keyflex.segment30%TYPE
3345: )
3346: RETURN BOOLEAN
3347: IS
3348: l_proc proc_name;
3454: END cost_segments_all_null;
3455:
3456: FUNCTION cost_allocation_kff_id (
3457: p_business_group_id IN per_all_organization_units.business_group_id%TYPE,
3458: p_segment_1 IN pay_cost_allocation_keyflex.segment1%TYPE,
3459: p_segment_2 IN pay_cost_allocation_keyflex.segment2%TYPE,
3460: p_segment_3 IN pay_cost_allocation_keyflex.segment3%TYPE,
3461: p_segment_4 IN pay_cost_allocation_keyflex.segment4%TYPE,
3462: p_segment_5 IN pay_cost_allocation_keyflex.segment5%TYPE,
3455:
3456: FUNCTION cost_allocation_kff_id (
3457: p_business_group_id IN per_all_organization_units.business_group_id%TYPE,
3458: p_segment_1 IN pay_cost_allocation_keyflex.segment1%TYPE,
3459: p_segment_2 IN pay_cost_allocation_keyflex.segment2%TYPE,
3460: p_segment_3 IN pay_cost_allocation_keyflex.segment3%TYPE,
3461: p_segment_4 IN pay_cost_allocation_keyflex.segment4%TYPE,
3462: p_segment_5 IN pay_cost_allocation_keyflex.segment5%TYPE,
3463: p_segment_6 IN pay_cost_allocation_keyflex.segment6%TYPE,
3456: FUNCTION cost_allocation_kff_id (
3457: p_business_group_id IN per_all_organization_units.business_group_id%TYPE,
3458: p_segment_1 IN pay_cost_allocation_keyflex.segment1%TYPE,
3459: p_segment_2 IN pay_cost_allocation_keyflex.segment2%TYPE,
3460: p_segment_3 IN pay_cost_allocation_keyflex.segment3%TYPE,
3461: p_segment_4 IN pay_cost_allocation_keyflex.segment4%TYPE,
3462: p_segment_5 IN pay_cost_allocation_keyflex.segment5%TYPE,
3463: p_segment_6 IN pay_cost_allocation_keyflex.segment6%TYPE,
3464: p_segment_7 IN pay_cost_allocation_keyflex.segment7%TYPE,
3457: p_business_group_id IN per_all_organization_units.business_group_id%TYPE,
3458: p_segment_1 IN pay_cost_allocation_keyflex.segment1%TYPE,
3459: p_segment_2 IN pay_cost_allocation_keyflex.segment2%TYPE,
3460: p_segment_3 IN pay_cost_allocation_keyflex.segment3%TYPE,
3461: p_segment_4 IN pay_cost_allocation_keyflex.segment4%TYPE,
3462: p_segment_5 IN pay_cost_allocation_keyflex.segment5%TYPE,
3463: p_segment_6 IN pay_cost_allocation_keyflex.segment6%TYPE,
3464: p_segment_7 IN pay_cost_allocation_keyflex.segment7%TYPE,
3465: p_segment_8 IN pay_cost_allocation_keyflex.segment8%TYPE,
3458: p_segment_1 IN pay_cost_allocation_keyflex.segment1%TYPE,
3459: p_segment_2 IN pay_cost_allocation_keyflex.segment2%TYPE,
3460: p_segment_3 IN pay_cost_allocation_keyflex.segment3%TYPE,
3461: p_segment_4 IN pay_cost_allocation_keyflex.segment4%TYPE,
3462: p_segment_5 IN pay_cost_allocation_keyflex.segment5%TYPE,
3463: p_segment_6 IN pay_cost_allocation_keyflex.segment6%TYPE,
3464: p_segment_7 IN pay_cost_allocation_keyflex.segment7%TYPE,
3465: p_segment_8 IN pay_cost_allocation_keyflex.segment8%TYPE,
3466: p_segment_9 IN pay_cost_allocation_keyflex.segment9%TYPE,
3459: p_segment_2 IN pay_cost_allocation_keyflex.segment2%TYPE,
3460: p_segment_3 IN pay_cost_allocation_keyflex.segment3%TYPE,
3461: p_segment_4 IN pay_cost_allocation_keyflex.segment4%TYPE,
3462: p_segment_5 IN pay_cost_allocation_keyflex.segment5%TYPE,
3463: p_segment_6 IN pay_cost_allocation_keyflex.segment6%TYPE,
3464: p_segment_7 IN pay_cost_allocation_keyflex.segment7%TYPE,
3465: p_segment_8 IN pay_cost_allocation_keyflex.segment8%TYPE,
3466: p_segment_9 IN pay_cost_allocation_keyflex.segment9%TYPE,
3467: p_segment_10 IN pay_cost_allocation_keyflex.segment10%TYPE,
3460: p_segment_3 IN pay_cost_allocation_keyflex.segment3%TYPE,
3461: p_segment_4 IN pay_cost_allocation_keyflex.segment4%TYPE,
3462: p_segment_5 IN pay_cost_allocation_keyflex.segment5%TYPE,
3463: p_segment_6 IN pay_cost_allocation_keyflex.segment6%TYPE,
3464: p_segment_7 IN pay_cost_allocation_keyflex.segment7%TYPE,
3465: p_segment_8 IN pay_cost_allocation_keyflex.segment8%TYPE,
3466: p_segment_9 IN pay_cost_allocation_keyflex.segment9%TYPE,
3467: p_segment_10 IN pay_cost_allocation_keyflex.segment10%TYPE,
3468: p_segment_11 IN pay_cost_allocation_keyflex.segment11%TYPE,
3461: p_segment_4 IN pay_cost_allocation_keyflex.segment4%TYPE,
3462: p_segment_5 IN pay_cost_allocation_keyflex.segment5%TYPE,
3463: p_segment_6 IN pay_cost_allocation_keyflex.segment6%TYPE,
3464: p_segment_7 IN pay_cost_allocation_keyflex.segment7%TYPE,
3465: p_segment_8 IN pay_cost_allocation_keyflex.segment8%TYPE,
3466: p_segment_9 IN pay_cost_allocation_keyflex.segment9%TYPE,
3467: p_segment_10 IN pay_cost_allocation_keyflex.segment10%TYPE,
3468: p_segment_11 IN pay_cost_allocation_keyflex.segment11%TYPE,
3469: p_segment_12 IN pay_cost_allocation_keyflex.segment12%TYPE,
3462: p_segment_5 IN pay_cost_allocation_keyflex.segment5%TYPE,
3463: p_segment_6 IN pay_cost_allocation_keyflex.segment6%TYPE,
3464: p_segment_7 IN pay_cost_allocation_keyflex.segment7%TYPE,
3465: p_segment_8 IN pay_cost_allocation_keyflex.segment8%TYPE,
3466: p_segment_9 IN pay_cost_allocation_keyflex.segment9%TYPE,
3467: p_segment_10 IN pay_cost_allocation_keyflex.segment10%TYPE,
3468: p_segment_11 IN pay_cost_allocation_keyflex.segment11%TYPE,
3469: p_segment_12 IN pay_cost_allocation_keyflex.segment12%TYPE,
3470: p_segment_13 IN pay_cost_allocation_keyflex.segment13%TYPE,
3463: p_segment_6 IN pay_cost_allocation_keyflex.segment6%TYPE,
3464: p_segment_7 IN pay_cost_allocation_keyflex.segment7%TYPE,
3465: p_segment_8 IN pay_cost_allocation_keyflex.segment8%TYPE,
3466: p_segment_9 IN pay_cost_allocation_keyflex.segment9%TYPE,
3467: p_segment_10 IN pay_cost_allocation_keyflex.segment10%TYPE,
3468: p_segment_11 IN pay_cost_allocation_keyflex.segment11%TYPE,
3469: p_segment_12 IN pay_cost_allocation_keyflex.segment12%TYPE,
3470: p_segment_13 IN pay_cost_allocation_keyflex.segment13%TYPE,
3471: p_segment_14 IN pay_cost_allocation_keyflex.segment14%TYPE,
3464: p_segment_7 IN pay_cost_allocation_keyflex.segment7%TYPE,
3465: p_segment_8 IN pay_cost_allocation_keyflex.segment8%TYPE,
3466: p_segment_9 IN pay_cost_allocation_keyflex.segment9%TYPE,
3467: p_segment_10 IN pay_cost_allocation_keyflex.segment10%TYPE,
3468: p_segment_11 IN pay_cost_allocation_keyflex.segment11%TYPE,
3469: p_segment_12 IN pay_cost_allocation_keyflex.segment12%TYPE,
3470: p_segment_13 IN pay_cost_allocation_keyflex.segment13%TYPE,
3471: p_segment_14 IN pay_cost_allocation_keyflex.segment14%TYPE,
3472: p_segment_15 IN pay_cost_allocation_keyflex.segment15%TYPE,
3465: p_segment_8 IN pay_cost_allocation_keyflex.segment8%TYPE,
3466: p_segment_9 IN pay_cost_allocation_keyflex.segment9%TYPE,
3467: p_segment_10 IN pay_cost_allocation_keyflex.segment10%TYPE,
3468: p_segment_11 IN pay_cost_allocation_keyflex.segment11%TYPE,
3469: p_segment_12 IN pay_cost_allocation_keyflex.segment12%TYPE,
3470: p_segment_13 IN pay_cost_allocation_keyflex.segment13%TYPE,
3471: p_segment_14 IN pay_cost_allocation_keyflex.segment14%TYPE,
3472: p_segment_15 IN pay_cost_allocation_keyflex.segment15%TYPE,
3473: p_segment_16 IN pay_cost_allocation_keyflex.segment16%TYPE,
3466: p_segment_9 IN pay_cost_allocation_keyflex.segment9%TYPE,
3467: p_segment_10 IN pay_cost_allocation_keyflex.segment10%TYPE,
3468: p_segment_11 IN pay_cost_allocation_keyflex.segment11%TYPE,
3469: p_segment_12 IN pay_cost_allocation_keyflex.segment12%TYPE,
3470: p_segment_13 IN pay_cost_allocation_keyflex.segment13%TYPE,
3471: p_segment_14 IN pay_cost_allocation_keyflex.segment14%TYPE,
3472: p_segment_15 IN pay_cost_allocation_keyflex.segment15%TYPE,
3473: p_segment_16 IN pay_cost_allocation_keyflex.segment16%TYPE,
3474: p_segment_17 IN pay_cost_allocation_keyflex.segment17%TYPE,
3467: p_segment_10 IN pay_cost_allocation_keyflex.segment10%TYPE,
3468: p_segment_11 IN pay_cost_allocation_keyflex.segment11%TYPE,
3469: p_segment_12 IN pay_cost_allocation_keyflex.segment12%TYPE,
3470: p_segment_13 IN pay_cost_allocation_keyflex.segment13%TYPE,
3471: p_segment_14 IN pay_cost_allocation_keyflex.segment14%TYPE,
3472: p_segment_15 IN pay_cost_allocation_keyflex.segment15%TYPE,
3473: p_segment_16 IN pay_cost_allocation_keyflex.segment16%TYPE,
3474: p_segment_17 IN pay_cost_allocation_keyflex.segment17%TYPE,
3475: p_segment_18 IN pay_cost_allocation_keyflex.segment18%TYPE,
3468: p_segment_11 IN pay_cost_allocation_keyflex.segment11%TYPE,
3469: p_segment_12 IN pay_cost_allocation_keyflex.segment12%TYPE,
3470: p_segment_13 IN pay_cost_allocation_keyflex.segment13%TYPE,
3471: p_segment_14 IN pay_cost_allocation_keyflex.segment14%TYPE,
3472: p_segment_15 IN pay_cost_allocation_keyflex.segment15%TYPE,
3473: p_segment_16 IN pay_cost_allocation_keyflex.segment16%TYPE,
3474: p_segment_17 IN pay_cost_allocation_keyflex.segment17%TYPE,
3475: p_segment_18 IN pay_cost_allocation_keyflex.segment18%TYPE,
3476: p_segment_19 IN pay_cost_allocation_keyflex.segment19%TYPE,
3469: p_segment_12 IN pay_cost_allocation_keyflex.segment12%TYPE,
3470: p_segment_13 IN pay_cost_allocation_keyflex.segment13%TYPE,
3471: p_segment_14 IN pay_cost_allocation_keyflex.segment14%TYPE,
3472: p_segment_15 IN pay_cost_allocation_keyflex.segment15%TYPE,
3473: p_segment_16 IN pay_cost_allocation_keyflex.segment16%TYPE,
3474: p_segment_17 IN pay_cost_allocation_keyflex.segment17%TYPE,
3475: p_segment_18 IN pay_cost_allocation_keyflex.segment18%TYPE,
3476: p_segment_19 IN pay_cost_allocation_keyflex.segment19%TYPE,
3477: p_segment_20 IN pay_cost_allocation_keyflex.segment20%TYPE,
3470: p_segment_13 IN pay_cost_allocation_keyflex.segment13%TYPE,
3471: p_segment_14 IN pay_cost_allocation_keyflex.segment14%TYPE,
3472: p_segment_15 IN pay_cost_allocation_keyflex.segment15%TYPE,
3473: p_segment_16 IN pay_cost_allocation_keyflex.segment16%TYPE,
3474: p_segment_17 IN pay_cost_allocation_keyflex.segment17%TYPE,
3475: p_segment_18 IN pay_cost_allocation_keyflex.segment18%TYPE,
3476: p_segment_19 IN pay_cost_allocation_keyflex.segment19%TYPE,
3477: p_segment_20 IN pay_cost_allocation_keyflex.segment20%TYPE,
3478: p_segment_21 IN pay_cost_allocation_keyflex.segment21%TYPE,
3471: p_segment_14 IN pay_cost_allocation_keyflex.segment14%TYPE,
3472: p_segment_15 IN pay_cost_allocation_keyflex.segment15%TYPE,
3473: p_segment_16 IN pay_cost_allocation_keyflex.segment16%TYPE,
3474: p_segment_17 IN pay_cost_allocation_keyflex.segment17%TYPE,
3475: p_segment_18 IN pay_cost_allocation_keyflex.segment18%TYPE,
3476: p_segment_19 IN pay_cost_allocation_keyflex.segment19%TYPE,
3477: p_segment_20 IN pay_cost_allocation_keyflex.segment20%TYPE,
3478: p_segment_21 IN pay_cost_allocation_keyflex.segment21%TYPE,
3479: p_segment_22 IN pay_cost_allocation_keyflex.segment22%TYPE,
3472: p_segment_15 IN pay_cost_allocation_keyflex.segment15%TYPE,
3473: p_segment_16 IN pay_cost_allocation_keyflex.segment16%TYPE,
3474: p_segment_17 IN pay_cost_allocation_keyflex.segment17%TYPE,
3475: p_segment_18 IN pay_cost_allocation_keyflex.segment18%TYPE,
3476: p_segment_19 IN pay_cost_allocation_keyflex.segment19%TYPE,
3477: p_segment_20 IN pay_cost_allocation_keyflex.segment20%TYPE,
3478: p_segment_21 IN pay_cost_allocation_keyflex.segment21%TYPE,
3479: p_segment_22 IN pay_cost_allocation_keyflex.segment22%TYPE,
3480: p_segment_23 IN pay_cost_allocation_keyflex.segment23%TYPE,
3473: p_segment_16 IN pay_cost_allocation_keyflex.segment16%TYPE,
3474: p_segment_17 IN pay_cost_allocation_keyflex.segment17%TYPE,
3475: p_segment_18 IN pay_cost_allocation_keyflex.segment18%TYPE,
3476: p_segment_19 IN pay_cost_allocation_keyflex.segment19%TYPE,
3477: p_segment_20 IN pay_cost_allocation_keyflex.segment20%TYPE,
3478: p_segment_21 IN pay_cost_allocation_keyflex.segment21%TYPE,
3479: p_segment_22 IN pay_cost_allocation_keyflex.segment22%TYPE,
3480: p_segment_23 IN pay_cost_allocation_keyflex.segment23%TYPE,
3481: p_segment_24 IN pay_cost_allocation_keyflex.segment24%TYPE,
3474: p_segment_17 IN pay_cost_allocation_keyflex.segment17%TYPE,
3475: p_segment_18 IN pay_cost_allocation_keyflex.segment18%TYPE,
3476: p_segment_19 IN pay_cost_allocation_keyflex.segment19%TYPE,
3477: p_segment_20 IN pay_cost_allocation_keyflex.segment20%TYPE,
3478: p_segment_21 IN pay_cost_allocation_keyflex.segment21%TYPE,
3479: p_segment_22 IN pay_cost_allocation_keyflex.segment22%TYPE,
3480: p_segment_23 IN pay_cost_allocation_keyflex.segment23%TYPE,
3481: p_segment_24 IN pay_cost_allocation_keyflex.segment24%TYPE,
3482: p_segment_25 IN pay_cost_allocation_keyflex.segment25%TYPE,
3475: p_segment_18 IN pay_cost_allocation_keyflex.segment18%TYPE,
3476: p_segment_19 IN pay_cost_allocation_keyflex.segment19%TYPE,
3477: p_segment_20 IN pay_cost_allocation_keyflex.segment20%TYPE,
3478: p_segment_21 IN pay_cost_allocation_keyflex.segment21%TYPE,
3479: p_segment_22 IN pay_cost_allocation_keyflex.segment22%TYPE,
3480: p_segment_23 IN pay_cost_allocation_keyflex.segment23%TYPE,
3481: p_segment_24 IN pay_cost_allocation_keyflex.segment24%TYPE,
3482: p_segment_25 IN pay_cost_allocation_keyflex.segment25%TYPE,
3483: p_segment_26 IN pay_cost_allocation_keyflex.segment26%TYPE,
3476: p_segment_19 IN pay_cost_allocation_keyflex.segment19%TYPE,
3477: p_segment_20 IN pay_cost_allocation_keyflex.segment20%TYPE,
3478: p_segment_21 IN pay_cost_allocation_keyflex.segment21%TYPE,
3479: p_segment_22 IN pay_cost_allocation_keyflex.segment22%TYPE,
3480: p_segment_23 IN pay_cost_allocation_keyflex.segment23%TYPE,
3481: p_segment_24 IN pay_cost_allocation_keyflex.segment24%TYPE,
3482: p_segment_25 IN pay_cost_allocation_keyflex.segment25%TYPE,
3483: p_segment_26 IN pay_cost_allocation_keyflex.segment26%TYPE,
3484: p_segment_27 IN pay_cost_allocation_keyflex.segment27%TYPE,
3477: p_segment_20 IN pay_cost_allocation_keyflex.segment20%TYPE,
3478: p_segment_21 IN pay_cost_allocation_keyflex.segment21%TYPE,
3479: p_segment_22 IN pay_cost_allocation_keyflex.segment22%TYPE,
3480: p_segment_23 IN pay_cost_allocation_keyflex.segment23%TYPE,
3481: p_segment_24 IN pay_cost_allocation_keyflex.segment24%TYPE,
3482: p_segment_25 IN pay_cost_allocation_keyflex.segment25%TYPE,
3483: p_segment_26 IN pay_cost_allocation_keyflex.segment26%TYPE,
3484: p_segment_27 IN pay_cost_allocation_keyflex.segment27%TYPE,
3485: p_segment_28 IN pay_cost_allocation_keyflex.segment28%TYPE,
3478: p_segment_21 IN pay_cost_allocation_keyflex.segment21%TYPE,
3479: p_segment_22 IN pay_cost_allocation_keyflex.segment22%TYPE,
3480: p_segment_23 IN pay_cost_allocation_keyflex.segment23%TYPE,
3481: p_segment_24 IN pay_cost_allocation_keyflex.segment24%TYPE,
3482: p_segment_25 IN pay_cost_allocation_keyflex.segment25%TYPE,
3483: p_segment_26 IN pay_cost_allocation_keyflex.segment26%TYPE,
3484: p_segment_27 IN pay_cost_allocation_keyflex.segment27%TYPE,
3485: p_segment_28 IN pay_cost_allocation_keyflex.segment28%TYPE,
3486: p_segment_29 IN pay_cost_allocation_keyflex.segment29%TYPE,
3479: p_segment_22 IN pay_cost_allocation_keyflex.segment22%TYPE,
3480: p_segment_23 IN pay_cost_allocation_keyflex.segment23%TYPE,
3481: p_segment_24 IN pay_cost_allocation_keyflex.segment24%TYPE,
3482: p_segment_25 IN pay_cost_allocation_keyflex.segment25%TYPE,
3483: p_segment_26 IN pay_cost_allocation_keyflex.segment26%TYPE,
3484: p_segment_27 IN pay_cost_allocation_keyflex.segment27%TYPE,
3485: p_segment_28 IN pay_cost_allocation_keyflex.segment28%TYPE,
3486: p_segment_29 IN pay_cost_allocation_keyflex.segment29%TYPE,
3487: p_segment_30 IN pay_cost_allocation_keyflex.segment30%TYPE
3480: p_segment_23 IN pay_cost_allocation_keyflex.segment23%TYPE,
3481: p_segment_24 IN pay_cost_allocation_keyflex.segment24%TYPE,
3482: p_segment_25 IN pay_cost_allocation_keyflex.segment25%TYPE,
3483: p_segment_26 IN pay_cost_allocation_keyflex.segment26%TYPE,
3484: p_segment_27 IN pay_cost_allocation_keyflex.segment27%TYPE,
3485: p_segment_28 IN pay_cost_allocation_keyflex.segment28%TYPE,
3486: p_segment_29 IN pay_cost_allocation_keyflex.segment29%TYPE,
3487: p_segment_30 IN pay_cost_allocation_keyflex.segment30%TYPE
3488: )
3481: p_segment_24 IN pay_cost_allocation_keyflex.segment24%TYPE,
3482: p_segment_25 IN pay_cost_allocation_keyflex.segment25%TYPE,
3483: p_segment_26 IN pay_cost_allocation_keyflex.segment26%TYPE,
3484: p_segment_27 IN pay_cost_allocation_keyflex.segment27%TYPE,
3485: p_segment_28 IN pay_cost_allocation_keyflex.segment28%TYPE,
3486: p_segment_29 IN pay_cost_allocation_keyflex.segment29%TYPE,
3487: p_segment_30 IN pay_cost_allocation_keyflex.segment30%TYPE
3488: )
3489: RETURN pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE
3482: p_segment_25 IN pay_cost_allocation_keyflex.segment25%TYPE,
3483: p_segment_26 IN pay_cost_allocation_keyflex.segment26%TYPE,
3484: p_segment_27 IN pay_cost_allocation_keyflex.segment27%TYPE,
3485: p_segment_28 IN pay_cost_allocation_keyflex.segment28%TYPE,
3486: p_segment_29 IN pay_cost_allocation_keyflex.segment29%TYPE,
3487: p_segment_30 IN pay_cost_allocation_keyflex.segment30%TYPE
3488: )
3489: RETURN pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE
3490: IS
3483: p_segment_26 IN pay_cost_allocation_keyflex.segment26%TYPE,
3484: p_segment_27 IN pay_cost_allocation_keyflex.segment27%TYPE,
3485: p_segment_28 IN pay_cost_allocation_keyflex.segment28%TYPE,
3486: p_segment_29 IN pay_cost_allocation_keyflex.segment29%TYPE,
3487: p_segment_30 IN pay_cost_allocation_keyflex.segment30%TYPE
3488: )
3489: RETURN pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE
3490: IS
3491: l_proc proc_name;
3485: p_segment_28 IN pay_cost_allocation_keyflex.segment28%TYPE,
3486: p_segment_29 IN pay_cost_allocation_keyflex.segment29%TYPE,
3487: p_segment_30 IN pay_cost_allocation_keyflex.segment30%TYPE
3488: )
3489: RETURN pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE
3490: IS
3491: l_proc proc_name;
3492:
3493: l_cost_allocation_kff_id pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
3489: RETURN pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE
3490: IS
3491: l_proc proc_name;
3492:
3493: l_cost_allocation_kff_id pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
3494: BEGIN
3495: g_debug :=hr_utility.debug_enabled;
3496: if g_debug then
3497: l_proc := g_package
3589: FUNCTION cost_allocation_kff_id (
3590: p_business_group_id IN per_all_organization_units.business_group_id%TYPE,
3591: p_bee_rec IN bee_rec
3592: )
3593: RETURN pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE
3594: IS
3595: l_proc proc_name;
3596:
3597: l_cost_allocation_kff_id pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
3593: RETURN pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE
3594: IS
3595: l_proc proc_name;
3596:
3597: l_cost_allocation_kff_id pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
3598: BEGIN
3599: g_debug :=hr_utility.debug_enabled;
3600: if g_debug then
3601: l_proc := g_package