eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.RRS_HIERARCHY_CRUD_PKG

Source


1 PACKAGE RRS_HIERARCHY_CRUD_PKG AUTHID CURRENT_USER AS
2 /* $Header: RRSHRCRS.pls 120.3 2009/08/07 21:24:21 pochang noship $ */
3 procedure Update_Hierarchy_Header(
4         p_api_version IN NUMBER DEFAULT 1,
5         p_name IN VARCHAR2,
6         p_new_name IN VARCHAR2 DEFAULT NULL,
7         p_description IN VARCHAR2 DEFAULT NULL,
8         p_purpose_code IN VARCHAR2 DEFAULT NULL,
9         p_start_date IN DATE DEFAULT NULL,
10         p_end_date IN DATE DEFAULT NULL,
11         p_nullify_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE,
12         p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
13         x_return_status OUT NOCOPY VARCHAR2,
14         x_msg_count OUT NOCOPY NUMBER,
15         x_msg_data OUT NOCOPY VARCHAR2
16 );
17 
18 procedure Update_Hierarchy_Node(
19         p_api_version IN NUMBER DEFAULT 1,
20         p_number IN VARCHAR2,
21         p_name IN VARCHAR2 DEFAULT NULL,
22         p_description IN VARCHAR2 DEFAULT NULL,
23         p_purpose_code IN VARCHAR2 DEFAULT NULL,
24         p_nullify_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE,
25         p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
26         x_return_status OUT NOCOPY VARCHAR2,
27         x_msg_count OUT NOCOPY NUMBER,
28         x_msg_data OUT NOCOPY VARCHAR2
29 );
30 
31 procedure Create_Hierarchy_Node(
32         p_api_version IN NUMBER DEFAULT 1,
33         p_number IN VARCHAR2,
34         p_name IN VARCHAR2 DEFAULT NULL,
35         p_description IN VARCHAR2 DEFAULT NULL,
36         p_purpose_code IN VARCHAR2 DEFAULT NULL,
37         p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
38         x_return_status OUT NOCOPY VARCHAR2,
39         x_msg_count OUT NOCOPY NUMBER,
40         x_msg_data OUT NOCOPY VARCHAR2
41 );
42 
43 procedure Create_Hierarchy_Coarse(
44         p_api_version IN NUMBER DEFAULT 1,
45         p_hier_name IN VARCHAR2,
46         p_hier_description IN VARCHAR2 DEFAULT NULL,
47         p_hier_purpose_code IN VARCHAR2 DEFAULT NULL,
48         p_hier_start_date IN DATE DEFAULT NULL,
49         p_hier_end_date IN DATE DEFAULT NULL,
50         p_hier_members_tab IN RRS_HIER_MEMBERS_COARSE_TAB DEFAULT NULL,
51         p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
52         x_return_status OUT NOCOPY VARCHAR2,
53         x_msg_count OUT NOCOPY NUMBER,
54         x_msg_data OUT NOCOPY VARCHAR2
55 );
56 
57 procedure Update_Hierarchy_Coarse(
58         p_api_version IN NUMBER DEFAULT 1,
59         p_hier_name IN VARCHAR2,
60         p_hier_new_name IN VARCHAR2 DEFAULT NULL,
61         p_hier_description IN VARCHAR2 DEFAULT NULL,
62         p_hier_purpose_code IN VARCHAR2 DEFAULT NULL,
63         p_hier_start_date IN DATE DEFAULT NULL,
64         p_hier_end_date IN DATE DEFAULT NULL,
65         p_hier_members_tab IN RRS_HIER_MEMBERS_COARSE_TAB DEFAULT NULL,
66         p_nullify_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE,
67         p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
68         x_return_status OUT NOCOPY VARCHAR2,
69         x_msg_count OUT NOCOPY NUMBER,
70         x_msg_data OUT NOCOPY VARCHAR2
71 );
72 
73 procedure Create_Hierarchy_Members(
74         p_hier_version_id IN NUMBER,
75         p_hier_id IN NUMBER,
76         p_root_id IN NUMBER,
77         p_root_number IN VARCHAR2,
78         p_hier_purpose_code IN VARCHAR2,
79         p_hier_members_tab IN RRS_HIER_MEMBERS_COARSE_TAB,
80         x_return_status OUT NOCOPY VARCHAR2,
81         x_msg_count OUT NOCOPY NUMBER,
82         x_msg_data OUT NOCOPY VARCHAR2
83 );
84 
85 procedure Update_Hierarchy_Fine(
86         p_api_version IN NUMBER DEFAULT 1,
87         p_hier_members_rec IN RRS_HIER_MEMBERS_FINE_REC,
88         p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
89         x_return_status OUT NOCOPY VARCHAR2,
90         x_msg_count OUT NOCOPY NUMBER,
91         x_msg_data OUT NOCOPY VARCHAR2
92 );
93 
94 procedure Validate_Rules_For_Members(
95         p_hier_purpose_code IN VARCHAR2,
96         x_return_status OUT NOCOPY VARCHAR2,
97         x_msg_data OUT NOCOPY VARCHAR2
98 );
99 
100 procedure Validate_Rules_For_Child(
101         p_hier_purpose_code IN VARCHAR2,
102         p_parent_id_number IN VARCHAR2,
103         p_parent_object_type IN VARCHAR2,
104         p_parent_purpose_code IN VARCHAR2,
105         p_child_id_number IN VARCHAR2,
106         p_child_object_type IN VARCHAR2,
107         p_child_purpose_code IN VARCHAR2,
108         x_return_status OUT NOCOPY VARCHAR2,
109         x_msg_data OUT NOCOPY VARCHAR2
110 );
111 
112 -- Hierarchy and Hierarchy Association Validation API
113 procedure Validate_Hierarchy_Status(
114         p_hier_id IN VARCHAR2,
115         x_return_status OUT NOCOPY VARCHAR2,
116         x_msg_count OUT NOCOPY NUMBER,
117         x_msg_data OUT NOCOPY VARCHAR2
118 );
119 
120 procedure Validate_Hierarchy_Association(
121         p_hier_id IN VARCHAR2,
122         p_parent_id IN VARCHAR2,
123         p_parent_object_type IN VARCHAR2,
124         p_child_id IN VARCHAR2,
125         p_child_object_type IN VARCHAR2,
126         x_return_status OUT NOCOPY VARCHAR2,
127         x_msg_count OUT NOCOPY NUMBER,
128         x_msg_data OUT NOCOPY VARCHAR2
129 );
130 
131 
132 /*
133 procedure Update_Hierarchy_Header_Test;
134 
135 procedure Update_Hierarchy_Node_Test;
136 
137 procedure Create_Hierarchy_Node_Test;
138 
139 procedure Create_Hierarchy_Coarse_Test;
140 
141 procedure Update_Hierarchy_Coarse_Test;
142 
143 procedure Update_Hierarchy_Fine_Test;
144 */
145 
146 END;