1 package per_mx_gen_hier_valid AUTHID CURRENT_USER as
2 /* $Header: permxgenhiervald.pkh 115.1 2004/05/07 13:46:31 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 validate generic hierarchy
26 'Mexican HRMS Statutory Reporting' for Mexico.
27
28 Change List
29 -----------
30 Date Name Vers Bug No Description
31 ----------- ---------- ----- ------- -----------------------------------
32 05-MAY-2004 vpandya 115.0 Created.
33 */
34 --
35
36 PROCEDURE validate_nodes( P_BUSINESS_GROUP_ID in NUMBER
37 ,P_ENTITY_ID in VARCHAR2
38 ,P_HIERARCHY_VERSION_ID in NUMBER
39 ,P_NODE_TYPE in VARCHAR2
40 ,P_SEQ in NUMBER
41 ,P_PARENT_HIERARCHY_NODE_ID in NUMBER
42 ,P_REQUEST_ID in NUMBER
43 ,P_PROGRAM_APPLICATION_ID in NUMBER
44 ,P_PROGRAM_ID in NUMBER
45 ,P_PROGRAM_UPDATE_DATE in DATE
46 ,P_EFFECTIVE_DATE in DATE );
47
48 PROCEDURE create_default_location( P_HIERARCHY_NODE_ID in NUMBER
49 ,P_BUSINESS_GROUP_ID in NUMBER
50 ,P_ENTITY_ID in VARCHAR2
51 ,P_HIERARCHY_VERSION_ID in NUMBER
52 ,P_NODE_TYPE in VARCHAR2
53 ,P_SEQ in NUMBER
54 ,P_PARENT_HIERARCHY_NODE_ID in NUMBER
55 ,P_REQUEST_ID in NUMBER
56 ,P_PROGRAM_APPLICATION_ID in NUMBER
57 ,P_PROGRAM_ID in NUMBER
58 ,P_PROGRAM_UPDATE_DATE in DATE
59 ,P_EFFECTIVE_DATE in DATE );
60
61 -- PROCEDURE delete_nodes( P_HIERARCHY_NODE_ID in NUMBER
62 -- ,P_OBJECT_VERSION_NUMBER in NUMBER);
63
64 PROCEDURE update_nodes( P_HIERARCHY_NODE_ID in NUMBER
65 ,P_ENTITY_ID in VARCHAR2
66 ,P_NODE_TYPE in VARCHAR2
67 ,P_SEQ in NUMBER
68 ,P_PARENT_HIERARCHY_NODE_ID in NUMBER
69 ,P_REQUEST_ID in NUMBER
70 ,P_PROGRAM_APPLICATION_ID in NUMBER
71 ,P_PROGRAM_ID in NUMBER
72 ,P_PROGRAM_UPDATE_DATE in DATE
73 ,P_OBJECT_VERSION_NUMBER in NUMBER
74 ,P_EFFECTIVE_DATE in DATE );
75
76 PROCEDURE update_hier_versions( P_HIERARCHY_VERSION_ID in NUMBER
77 ,P_VERSION_NUMBER in NUMBER
78 ,P_DATE_FROM in DATE
79 ,P_DATE_TO in DATE
80 ,P_STATUS in VARCHAR2
81 ,P_VALIDATE_FLAG in VARCHAR2
82 ,P_REQUEST_ID in NUMBER
83 ,P_PROGRAM_APPLICATION_ID in NUMBER
84 ,P_PROGRAM_ID in NUMBER
85 ,P_PROGRAM_UPDATE_DATE in DATE
86 ,P_OBJECT_VERSION_NUMBER in NUMBER
87 ,P_EFFECTIVE_DATE in DATE );
88
89 END per_mx_gen_hier_valid;