1: package hr_entry_api AUTHID CURRENT_USER as
2: /* $Header: pyentapi.pkh 120.2.12010000.1 2008/07/27 22:31:54 appldev ship $ */
3: --
4: /*
5: /*
5: /*
6:
7: * Copyright (C) 1993 Oracle Corporation UK Ltd. Richmond, England. *
8:
9: Name : hr_entry_api
10: Description : API for element entries. Supports insert, update and delete.
11: Uses : hr_entry , hr_utility
12: Used By : hrentmnt
13:
7: * Copyright (C) 1993 Oracle Corporation UK Ltd. Richmond, England. *
8:
9: Name : hr_entry_api
10: Description : API for element entries. Supports insert, update and delete.
11: Uses : hr_entry , hr_utility
12: Used By : hrentmnt
13:
14: Change List
15: -----------
79: */
80: --
81: ------------------------------------------------------------------------------
82: -- NAME --
83: -- hr_entry_api.conv_entry_values_to_table --
84: -- --
85: -- DESCRIPTION --
86: -- Converts a set of predefined parameters containing the INPUT_VALUE_IDs --
87: -- and SCREEN_ENTRY_VALUEs for an element entry to a pair of PLSQL tables --
127: p_entry_value13 varchar2,
128: p_entry_value14 varchar2,
129: p_entry_value15 varchar2,
130: p_num_entry_values out nocopy number,
131: p_input_value_id_tbl out nocopy hr_entry.number_table,
132: p_entry_value_tbl out nocopy hr_entry.varchar2_table
133: );
134: --
135: ------------------------------------------------------------------------------
128: p_entry_value14 varchar2,
129: p_entry_value15 varchar2,
130: p_num_entry_values out nocopy number,
131: p_input_value_id_tbl out nocopy hr_entry.number_table,
132: p_entry_value_tbl out nocopy hr_entry.varchar2_table
133: );
134: --
135: ------------------------------------------------------------------------------
136: -- NAME --
133: );
134: --
135: ------------------------------------------------------------------------------
136: -- NAME --
137: -- hr_entry.conv_table_to_table --
138: -- --
139: -- DESCRIPTION --
140: -- Given a table of entry values it converts to DB format if required. Any --
141: -- entry values that are not specified are derived NB. when inserting the --
150: p_element_link_id number,
151: p_num_entry_values in out nocopy number,
152: p_creator_type varchar2,
153: p_entry_type varchar2,
154: p_input_value_id_tbl in out nocopy hr_entry.number_table,
155: p_entry_value_tbl in out nocopy hr_entry.varchar2_table
156: );
157: --
158: ------------------------------------------------------------------------------
151: p_num_entry_values in out nocopy number,
152: p_creator_type varchar2,
153: p_entry_type varchar2,
154: p_input_value_id_tbl in out nocopy hr_entry.number_table,
155: p_entry_value_tbl in out nocopy hr_entry.varchar2_table
156: );
157: --
158: ------------------------------------------------------------------------------
159: -- NAME --
156: );
157: --
158: ------------------------------------------------------------------------------
159: -- NAME --
160: -- hr_entry_api.set_formula_contexts --
161: -- --
162: -- DESCRIPTION --
163: -- Called to set the (global) contexts that will be used in any input value --
164: -- validation formula. We obtain the business_group_id from the assignment --
172: );
173: --
174: ------------------------------------------------------------------------------
175: -- NAME --
176: -- hr_entry.validate_entry_value --
177: -- --
178: -- DESCRIPTION --
179: -- Validates and converts an entry value to DB format. --
180: ------------------------------------------------------------------------------
193: );
194: --
195: ------------------------------------------------------------------------------
196: -- NAME --
197: -- hr_entry_api.get_link --
198: -- --
199: -- DESCRIPTION --
200: -- Returns for the element link that represents the assignments eligibility --
201: -- for a particular element type on a given date. --
209: ) return number;
210: --
211: ------------------------------------------------------------------------------
212: -- NAME --
213: -- hr_entry_api.insert_element_entry --
214: -- --
215: -- DESCRIPTION --
216: -- Cover routine for call to hr_entry_api.ins_element_entry that accepts --
217: -- entry values passed as a table. It converts the entry values to DB --
212: -- NAME --
213: -- hr_entry_api.insert_element_entry --
214: -- --
215: -- DESCRIPTION --
216: -- Cover routine for call to hr_entry_api.ins_element_entry that accepts --
217: -- entry values passed as a table. It converts the entry values to DB --
218: -- format and also defaults any entry values that were not specified. --
219: -- NB. all entry values specified are validated ! --
220: ------------------------------------------------------------------------------
272: --
273: -- Element Entry Values Table
274: --
275: p_num_entry_values number,
276: p_input_value_id_tbl hr_entry.number_table,
277: p_entry_value_tbl hr_entry.varchar2_table
278: );
279: --
280: ------------------------------------------------------------------------------
273: -- Element Entry Values Table
274: --
275: p_num_entry_values number,
276: p_input_value_id_tbl hr_entry.number_table,
277: p_entry_value_tbl hr_entry.varchar2_table
278: );
279: --
280: ------------------------------------------------------------------------------
281: -- NAME --
278: );
279: --
280: ------------------------------------------------------------------------------
281: -- NAME --
282: -- hr_entry_api.insert_element_entry --
283: -- --
284: -- DESCRIPTION --
285: -- Cover routine for call to hr_entry_api.ins_element_entry that accepts --
286: -- entry values passed as parameters. It converts the entry values to DB --
281: -- NAME --
282: -- hr_entry_api.insert_element_entry --
283: -- --
284: -- DESCRIPTION --
285: -- Cover routine for call to hr_entry_api.ins_element_entry that accepts --
286: -- entry values passed as parameters. It converts the entry values to DB --
287: -- format and also defaults any entry values that were not specified. --
288: -- NB. all entry values specified are validated ! --
289: ------------------------------------------------------------------------------
375: -- --
376: --
377: ------------------------------------------------------------------------------
378: -- NAME --
379: -- hr_entry_api.insert_element_entry --
380: -- --
381: -- DESCRIPTION --
382: -- Cover routine for call to hr_entry_api.ins_element_entry that accepts --
383: -- entry values passed as a table. It converts the entry values to DB --
378: -- NAME --
379: -- hr_entry_api.insert_element_entry --
380: -- --
381: -- DESCRIPTION --
382: -- Cover routine for call to hr_entry_api.ins_element_entry that accepts --
383: -- entry values passed as a table. It converts the entry values to DB --
384: -- format and also defaults any entry values that were not specified. --
385: -- NB. all entry values specified are validated ! --
386: ------------------------------------------------------------------------------
437: --
438: -- Element Entry Values Table
439: --
440: p_num_entry_values number,
441: p_input_value_id_tbl hr_entry.number_table,
442: p_entry_value_tbl hr_entry.varchar2_table,
443: --
444: -- Developer Descriptive Flex
445: --
438: -- Element Entry Values Table
439: --
440: p_num_entry_values number,
441: p_input_value_id_tbl hr_entry.number_table,
442: p_entry_value_tbl hr_entry.varchar2_table,
443: --
444: -- Developer Descriptive Flex
445: --
446: p_entry_information_category varchar2 ,
481: -- --
482: --
483: ------------------------------------------------------------------------------
484: -- NAME --
485: -- hr_entry_api.insert_element_entry --
486: -- --
487: -- DESCRIPTION --
488: -- Cover routine for call to hr_entry_api.ins_element_entry that accepts --
489: -- entry values passed as parameters. It converts the entry values to DB --
484: -- NAME --
485: -- hr_entry_api.insert_element_entry --
486: -- --
487: -- DESCRIPTION --
488: -- Cover routine for call to hr_entry_api.ins_element_entry that accepts --
489: -- entry values passed as parameters. It converts the entry values to DB --
490: -- format and also defaults any entry values that were not specified. --
491: -- NB. all entry values specified are validated ! --
492: ------------------------------------------------------------------------------
613: );
614: --
615: ------------------------------------------------------------------------------
616: -- NAME --
617: -- hr_entry_api.update_element_entry --
618: -- --
619: -- DESCRIPTION --
620: -- Cover routine for call to hr_entry_api.upd_element_entry that accepts --
621: -- entry values passed as a table. It converts the entry values to DB --
616: -- NAME --
617: -- hr_entry_api.update_element_entry --
618: -- --
619: -- DESCRIPTION --
620: -- Cover routine for call to hr_entry_api.upd_element_entry that accepts --
621: -- entry values passed as a table. It converts the entry values to DB --
622: -- format. Any entry values that were not specified are copied from the --
623: -- element entry being updated. --
624: -- NB. all entry values specified are validated ! --
678: --
679: -- Element Entry Values Table
680: --
681: p_num_entry_values number,
682: p_input_value_id_tbl hr_entry.number_table,
683: p_entry_value_tbl hr_entry.varchar2_table
684: );
685: --
686: ------------------------------------------------------------------------------
679: -- Element Entry Values Table
680: --
681: p_num_entry_values number,
682: p_input_value_id_tbl hr_entry.number_table,
683: p_entry_value_tbl hr_entry.varchar2_table
684: );
685: --
686: ------------------------------------------------------------------------------
687: -- NAME --
684: );
685: --
686: ------------------------------------------------------------------------------
687: -- NAME --
688: -- hr_entry_api.update_element_entry --
689: -- --
690: -- DESCRIPTION --
691: -- Cover routine for call to hr_entry_api.upd_element_entry that accepts --
692: -- entry values passed as parameters. It converts the entry values to DB --
687: -- NAME --
688: -- hr_entry_api.update_element_entry --
689: -- --
690: -- DESCRIPTION --
691: -- Cover routine for call to hr_entry_api.upd_element_entry that accepts --
692: -- entry values passed as parameters. It converts the entry values to DB --
693: -- format. Any entry values that were not specified are copied from the --
694: -- element entry being updated. --
695: -- NB. all entry values specified are validated ! --
784: -- --
785: --
786: ------------------------------------------------------------------------------
787: -- NAME --
788: -- hr_entry_api.update_element_entry --
789: -- --
790: -- DESCRIPTION --
791: -- Cover routine for call to hr_entry_api.upd_element_entry that accepts --
792: -- entry values passed as a table. It converts the entry values to DB --
787: -- NAME --
788: -- hr_entry_api.update_element_entry --
789: -- --
790: -- DESCRIPTION --
791: -- Cover routine for call to hr_entry_api.upd_element_entry that accepts --
792: -- entry values passed as a table. It converts the entry values to DB --
793: -- format. Any entry values that were not specified are copied from the --
794: -- element entry being updated. --
795: -- NB. all entry values specified are validated ! --
851: --
852: -- Element Entry Values Table
853: --
854: p_num_entry_values number,
855: p_input_value_id_tbl hr_entry.number_table,
856: p_entry_value_tbl hr_entry.varchar2_table,
857: --
858: -- Developer Descriptive Flex
859: --
852: -- Element Entry Values Table
853: --
854: p_num_entry_values number,
855: p_input_value_id_tbl hr_entry.number_table,
856: p_entry_value_tbl hr_entry.varchar2_table,
857: --
858: -- Developer Descriptive Flex
859: --
860: p_entry_information_category varchar2 ,
894: -- --
895: --
896: ------------------------------------------------------------------------------
897: -- NAME --
898: -- hr_entry_api.update_element_entry --
899: -- --
900: -- DESCRIPTION --
901: -- Cover routine for call to hr_entry_api.upd_element_entry that accepts --
902: -- entry values passed as parameters. It converts the entry values to DB --
897: -- NAME --
898: -- hr_entry_api.update_element_entry --
899: -- --
900: -- DESCRIPTION --
901: -- Cover routine for call to hr_entry_api.upd_element_entry that accepts --
902: -- entry values passed as parameters. It converts the entry values to DB --
903: -- format. Any entry values that were not specified are copied from the --
904: -- element entry being updated. --
905: -- NB. all entry values specified are validated ! --
1029: );
1030: --
1031: ------------------------------------------------------------------------------
1032: -- NAME --
1033: -- hr_entry_api.delete_element_entry --
1034: -- --
1035: -- DESCRIPTION --
1036: -- Deletes an element entry providing full validation. --
1037: ------------------------------------------------------------------------------
1052: p_element_entry_id number
1053: );
1054: --
1055: --
1056: end hr_entry_api;