[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".
295: p_ele_ot_base in varchar2,
296: p_flsa_hours in varchar2,
297: p_ele_processing_type in varchar2,
298: p_ele_priority in number,
299: p_ele_standard_link in varchar2,
300: p_ele_calc_ff_id in number,
301: p_ele_calc_ff_name in varchar2,
302: p_sep_check_option in varchar2,
303: p_dedn_proc in varchar2,
396: p_ele_class in varchar2,
397: p_ele_ot_base in varchar2,
398: p_ele_processing_type in varchar2,
399: p_ele_priority in number,
400: p_ele_standard_link in varchar2,
401: p_skip_formula_id in number default NULL,
402: p_ind_only_flag in varchar2,
403: p_ele_eff_start_date in date,
404: p_bg_name in varchar2,
443: p_mult_entries_allowed => v_mult_entries_allowed,
444: p_formula_id => p_skip_formula_id,
445: p_processing_priority => p_ele_priority,
446: p_process_mode => p_process_mode,
447: p_standard_link_flag => p_ele_standard_link,
448: p_business_group_name => p_bg_name,
449: p_effective_start_date => p_ele_eff_start_date,
450: p_legislation_code => NULL,
451: p_legislation_subgroup => g_template_leg_subgroup);
800: --
801: END IF;
802:
803: --
804: -- "Standard" assignment status processing rule has assignment status type id
805: -- that is NULL!
806: --
807: -- v_asst_status_type_id := NULL;
808:
872: p_rowid => NULL,
873: p_recurring_flag => p_ele_proc_type,
874: p_mandatory_flag => 'N',
875: p_hot_default_flag => 'N',
876: p_standard_link_flag => 'N',
877: p_classification_type => 'N',
878: p_name => v_inpval_name,
879: p_uom => v_inpval_uom,
880: p_min_value => NULL,
931: p_rowid => NULL,
932: p_recurring_flag => p_ele_proc_type,
933: p_mandatory_flag => 'N',
934: p_hot_default_flag => 'N',
935: p_standard_link_flag => 'N',
936: p_classification_type => 'N',
937: p_name => v_inpval_name,
938: p_uom => v_inpval_uom,
939: p_min_value => NULL,
990: p_rowid => NULL,
991: p_recurring_flag => p_ele_proc_type,
992: p_mandatory_flag => 'N',
993: p_hot_default_flag => 'N',
994: p_standard_link_flag => 'N',
995: p_classification_type => 'N',
996: p_name => v_inpval_name,
997: p_uom => v_inpval_uom,
998: p_min_value => NULL,
1060: p_rowid => NULL,
1061: p_recurring_flag => p_ele_proc_type,
1062: p_mandatory_flag => 'N',
1063: p_hot_default_flag => 'N',
1064: p_standard_link_flag => 'N',
1065: p_classification_type => 'N',
1066: p_name => v_inpval_name,
1067: p_uom => v_inpval_uom,
1068: p_min_value => NULL,
1122: p_rowid => NULL,
1123: p_recurring_flag => p_ele_proc_type,
1124: p_mandatory_flag => 'N',
1125: p_hot_default_flag => 'N',
1126: p_standard_link_flag => 'N',
1127: p_classification_type => 'N',
1128: p_name => v_inpval_name,
1129: p_uom => v_inpval_uom,
1130: p_min_value => NULL,
1349: p_rowid => NULL,
1350: p_recurring_flag => p_ele_proc_type,
1351: p_mandatory_flag => 'N',
1352: p_hot_default_flag => 'N',
1353: p_standard_link_flag => 'N',
1354: p_classification_type => 'N',
1355: p_name => v_inpval_name,
1356: p_uom => v_inpval_uom,
1357: p_min_value => NULL,
1408: p_rowid => NULL,
1409: p_recurring_flag => p_ele_proc_type,
1410: p_mandatory_flag => 'N',
1411: p_hot_default_flag => 'N',
1412: p_standard_link_flag => 'N',
1413: p_classification_type => 'N',
1414: p_name => v_inpval_name,
1415: p_uom => v_inpval_uom,
1416: p_min_value => NULL,
1467: p_rowid => NULL,
1468: p_recurring_flag => p_ele_proc_type,
1469: p_mandatory_flag => 'N',
1470: p_hot_default_flag => 'N',
1471: p_standard_link_flag => 'N',
1472: p_classification_type => 'N',
1473: p_name => v_inpval_name,
1474: p_uom => v_inpval_uom,
1475: p_min_value => NULL,
1526: p_rowid => NULL,
1527: p_recurring_flag => p_ele_proc_type,
1528: p_mandatory_flag => 'N',
1529: p_hot_default_flag => 'N',
1530: p_standard_link_flag => 'N',
1531: p_classification_type => 'N',
1532: p_name => v_inpval_name,
1533: p_uom => v_inpval_uom,
1534: p_min_value => NULL,
1776: p_rowid => NULL,
1777: p_recurring_flag => p_ele_proc_type,
1778: p_mandatory_flag => 'N',
1779: p_hot_default_flag => 'N',
1780: p_standard_link_flag => 'N',
1781: p_classification_type => 'N',
1782: p_name => v_inpval_name,
1783: p_uom => v_inpval_uom,
1784: p_min_value => NULL,
1910: p_rowid => NULL,
1911: p_recurring_flag => p_ele_proc_type,
1912: p_mandatory_flag => 'N',
1913: p_hot_default_flag => 'N',
1914: p_standard_link_flag => 'N',
1915: p_classification_type => 'N',
1916: p_name => v_inpval_name,
1917: p_uom => v_inpval_uom,
1918: p_min_value => NULL,
2124: p_rowid => NULL,
2125: p_recurring_flag => p_ele_proc_type,
2126: p_mandatory_flag => 'N',
2127: p_hot_default_flag => 'N',
2128: p_standard_link_flag => 'N',
2129: p_classification_type => 'N',
2130: p_name => v_inpval_name,
2131: p_uom => v_inpval_uom,
2132: p_min_value => NULL,
2191: p_rowid => NULL,
2192: p_recurring_flag => p_ele_proc_type,
2193: p_mandatory_flag => 'N',
2194: p_hot_default_flag => 'N',
2195: p_standard_link_flag => 'N',
2196: p_classification_type => 'N',
2197: p_name => v_inpval_name,
2198: p_uom => v_inpval_uom,
2199: p_min_value => NULL,
2292: p_rowid => NULL,
2293: p_recurring_flag => p_ele_proc_type,
2294: p_mandatory_flag => v_mand_flag,
2295: p_hot_default_flag => 'N',
2296: p_standard_link_flag => 'N',
2297: p_classification_type => 'N',
2298: p_name => v_inpval_name,
2299: p_uom => v_inpval_uom,
2300: p_min_value => NULL,
2388: p_rowid => NULL,
2389: p_recurring_flag => p_ele_proc_type,
2390: p_mandatory_flag => v_mand_flag,
2391: p_hot_default_flag => 'N',
2392: p_standard_link_flag => 'N',
2393: p_classification_type => 'N',
2394: p_name => v_inpval_name,
2395: p_uom => v_inpval_uom,
2396: p_min_value => NULL,
2457: p_rowid => NULL,
2458: p_recurring_flag => p_ele_proc_type,
2459: p_mandatory_flag => 'N',
2460: p_hot_default_flag => 'N',
2461: p_standard_link_flag => 'N',
2462: p_classification_type => 'N',
2463: p_name => v_inpval_name,
2464: p_uom => v_inpval_uom,
2465: p_min_value => NULL,
2536: p_rowid => NULL,
2537: p_recurring_flag => 'N',
2538: p_mandatory_flag => 'N',
2539: p_hot_default_flag => 'N',
2540: p_standard_link_flag => 'N',
2541: p_classification_type => 'N',
2542: p_name => v_inpval_name,
2543: p_uom => v_inpval_uom,
2544: p_min_value => NULL,
2608: p_rowid => NULL,
2609: p_recurring_flag => 'N',
2610: p_mandatory_flag => 'N',
2611: p_hot_default_flag => 'N',
2612: p_standard_link_flag => 'N',
2613: p_classification_type => 'N',
2614: p_name => v_inpval_name,
2615: p_uom => v_inpval_uom,
2616: p_min_value => NULL,
2696: p_rowid => NULL,
2697: p_recurring_flag => 'N',
2698: p_mandatory_flag => 'N',
2699: p_hot_default_flag => 'N',
2700: p_standard_link_flag => 'N',
2701: p_classification_type => 'N',
2702: p_name => v_inpval_name,
2703: p_uom => v_inpval_uom,
2704: p_min_value => NULL,
2768: p_rowid => NULL,
2769: p_recurring_flag => 'N',
2770: p_mandatory_flag => 'N',
2771: p_hot_default_flag => 'N',
2772: p_standard_link_flag => 'N',
2773: p_classification_type => 'N',
2774: p_name => v_inpval_name,
2775: p_uom => v_inpval_uom,
2776: p_min_value => NULL,
2843: p_rowid => NULL,
2844: p_recurring_flag => 'N',
2845: p_mandatory_flag => 'N',
2846: p_hot_default_flag => 'N',
2847: p_standard_link_flag => 'N',
2848: p_classification_type => 'N',
2849: p_name => v_inpval_name,
2850: p_uom => v_inpval_uom,
2851: p_min_value => NULL,
2917: p_rowid => NULL,
2918: p_recurring_flag => 'N',
2919: p_mandatory_flag => 'N',
2920: p_hot_default_flag => 'N',
2921: p_standard_link_flag => 'N',
2922: p_classification_type => 'N',
2923: p_name => v_inpval_name,
2924: p_uom => v_inpval_uom,
2925: p_min_value => NULL,
2989: p_rowid => NULL,
2990: p_recurring_flag => 'N',
2991: p_mandatory_flag => 'N',
2992: p_hot_default_flag => 'N',
2993: p_standard_link_flag => 'N',
2994: p_classification_type => 'N',
2995: p_name => v_inpval_name,
2996: p_uom => v_inpval_uom,
2997: p_min_value => NULL,
3061: p_rowid => NULL,
3062: p_recurring_flag => 'N',
3063: p_mandatory_flag => 'N',
3064: p_hot_default_flag => 'N',
3065: p_standard_link_flag => 'N',
3066: p_classification_type => 'N',
3067: p_name => v_inpval_name,
3068: p_uom => v_inpval_uom,
3069: p_min_value => NULL,
3133: p_rowid => NULL,
3134: p_recurring_flag => 'N',
3135: p_mandatory_flag => 'N',
3136: p_hot_default_flag => 'N',
3137: p_standard_link_flag => 'N',
3138: p_classification_type => 'N',
3139: p_name => v_inpval_name,
3140: p_uom => v_inpval_uom,
3141: p_min_value => NULL,
3205: p_rowid => NULL,
3206: p_recurring_flag => 'N',
3207: p_mandatory_flag => 'N',
3208: p_hot_default_flag => 'N',
3209: p_standard_link_flag => 'N',
3210: p_classification_type => 'N',
3211: p_name => v_inpval_name,
3212: p_uom => v_inpval_uom,
3213: p_min_value => NULL,
3277: p_rowid => NULL,
3278: p_recurring_flag => 'N',
3279: p_mandatory_flag => 'N',
3280: p_hot_default_flag => 'N',
3281: p_standard_link_flag => 'N',
3282: p_classification_type => 'N',
3283: p_name => v_inpval_name,
3284: p_uom => v_inpval_uom,
3285: p_min_value => NULL,
4283: p_ele_classification,
4284: p_ele_ot_base,
4285: p_ele_processing_type,
4286: p_ele_priority,
4287: p_ele_standard_link,
4288: v_skip_formula_id,
4289: 'N',
4290: g_eff_start_date,
4291: v_bg_name,
4374: 'Information',
4375: p_ele_ot_base,
4376: p_ele_processing_type,
4377: v_info_dflt_priority,
4378: p_ele_standard_link,
4379: v_skip_formula_id,
4380: 'N',
4381: g_eff_start_date,
4382: v_bg_name,
4416: p_rowid => NULL,
4417: p_recurring_flag => p_ele_processing_type,
4418: p_mandatory_flag => 'N',
4419: p_hot_default_flag => 'X',
4420: p_standard_link_flag => 'N',
4421: p_classification_type => 'N',
4422: p_name => 'Pay Value',
4423: p_uom => 'M',
4424: p_min_value => NULL,
4506: p_rowid => NULL,
4507: p_recurring_flag => 'N',
4508: p_mandatory_flag => 'X',
4509: p_hot_default_flag => 'N',
4510: p_standard_link_flag => 'N',
4511: p_classification_type => 'N',
4512: p_name => 'Pay Value',
4513: p_uom => 'M',
4514: p_min_value => NULL,
4572: p_rowid => NULL,
4573: p_recurring_flag => 'N',
4574: p_mandatory_flag => 'X',
4575: p_hot_default_flag => 'N',
4576: p_standard_link_flag => 'N',
4577: p_classification_type => 'N',
4578: p_name => 'Pay Value',
4579: p_uom => 'M',
4580: p_min_value => NULL,
5246: p_ele_category in varchar2,
5247: p_ele_ot_base in varchar2,
5248: p_ele_processing_type in varchar2,
5249: p_ele_priority in number,
5250: p_ele_standard_link in varchar2,
5251: p_ele_calculation_rule in varchar2) IS
5252:
5253: CURSOR chk_for_lock IS
5254: SELECT *
5291: AND ( (recinfo.processing_type = p_ele_processing_type)
5292: OR (recinfo.processing_type IS NULL AND p_ele_processing_type IS NULL))
5293: AND ( (recinfo.processing_priority = p_ele_priority)
5294: OR (recinfo.processing_priority IS NULL AND p_ele_priority IS NULL))
5295: AND ( (recinfo.standard_link_flag = p_ele_standard_link)
5296: OR (recinfo.standard_link_flag IS NULL
5297: AND p_ele_standard_link IS NULL)))
5298: THEN
5299: hr_utility.set_location('pyusuiet',1230);
5292: OR (recinfo.processing_type IS NULL AND p_ele_processing_type IS NULL))
5293: AND ( (recinfo.processing_priority = p_ele_priority)
5294: OR (recinfo.processing_priority IS NULL AND p_ele_priority IS NULL))
5295: AND ( (recinfo.standard_link_flag = p_ele_standard_link)
5296: OR (recinfo.standard_link_flag IS NULL
5297: AND p_ele_standard_link IS NULL)))
5298: THEN
5299: hr_utility.set_location('pyusuiet',1230);
5300: RETURN;
5293: AND ( (recinfo.processing_priority = p_ele_priority)
5294: OR (recinfo.processing_priority IS NULL AND p_ele_priority IS NULL))
5295: AND ( (recinfo.standard_link_flag = p_ele_standard_link)
5296: OR (recinfo.standard_link_flag IS NULL
5297: AND p_ele_standard_link IS NULL)))
5298: THEN
5299: hr_utility.set_location('pyusuiet',1230);
5300: RETURN;
5301: ELSE