8: -- ----------------------------------------------------------------------------
9: -- |----------------------------< create_ame_rule >---------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_ame_rule
12: (p_validate in number default hr_api.g_false_num
13: ,p_rule_key in varchar2
14: ,p_description in varchar2
15: ,p_rule_type in varchar2
16: ,p_item_class_id in number default null
63: --
64: -- Convert constant values to their corresponding boolean value
65: --
66: l_validate :=
67: hr_api.constant_to_boolean
68: (p_constant_value => p_validate);
69: --
70: -- Register Surrogate ID or user key values
71: --
174: -- ----------------------------------------------------------------------------
175: -- |-------------------------< create_ame_rule_usage >------------------------|
176: -- ----------------------------------------------------------------------------
177: PROCEDURE create_ame_rule_usage
178: (p_validate in number default hr_api.g_false_num
179: ,p_rule_id in number
180: ,p_application_id in number
181: ,p_priority in number default null
182: ,p_approver_category in varchar2 default null
213: --
214: -- Convert constant values to their corresponding boolean value
215: --
216: l_validate :=
217: hr_api.constant_to_boolean
218: (p_constant_value => p_validate);
219: --
220: -- Register Surrogate ID or user key values
221: --
288: -- ----------------------------------------------------------------------------
289: -- |---------------------< create_ame_condition_to_rule >---------------------|
290: -- ----------------------------------------------------------------------------
291: PROCEDURE create_ame_condition_to_rule
292: (p_validate in number default hr_api.g_false_num
293: ,p_rule_id in number
294: ,p_condition_id in number
295: ,p_object_version_number out nocopy number
296: ,p_start_date out nocopy date
322: --
323: -- Convert constant values to their corresponding boolean value
324: --
325: l_validate :=
326: hr_api.constant_to_boolean
327: (p_constant_value => p_validate);
328: --
329: -- Register Surrogate ID or user key values
330: --
396: -- ----------------------------------------------------------------------------
397: -- |-----------------------< create_ame_action_to_rule >----------------------|
398: -- ----------------------------------------------------------------------------
399: PROCEDURE create_ame_action_to_rule
400: (p_validate in number default hr_api.g_false_num
401: ,p_rule_id in number
402: ,p_action_id in number
403: ,p_object_version_number out nocopy number
404: ,p_start_date out nocopy date
430: --
431: -- Convert constant values to their corresponding boolean value
432: --
433: l_validate :=
434: hr_api.constant_to_boolean
435: (p_constant_value => p_validate);
436: --
437: -- Register Surrogate ID or user key values
438: --
504: -- ----------------------------------------------------------------------------
505: -- |----------------------------< update_ame_rule >---------------------------|
506: -- ----------------------------------------------------------------------------
507: PROCEDURE update_ame_rule
508: (p_validate in number default hr_api.g_false_num
509: ,p_rule_id in number
510: ,p_description in varchar2 default hr_api.g_varchar2
511: ,p_object_version_number in out nocopy number
512: ,p_start_date in out nocopy date
506: -- ----------------------------------------------------------------------------
507: PROCEDURE update_ame_rule
508: (p_validate in number default hr_api.g_false_num
509: ,p_rule_id in number
510: ,p_description in varchar2 default hr_api.g_varchar2
511: ,p_object_version_number in out nocopy number
512: ,p_start_date in out nocopy date
513: ,p_end_date in out nocopy date
514: ,p_return_status out nocopy varchar2
543: --
544: -- Convert constant values to their corresponding boolean value
545: --
546: l_validate :=
547: hr_api.constant_to_boolean
548: (p_constant_value => p_validate);
549: --
550: -- Register Surrogate ID or user key values
551: --
617: -- ----------------------------------------------------------------------------
618: -- |-------------------------< update_ame_rule_usage >------------------------|
619: -- ----------------------------------------------------------------------------
620: PROCEDURE update_ame_rule_usage
621: (p_validate in number default hr_api.g_false_num
622: ,p_rule_id in number
623: ,p_application_id in number
624: ,p_priority in number default hr_api.g_number
625: ,p_approver_category in varchar2 default hr_api.g_varchar2
620: PROCEDURE update_ame_rule_usage
621: (p_validate in number default hr_api.g_false_num
622: ,p_rule_id in number
623: ,p_application_id in number
624: ,p_priority in number default hr_api.g_number
625: ,p_approver_category in varchar2 default hr_api.g_varchar2
626: ,p_old_start_date in date
627: ,p_object_version_number in out nocopy number
628: ,p_start_date in out nocopy date
621: (p_validate in number default hr_api.g_false_num
622: ,p_rule_id in number
623: ,p_application_id in number
624: ,p_priority in number default hr_api.g_number
625: ,p_approver_category in varchar2 default hr_api.g_varchar2
626: ,p_old_start_date in date
627: ,p_object_version_number in out nocopy number
628: ,p_start_date in out nocopy date
629: ,p_end_date in out nocopy date
660: --
661: -- Convert constant values to their corresponding boolean value
662: --
663: l_validate :=
664: hr_api.constant_to_boolean
665: (p_constant_value => p_validate);
666: --
667: -- Register Surrogate ID or user key values
668: --
737: -- ----------------------------------------------------------------------------
738: -- |-------------------------< delete_ame_rule_usage >------------------------|
739: -- ----------------------------------------------------------------------------
740: PROCEDURE delete_ame_rule_usage
741: (p_validate in number default hr_api.g_false_num
742: ,p_rule_id in number
743: ,p_application_id in number
744: ,p_object_version_number in out nocopy number
745: ,p_start_date in out nocopy date
776: --
777: -- Convert constant values to their corresponding boolean value
778: --
779: l_validate :=
780: hr_api.constant_to_boolean
781: (p_constant_value => p_validate);
782: --
783: -- Register Surrogate ID or user key values
784: --
849: -- ----------------------------------------------------------------------------
850: -- |-----------------------< delete_ame_rule_condition >----------------------|
851: -- ----------------------------------------------------------------------------
852: PROCEDURE delete_ame_rule_condition
853: (p_validate in number default hr_api.g_false_num
854: ,p_rule_id in number
855: ,p_condition_id in number
856: ,p_object_version_number in out nocopy number
857: ,p_start_date out nocopy date
884: --
885: -- Convert constant values to their corresponding boolean value
886: --
887: l_validate :=
888: hr_api.constant_to_boolean
889: (p_constant_value => p_validate);
890: --
891: -- Register Surrogate ID or user key values
892: --
958: -- ----------------------------------------------------------------------------
959: -- |------------------------< delete_ame_rule_action >------------------------|
960: -- ----------------------------------------------------------------------------
961: PROCEDURE delete_ame_rule_action
962: (p_validate in number default hr_api.g_false_num
963: ,p_rule_id in number
964: ,p_action_id in number
965: ,p_object_version_number in out nocopy number
966: ,p_start_date out nocopy date
993: --
994: -- Convert constant values to their corresponding boolean value
995: --
996: l_validate :=
997: hr_api.constant_to_boolean
998: (p_constant_value => p_validate);
999: --
1000: -- Register Surrogate ID or user key values
1001: --