[Home] [Help]
33: 07-NOV-93 hparicha 1.3 Defaults input value for
34: "Deduction Processing" inpval
35: based on new radio group in
36: PAYSUDEE.
37: "Standard" processing rule
38: now uses NULL asst status type.
39: 25-FEB-94 hparicha 40.18 G581 "Negative Earnings" fn'ality.
40: General cleanup of code.
41: 17-MAR-94 hparicha 40.19 G604 Call "create_gross_up".
293: p_ele_ot_base in varchar2,
294: p_flsa_hours in varchar2,
295: p_ele_processing_type in varchar2,
296: p_ele_priority in number,
297: p_ele_standard_link in varchar2,
298: p_ele_calc_ff_id in number,
299: p_ele_calc_ff_name in varchar2,
300: p_sep_check_option in varchar2,
301: p_dedn_proc in varchar2,
394: p_ele_class in varchar2,
395: p_ele_ot_base in varchar2,
396: p_ele_processing_type in varchar2,
397: p_ele_priority in number,
398: p_ele_standard_link in varchar2,
399: p_skip_formula_id in number default NULL,
400: p_ind_only_flag in varchar2,
401: p_ele_eff_start_date in date,
402: p_bg_name in varchar2,
441: p_mult_entries_allowed => v_mult_entries_allowed,
442: p_formula_id => p_skip_formula_id,
443: p_processing_priority => p_ele_priority,
444: p_process_mode => p_process_mode,
445: p_standard_link_flag => p_ele_standard_link,
446: p_business_group_name => p_bg_name,
447: p_effective_start_date => p_ele_eff_start_date,
448: p_legislation_code => NULL,
449: p_legislation_subgroup => g_template_leg_subgroup);
798: --
799: END IF;
800:
801: --
802: -- "Standard" assignment status processing rule has assignment status type id
803: -- that is NULL!
804: --
805: -- v_asst_status_type_id := NULL;
806:
870: p_rowid => NULL,
871: p_recurring_flag => p_ele_proc_type,
872: p_mandatory_flag => 'N',
873: p_hot_default_flag => 'N',
874: p_standard_link_flag => 'N',
875: p_classification_type => 'N',
876: p_name => v_inpval_name,
877: p_uom => v_inpval_uom,
878: p_min_value => NULL,
929: p_rowid => NULL,
930: p_recurring_flag => p_ele_proc_type,
931: p_mandatory_flag => 'N',
932: p_hot_default_flag => 'N',
933: p_standard_link_flag => 'N',
934: p_classification_type => 'N',
935: p_name => v_inpval_name,
936: p_uom => v_inpval_uom,
937: p_min_value => NULL,
988: p_rowid => NULL,
989: p_recurring_flag => p_ele_proc_type,
990: p_mandatory_flag => 'N',
991: p_hot_default_flag => 'N',
992: p_standard_link_flag => 'N',
993: p_classification_type => 'N',
994: p_name => v_inpval_name,
995: p_uom => v_inpval_uom,
996: p_min_value => NULL,
1058: p_rowid => NULL,
1059: p_recurring_flag => p_ele_proc_type,
1060: p_mandatory_flag => 'N',
1061: p_hot_default_flag => 'N',
1062: p_standard_link_flag => 'N',
1063: p_classification_type => 'N',
1064: p_name => v_inpval_name,
1065: p_uom => v_inpval_uom,
1066: p_min_value => NULL,
1120: p_rowid => NULL,
1121: p_recurring_flag => p_ele_proc_type,
1122: p_mandatory_flag => 'N',
1123: p_hot_default_flag => 'N',
1124: p_standard_link_flag => 'N',
1125: p_classification_type => 'N',
1126: p_name => v_inpval_name,
1127: p_uom => v_inpval_uom,
1128: p_min_value => NULL,
1347: p_rowid => NULL,
1348: p_recurring_flag => p_ele_proc_type,
1349: p_mandatory_flag => 'N',
1350: p_hot_default_flag => 'N',
1351: p_standard_link_flag => 'N',
1352: p_classification_type => 'N',
1353: p_name => v_inpval_name,
1354: p_uom => v_inpval_uom,
1355: p_min_value => NULL,
1406: p_rowid => NULL,
1407: p_recurring_flag => p_ele_proc_type,
1408: p_mandatory_flag => 'N',
1409: p_hot_default_flag => 'N',
1410: p_standard_link_flag => 'N',
1411: p_classification_type => 'N',
1412: p_name => v_inpval_name,
1413: p_uom => v_inpval_uom,
1414: p_min_value => NULL,
1465: p_rowid => NULL,
1466: p_recurring_flag => p_ele_proc_type,
1467: p_mandatory_flag => 'N',
1468: p_hot_default_flag => 'N',
1469: p_standard_link_flag => 'N',
1470: p_classification_type => 'N',
1471: p_name => v_inpval_name,
1472: p_uom => v_inpval_uom,
1473: p_min_value => NULL,
1524: p_rowid => NULL,
1525: p_recurring_flag => p_ele_proc_type,
1526: p_mandatory_flag => 'N',
1527: p_hot_default_flag => 'N',
1528: p_standard_link_flag => 'N',
1529: p_classification_type => 'N',
1530: p_name => v_inpval_name,
1531: p_uom => v_inpval_uom,
1532: p_min_value => NULL,
1774: p_rowid => NULL,
1775: p_recurring_flag => p_ele_proc_type,
1776: p_mandatory_flag => 'N',
1777: p_hot_default_flag => 'N',
1778: p_standard_link_flag => 'N',
1779: p_classification_type => 'N',
1780: p_name => v_inpval_name,
1781: p_uom => v_inpval_uom,
1782: p_min_value => NULL,
1908: p_rowid => NULL,
1909: p_recurring_flag => p_ele_proc_type,
1910: p_mandatory_flag => 'N',
1911: p_hot_default_flag => 'N',
1912: p_standard_link_flag => 'N',
1913: p_classification_type => 'N',
1914: p_name => v_inpval_name,
1915: p_uom => v_inpval_uom,
1916: p_min_value => NULL,
2122: p_rowid => NULL,
2123: p_recurring_flag => p_ele_proc_type,
2124: p_mandatory_flag => 'N',
2125: p_hot_default_flag => 'N',
2126: p_standard_link_flag => 'N',
2127: p_classification_type => 'N',
2128: p_name => v_inpval_name,
2129: p_uom => v_inpval_uom,
2130: p_min_value => NULL,
2189: p_rowid => NULL,
2190: p_recurring_flag => p_ele_proc_type,
2191: p_mandatory_flag => 'N',
2192: p_hot_default_flag => 'N',
2193: p_standard_link_flag => 'N',
2194: p_classification_type => 'N',
2195: p_name => v_inpval_name,
2196: p_uom => v_inpval_uom,
2197: p_min_value => NULL,
2290: p_rowid => NULL,
2291: p_recurring_flag => p_ele_proc_type,
2292: p_mandatory_flag => v_mand_flag,
2293: p_hot_default_flag => 'N',
2294: p_standard_link_flag => 'N',
2295: p_classification_type => 'N',
2296: p_name => v_inpval_name,
2297: p_uom => v_inpval_uom,
2298: p_min_value => NULL,
2386: p_rowid => NULL,
2387: p_recurring_flag => p_ele_proc_type,
2388: p_mandatory_flag => v_mand_flag,
2389: p_hot_default_flag => 'N',
2390: p_standard_link_flag => 'N',
2391: p_classification_type => 'N',
2392: p_name => v_inpval_name,
2393: p_uom => v_inpval_uom,
2394: p_min_value => NULL,
2455: p_rowid => NULL,
2456: p_recurring_flag => p_ele_proc_type,
2457: p_mandatory_flag => 'N',
2458: p_hot_default_flag => 'N',
2459: p_standard_link_flag => 'N',
2460: p_classification_type => 'N',
2461: p_name => v_inpval_name,
2462: p_uom => v_inpval_uom,
2463: p_min_value => NULL,
2534: p_rowid => NULL,
2535: p_recurring_flag => 'N',
2536: p_mandatory_flag => 'N',
2537: p_hot_default_flag => 'N',
2538: p_standard_link_flag => 'N',
2539: p_classification_type => 'N',
2540: p_name => v_inpval_name,
2541: p_uom => v_inpval_uom,
2542: p_min_value => NULL,
2606: p_rowid => NULL,
2607: p_recurring_flag => 'N',
2608: p_mandatory_flag => 'N',
2609: p_hot_default_flag => 'N',
2610: p_standard_link_flag => 'N',
2611: p_classification_type => 'N',
2612: p_name => v_inpval_name,
2613: p_uom => v_inpval_uom,
2614: p_min_value => NULL,
2694: p_rowid => NULL,
2695: p_recurring_flag => 'N',
2696: p_mandatory_flag => 'N',
2697: p_hot_default_flag => 'N',
2698: p_standard_link_flag => 'N',
2699: p_classification_type => 'N',
2700: p_name => v_inpval_name,
2701: p_uom => v_inpval_uom,
2702: p_min_value => NULL,
2766: p_rowid => NULL,
2767: p_recurring_flag => 'N',
2768: p_mandatory_flag => 'N',
2769: p_hot_default_flag => 'N',
2770: p_standard_link_flag => 'N',
2771: p_classification_type => 'N',
2772: p_name => v_inpval_name,
2773: p_uom => v_inpval_uom,
2774: p_min_value => NULL,
2841: p_rowid => NULL,
2842: p_recurring_flag => 'N',
2843: p_mandatory_flag => 'N',
2844: p_hot_default_flag => 'N',
2845: p_standard_link_flag => 'N',
2846: p_classification_type => 'N',
2847: p_name => v_inpval_name,
2848: p_uom => v_inpval_uom,
2849: p_min_value => NULL,
2915: p_rowid => NULL,
2916: p_recurring_flag => 'N',
2917: p_mandatory_flag => 'N',
2918: p_hot_default_flag => 'N',
2919: p_standard_link_flag => 'N',
2920: p_classification_type => 'N',
2921: p_name => v_inpval_name,
2922: p_uom => v_inpval_uom,
2923: p_min_value => NULL,
2987: p_rowid => NULL,
2988: p_recurring_flag => 'N',
2989: p_mandatory_flag => 'N',
2990: p_hot_default_flag => 'N',
2991: p_standard_link_flag => 'N',
2992: p_classification_type => 'N',
2993: p_name => v_inpval_name,
2994: p_uom => v_inpval_uom,
2995: p_min_value => NULL,
3059: p_rowid => NULL,
3060: p_recurring_flag => 'N',
3061: p_mandatory_flag => 'N',
3062: p_hot_default_flag => 'N',
3063: p_standard_link_flag => 'N',
3064: p_classification_type => 'N',
3065: p_name => v_inpval_name,
3066: p_uom => v_inpval_uom,
3067: p_min_value => NULL,
3131: p_rowid => NULL,
3132: p_recurring_flag => 'N',
3133: p_mandatory_flag => 'N',
3134: p_hot_default_flag => 'N',
3135: p_standard_link_flag => 'N',
3136: p_classification_type => 'N',
3137: p_name => v_inpval_name,
3138: p_uom => v_inpval_uom,
3139: p_min_value => NULL,
3203: p_rowid => NULL,
3204: p_recurring_flag => 'N',
3205: p_mandatory_flag => 'N',
3206: p_hot_default_flag => 'N',
3207: p_standard_link_flag => 'N',
3208: p_classification_type => 'N',
3209: p_name => v_inpval_name,
3210: p_uom => v_inpval_uom,
3211: p_min_value => NULL,
3275: p_rowid => NULL,
3276: p_recurring_flag => 'N',
3277: p_mandatory_flag => 'N',
3278: p_hot_default_flag => 'N',
3279: p_standard_link_flag => 'N',
3280: p_classification_type => 'N',
3281: p_name => v_inpval_name,
3282: p_uom => v_inpval_uom,
3283: p_min_value => NULL,
4281: p_ele_classification,
4282: p_ele_ot_base,
4283: p_ele_processing_type,
4284: p_ele_priority,
4285: p_ele_standard_link,
4286: v_skip_formula_id,
4287: 'N',
4288: g_eff_start_date,
4289: v_bg_name,
4372: 'Information',
4373: p_ele_ot_base,
4374: p_ele_processing_type,
4375: v_info_dflt_priority,
4376: p_ele_standard_link,
4377: v_skip_formula_id,
4378: 'N',
4379: g_eff_start_date,
4380: v_bg_name,
4414: p_rowid => NULL,
4415: p_recurring_flag => p_ele_processing_type,
4416: p_mandatory_flag => 'N',
4417: p_hot_default_flag => 'X',
4418: p_standard_link_flag => 'N',
4419: p_classification_type => 'N',
4420: p_name => 'Pay Value',
4421: p_uom => 'M',
4422: p_min_value => NULL,
4504: p_rowid => NULL,
4505: p_recurring_flag => 'N',
4506: p_mandatory_flag => 'X',
4507: p_hot_default_flag => 'N',
4508: p_standard_link_flag => 'N',
4509: p_classification_type => 'N',
4510: p_name => 'Pay Value',
4511: p_uom => 'M',
4512: p_min_value => NULL,
4570: p_rowid => NULL,
4571: p_recurring_flag => 'N',
4572: p_mandatory_flag => 'X',
4573: p_hot_default_flag => 'N',
4574: p_standard_link_flag => 'N',
4575: p_classification_type => 'N',
4576: p_name => 'Pay Value',
4577: p_uom => 'M',
4578: p_min_value => NULL,
5244: p_ele_category in varchar2,
5245: p_ele_ot_base in varchar2,
5246: p_ele_processing_type in varchar2,
5247: p_ele_priority in number,
5248: p_ele_standard_link in varchar2,
5249: p_ele_calculation_rule in varchar2) IS
5250:
5251: CURSOR chk_for_lock IS
5252: SELECT *
5289: AND ( (recinfo.processing_type = p_ele_processing_type)
5290: OR (recinfo.processing_type IS NULL AND p_ele_processing_type IS NULL))
5291: AND ( (recinfo.processing_priority = p_ele_priority)
5292: OR (recinfo.processing_priority IS NULL AND p_ele_priority IS NULL))
5293: AND ( (recinfo.standard_link_flag = p_ele_standard_link)
5294: OR (recinfo.standard_link_flag IS NULL
5295: AND p_ele_standard_link IS NULL)))
5296: THEN
5297: hr_utility.set_location('pyusuiet',1230);
5290: OR (recinfo.processing_type IS NULL AND p_ele_processing_type IS NULL))
5291: AND ( (recinfo.processing_priority = p_ele_priority)
5292: OR (recinfo.processing_priority IS NULL AND p_ele_priority IS NULL))
5293: AND ( (recinfo.standard_link_flag = p_ele_standard_link)
5294: OR (recinfo.standard_link_flag IS NULL
5295: AND p_ele_standard_link IS NULL)))
5296: THEN
5297: hr_utility.set_location('pyusuiet',1230);
5298: RETURN;
5291: AND ( (recinfo.processing_priority = p_ele_priority)
5292: OR (recinfo.processing_priority IS NULL AND p_ele_priority IS NULL))
5293: AND ( (recinfo.standard_link_flag = p_ele_standard_link)
5294: OR (recinfo.standard_link_flag IS NULL
5295: AND p_ele_standard_link IS NULL)))
5296: THEN
5297: hr_utility.set_location('pyusuiet',1230);
5298: RETURN;
5299: ELSE