[Home] [Help]
496: g_wh_supp_over_flow_balance_id number(9);
497:
498: g_ele_classification VARCHAR2(30) := 'INVOLUNTARY DEDUCTIONS';
499: g_ele_info_cat VARCHAR2(30) := 'US_INVOLUNTARY DEDUCTIONS';
500: g_ele_standard_link VARCHAR2(1) := 'N';
501: g_ele_priority NUMBER(9);
502: g_ele_class_id NUMBER(9);
503: g_skip_formula_id NUMBER(9);
504: g_partial_dedn VARCHAR2(30) := 'Y';
539: p_ele_class in varchar2,
540: p_ele_category in varchar2,
541: p_ele_processing_type in varchar2,
542: p_ele_priority in number,
543: p_ele_standard_link in varchar2,
544: p_skip_formula_id in number default NULL,
545: p_ind_only_flag in varchar2,
546: p_third_party_pay in varchar2,
547: p_ele_eff_start_date in date,
589: p_mult_entries_allowed => v_mult_entries_allowed,
590: p_indirect_only_flag => p_ind_only_flag,
591: p_formula_id => p_skip_formula_id,
592: p_processing_priority => p_ele_priority,
593: p_standard_link_flag => p_ele_standard_link,
594: p_business_group_name => p_bg_name,
595: p_effective_start_date => p_ele_eff_start_date,
596: p_effective_end_date => p_ele_eff_end_date,
597: p_legislation_code => NULL,
2425: p_ele_class => g_ele_classification,
2426: p_ele_category => p_category,
2427: p_ele_processing_type => garn_ele_proc_type(i),
2428: p_ele_priority => garn_ele_priority(i),
2429: p_ele_standard_link => g_ele_standard_link,
2430: p_skip_formula_id => g_skip_formula_id,
2431: p_ind_only_flag => garn_indirect_only(i),
2432: p_third_party_pay => garn_third_party_pay(i),
2433: p_ele_eff_start_date => g_eff_start_date,
2540: NULL; -- spr already has this formula attached.
2541:
2542: ELSE
2543:
2544: -- Make sure to update the "standard" processing rule, ie. which
2545: -- is the one that was checked for in spr_exists.
2546: UPDATE pay_status_processing_rules_f
2547: SET formula_id = v_calc_formula_id
2548: WHERE status_processing_rule_id = already_exists
2608: p_rowid => NULL,
2609: p_recurring_flag => 'N',
2610: p_mandatory_flag => garn_base_iv_mand(k),
2611: p_hot_default_flag => 'N',
2612: p_standard_link_flag => 'N',
2613: p_classification_type => 'N',
2614: p_name => garn_base_iv_names(k),
2615: p_uom => garn_base_iv_uom(k),
2616: p_min_value => NULL,
2674: p_rowid => NULL,
2675: p_recurring_flag => 'N',
2676: p_mandatory_flag => garn_base_iv_mand(k),
2677: p_hot_default_flag => 'N',
2678: p_standard_link_flag => 'N',
2679: p_classification_type => 'N',
2680: p_name => garn_base_iv_names(k),
2681: p_uom => garn_base_iv_uom(k),
2682: p_min_value => NULL,
2777: p_rowid => NULL,
2778: p_recurring_flag => 'N',
2779: p_mandatory_flag => garn_calc_iv_mand(c),
2780: p_hot_default_flag => 'N',
2781: p_standard_link_flag => 'N',
2782: p_classification_type => 'N',
2783: p_name => garn_calc_iv_names(c),
2784: p_uom => garn_calc_iv_uom(c),
2785: p_min_value => NULL,
2840: p_rowid => NULL,
2841: p_recurring_flag => 'N',
2842: p_mandatory_flag => garn_calc_iv_mand(c),
2843: p_hot_default_flag => 'N',
2844: p_standard_link_flag => 'N',
2845: p_classification_type => 'N',
2846: p_name => garn_calc_iv_names(c),
2847: p_uom => garn_calc_iv_uom(c),
2848: p_min_value => NULL,
2941: p_rowid => NULL,
2942: p_recurring_flag => 'N',
2943: p_mandatory_flag => garn_verif_iv_mand(v),
2944: p_hot_default_flag => 'N',
2945: p_standard_link_flag => 'N',
2946: p_classification_type => 'N',
2947: p_name => garn_verif_iv_names(v),
2948: p_uom => garn_verif_iv_uom(v),
2949: p_min_value => NULL,
3004: p_rowid => NULL,
3005: p_recurring_flag => 'N',
3006: p_mandatory_flag => garn_verif_iv_mand(v),
3007: p_hot_default_flag => 'N',
3008: p_standard_link_flag => 'N',
3009: p_classification_type => 'N',
3010: p_name => garn_verif_iv_names(v),
3011: p_uom => garn_verif_iv_uom(v),
3012: p_min_value => NULL,
3104: p_rowid => NULL,
3105: p_recurring_flag => 'N',
3106: p_mandatory_flag => garn_si_iv_mand(siv),
3107: p_hot_default_flag => 'N',
3108: p_standard_link_flag => 'N',
3109: p_classification_type => 'N',
3110: p_name => garn_si_iv_names(siv),
3111: p_uom => garn_si_iv_uom(siv),
3112: p_min_value => NULL,
3167: p_rowid => NULL,
3168: p_recurring_flag => 'N',
3169: p_mandatory_flag => garn_si_iv_mand(siv),
3170: p_hot_default_flag => 'N',
3171: p_standard_link_flag => 'N',
3172: p_classification_type => 'N',
3173: p_name => garn_si_iv_names(siv),
3174: p_uom => garn_si_iv_uom(siv),
3175: p_min_value => NULL,
3269: p_rowid => NULL,
3270: p_recurring_flag => 'N',
3271: p_mandatory_flag => garn_sf_iv_mand(sfv),
3272: p_hot_default_flag => 'N',
3273: p_standard_link_flag => 'N',
3274: p_classification_type => 'N',
3275: p_name => garn_sf_iv_names(sfv),
3276: p_uom => garn_sf_iv_uom(sfv),
3277: p_min_value => NULL,
3332: p_rowid => NULL,
3333: p_recurring_flag => 'N',
3334: p_mandatory_flag => garn_sf_iv_mand(sfv),
3335: p_hot_default_flag => 'N',
3336: p_standard_link_flag => 'N',
3337: p_classification_type => 'N',
3338: p_name => garn_sf_iv_names(sfv),
3339: p_uom => garn_sf_iv_uom(sfv),
3340: p_min_value => NULL,
3432: p_rowid => NULL,
3433: p_recurring_flag => 'N',
3434: p_mandatory_flag => garn_fee_iv_mand(lfee),
3435: p_hot_default_flag => 'N',
3436: p_standard_link_flag => 'N',
3437: p_classification_type => 'N',
3438: p_name => garn_fee_iv_names(lfee),
3439: p_uom => garn_fee_iv_uom(lfee),
3440: p_min_value => NULL,
3495: p_rowid => NULL,
3496: p_recurring_flag => 'N',
3497: p_mandatory_flag => garn_fee_iv_mand(lfee),
3498: p_hot_default_flag => 'N',
3499: p_standard_link_flag => 'N',
3500: p_classification_type => 'N',
3501: p_name => garn_fee_iv_names(lfee),
3502: p_uom => garn_fee_iv_uom(lfee),
3503: p_min_value => NULL,
3593: p_rowid => NULL,
3594: p_recurring_flag => 'N',
3595: p_mandatory_flag => garn_vp_iv_mand(lvp),
3596: p_hot_default_flag => 'N',
3597: p_standard_link_flag => 'N',
3598: p_classification_type => 'N',
3599: p_name => garn_vp_iv_names(lvp),
3600: p_uom => garn_vp_iv_uom(lvp),
3601: p_min_value => NULL,
3656: p_rowid => NULL,
3657: p_recurring_flag => 'N',
3658: p_mandatory_flag => garn_vp_iv_mand(lvp),
3659: p_hot_default_flag => 'N',
3660: p_standard_link_flag => 'N',
3661: p_classification_type => 'N',
3662: p_name => garn_vp_iv_names(lvp),
3663: p_uom => garn_vp_iv_uom(lvp),
3664: p_min_value => NULL,