DBA Data[Home] [Help]

APPS.HR_USER_INIT_DEDN dependencies on STANDARD

Line 310: p_ele_standard_link in varchar2 default 'N',

306: p_ben_class_id in number,
307: p_ele_category in varchar2 default NULL,
308: p_ele_processing_type in varchar2,
309: p_ele_priority in number default NULL,
310: p_ele_standard_link in varchar2 default 'N',
311: p_ele_proc_runtype in varchar2,
312: p_ele_start_rule in varchar2,
313: p_ele_stop_rule in varchar2,
314: p_ele_ee_bond in varchar2 default 'N',

Line 442: p_ele_standard_link in varchar2,

438: p_ele_category in varchar2,
439: p_ele_start_rule in varchar2,
440: p_ele_processing_type in varchar2,
441: p_ele_priority in number,
442: p_ele_standard_link in varchar2,
443: p_skip_formula_id in number default NULL,
444: p_ind_only_flag in varchar2,
445: p_ele_eff_start_date in date,
446: p_ele_eff_end_date in date,

Line 495: p_standard_link_flag => p_ele_standard_link,

491: p_mult_entries_allowed => v_mult_entries_allowed,
492: p_indirect_only_flag => p_ind_only_flag,
493: p_formula_id => p_skip_formula_id,
494: p_processing_priority => p_ele_priority,
495: p_standard_link_flag => p_ele_standard_link,
496: p_business_group_name => p_bg_name,
497: p_effective_start_date => p_ele_eff_start_date,
498: p_effective_end_date => p_ele_eff_end_date,
499: p_legislation_code => NULL,

Line 948: -- Remember: NULL asst_status_type_id means "Standard" processing rule!

944: p_assignment_status_type_id => v_asst_status_type_id,
945: p_formula_id => v_calc_rule_formula_id,
946: p_processing_rule => v_proc_rule);
947: --
948: -- Remember: NULL asst_status_type_id means "Standard" processing rule!
949:
950: -- REQUIRED FOR EACH INPUT VALUE CREATED IN THIS MANNER, TO (HERE).
951: -- Creating "Percentage" inpval
952: hr_utility.set_location('hr_user_init_dedn.ins_dedn_formula_processing',20);

Line 990: p_standard_link_flag => 'N',

986: p_rowid => NULL,
987: p_recurring_flag => p_ele_proc_type,
988: p_mandatory_flag => 'N',
989: p_hot_default_flag => 'N',
990: p_standard_link_flag => 'N',
991: p_classification_type => 'N',
992: p_name => v_inpval_name,
993: p_uom => v_inpval_uom,
994: p_min_value => NULL,

Line 1179: -- Remember: NULL asst_status_type_id means "Standard" processing rule!

1175: p_assignment_status_type_id => v_asst_status_type_id,
1176: p_formula_id => v_calc_rule_formula_id,
1177: p_processing_rule => v_proc_rule);
1178: --
1179: -- Remember: NULL asst_status_type_id means "Standard" processing rule!
1180:
1181: -- REQUIRED FOR EACH INPUT VALUE CREATED IN THIS MANNER, TO (HERE).
1182: --
1183: -- Creating "Table Column" inpval

Line 1228: p_standard_link_flag => 'N',

1224: p_rowid => NULL,
1225: p_recurring_flag => p_ele_proc_type,
1226: p_mandatory_flag => 'N',
1227: p_hot_default_flag => 'N',
1228: p_standard_link_flag => 'N',
1229: p_classification_type => 'N',
1230: p_name => v_inpval_name,
1231: p_uom => v_inpval_uom,
1232: p_min_value => NULL,

Line 1316: p_standard_link_flag => 'N',

1312: p_rowid => NULL,
1313: p_recurring_flag => p_ele_proc_type,
1314: p_mandatory_flag => 'N',
1315: p_hot_default_flag => 'N',
1316: p_standard_link_flag => 'N',
1317: p_classification_type => 'N',
1318: p_name => v_inpval_name,
1319: p_uom => v_inpval_uom,
1320: p_min_value => NULL,

Line 1467: -- Remember: NULL asst_status_type_id means "Standard" processing rule!

1463: p_assignment_status_type_id => v_asst_status_type_id,
1464: p_formula_id => v_calc_rule_formula_id,
1465: p_processing_rule => v_proc_rule);
1466: --
1467: -- Remember: NULL asst_status_type_id means "Standard" processing rule!
1468:
1469: -- REQUIRED FOR EACH INPUT VALUE CREATED IN THIS MANNER, TO (HERE).
1470: --
1471: -- Creating "Coverage" inpval

Line 1512: p_standard_link_flag => 'N',

1508: p_rowid => NULL,
1509: p_recurring_flag => p_ele_proc_type,
1510: p_mandatory_flag => 'Y',
1511: p_hot_default_flag => 'N',
1512: p_standard_link_flag => 'N',
1513: p_classification_type => 'N',
1514: p_name => v_inpval_name,
1515: p_uom => v_inpval_uom,
1516: p_min_value => NULL,

Line 1587: p_standard_link_flag => 'N',

1583: p_rowid => NULL,
1584: p_recurring_flag => p_ele_proc_type,
1585: p_mandatory_flag => 'N',
1586: p_hot_default_flag => 'N',
1587: p_standard_link_flag => 'N',
1588: p_classification_type => 'N',
1589: p_name => v_inpval_name,
1590: p_uom => v_inpval_uom,
1591: p_min_value => NULL,

Line 1662: p_standard_link_flag => 'N',

1658: p_rowid => NULL,
1659: p_recurring_flag => p_ele_proc_type,
1660: p_mandatory_flag => 'N',
1661: p_hot_default_flag => 'N',
1662: p_standard_link_flag => 'N',
1663: p_classification_type => 'N',
1664: p_name => v_inpval_name,
1665: p_uom => v_inpval_uom,
1666: p_min_value => NULL,

Line 1873: p_standard_link_flag => 'N',

1869: p_rowid => NULL,
1870: p_recurring_flag => p_ele_proc_type,
1871: p_mandatory_flag => 'N',
1872: p_hot_default_flag => 'N',
1873: p_standard_link_flag => 'N',
1874: p_classification_type => 'N',
1875: p_name => v_inpval_name,
1876: p_uom => v_inpval_uom,
1877: p_min_value => NULL,

Line 1988: p_standard_link_flag => 'N',

1984: p_rowid => NULL,
1985: p_recurring_flag => 'N',
1986: p_mandatory_flag => 'X',
1987: p_hot_default_flag => 'N',
1988: p_standard_link_flag => 'N',
1989: p_classification_type => 'N',
1990: p_name => v_inpval_name,
1991: p_uom => v_inpval_uom,
1992: p_min_value => NULL,

Line 2093: p_standard_link_flag => 'N',

2089: p_rowid => NULL,
2090: p_recurring_flag => p_ele_proc_type,
2091: p_mandatory_flag => 'N',
2092: p_hot_default_flag => 'N',
2093: p_standard_link_flag => 'N',
2094: p_classification_type => 'N',
2095: p_name => v_inpval_name,
2096: p_uom => v_inpval_uom,
2097: p_min_value => NULL,

Line 2167: p_standard_link_flag => 'N',

2163: p_rowid => NULL,
2164: p_recurring_flag => 'N',
2165: p_mandatory_flag => 'N',
2166: p_hot_default_flag => 'N',
2167: p_standard_link_flag => 'N',
2168: p_classification_type => 'N',
2169: p_name => v_inpval_name,
2170: p_uom => v_inpval_uom,
2171: p_min_value => NULL,

Line 2301: p_standard_link_flag => 'N',

2297: p_rowid => NULL,
2298: p_recurring_flag => p_ele_proc_type,
2299: p_mandatory_flag => 'N',
2300: p_hot_default_flag => 'N',
2301: p_standard_link_flag => 'N',
2302: p_classification_type => 'N',
2303: p_name => v_inpval_name,
2304: p_uom => v_inpval_uom,
2305: p_min_value => NULL,

Line 2378: p_standard_link_flag => 'N',

2374: p_rowid => NULL,
2375: p_recurring_flag => p_ele_proc_type,
2376: p_mandatory_flag => 'N',
2377: p_hot_default_flag => 'N',
2378: p_standard_link_flag => 'N',
2379: p_classification_type => 'N',
2380: p_name => v_inpval_name,
2381: p_uom => v_inpval_uom,
2382: p_min_value => NULL,

Line 2465: p_standard_link_flag => 'N',

2461: p_rowid => NULL,
2462: p_recurring_flag => p_ele_proc_type,
2463: p_mandatory_flag => 'N',
2464: p_hot_default_flag => 'N',
2465: p_standard_link_flag => 'N',
2466: p_classification_type => 'N',
2467: p_name => v_inpval_name,
2468: p_uom => v_inpval_uom,
2469: p_min_value => NULL,

Line 2539: p_standard_link_flag => 'N',

2535: p_rowid => NULL,
2536: p_recurring_flag => p_ele_proc_type,
2537: p_mandatory_flag => 'N',
2538: p_hot_default_flag => 'N',
2539: p_standard_link_flag => 'N',
2540: p_classification_type => 'N',
2541: p_name => v_inpval_name,
2542: p_uom => v_inpval_uom,
2543: p_min_value => NULL,

Line 2613: p_standard_link_flag => 'N',

2609: p_rowid => NULL,
2610: p_recurring_flag => p_ele_proc_type,
2611: p_mandatory_flag => 'N',
2612: p_hot_default_flag => 'N',
2613: p_standard_link_flag => 'N',
2614: p_classification_type => 'N',
2615: p_name => v_inpval_name,
2616: p_uom => v_inpval_uom,
2617: p_min_value => NULL,

Line 2723: p_standard_link_flag => 'N',

2719: p_rowid => NULL,
2720: p_recurring_flag => p_ele_proc_type,
2721: p_mandatory_flag => 'N',
2722: p_hot_default_flag => 'N',
2723: p_standard_link_flag => 'N',
2724: p_classification_type => 'N',
2725: p_name => v_inpval_name,
2726: p_uom => v_inpval_uom,
2727: p_min_value => NULL,

Line 2811: p_standard_link_flag => 'N',

2807: p_rowid => NULL,
2808: p_recurring_flag => 'N',
2809: p_mandatory_flag => 'N',
2810: p_hot_default_flag => 'N',
2811: p_standard_link_flag => 'N',
2812: p_classification_type => 'N',
2813: p_name => v_inpval_name,
2814: p_uom => v_inpval_uom,
2815: p_min_value => NULL,

Line 2909: p_standard_link_flag => 'N',

2905: p_rowid => NULL,
2906: p_recurring_flag => 'N',
2907: p_mandatory_flag => 'N',
2908: p_hot_default_flag => 'N',
2909: p_standard_link_flag => 'N',
2910: p_classification_type => 'N',
2911: p_name => v_inpval_name,
2912: p_uom => v_inpval_uom,
2913: p_min_value => NULL,

Line 3010: p_standard_link_flag => 'N',

3006: p_rowid => NULL,
3007: p_recurring_flag => p_ele_proc_type,
3008: p_mandatory_flag => 'N',
3009: p_hot_default_flag => 'N',
3010: p_standard_link_flag => 'N',
3011: p_classification_type => 'N',
3012: p_name => v_inpval_name,
3013: p_uom => v_inpval_uom,
3014: p_min_value => NULL,

Line 3135: p_standard_link_flag => 'N',

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,

Line 3207: p_standard_link_flag => 'N',

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,

Line 3278: p_standard_link_flag => 'N',

3274: p_rowid => NULL,
3275: p_recurring_flag => 'N',
3276: p_mandatory_flag => 'N',
3277: p_hot_default_flag => 'N',
3278: p_standard_link_flag => 'N',
3279: p_classification_type => 'N',
3280: p_name => v_inpval_name,
3281: p_uom => v_inpval_uom,
3282: p_min_value => NULL,

Line 3357: p_standard_link_flag => 'N',

3353: p_rowid => NULL,
3354: p_recurring_flag => 'N',
3355: p_mandatory_flag => 'N',
3356: p_hot_default_flag => 'N',
3357: p_standard_link_flag => 'N',
3358: p_classification_type => 'N',
3359: p_name => v_inpval_name,
3360: p_uom => v_inpval_uom,
3361: p_min_value => NULL,

Line 3429: p_standard_link_flag => 'N',

3425: p_rowid => NULL,
3426: p_recurring_flag => 'N',
3427: p_mandatory_flag => 'N',
3428: p_hot_default_flag => 'N',
3429: p_standard_link_flag => 'N',
3430: p_classification_type => 'N',
3431: p_name => v_inpval_name,
3432: p_uom => v_inpval_uom,
3433: p_min_value => NULL,

Line 3469: -- Find "Standard" status processing rule id for this element.

3465: -- Generic input values for [all] deductions.
3466: --
3467: -- *** Also need to create FORMULA RESULT RULES to "zero" out these values.
3468: --
3469: -- Find "Standard" status processing rule id for this element.
3470: -- We know this must be the only one right now:
3471: --
3472: --
3473:

Line 4133: p_ele_standard_link,

4129: p_ele_category,
4130: p_ele_start_rule,
4131: p_ele_processing_type,
4132: p_ele_priority,
4133: p_ele_standard_link,
4134: v_skip_formula_id,
4135: 'N',
4136: g_eff_start_date,
4137: g_eff_end_date,

Line 4748: p_ele_standard_link in varchar2 default 'N') IS

4744: p_ele_classification in varchar2,
4745: p_ele_category in varchar2 default NULL,
4746: p_ele_processing_type in varchar2,
4747: p_ele_priority in number default NULL,
4748: p_ele_standard_link in varchar2 default 'N') IS
4749:
4750: CURSOR chk_for_lock IS
4751: SELECT *
4752: FROM pay_all_deduction_types_v

Line 4790: AND ( (recinfo.standard_link_flag = p_ele_standard_link)

4786: AND ( (recinfo.processing_type = p_ele_processing_type)
4787: OR (recinfo.processing_type IS NULL AND p_ele_processing_type IS NULL))
4788: AND ( (recinfo.processing_priority = p_ele_priority)
4789: OR (recinfo.processing_priority IS NULL AND p_ele_priority IS NULL))
4790: AND ( (recinfo.standard_link_flag = p_ele_standard_link)
4791: OR (recinfo.standard_link_flag IS NULL AND p_ele_standard_link IS NULL)))
4792: THEN
4793: hr_utility.set_location('hr_user_init_dedn.lock_template_rows',30);
4794: RETURN;

Line 4791: OR (recinfo.standard_link_flag IS NULL AND p_ele_standard_link IS NULL)))

4787: OR (recinfo.processing_type IS NULL AND p_ele_processing_type IS NULL))
4788: AND ( (recinfo.processing_priority = p_ele_priority)
4789: OR (recinfo.processing_priority IS NULL AND p_ele_priority IS NULL))
4790: AND ( (recinfo.standard_link_flag = p_ele_standard_link)
4791: OR (recinfo.standard_link_flag IS NULL AND p_ele_standard_link IS NULL)))
4792: THEN
4793: hr_utility.set_location('hr_user_init_dedn.lock_template_rows',30);
4794: RETURN;
4795: ELSE