DBA Data[Home] [Help]

APPS.HR_ENTRY_API dependencies on HR_ENTRY

Line 1: package hr_entry_api AUTHID CURRENT_USER as

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: /*

Line 9: Name : hr_entry_api

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:

Line 11: Uses : hr_entry , hr_utility

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: -----------

Line 83: -- hr_entry_api.conv_entry_values_to_table --

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 --

Line 131: p_input_value_id_tbl out nocopy hr_entry.number_table,

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: ------------------------------------------------------------------------------

Line 132: p_entry_value_tbl out nocopy hr_entry.varchar2_table

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 --

Line 137: -- hr_entry.conv_table_to_table --

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 --

Line 154: p_input_value_id_tbl in out nocopy hr_entry.number_table,

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: ------------------------------------------------------------------------------

Line 155: p_entry_value_tbl in out nocopy hr_entry.varchar2_table

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 --

Line 160: -- hr_entry_api.set_formula_contexts --

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 --

Line 176: -- hr_entry.validate_entry_value --

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: ------------------------------------------------------------------------------

Line 197: -- hr_entry_api.get_link --

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. --

Line 213: -- hr_entry_api.insert_element_entry --

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 --

Line 216: -- Cover routine for call to hr_entry_api.ins_element_entry that accepts --

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: ------------------------------------------------------------------------------

Line 276: p_input_value_id_tbl hr_entry.number_table,

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: ------------------------------------------------------------------------------

Line 277: p_entry_value_tbl hr_entry.varchar2_table

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 --

Line 282: -- hr_entry_api.insert_element_entry --

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 --

Line 285: -- Cover routine for call to hr_entry_api.ins_element_entry that accepts --

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: ------------------------------------------------------------------------------

Line 379: -- hr_entry_api.insert_element_entry --

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 --

Line 382: -- Cover routine for call to hr_entry_api.ins_element_entry that accepts --

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: ------------------------------------------------------------------------------

Line 441: p_input_value_id_tbl hr_entry.number_table,

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: --

Line 442: p_entry_value_tbl hr_entry.varchar2_table,

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 ,

Line 485: -- hr_entry_api.insert_element_entry --

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 --

Line 488: -- Cover routine for call to hr_entry_api.ins_element_entry that accepts --

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: ------------------------------------------------------------------------------

Line 617: -- hr_entry_api.update_element_entry --

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 --

Line 620: -- Cover routine for call to hr_entry_api.upd_element_entry that accepts --

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 ! --

Line 682: p_input_value_id_tbl hr_entry.number_table,

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: ------------------------------------------------------------------------------

Line 683: p_entry_value_tbl hr_entry.varchar2_table

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 --

Line 688: -- hr_entry_api.update_element_entry --

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 --

Line 691: -- Cover routine for call to hr_entry_api.upd_element_entry that accepts --

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 ! --

Line 788: -- hr_entry_api.update_element_entry --

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 --

Line 791: -- Cover routine for call to hr_entry_api.upd_element_entry that accepts --

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 ! --

Line 855: p_input_value_id_tbl hr_entry.number_table,

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: --

Line 856: p_entry_value_tbl hr_entry.varchar2_table,

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 ,

Line 898: -- hr_entry_api.update_element_entry --

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 --

Line 901: -- Cover routine for call to hr_entry_api.upd_element_entry that accepts --

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 ! --

Line 1033: -- hr_entry_api.delete_element_entry --

1029: );
1030: --
1031: ------------------------------------------------------------------------------
1032: -- NAME --
1033: -- hr_entry_api.delete_element_entry --
1034: -- --
1035: -- DESCRIPTION --
1036: -- Deletes an element entry providing full validation. --
1037: ------------------------------------------------------------------------------

Line 1056: end hr_entry_api;

1052: p_element_entry_id number
1053: );
1054: --
1055: --
1056: end hr_entry_api;