3168: RETURN l_costflex_value;
3169: END costflex_value;
3170:
3171: FUNCTION costflex_concat_segments (
3172: p_cost_allocation_keyflex_id IN pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE
3173: )
3174: RETURN pay_cost_allocation_keyflex.concatenated_segments%TYPE
3175: IS
3176: l_proc proc_name;
3170:
3171: FUNCTION costflex_concat_segments (
3172: p_cost_allocation_keyflex_id IN pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE
3173: )
3174: RETURN pay_cost_allocation_keyflex.concatenated_segments%TYPE
3175: IS
3176: l_proc proc_name;
3177:
3178:
3176: l_proc proc_name;
3177:
3178:
3179: CURSOR csr_costflex_concat_segments (
3180: p_cost_allocation_keyflex_id pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE
3181: )
3182: IS
3183: SELECT concatenated_segments
3184: FROM pay_cost_allocation_keyflex
3180: p_cost_allocation_keyflex_id pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE
3181: )
3182: IS
3183: SELECT concatenated_segments
3184: FROM pay_cost_allocation_keyflex
3185: WHERE cost_allocation_keyflex_id = p_cost_allocation_keyflex_id;
3186:
3187: l_costflex_concat_segments pay_cost_allocation_keyflex.concatenated_segments%TYPE;
3188: l_found_in_cache BOOLEAN := FALSE;
3183: SELECT concatenated_segments
3184: FROM pay_cost_allocation_keyflex
3185: WHERE cost_allocation_keyflex_id = p_cost_allocation_keyflex_id;
3186:
3187: l_costflex_concat_segments pay_cost_allocation_keyflex.concatenated_segments%TYPE;
3188: l_found_in_cache BOOLEAN := FALSE;
3189: BEGIN
3190: g_debug :=hr_utility.debug_enabled;
3191: if g_debug then
3233: RETURN l_costflex_concat_segments;
3234: END costflex_concat_segments;
3235:
3236: FUNCTION cost_segments_all_null (
3237: p_segment_1 IN pay_cost_allocation_keyflex.segment1%TYPE,
3238: p_segment_2 IN pay_cost_allocation_keyflex.segment2%TYPE,
3239: p_segment_3 IN pay_cost_allocation_keyflex.segment3%TYPE,
3240: p_segment_4 IN pay_cost_allocation_keyflex.segment4%TYPE,
3241: p_segment_5 IN pay_cost_allocation_keyflex.segment5%TYPE,
3234: END costflex_concat_segments;
3235:
3236: FUNCTION cost_segments_all_null (
3237: p_segment_1 IN pay_cost_allocation_keyflex.segment1%TYPE,
3238: p_segment_2 IN pay_cost_allocation_keyflex.segment2%TYPE,
3239: p_segment_3 IN pay_cost_allocation_keyflex.segment3%TYPE,
3240: p_segment_4 IN pay_cost_allocation_keyflex.segment4%TYPE,
3241: p_segment_5 IN pay_cost_allocation_keyflex.segment5%TYPE,
3242: p_segment_6 IN pay_cost_allocation_keyflex.segment6%TYPE,
3235:
3236: FUNCTION cost_segments_all_null (
3237: p_segment_1 IN pay_cost_allocation_keyflex.segment1%TYPE,
3238: p_segment_2 IN pay_cost_allocation_keyflex.segment2%TYPE,
3239: p_segment_3 IN pay_cost_allocation_keyflex.segment3%TYPE,
3240: p_segment_4 IN pay_cost_allocation_keyflex.segment4%TYPE,
3241: p_segment_5 IN pay_cost_allocation_keyflex.segment5%TYPE,
3242: p_segment_6 IN pay_cost_allocation_keyflex.segment6%TYPE,
3243: p_segment_7 IN pay_cost_allocation_keyflex.segment7%TYPE,
3236: FUNCTION cost_segments_all_null (
3237: p_segment_1 IN pay_cost_allocation_keyflex.segment1%TYPE,
3238: p_segment_2 IN pay_cost_allocation_keyflex.segment2%TYPE,
3239: p_segment_3 IN pay_cost_allocation_keyflex.segment3%TYPE,
3240: p_segment_4 IN pay_cost_allocation_keyflex.segment4%TYPE,
3241: p_segment_5 IN pay_cost_allocation_keyflex.segment5%TYPE,
3242: p_segment_6 IN pay_cost_allocation_keyflex.segment6%TYPE,
3243: p_segment_7 IN pay_cost_allocation_keyflex.segment7%TYPE,
3244: p_segment_8 IN pay_cost_allocation_keyflex.segment8%TYPE,
3237: p_segment_1 IN pay_cost_allocation_keyflex.segment1%TYPE,
3238: p_segment_2 IN pay_cost_allocation_keyflex.segment2%TYPE,
3239: p_segment_3 IN pay_cost_allocation_keyflex.segment3%TYPE,
3240: p_segment_4 IN pay_cost_allocation_keyflex.segment4%TYPE,
3241: p_segment_5 IN pay_cost_allocation_keyflex.segment5%TYPE,
3242: p_segment_6 IN pay_cost_allocation_keyflex.segment6%TYPE,
3243: p_segment_7 IN pay_cost_allocation_keyflex.segment7%TYPE,
3244: p_segment_8 IN pay_cost_allocation_keyflex.segment8%TYPE,
3245: p_segment_9 IN pay_cost_allocation_keyflex.segment9%TYPE,
3238: p_segment_2 IN pay_cost_allocation_keyflex.segment2%TYPE,
3239: p_segment_3 IN pay_cost_allocation_keyflex.segment3%TYPE,
3240: p_segment_4 IN pay_cost_allocation_keyflex.segment4%TYPE,
3241: p_segment_5 IN pay_cost_allocation_keyflex.segment5%TYPE,
3242: p_segment_6 IN pay_cost_allocation_keyflex.segment6%TYPE,
3243: p_segment_7 IN pay_cost_allocation_keyflex.segment7%TYPE,
3244: p_segment_8 IN pay_cost_allocation_keyflex.segment8%TYPE,
3245: p_segment_9 IN pay_cost_allocation_keyflex.segment9%TYPE,
3246: p_segment_10 IN pay_cost_allocation_keyflex.segment10%TYPE,
3239: p_segment_3 IN pay_cost_allocation_keyflex.segment3%TYPE,
3240: p_segment_4 IN pay_cost_allocation_keyflex.segment4%TYPE,
3241: p_segment_5 IN pay_cost_allocation_keyflex.segment5%TYPE,
3242: p_segment_6 IN pay_cost_allocation_keyflex.segment6%TYPE,
3243: p_segment_7 IN pay_cost_allocation_keyflex.segment7%TYPE,
3244: p_segment_8 IN pay_cost_allocation_keyflex.segment8%TYPE,
3245: p_segment_9 IN pay_cost_allocation_keyflex.segment9%TYPE,
3246: p_segment_10 IN pay_cost_allocation_keyflex.segment10%TYPE,
3247: p_segment_11 IN pay_cost_allocation_keyflex.segment11%TYPE,
3240: p_segment_4 IN pay_cost_allocation_keyflex.segment4%TYPE,
3241: p_segment_5 IN pay_cost_allocation_keyflex.segment5%TYPE,
3242: p_segment_6 IN pay_cost_allocation_keyflex.segment6%TYPE,
3243: p_segment_7 IN pay_cost_allocation_keyflex.segment7%TYPE,
3244: p_segment_8 IN pay_cost_allocation_keyflex.segment8%TYPE,
3245: p_segment_9 IN pay_cost_allocation_keyflex.segment9%TYPE,
3246: p_segment_10 IN pay_cost_allocation_keyflex.segment10%TYPE,
3247: p_segment_11 IN pay_cost_allocation_keyflex.segment11%TYPE,
3248: p_segment_12 IN pay_cost_allocation_keyflex.segment12%TYPE,
3241: p_segment_5 IN pay_cost_allocation_keyflex.segment5%TYPE,
3242: p_segment_6 IN pay_cost_allocation_keyflex.segment6%TYPE,
3243: p_segment_7 IN pay_cost_allocation_keyflex.segment7%TYPE,
3244: p_segment_8 IN pay_cost_allocation_keyflex.segment8%TYPE,
3245: p_segment_9 IN pay_cost_allocation_keyflex.segment9%TYPE,
3246: p_segment_10 IN pay_cost_allocation_keyflex.segment10%TYPE,
3247: p_segment_11 IN pay_cost_allocation_keyflex.segment11%TYPE,
3248: p_segment_12 IN pay_cost_allocation_keyflex.segment12%TYPE,
3249: p_segment_13 IN pay_cost_allocation_keyflex.segment13%TYPE,
3242: p_segment_6 IN pay_cost_allocation_keyflex.segment6%TYPE,
3243: p_segment_7 IN pay_cost_allocation_keyflex.segment7%TYPE,
3244: p_segment_8 IN pay_cost_allocation_keyflex.segment8%TYPE,
3245: p_segment_9 IN pay_cost_allocation_keyflex.segment9%TYPE,
3246: p_segment_10 IN pay_cost_allocation_keyflex.segment10%TYPE,
3247: p_segment_11 IN pay_cost_allocation_keyflex.segment11%TYPE,
3248: p_segment_12 IN pay_cost_allocation_keyflex.segment12%TYPE,
3249: p_segment_13 IN pay_cost_allocation_keyflex.segment13%TYPE,
3250: p_segment_14 IN pay_cost_allocation_keyflex.segment14%TYPE,
3243: p_segment_7 IN pay_cost_allocation_keyflex.segment7%TYPE,
3244: p_segment_8 IN pay_cost_allocation_keyflex.segment8%TYPE,
3245: p_segment_9 IN pay_cost_allocation_keyflex.segment9%TYPE,
3246: p_segment_10 IN pay_cost_allocation_keyflex.segment10%TYPE,
3247: p_segment_11 IN pay_cost_allocation_keyflex.segment11%TYPE,
3248: p_segment_12 IN pay_cost_allocation_keyflex.segment12%TYPE,
3249: p_segment_13 IN pay_cost_allocation_keyflex.segment13%TYPE,
3250: p_segment_14 IN pay_cost_allocation_keyflex.segment14%TYPE,
3251: p_segment_15 IN pay_cost_allocation_keyflex.segment15%TYPE,
3244: p_segment_8 IN pay_cost_allocation_keyflex.segment8%TYPE,
3245: p_segment_9 IN pay_cost_allocation_keyflex.segment9%TYPE,
3246: p_segment_10 IN pay_cost_allocation_keyflex.segment10%TYPE,
3247: p_segment_11 IN pay_cost_allocation_keyflex.segment11%TYPE,
3248: p_segment_12 IN pay_cost_allocation_keyflex.segment12%TYPE,
3249: p_segment_13 IN pay_cost_allocation_keyflex.segment13%TYPE,
3250: p_segment_14 IN pay_cost_allocation_keyflex.segment14%TYPE,
3251: p_segment_15 IN pay_cost_allocation_keyflex.segment15%TYPE,
3252: p_segment_16 IN pay_cost_allocation_keyflex.segment16%TYPE,
3245: p_segment_9 IN pay_cost_allocation_keyflex.segment9%TYPE,
3246: p_segment_10 IN pay_cost_allocation_keyflex.segment10%TYPE,
3247: p_segment_11 IN pay_cost_allocation_keyflex.segment11%TYPE,
3248: p_segment_12 IN pay_cost_allocation_keyflex.segment12%TYPE,
3249: p_segment_13 IN pay_cost_allocation_keyflex.segment13%TYPE,
3250: p_segment_14 IN pay_cost_allocation_keyflex.segment14%TYPE,
3251: p_segment_15 IN pay_cost_allocation_keyflex.segment15%TYPE,
3252: p_segment_16 IN pay_cost_allocation_keyflex.segment16%TYPE,
3253: p_segment_17 IN pay_cost_allocation_keyflex.segment17%TYPE,
3246: p_segment_10 IN pay_cost_allocation_keyflex.segment10%TYPE,
3247: p_segment_11 IN pay_cost_allocation_keyflex.segment11%TYPE,
3248: p_segment_12 IN pay_cost_allocation_keyflex.segment12%TYPE,
3249: p_segment_13 IN pay_cost_allocation_keyflex.segment13%TYPE,
3250: p_segment_14 IN pay_cost_allocation_keyflex.segment14%TYPE,
3251: p_segment_15 IN pay_cost_allocation_keyflex.segment15%TYPE,
3252: p_segment_16 IN pay_cost_allocation_keyflex.segment16%TYPE,
3253: p_segment_17 IN pay_cost_allocation_keyflex.segment17%TYPE,
3254: p_segment_18 IN pay_cost_allocation_keyflex.segment18%TYPE,
3247: p_segment_11 IN pay_cost_allocation_keyflex.segment11%TYPE,
3248: p_segment_12 IN pay_cost_allocation_keyflex.segment12%TYPE,
3249: p_segment_13 IN pay_cost_allocation_keyflex.segment13%TYPE,
3250: p_segment_14 IN pay_cost_allocation_keyflex.segment14%TYPE,
3251: p_segment_15 IN pay_cost_allocation_keyflex.segment15%TYPE,
3252: p_segment_16 IN pay_cost_allocation_keyflex.segment16%TYPE,
3253: p_segment_17 IN pay_cost_allocation_keyflex.segment17%TYPE,
3254: p_segment_18 IN pay_cost_allocation_keyflex.segment18%TYPE,
3255: p_segment_19 IN pay_cost_allocation_keyflex.segment19%TYPE,
3248: p_segment_12 IN pay_cost_allocation_keyflex.segment12%TYPE,
3249: p_segment_13 IN pay_cost_allocation_keyflex.segment13%TYPE,
3250: p_segment_14 IN pay_cost_allocation_keyflex.segment14%TYPE,
3251: p_segment_15 IN pay_cost_allocation_keyflex.segment15%TYPE,
3252: p_segment_16 IN pay_cost_allocation_keyflex.segment16%TYPE,
3253: p_segment_17 IN pay_cost_allocation_keyflex.segment17%TYPE,
3254: p_segment_18 IN pay_cost_allocation_keyflex.segment18%TYPE,
3255: p_segment_19 IN pay_cost_allocation_keyflex.segment19%TYPE,
3256: p_segment_20 IN pay_cost_allocation_keyflex.segment20%TYPE,
3249: p_segment_13 IN pay_cost_allocation_keyflex.segment13%TYPE,
3250: p_segment_14 IN pay_cost_allocation_keyflex.segment14%TYPE,
3251: p_segment_15 IN pay_cost_allocation_keyflex.segment15%TYPE,
3252: p_segment_16 IN pay_cost_allocation_keyflex.segment16%TYPE,
3253: p_segment_17 IN pay_cost_allocation_keyflex.segment17%TYPE,
3254: p_segment_18 IN pay_cost_allocation_keyflex.segment18%TYPE,
3255: p_segment_19 IN pay_cost_allocation_keyflex.segment19%TYPE,
3256: p_segment_20 IN pay_cost_allocation_keyflex.segment20%TYPE,
3257: p_segment_21 IN pay_cost_allocation_keyflex.segment21%TYPE,
3250: p_segment_14 IN pay_cost_allocation_keyflex.segment14%TYPE,
3251: p_segment_15 IN pay_cost_allocation_keyflex.segment15%TYPE,
3252: p_segment_16 IN pay_cost_allocation_keyflex.segment16%TYPE,
3253: p_segment_17 IN pay_cost_allocation_keyflex.segment17%TYPE,
3254: p_segment_18 IN pay_cost_allocation_keyflex.segment18%TYPE,
3255: p_segment_19 IN pay_cost_allocation_keyflex.segment19%TYPE,
3256: p_segment_20 IN pay_cost_allocation_keyflex.segment20%TYPE,
3257: p_segment_21 IN pay_cost_allocation_keyflex.segment21%TYPE,
3258: p_segment_22 IN pay_cost_allocation_keyflex.segment22%TYPE,
3251: p_segment_15 IN pay_cost_allocation_keyflex.segment15%TYPE,
3252: p_segment_16 IN pay_cost_allocation_keyflex.segment16%TYPE,
3253: p_segment_17 IN pay_cost_allocation_keyflex.segment17%TYPE,
3254: p_segment_18 IN pay_cost_allocation_keyflex.segment18%TYPE,
3255: p_segment_19 IN pay_cost_allocation_keyflex.segment19%TYPE,
3256: p_segment_20 IN pay_cost_allocation_keyflex.segment20%TYPE,
3257: p_segment_21 IN pay_cost_allocation_keyflex.segment21%TYPE,
3258: p_segment_22 IN pay_cost_allocation_keyflex.segment22%TYPE,
3259: p_segment_23 IN pay_cost_allocation_keyflex.segment23%TYPE,
3252: p_segment_16 IN pay_cost_allocation_keyflex.segment16%TYPE,
3253: p_segment_17 IN pay_cost_allocation_keyflex.segment17%TYPE,
3254: p_segment_18 IN pay_cost_allocation_keyflex.segment18%TYPE,
3255: p_segment_19 IN pay_cost_allocation_keyflex.segment19%TYPE,
3256: p_segment_20 IN pay_cost_allocation_keyflex.segment20%TYPE,
3257: p_segment_21 IN pay_cost_allocation_keyflex.segment21%TYPE,
3258: p_segment_22 IN pay_cost_allocation_keyflex.segment22%TYPE,
3259: p_segment_23 IN pay_cost_allocation_keyflex.segment23%TYPE,
3260: p_segment_24 IN pay_cost_allocation_keyflex.segment24%TYPE,
3253: p_segment_17 IN pay_cost_allocation_keyflex.segment17%TYPE,
3254: p_segment_18 IN pay_cost_allocation_keyflex.segment18%TYPE,
3255: p_segment_19 IN pay_cost_allocation_keyflex.segment19%TYPE,
3256: p_segment_20 IN pay_cost_allocation_keyflex.segment20%TYPE,
3257: p_segment_21 IN pay_cost_allocation_keyflex.segment21%TYPE,
3258: p_segment_22 IN pay_cost_allocation_keyflex.segment22%TYPE,
3259: p_segment_23 IN pay_cost_allocation_keyflex.segment23%TYPE,
3260: p_segment_24 IN pay_cost_allocation_keyflex.segment24%TYPE,
3261: p_segment_25 IN pay_cost_allocation_keyflex.segment25%TYPE,
3254: p_segment_18 IN pay_cost_allocation_keyflex.segment18%TYPE,
3255: p_segment_19 IN pay_cost_allocation_keyflex.segment19%TYPE,
3256: p_segment_20 IN pay_cost_allocation_keyflex.segment20%TYPE,
3257: p_segment_21 IN pay_cost_allocation_keyflex.segment21%TYPE,
3258: p_segment_22 IN pay_cost_allocation_keyflex.segment22%TYPE,
3259: p_segment_23 IN pay_cost_allocation_keyflex.segment23%TYPE,
3260: p_segment_24 IN pay_cost_allocation_keyflex.segment24%TYPE,
3261: p_segment_25 IN pay_cost_allocation_keyflex.segment25%TYPE,
3262: p_segment_26 IN pay_cost_allocation_keyflex.segment26%TYPE,
3255: p_segment_19 IN pay_cost_allocation_keyflex.segment19%TYPE,
3256: p_segment_20 IN pay_cost_allocation_keyflex.segment20%TYPE,
3257: p_segment_21 IN pay_cost_allocation_keyflex.segment21%TYPE,
3258: p_segment_22 IN pay_cost_allocation_keyflex.segment22%TYPE,
3259: p_segment_23 IN pay_cost_allocation_keyflex.segment23%TYPE,
3260: p_segment_24 IN pay_cost_allocation_keyflex.segment24%TYPE,
3261: p_segment_25 IN pay_cost_allocation_keyflex.segment25%TYPE,
3262: p_segment_26 IN pay_cost_allocation_keyflex.segment26%TYPE,
3263: p_segment_27 IN pay_cost_allocation_keyflex.segment27%TYPE,
3256: p_segment_20 IN pay_cost_allocation_keyflex.segment20%TYPE,
3257: p_segment_21 IN pay_cost_allocation_keyflex.segment21%TYPE,
3258: p_segment_22 IN pay_cost_allocation_keyflex.segment22%TYPE,
3259: p_segment_23 IN pay_cost_allocation_keyflex.segment23%TYPE,
3260: p_segment_24 IN pay_cost_allocation_keyflex.segment24%TYPE,
3261: p_segment_25 IN pay_cost_allocation_keyflex.segment25%TYPE,
3262: p_segment_26 IN pay_cost_allocation_keyflex.segment26%TYPE,
3263: p_segment_27 IN pay_cost_allocation_keyflex.segment27%TYPE,
3264: p_segment_28 IN pay_cost_allocation_keyflex.segment28%TYPE,
3257: p_segment_21 IN pay_cost_allocation_keyflex.segment21%TYPE,
3258: p_segment_22 IN pay_cost_allocation_keyflex.segment22%TYPE,
3259: p_segment_23 IN pay_cost_allocation_keyflex.segment23%TYPE,
3260: p_segment_24 IN pay_cost_allocation_keyflex.segment24%TYPE,
3261: p_segment_25 IN pay_cost_allocation_keyflex.segment25%TYPE,
3262: p_segment_26 IN pay_cost_allocation_keyflex.segment26%TYPE,
3263: p_segment_27 IN pay_cost_allocation_keyflex.segment27%TYPE,
3264: p_segment_28 IN pay_cost_allocation_keyflex.segment28%TYPE,
3265: p_segment_29 IN pay_cost_allocation_keyflex.segment29%TYPE,
3258: p_segment_22 IN pay_cost_allocation_keyflex.segment22%TYPE,
3259: p_segment_23 IN pay_cost_allocation_keyflex.segment23%TYPE,
3260: p_segment_24 IN pay_cost_allocation_keyflex.segment24%TYPE,
3261: p_segment_25 IN pay_cost_allocation_keyflex.segment25%TYPE,
3262: p_segment_26 IN pay_cost_allocation_keyflex.segment26%TYPE,
3263: p_segment_27 IN pay_cost_allocation_keyflex.segment27%TYPE,
3264: p_segment_28 IN pay_cost_allocation_keyflex.segment28%TYPE,
3265: p_segment_29 IN pay_cost_allocation_keyflex.segment29%TYPE,
3266: p_segment_30 IN pay_cost_allocation_keyflex.segment30%TYPE
3259: p_segment_23 IN pay_cost_allocation_keyflex.segment23%TYPE,
3260: p_segment_24 IN pay_cost_allocation_keyflex.segment24%TYPE,
3261: p_segment_25 IN pay_cost_allocation_keyflex.segment25%TYPE,
3262: p_segment_26 IN pay_cost_allocation_keyflex.segment26%TYPE,
3263: p_segment_27 IN pay_cost_allocation_keyflex.segment27%TYPE,
3264: p_segment_28 IN pay_cost_allocation_keyflex.segment28%TYPE,
3265: p_segment_29 IN pay_cost_allocation_keyflex.segment29%TYPE,
3266: p_segment_30 IN pay_cost_allocation_keyflex.segment30%TYPE
3267: )
3260: p_segment_24 IN pay_cost_allocation_keyflex.segment24%TYPE,
3261: p_segment_25 IN pay_cost_allocation_keyflex.segment25%TYPE,
3262: p_segment_26 IN pay_cost_allocation_keyflex.segment26%TYPE,
3263: p_segment_27 IN pay_cost_allocation_keyflex.segment27%TYPE,
3264: p_segment_28 IN pay_cost_allocation_keyflex.segment28%TYPE,
3265: p_segment_29 IN pay_cost_allocation_keyflex.segment29%TYPE,
3266: p_segment_30 IN pay_cost_allocation_keyflex.segment30%TYPE
3267: )
3268: RETURN BOOLEAN
3261: p_segment_25 IN pay_cost_allocation_keyflex.segment25%TYPE,
3262: p_segment_26 IN pay_cost_allocation_keyflex.segment26%TYPE,
3263: p_segment_27 IN pay_cost_allocation_keyflex.segment27%TYPE,
3264: p_segment_28 IN pay_cost_allocation_keyflex.segment28%TYPE,
3265: p_segment_29 IN pay_cost_allocation_keyflex.segment29%TYPE,
3266: p_segment_30 IN pay_cost_allocation_keyflex.segment30%TYPE
3267: )
3268: RETURN BOOLEAN
3269: IS
3262: p_segment_26 IN pay_cost_allocation_keyflex.segment26%TYPE,
3263: p_segment_27 IN pay_cost_allocation_keyflex.segment27%TYPE,
3264: p_segment_28 IN pay_cost_allocation_keyflex.segment28%TYPE,
3265: p_segment_29 IN pay_cost_allocation_keyflex.segment29%TYPE,
3266: p_segment_30 IN pay_cost_allocation_keyflex.segment30%TYPE
3267: )
3268: RETURN BOOLEAN
3269: IS
3270: l_proc proc_name;
3376: END cost_segments_all_null;
3377:
3378: FUNCTION cost_allocation_kff_id (
3379: p_business_group_id IN per_all_organization_units.business_group_id%TYPE,
3380: p_segment_1 IN pay_cost_allocation_keyflex.segment1%TYPE,
3381: p_segment_2 IN pay_cost_allocation_keyflex.segment2%TYPE,
3382: p_segment_3 IN pay_cost_allocation_keyflex.segment3%TYPE,
3383: p_segment_4 IN pay_cost_allocation_keyflex.segment4%TYPE,
3384: p_segment_5 IN pay_cost_allocation_keyflex.segment5%TYPE,
3377:
3378: FUNCTION cost_allocation_kff_id (
3379: p_business_group_id IN per_all_organization_units.business_group_id%TYPE,
3380: p_segment_1 IN pay_cost_allocation_keyflex.segment1%TYPE,
3381: p_segment_2 IN pay_cost_allocation_keyflex.segment2%TYPE,
3382: p_segment_3 IN pay_cost_allocation_keyflex.segment3%TYPE,
3383: p_segment_4 IN pay_cost_allocation_keyflex.segment4%TYPE,
3384: p_segment_5 IN pay_cost_allocation_keyflex.segment5%TYPE,
3385: p_segment_6 IN pay_cost_allocation_keyflex.segment6%TYPE,
3378: FUNCTION cost_allocation_kff_id (
3379: p_business_group_id IN per_all_organization_units.business_group_id%TYPE,
3380: p_segment_1 IN pay_cost_allocation_keyflex.segment1%TYPE,
3381: p_segment_2 IN pay_cost_allocation_keyflex.segment2%TYPE,
3382: p_segment_3 IN pay_cost_allocation_keyflex.segment3%TYPE,
3383: p_segment_4 IN pay_cost_allocation_keyflex.segment4%TYPE,
3384: p_segment_5 IN pay_cost_allocation_keyflex.segment5%TYPE,
3385: p_segment_6 IN pay_cost_allocation_keyflex.segment6%TYPE,
3386: p_segment_7 IN pay_cost_allocation_keyflex.segment7%TYPE,
3379: p_business_group_id IN per_all_organization_units.business_group_id%TYPE,
3380: p_segment_1 IN pay_cost_allocation_keyflex.segment1%TYPE,
3381: p_segment_2 IN pay_cost_allocation_keyflex.segment2%TYPE,
3382: p_segment_3 IN pay_cost_allocation_keyflex.segment3%TYPE,
3383: p_segment_4 IN pay_cost_allocation_keyflex.segment4%TYPE,
3384: p_segment_5 IN pay_cost_allocation_keyflex.segment5%TYPE,
3385: p_segment_6 IN pay_cost_allocation_keyflex.segment6%TYPE,
3386: p_segment_7 IN pay_cost_allocation_keyflex.segment7%TYPE,
3387: p_segment_8 IN pay_cost_allocation_keyflex.segment8%TYPE,
3380: p_segment_1 IN pay_cost_allocation_keyflex.segment1%TYPE,
3381: p_segment_2 IN pay_cost_allocation_keyflex.segment2%TYPE,
3382: p_segment_3 IN pay_cost_allocation_keyflex.segment3%TYPE,
3383: p_segment_4 IN pay_cost_allocation_keyflex.segment4%TYPE,
3384: p_segment_5 IN pay_cost_allocation_keyflex.segment5%TYPE,
3385: p_segment_6 IN pay_cost_allocation_keyflex.segment6%TYPE,
3386: p_segment_7 IN pay_cost_allocation_keyflex.segment7%TYPE,
3387: p_segment_8 IN pay_cost_allocation_keyflex.segment8%TYPE,
3388: p_segment_9 IN pay_cost_allocation_keyflex.segment9%TYPE,
3381: p_segment_2 IN pay_cost_allocation_keyflex.segment2%TYPE,
3382: p_segment_3 IN pay_cost_allocation_keyflex.segment3%TYPE,
3383: p_segment_4 IN pay_cost_allocation_keyflex.segment4%TYPE,
3384: p_segment_5 IN pay_cost_allocation_keyflex.segment5%TYPE,
3385: p_segment_6 IN pay_cost_allocation_keyflex.segment6%TYPE,
3386: p_segment_7 IN pay_cost_allocation_keyflex.segment7%TYPE,
3387: p_segment_8 IN pay_cost_allocation_keyflex.segment8%TYPE,
3388: p_segment_9 IN pay_cost_allocation_keyflex.segment9%TYPE,
3389: p_segment_10 IN pay_cost_allocation_keyflex.segment10%TYPE,
3382: p_segment_3 IN pay_cost_allocation_keyflex.segment3%TYPE,
3383: p_segment_4 IN pay_cost_allocation_keyflex.segment4%TYPE,
3384: p_segment_5 IN pay_cost_allocation_keyflex.segment5%TYPE,
3385: p_segment_6 IN pay_cost_allocation_keyflex.segment6%TYPE,
3386: p_segment_7 IN pay_cost_allocation_keyflex.segment7%TYPE,
3387: p_segment_8 IN pay_cost_allocation_keyflex.segment8%TYPE,
3388: p_segment_9 IN pay_cost_allocation_keyflex.segment9%TYPE,
3389: p_segment_10 IN pay_cost_allocation_keyflex.segment10%TYPE,
3390: p_segment_11 IN pay_cost_allocation_keyflex.segment11%TYPE,
3383: p_segment_4 IN pay_cost_allocation_keyflex.segment4%TYPE,
3384: p_segment_5 IN pay_cost_allocation_keyflex.segment5%TYPE,
3385: p_segment_6 IN pay_cost_allocation_keyflex.segment6%TYPE,
3386: p_segment_7 IN pay_cost_allocation_keyflex.segment7%TYPE,
3387: p_segment_8 IN pay_cost_allocation_keyflex.segment8%TYPE,
3388: p_segment_9 IN pay_cost_allocation_keyflex.segment9%TYPE,
3389: p_segment_10 IN pay_cost_allocation_keyflex.segment10%TYPE,
3390: p_segment_11 IN pay_cost_allocation_keyflex.segment11%TYPE,
3391: p_segment_12 IN pay_cost_allocation_keyflex.segment12%TYPE,
3384: p_segment_5 IN pay_cost_allocation_keyflex.segment5%TYPE,
3385: p_segment_6 IN pay_cost_allocation_keyflex.segment6%TYPE,
3386: p_segment_7 IN pay_cost_allocation_keyflex.segment7%TYPE,
3387: p_segment_8 IN pay_cost_allocation_keyflex.segment8%TYPE,
3388: p_segment_9 IN pay_cost_allocation_keyflex.segment9%TYPE,
3389: p_segment_10 IN pay_cost_allocation_keyflex.segment10%TYPE,
3390: p_segment_11 IN pay_cost_allocation_keyflex.segment11%TYPE,
3391: p_segment_12 IN pay_cost_allocation_keyflex.segment12%TYPE,
3392: p_segment_13 IN pay_cost_allocation_keyflex.segment13%TYPE,
3385: p_segment_6 IN pay_cost_allocation_keyflex.segment6%TYPE,
3386: p_segment_7 IN pay_cost_allocation_keyflex.segment7%TYPE,
3387: p_segment_8 IN pay_cost_allocation_keyflex.segment8%TYPE,
3388: p_segment_9 IN pay_cost_allocation_keyflex.segment9%TYPE,
3389: p_segment_10 IN pay_cost_allocation_keyflex.segment10%TYPE,
3390: p_segment_11 IN pay_cost_allocation_keyflex.segment11%TYPE,
3391: p_segment_12 IN pay_cost_allocation_keyflex.segment12%TYPE,
3392: p_segment_13 IN pay_cost_allocation_keyflex.segment13%TYPE,
3393: p_segment_14 IN pay_cost_allocation_keyflex.segment14%TYPE,
3386: p_segment_7 IN pay_cost_allocation_keyflex.segment7%TYPE,
3387: p_segment_8 IN pay_cost_allocation_keyflex.segment8%TYPE,
3388: p_segment_9 IN pay_cost_allocation_keyflex.segment9%TYPE,
3389: p_segment_10 IN pay_cost_allocation_keyflex.segment10%TYPE,
3390: p_segment_11 IN pay_cost_allocation_keyflex.segment11%TYPE,
3391: p_segment_12 IN pay_cost_allocation_keyflex.segment12%TYPE,
3392: p_segment_13 IN pay_cost_allocation_keyflex.segment13%TYPE,
3393: p_segment_14 IN pay_cost_allocation_keyflex.segment14%TYPE,
3394: p_segment_15 IN pay_cost_allocation_keyflex.segment15%TYPE,
3387: p_segment_8 IN pay_cost_allocation_keyflex.segment8%TYPE,
3388: p_segment_9 IN pay_cost_allocation_keyflex.segment9%TYPE,
3389: p_segment_10 IN pay_cost_allocation_keyflex.segment10%TYPE,
3390: p_segment_11 IN pay_cost_allocation_keyflex.segment11%TYPE,
3391: p_segment_12 IN pay_cost_allocation_keyflex.segment12%TYPE,
3392: p_segment_13 IN pay_cost_allocation_keyflex.segment13%TYPE,
3393: p_segment_14 IN pay_cost_allocation_keyflex.segment14%TYPE,
3394: p_segment_15 IN pay_cost_allocation_keyflex.segment15%TYPE,
3395: p_segment_16 IN pay_cost_allocation_keyflex.segment16%TYPE,
3388: p_segment_9 IN pay_cost_allocation_keyflex.segment9%TYPE,
3389: p_segment_10 IN pay_cost_allocation_keyflex.segment10%TYPE,
3390: p_segment_11 IN pay_cost_allocation_keyflex.segment11%TYPE,
3391: p_segment_12 IN pay_cost_allocation_keyflex.segment12%TYPE,
3392: p_segment_13 IN pay_cost_allocation_keyflex.segment13%TYPE,
3393: p_segment_14 IN pay_cost_allocation_keyflex.segment14%TYPE,
3394: p_segment_15 IN pay_cost_allocation_keyflex.segment15%TYPE,
3395: p_segment_16 IN pay_cost_allocation_keyflex.segment16%TYPE,
3396: p_segment_17 IN pay_cost_allocation_keyflex.segment17%TYPE,
3389: p_segment_10 IN pay_cost_allocation_keyflex.segment10%TYPE,
3390: p_segment_11 IN pay_cost_allocation_keyflex.segment11%TYPE,
3391: p_segment_12 IN pay_cost_allocation_keyflex.segment12%TYPE,
3392: p_segment_13 IN pay_cost_allocation_keyflex.segment13%TYPE,
3393: p_segment_14 IN pay_cost_allocation_keyflex.segment14%TYPE,
3394: p_segment_15 IN pay_cost_allocation_keyflex.segment15%TYPE,
3395: p_segment_16 IN pay_cost_allocation_keyflex.segment16%TYPE,
3396: p_segment_17 IN pay_cost_allocation_keyflex.segment17%TYPE,
3397: p_segment_18 IN pay_cost_allocation_keyflex.segment18%TYPE,
3390: p_segment_11 IN pay_cost_allocation_keyflex.segment11%TYPE,
3391: p_segment_12 IN pay_cost_allocation_keyflex.segment12%TYPE,
3392: p_segment_13 IN pay_cost_allocation_keyflex.segment13%TYPE,
3393: p_segment_14 IN pay_cost_allocation_keyflex.segment14%TYPE,
3394: p_segment_15 IN pay_cost_allocation_keyflex.segment15%TYPE,
3395: p_segment_16 IN pay_cost_allocation_keyflex.segment16%TYPE,
3396: p_segment_17 IN pay_cost_allocation_keyflex.segment17%TYPE,
3397: p_segment_18 IN pay_cost_allocation_keyflex.segment18%TYPE,
3398: p_segment_19 IN pay_cost_allocation_keyflex.segment19%TYPE,
3391: p_segment_12 IN pay_cost_allocation_keyflex.segment12%TYPE,
3392: p_segment_13 IN pay_cost_allocation_keyflex.segment13%TYPE,
3393: p_segment_14 IN pay_cost_allocation_keyflex.segment14%TYPE,
3394: p_segment_15 IN pay_cost_allocation_keyflex.segment15%TYPE,
3395: p_segment_16 IN pay_cost_allocation_keyflex.segment16%TYPE,
3396: p_segment_17 IN pay_cost_allocation_keyflex.segment17%TYPE,
3397: p_segment_18 IN pay_cost_allocation_keyflex.segment18%TYPE,
3398: p_segment_19 IN pay_cost_allocation_keyflex.segment19%TYPE,
3399: p_segment_20 IN pay_cost_allocation_keyflex.segment20%TYPE,
3392: p_segment_13 IN pay_cost_allocation_keyflex.segment13%TYPE,
3393: p_segment_14 IN pay_cost_allocation_keyflex.segment14%TYPE,
3394: p_segment_15 IN pay_cost_allocation_keyflex.segment15%TYPE,
3395: p_segment_16 IN pay_cost_allocation_keyflex.segment16%TYPE,
3396: p_segment_17 IN pay_cost_allocation_keyflex.segment17%TYPE,
3397: p_segment_18 IN pay_cost_allocation_keyflex.segment18%TYPE,
3398: p_segment_19 IN pay_cost_allocation_keyflex.segment19%TYPE,
3399: p_segment_20 IN pay_cost_allocation_keyflex.segment20%TYPE,
3400: p_segment_21 IN pay_cost_allocation_keyflex.segment21%TYPE,
3393: p_segment_14 IN pay_cost_allocation_keyflex.segment14%TYPE,
3394: p_segment_15 IN pay_cost_allocation_keyflex.segment15%TYPE,
3395: p_segment_16 IN pay_cost_allocation_keyflex.segment16%TYPE,
3396: p_segment_17 IN pay_cost_allocation_keyflex.segment17%TYPE,
3397: p_segment_18 IN pay_cost_allocation_keyflex.segment18%TYPE,
3398: p_segment_19 IN pay_cost_allocation_keyflex.segment19%TYPE,
3399: p_segment_20 IN pay_cost_allocation_keyflex.segment20%TYPE,
3400: p_segment_21 IN pay_cost_allocation_keyflex.segment21%TYPE,
3401: p_segment_22 IN pay_cost_allocation_keyflex.segment22%TYPE,
3394: p_segment_15 IN pay_cost_allocation_keyflex.segment15%TYPE,
3395: p_segment_16 IN pay_cost_allocation_keyflex.segment16%TYPE,
3396: p_segment_17 IN pay_cost_allocation_keyflex.segment17%TYPE,
3397: p_segment_18 IN pay_cost_allocation_keyflex.segment18%TYPE,
3398: p_segment_19 IN pay_cost_allocation_keyflex.segment19%TYPE,
3399: p_segment_20 IN pay_cost_allocation_keyflex.segment20%TYPE,
3400: p_segment_21 IN pay_cost_allocation_keyflex.segment21%TYPE,
3401: p_segment_22 IN pay_cost_allocation_keyflex.segment22%TYPE,
3402: p_segment_23 IN pay_cost_allocation_keyflex.segment23%TYPE,
3395: p_segment_16 IN pay_cost_allocation_keyflex.segment16%TYPE,
3396: p_segment_17 IN pay_cost_allocation_keyflex.segment17%TYPE,
3397: p_segment_18 IN pay_cost_allocation_keyflex.segment18%TYPE,
3398: p_segment_19 IN pay_cost_allocation_keyflex.segment19%TYPE,
3399: p_segment_20 IN pay_cost_allocation_keyflex.segment20%TYPE,
3400: p_segment_21 IN pay_cost_allocation_keyflex.segment21%TYPE,
3401: p_segment_22 IN pay_cost_allocation_keyflex.segment22%TYPE,
3402: p_segment_23 IN pay_cost_allocation_keyflex.segment23%TYPE,
3403: p_segment_24 IN pay_cost_allocation_keyflex.segment24%TYPE,
3396: p_segment_17 IN pay_cost_allocation_keyflex.segment17%TYPE,
3397: p_segment_18 IN pay_cost_allocation_keyflex.segment18%TYPE,
3398: p_segment_19 IN pay_cost_allocation_keyflex.segment19%TYPE,
3399: p_segment_20 IN pay_cost_allocation_keyflex.segment20%TYPE,
3400: p_segment_21 IN pay_cost_allocation_keyflex.segment21%TYPE,
3401: p_segment_22 IN pay_cost_allocation_keyflex.segment22%TYPE,
3402: p_segment_23 IN pay_cost_allocation_keyflex.segment23%TYPE,
3403: p_segment_24 IN pay_cost_allocation_keyflex.segment24%TYPE,
3404: p_segment_25 IN pay_cost_allocation_keyflex.segment25%TYPE,
3397: p_segment_18 IN pay_cost_allocation_keyflex.segment18%TYPE,
3398: p_segment_19 IN pay_cost_allocation_keyflex.segment19%TYPE,
3399: p_segment_20 IN pay_cost_allocation_keyflex.segment20%TYPE,
3400: p_segment_21 IN pay_cost_allocation_keyflex.segment21%TYPE,
3401: p_segment_22 IN pay_cost_allocation_keyflex.segment22%TYPE,
3402: p_segment_23 IN pay_cost_allocation_keyflex.segment23%TYPE,
3403: p_segment_24 IN pay_cost_allocation_keyflex.segment24%TYPE,
3404: p_segment_25 IN pay_cost_allocation_keyflex.segment25%TYPE,
3405: p_segment_26 IN pay_cost_allocation_keyflex.segment26%TYPE,
3398: p_segment_19 IN pay_cost_allocation_keyflex.segment19%TYPE,
3399: p_segment_20 IN pay_cost_allocation_keyflex.segment20%TYPE,
3400: p_segment_21 IN pay_cost_allocation_keyflex.segment21%TYPE,
3401: p_segment_22 IN pay_cost_allocation_keyflex.segment22%TYPE,
3402: p_segment_23 IN pay_cost_allocation_keyflex.segment23%TYPE,
3403: p_segment_24 IN pay_cost_allocation_keyflex.segment24%TYPE,
3404: p_segment_25 IN pay_cost_allocation_keyflex.segment25%TYPE,
3405: p_segment_26 IN pay_cost_allocation_keyflex.segment26%TYPE,
3406: p_segment_27 IN pay_cost_allocation_keyflex.segment27%TYPE,
3399: p_segment_20 IN pay_cost_allocation_keyflex.segment20%TYPE,
3400: p_segment_21 IN pay_cost_allocation_keyflex.segment21%TYPE,
3401: p_segment_22 IN pay_cost_allocation_keyflex.segment22%TYPE,
3402: p_segment_23 IN pay_cost_allocation_keyflex.segment23%TYPE,
3403: p_segment_24 IN pay_cost_allocation_keyflex.segment24%TYPE,
3404: p_segment_25 IN pay_cost_allocation_keyflex.segment25%TYPE,
3405: p_segment_26 IN pay_cost_allocation_keyflex.segment26%TYPE,
3406: p_segment_27 IN pay_cost_allocation_keyflex.segment27%TYPE,
3407: p_segment_28 IN pay_cost_allocation_keyflex.segment28%TYPE,
3400: p_segment_21 IN pay_cost_allocation_keyflex.segment21%TYPE,
3401: p_segment_22 IN pay_cost_allocation_keyflex.segment22%TYPE,
3402: p_segment_23 IN pay_cost_allocation_keyflex.segment23%TYPE,
3403: p_segment_24 IN pay_cost_allocation_keyflex.segment24%TYPE,
3404: p_segment_25 IN pay_cost_allocation_keyflex.segment25%TYPE,
3405: p_segment_26 IN pay_cost_allocation_keyflex.segment26%TYPE,
3406: p_segment_27 IN pay_cost_allocation_keyflex.segment27%TYPE,
3407: p_segment_28 IN pay_cost_allocation_keyflex.segment28%TYPE,
3408: p_segment_29 IN pay_cost_allocation_keyflex.segment29%TYPE,
3401: p_segment_22 IN pay_cost_allocation_keyflex.segment22%TYPE,
3402: p_segment_23 IN pay_cost_allocation_keyflex.segment23%TYPE,
3403: p_segment_24 IN pay_cost_allocation_keyflex.segment24%TYPE,
3404: p_segment_25 IN pay_cost_allocation_keyflex.segment25%TYPE,
3405: p_segment_26 IN pay_cost_allocation_keyflex.segment26%TYPE,
3406: p_segment_27 IN pay_cost_allocation_keyflex.segment27%TYPE,
3407: p_segment_28 IN pay_cost_allocation_keyflex.segment28%TYPE,
3408: p_segment_29 IN pay_cost_allocation_keyflex.segment29%TYPE,
3409: p_segment_30 IN pay_cost_allocation_keyflex.segment30%TYPE
3402: p_segment_23 IN pay_cost_allocation_keyflex.segment23%TYPE,
3403: p_segment_24 IN pay_cost_allocation_keyflex.segment24%TYPE,
3404: p_segment_25 IN pay_cost_allocation_keyflex.segment25%TYPE,
3405: p_segment_26 IN pay_cost_allocation_keyflex.segment26%TYPE,
3406: p_segment_27 IN pay_cost_allocation_keyflex.segment27%TYPE,
3407: p_segment_28 IN pay_cost_allocation_keyflex.segment28%TYPE,
3408: p_segment_29 IN pay_cost_allocation_keyflex.segment29%TYPE,
3409: p_segment_30 IN pay_cost_allocation_keyflex.segment30%TYPE
3410: )
3403: p_segment_24 IN pay_cost_allocation_keyflex.segment24%TYPE,
3404: p_segment_25 IN pay_cost_allocation_keyflex.segment25%TYPE,
3405: p_segment_26 IN pay_cost_allocation_keyflex.segment26%TYPE,
3406: p_segment_27 IN pay_cost_allocation_keyflex.segment27%TYPE,
3407: p_segment_28 IN pay_cost_allocation_keyflex.segment28%TYPE,
3408: p_segment_29 IN pay_cost_allocation_keyflex.segment29%TYPE,
3409: p_segment_30 IN pay_cost_allocation_keyflex.segment30%TYPE
3410: )
3411: RETURN pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE
3404: p_segment_25 IN pay_cost_allocation_keyflex.segment25%TYPE,
3405: p_segment_26 IN pay_cost_allocation_keyflex.segment26%TYPE,
3406: p_segment_27 IN pay_cost_allocation_keyflex.segment27%TYPE,
3407: p_segment_28 IN pay_cost_allocation_keyflex.segment28%TYPE,
3408: p_segment_29 IN pay_cost_allocation_keyflex.segment29%TYPE,
3409: p_segment_30 IN pay_cost_allocation_keyflex.segment30%TYPE
3410: )
3411: RETURN pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE
3412: IS
3405: p_segment_26 IN pay_cost_allocation_keyflex.segment26%TYPE,
3406: p_segment_27 IN pay_cost_allocation_keyflex.segment27%TYPE,
3407: p_segment_28 IN pay_cost_allocation_keyflex.segment28%TYPE,
3408: p_segment_29 IN pay_cost_allocation_keyflex.segment29%TYPE,
3409: p_segment_30 IN pay_cost_allocation_keyflex.segment30%TYPE
3410: )
3411: RETURN pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE
3412: IS
3413: l_proc proc_name;
3407: p_segment_28 IN pay_cost_allocation_keyflex.segment28%TYPE,
3408: p_segment_29 IN pay_cost_allocation_keyflex.segment29%TYPE,
3409: p_segment_30 IN pay_cost_allocation_keyflex.segment30%TYPE
3410: )
3411: RETURN pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE
3412: IS
3413: l_proc proc_name;
3414:
3415: l_cost_allocation_kff_id pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
3411: RETURN pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE
3412: IS
3413: l_proc proc_name;
3414:
3415: l_cost_allocation_kff_id pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
3416: BEGIN
3417: g_debug :=hr_utility.debug_enabled;
3418: if g_debug then
3419: l_proc := g_package
3511: FUNCTION cost_allocation_kff_id (
3512: p_business_group_id IN per_all_organization_units.business_group_id%TYPE,
3513: p_bee_rec IN bee_rec
3514: )
3515: RETURN pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE
3516: IS
3517: l_proc proc_name;
3518:
3519: l_cost_allocation_kff_id pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
3515: RETURN pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE
3516: IS
3517: l_proc proc_name;
3518:
3519: l_cost_allocation_kff_id pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
3520: BEGIN
3521: g_debug :=hr_utility.debug_enabled;
3522: if g_debug then
3523: l_proc := g_package