1 PACKAGE pay_element_template_user_init AS
2 /* $Header: payeletmplusrini.pkh 120.1 2005/09/14 11:12:37 vpandya noship $ */
3 --
4
5 /*
6 ******************************************************************
7 * *
8 * Copyright (C) 1992 Oracle Corporation UK Ltd., *
9 * Chertsey, England. *
10 * *
11 * All rights reserved. *
12 * *
13 * This material has been provided pursuant to an agreement *
14 * containing restrictions on its use. The material is also *
15 * protected by copyright law. No part of this material may *
16 * be copied or distributed, transmitted or transcribed, in *
17 * any form or by any means, electronic, mechanical, magnetic, *
18 * manual, or otherwise, or disclosed to third parties without *
19 * the express written permission of Oracle Corporation UK Ltd, *
20 * Oracle Park, Bittams Lane, Guildford Road, Chertsey, Surrey, *
21 * England. *
22 * *
23 ******************************************************************
24
25 Description: This package is used to create earning and deduction
26 elements using Element Templates for Oracle
27 International Payroll.
28
29 Change List
30 -----------
31 Date Name Vers Bug No Description
32 ----------- ---------- ----- ------- -----------------------------------
33 12-NOV-2004 vpandya 115.0 Created.
34 01-DEC-2004 vpandya 115.1 Made p_rec as IN parameter only
35 20-DEC-2004 vpandya 115.2 Added SYSTEM to Object type
36 declaration.
37 27-JAN-2005 vmehta 115.3 Removed reference to SYSTEM schema
38 from objects.
39 28-APR-2005 pganguly 115.4 Added the delete_element
40 procedure.
41 14-Sep-2005 vpandya 115.5 Added Exception Handlers and
42 Pragmas.
43 */
44 --
45
46 --
47 -- Exception Handlers
48 --
49
50 Cannot_Find_Prog_Unit Exception;
51
52 --
53 -- Pragmas
54 --
55 -- Note: Generally oracle returns error ORA-06508 when program unit is not
56 -- found. But here we call program unit dynamically using string e.g.
57 -- EXECUTE IMMEDIATE 'BEGIN Program_Unit END;' USING variable;
58 -- In this case oracle returns error ORA-06550.
59
60 Pragma Exception_Init(Cannot_Find_Prog_Unit, -6550);
61
62 PROCEDURE create_element
63 ( p_validate IN BOOLEAN
64 ,p_save_for_later IN VARCHAR2
65 ,p_rec IN PAY_ELE_TMPLT_OBJ
66 ,p_sub_class IN PAY_ELE_SUB_CLASS_TABLE
67 ,p_freq_rule IN PAY_FREQ_RULE_TABLE
68 ,p_ele_template_id OUT NOCOPY NUMBER
69 );
70
71
72 PROCEDURE delete_element
73 ( p_validate IN BOOLEAN,
74 p_template_id IN NUMBER
75 );
76
77 END pay_element_template_user_init;