DBA Data[Home] [Help]

APPS.HR_USER_INIT_DEDN dependencies on STANDARD

Line 321: p_ele_standard_link in varchar2 default 'N',

317: p_ben_class_id in number,
318: p_ele_category in varchar2 default NULL,
319: p_ele_processing_type in varchar2,
320: p_ele_priority in number default NULL,
321: p_ele_standard_link in varchar2 default 'N',
322: p_ele_proc_runtype in varchar2,
323: p_ele_start_rule in varchar2,
324: p_ele_stop_rule in varchar2,
325: p_ele_ee_bond in varchar2 default 'N',

Line 454: p_ele_standard_link in varchar2,

450: p_ele_category in varchar2,
451: p_ele_start_rule in varchar2,
452: p_ele_processing_type in varchar2,
453: p_ele_priority in number,
454: p_ele_standard_link in varchar2,
455: p_skip_formula_id in number default NULL,
456: p_ind_only_flag in varchar2,
457: p_ele_eff_start_date in date,
458: p_ele_eff_end_date in date,

Line 507: p_standard_link_flag => p_ele_standard_link,

503: p_mult_entries_allowed => v_mult_entries_allowed,
504: p_indirect_only_flag => p_ind_only_flag,
505: p_formula_id => p_skip_formula_id,
506: p_processing_priority => p_ele_priority,
507: p_standard_link_flag => p_ele_standard_link,
508: p_business_group_name => p_bg_name,
509: p_effective_start_date => p_ele_eff_start_date,
510: p_effective_end_date => p_ele_eff_end_date,
511: p_legislation_code => NULL,

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

956: p_assignment_status_type_id => v_asst_status_type_id,
957: p_formula_id => v_calc_rule_formula_id,
958: p_processing_rule => v_proc_rule);
959: --
960: -- Remember: NULL asst_status_type_id means "Standard" processing rule!
961:
962: -- REQUIRED FOR EACH INPUT VALUE CREATED IN THIS MANNER, TO (HERE).
963: -- Creating "Percentage" inpval
964: hr_utility.set_location('hr_user_init_dedn.ins_dedn_formula_processing',20);

Line 1002: p_standard_link_flag => 'N',

998: p_rowid => NULL,
999: p_recurring_flag => p_ele_proc_type,
1000: p_mandatory_flag => 'N',
1001: p_hot_default_flag => 'N',
1002: p_standard_link_flag => 'N',
1003: p_classification_type => 'N',
1004: p_name => v_inpval_name,
1005: p_uom => v_inpval_uom,
1006: p_min_value => NULL,

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

1187: p_assignment_status_type_id => v_asst_status_type_id,
1188: p_formula_id => v_calc_rule_formula_id,
1189: p_processing_rule => v_proc_rule);
1190: --
1191: -- Remember: NULL asst_status_type_id means "Standard" processing rule!
1192:
1193: -- REQUIRED FOR EACH INPUT VALUE CREATED IN THIS MANNER, TO (HERE).
1194: --
1195: -- Creating "Table Column" inpval

Line 1240: p_standard_link_flag => 'N',

1236: p_rowid => NULL,
1237: p_recurring_flag => p_ele_proc_type,
1238: p_mandatory_flag => 'N',
1239: p_hot_default_flag => 'N',
1240: p_standard_link_flag => 'N',
1241: p_classification_type => 'N',
1242: p_name => v_inpval_name,
1243: p_uom => v_inpval_uom,
1244: p_min_value => NULL,

Line 1328: p_standard_link_flag => 'N',

1324: p_rowid => NULL,
1325: p_recurring_flag => p_ele_proc_type,
1326: p_mandatory_flag => 'N',
1327: p_hot_default_flag => 'N',
1328: p_standard_link_flag => 'N',
1329: p_classification_type => 'N',
1330: p_name => v_inpval_name,
1331: p_uom => v_inpval_uom,
1332: p_min_value => NULL,

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

1475: p_assignment_status_type_id => v_asst_status_type_id,
1476: p_formula_id => v_calc_rule_formula_id,
1477: p_processing_rule => v_proc_rule);
1478: --
1479: -- Remember: NULL asst_status_type_id means "Standard" processing rule!
1480:
1481: -- REQUIRED FOR EACH INPUT VALUE CREATED IN THIS MANNER, TO (HERE).
1482: --
1483: -- Creating "Coverage" inpval

Line 1524: p_standard_link_flag => 'N',

1520: p_rowid => NULL,
1521: p_recurring_flag => p_ele_proc_type,
1522: p_mandatory_flag => 'Y',
1523: p_hot_default_flag => 'N',
1524: p_standard_link_flag => 'N',
1525: p_classification_type => 'N',
1526: p_name => v_inpval_name,
1527: p_uom => v_inpval_uom,
1528: p_min_value => NULL,

Line 1599: p_standard_link_flag => 'N',

1595: p_rowid => NULL,
1596: p_recurring_flag => p_ele_proc_type,
1597: p_mandatory_flag => 'N',
1598: p_hot_default_flag => 'N',
1599: p_standard_link_flag => 'N',
1600: p_classification_type => 'N',
1601: p_name => v_inpval_name,
1602: p_uom => v_inpval_uom,
1603: p_min_value => NULL,

Line 1674: p_standard_link_flag => 'N',

1670: p_rowid => NULL,
1671: p_recurring_flag => p_ele_proc_type,
1672: p_mandatory_flag => 'N',
1673: p_hot_default_flag => 'N',
1674: p_standard_link_flag => 'N',
1675: p_classification_type => 'N',
1676: p_name => v_inpval_name,
1677: p_uom => v_inpval_uom,
1678: p_min_value => NULL,

Line 1885: p_standard_link_flag => 'N',

1881: p_rowid => NULL,
1882: p_recurring_flag => p_ele_proc_type,
1883: p_mandatory_flag => 'N',
1884: p_hot_default_flag => 'N',
1885: p_standard_link_flag => 'N',
1886: p_classification_type => 'N',
1887: p_name => v_inpval_name,
1888: p_uom => v_inpval_uom,
1889: p_min_value => NULL,

Line 2000: p_standard_link_flag => 'N',

1996: p_rowid => NULL,
1997: p_recurring_flag => 'N',
1998: p_mandatory_flag => 'X',
1999: p_hot_default_flag => 'N',
2000: p_standard_link_flag => 'N',
2001: p_classification_type => 'N',
2002: p_name => v_inpval_name,
2003: p_uom => v_inpval_uom,
2004: p_min_value => NULL,

Line 2105: p_standard_link_flag => 'N',

2101: p_rowid => NULL,
2102: p_recurring_flag => p_ele_proc_type,
2103: p_mandatory_flag => 'N',
2104: p_hot_default_flag => 'N',
2105: p_standard_link_flag => 'N',
2106: p_classification_type => 'N',
2107: p_name => v_inpval_name,
2108: p_uom => v_inpval_uom,
2109: p_min_value => NULL,

Line 2179: p_standard_link_flag => 'N',

2175: p_rowid => NULL,
2176: p_recurring_flag => 'N',
2177: p_mandatory_flag => 'N',
2178: p_hot_default_flag => 'N',
2179: p_standard_link_flag => 'N',
2180: p_classification_type => 'N',
2181: p_name => v_inpval_name,
2182: p_uom => v_inpval_uom,
2183: p_min_value => NULL,

Line 2313: p_standard_link_flag => 'N',

2309: p_rowid => NULL,
2310: p_recurring_flag => p_ele_proc_type,
2311: p_mandatory_flag => 'N',
2312: p_hot_default_flag => 'N',
2313: p_standard_link_flag => 'N',
2314: p_classification_type => 'N',
2315: p_name => v_inpval_name,
2316: p_uom => v_inpval_uom,
2317: p_min_value => NULL,

Line 2390: p_standard_link_flag => 'N',

2386: p_rowid => NULL,
2387: p_recurring_flag => p_ele_proc_type,
2388: p_mandatory_flag => 'N',
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,

Line 2477: p_standard_link_flag => 'N',

2473: p_rowid => NULL,
2474: p_recurring_flag => p_ele_proc_type,
2475: p_mandatory_flag => 'N',
2476: p_hot_default_flag => 'N',
2477: p_standard_link_flag => 'N',
2478: p_classification_type => 'N',
2479: p_name => v_inpval_name,
2480: p_uom => v_inpval_uom,
2481: p_min_value => NULL,

Line 2551: p_standard_link_flag => 'N',

2547: p_rowid => NULL,
2548: p_recurring_flag => p_ele_proc_type,
2549: p_mandatory_flag => 'N',
2550: p_hot_default_flag => 'N',
2551: p_standard_link_flag => 'N',
2552: p_classification_type => 'N',
2553: p_name => v_inpval_name,
2554: p_uom => v_inpval_uom,
2555: p_min_value => NULL,

Line 2623: p_standard_link_flag => 'N',

2619: p_rowid => NULL,
2620: p_recurring_flag => p_ele_proc_type,
2621: p_mandatory_flag => 'N',
2622: p_hot_default_flag => 'N',
2623: p_standard_link_flag => 'N',
2624: p_classification_type => 'N',
2625: p_name => v_inpval_name,
2626: p_uom => v_inpval_uom,
2627: p_min_value => NULL,

Line 2696: p_standard_link_flag => 'N',

2692: p_rowid => NULL,
2693: p_recurring_flag => p_ele_proc_type,
2694: p_mandatory_flag => 'N',
2695: p_hot_default_flag => 'N',
2696: p_standard_link_flag => 'N',
2697: p_classification_type => 'N',
2698: p_name => v_inpval_name,
2699: p_uom => v_inpval_uom,
2700: p_min_value => NULL,

Line 2821: p_standard_link_flag => 'N',

2817: p_rowid => NULL,
2818: p_recurring_flag => p_ele_proc_type,
2819: p_mandatory_flag => 'N',
2820: p_hot_default_flag => 'N',
2821: p_standard_link_flag => 'N',
2822: p_classification_type => 'N',
2823: p_name => v_inpval_name,
2824: p_uom => v_inpval_uom,
2825: 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 3007: p_standard_link_flag => 'N',

3003: p_rowid => NULL,
3004: p_recurring_flag => 'N',
3005: p_mandatory_flag => 'N',
3006: p_hot_default_flag => 'N',
3007: p_standard_link_flag => 'N',
3008: p_classification_type => 'N',
3009: p_name => v_inpval_name,
3010: p_uom => v_inpval_uom,
3011: p_min_value => NULL,

Line 3108: p_standard_link_flag => 'N',

3104: p_rowid => NULL,
3105: p_recurring_flag => p_ele_proc_type,
3106: p_mandatory_flag => 'N',
3107: p_hot_default_flag => 'N',
3108: p_standard_link_flag => 'N',
3109: p_classification_type => 'N',
3110: p_name => v_inpval_name,
3111: p_uom => v_inpval_uom,
3112: p_min_value => NULL,

Line 3233: p_standard_link_flag => 'N',

3229: p_rowid => NULL,
3230: p_recurring_flag => 'N',
3231: p_mandatory_flag => 'N',
3232: p_hot_default_flag => 'N',
3233: p_standard_link_flag => 'N',
3234: p_classification_type => 'N',
3235: p_name => v_inpval_name,
3236: p_uom => v_inpval_uom,
3237: p_min_value => NULL,

Line 3305: p_standard_link_flag => 'N',

3301: p_rowid => NULL,
3302: p_recurring_flag => 'N',
3303: p_mandatory_flag => 'N',
3304: p_hot_default_flag => 'N',
3305: p_standard_link_flag => 'N',
3306: p_classification_type => 'N',
3307: p_name => v_inpval_name,
3308: p_uom => v_inpval_uom,
3309: p_min_value => NULL,

Line 3376: p_standard_link_flag => 'N',

3372: p_rowid => NULL,
3373: p_recurring_flag => 'N',
3374: p_mandatory_flag => 'N',
3375: p_hot_default_flag => 'N',
3376: p_standard_link_flag => 'N',
3377: p_classification_type => 'N',
3378: p_name => v_inpval_name,
3379: p_uom => v_inpval_uom,
3380: p_min_value => NULL,

Line 3455: p_standard_link_flag => 'N',

3451: p_rowid => NULL,
3452: p_recurring_flag => 'N',
3453: p_mandatory_flag => 'N',
3454: p_hot_default_flag => 'N',
3455: p_standard_link_flag => 'N',
3456: p_classification_type => 'N',
3457: p_name => v_inpval_name,
3458: p_uom => v_inpval_uom,
3459: p_min_value => NULL,

Line 3527: p_standard_link_flag => 'N',

3523: p_rowid => NULL,
3524: p_recurring_flag => 'N',
3525: p_mandatory_flag => 'N',
3526: p_hot_default_flag => 'N',
3527: p_standard_link_flag => 'N',
3528: p_classification_type => 'N',
3529: p_name => v_inpval_name,
3530: p_uom => v_inpval_uom,
3531: p_min_value => NULL,

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

3563: -- Generic input values for [all] deductions.
3564: --
3565: -- *** Also need to create FORMULA RESULT RULES to "zero" out these values.
3566: --
3567: -- Find "Standard" status processing rule id for this element.
3568: -- We know this must be the only one right now:
3569: --
3570: --
3571:

Line 4241: p_ele_standard_link,

4237: p_ele_category,
4238: p_ele_start_rule,
4239: p_ele_processing_type,
4240: p_ele_priority,
4241: p_ele_standard_link,
4242: v_skip_formula_id,
4243: 'N',
4244: g_eff_start_date,
4245: g_eff_end_date,

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

4868: p_ele_classification in varchar2,
4869: p_ele_category in varchar2 default NULL,
4870: p_ele_processing_type in varchar2,
4871: p_ele_priority in number default NULL,
4872: p_ele_standard_link in varchar2 default 'N') IS
4873:
4874: CURSOR chk_for_lock IS
4875: SELECT *
4876: FROM pay_all_deduction_types_v

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

4910: AND ( (recinfo.processing_type = p_ele_processing_type)
4911: OR (recinfo.processing_type IS NULL AND p_ele_processing_type IS NULL))
4912: AND ( (recinfo.processing_priority = p_ele_priority)
4913: OR (recinfo.processing_priority IS NULL AND p_ele_priority IS NULL))
4914: AND ( (recinfo.standard_link_flag = p_ele_standard_link)
4915: OR (recinfo.standard_link_flag IS NULL AND p_ele_standard_link IS NULL)))
4916: THEN
4917: hr_utility.set_location('hr_user_init_dedn.lock_template_rows',30);
4918: RETURN;

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

4911: OR (recinfo.processing_type IS NULL AND p_ele_processing_type IS NULL))
4912: AND ( (recinfo.processing_priority = p_ele_priority)
4913: OR (recinfo.processing_priority IS NULL AND p_ele_priority IS NULL))
4914: AND ( (recinfo.standard_link_flag = p_ele_standard_link)
4915: OR (recinfo.standard_link_flag IS NULL AND p_ele_standard_link IS NULL)))
4916: THEN
4917: hr_utility.set_location('hr_user_init_dedn.lock_template_rows',30);
4918: RETURN;
4919: ELSE