DBA Data[Home] [Help]

APPS.HXT_INTERFACE_UTILITIES dependencies on PAY_COST_ALLOCATION_KEYFLEX

Line 3250: p_cost_allocation_keyflex_id IN pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE

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;

Line 3252: RETURN pay_cost_allocation_keyflex.concatenated_segments%TYPE

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:

Line 3258: p_cost_allocation_keyflex_id pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE

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

Line 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;

Line 3265: l_costflex_concat_segments pay_cost_allocation_keyflex.concatenated_segments%TYPE;

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

Line 3315: p_segment_1 IN pay_cost_allocation_keyflex.segment1%TYPE,

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,

Line 3316: p_segment_2 IN pay_cost_allocation_keyflex.segment2%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,

Line 3317: p_segment_3 IN pay_cost_allocation_keyflex.segment3%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,

Line 3318: p_segment_4 IN pay_cost_allocation_keyflex.segment4%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,

Line 3319: p_segment_5 IN pay_cost_allocation_keyflex.segment5%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,

Line 3320: p_segment_6 IN pay_cost_allocation_keyflex.segment6%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,

Line 3321: p_segment_7 IN pay_cost_allocation_keyflex.segment7%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,

Line 3322: p_segment_8 IN pay_cost_allocation_keyflex.segment8%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,

Line 3323: p_segment_9 IN pay_cost_allocation_keyflex.segment9%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,

Line 3324: p_segment_10 IN pay_cost_allocation_keyflex.segment10%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,

Line 3325: p_segment_11 IN pay_cost_allocation_keyflex.segment11%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,

Line 3326: p_segment_12 IN pay_cost_allocation_keyflex.segment12%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,

Line 3327: p_segment_13 IN pay_cost_allocation_keyflex.segment13%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,

Line 3328: p_segment_14 IN pay_cost_allocation_keyflex.segment14%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,

Line 3329: p_segment_15 IN pay_cost_allocation_keyflex.segment15%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,

Line 3330: p_segment_16 IN pay_cost_allocation_keyflex.segment16%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,

Line 3331: p_segment_17 IN pay_cost_allocation_keyflex.segment17%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,

Line 3332: p_segment_18 IN pay_cost_allocation_keyflex.segment18%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,

Line 3333: p_segment_19 IN pay_cost_allocation_keyflex.segment19%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,

Line 3334: p_segment_20 IN pay_cost_allocation_keyflex.segment20%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,

Line 3335: p_segment_21 IN pay_cost_allocation_keyflex.segment21%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,

Line 3336: p_segment_22 IN pay_cost_allocation_keyflex.segment22%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,

Line 3337: p_segment_23 IN pay_cost_allocation_keyflex.segment23%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,

Line 3338: p_segment_24 IN pay_cost_allocation_keyflex.segment24%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,

Line 3339: p_segment_25 IN pay_cost_allocation_keyflex.segment25%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,

Line 3340: p_segment_26 IN pay_cost_allocation_keyflex.segment26%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

Line 3341: p_segment_27 IN pay_cost_allocation_keyflex.segment27%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: )

Line 3342: p_segment_28 IN pay_cost_allocation_keyflex.segment28%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: )
3346: RETURN BOOLEAN

Line 3343: p_segment_29 IN pay_cost_allocation_keyflex.segment29%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
3347: IS

Line 3344: p_segment_30 IN pay_cost_allocation_keyflex.segment30%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
3348: l_proc proc_name;

Line 3458: p_segment_1 IN pay_cost_allocation_keyflex.segment1%TYPE,

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,

Line 3459: p_segment_2 IN pay_cost_allocation_keyflex.segment2%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,

Line 3460: p_segment_3 IN pay_cost_allocation_keyflex.segment3%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,

Line 3461: p_segment_4 IN pay_cost_allocation_keyflex.segment4%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,

Line 3462: p_segment_5 IN pay_cost_allocation_keyflex.segment5%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,

Line 3463: p_segment_6 IN pay_cost_allocation_keyflex.segment6%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,

Line 3464: p_segment_7 IN pay_cost_allocation_keyflex.segment7%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,

Line 3465: p_segment_8 IN pay_cost_allocation_keyflex.segment8%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,

Line 3466: p_segment_9 IN pay_cost_allocation_keyflex.segment9%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,

Line 3467: p_segment_10 IN pay_cost_allocation_keyflex.segment10%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,

Line 3468: p_segment_11 IN pay_cost_allocation_keyflex.segment11%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,

Line 3469: p_segment_12 IN pay_cost_allocation_keyflex.segment12%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,

Line 3470: p_segment_13 IN pay_cost_allocation_keyflex.segment13%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,

Line 3471: p_segment_14 IN pay_cost_allocation_keyflex.segment14%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,

Line 3472: p_segment_15 IN pay_cost_allocation_keyflex.segment15%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,

Line 3473: p_segment_16 IN pay_cost_allocation_keyflex.segment16%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,

Line 3474: p_segment_17 IN pay_cost_allocation_keyflex.segment17%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,

Line 3475: p_segment_18 IN pay_cost_allocation_keyflex.segment18%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,

Line 3476: p_segment_19 IN pay_cost_allocation_keyflex.segment19%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,

Line 3477: p_segment_20 IN pay_cost_allocation_keyflex.segment20%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,

Line 3478: p_segment_21 IN pay_cost_allocation_keyflex.segment21%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,

Line 3479: p_segment_22 IN pay_cost_allocation_keyflex.segment22%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,

Line 3480: p_segment_23 IN pay_cost_allocation_keyflex.segment23%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,

Line 3481: p_segment_24 IN pay_cost_allocation_keyflex.segment24%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,

Line 3482: p_segment_25 IN pay_cost_allocation_keyflex.segment25%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,

Line 3483: p_segment_26 IN pay_cost_allocation_keyflex.segment26%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

Line 3484: p_segment_27 IN pay_cost_allocation_keyflex.segment27%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: )

Line 3485: p_segment_28 IN pay_cost_allocation_keyflex.segment28%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: )
3489: RETURN pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE

Line 3486: p_segment_29 IN pay_cost_allocation_keyflex.segment29%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

Line 3487: p_segment_30 IN pay_cost_allocation_keyflex.segment30%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
3491: l_proc proc_name;

Line 3489: RETURN pay_cost_allocation_keyflex.cost_allocation_keyflex_id%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;
3492:
3493: l_cost_allocation_kff_id pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;

Line 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

Line 3593: RETURN pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE

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;

Line 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