1 PACKAGE ICX_Related_Templates_PUB AUTHID CURRENT_USER AS
2 /* $Header: ICXPTMPS.pls 115.1 99/07/17 03:21:06 porting ship $ */
3
4 -- Start of Comments
5 -- API name : Related_Templates
6 -- Type : PUBLIC
7 -- Function : The Related_Templates API provides procedures to insert
8 -- and delete template relationships for n-level template
9 -- heirarchy definition
10 --
11 --
12 -- Pre-reqs : None
13 --
14 -- Insert_Relation
15 -- Parameters :
16 -- IN : p_api_version_number number current version = 1.0
17 -- p_init_msg_list varchar2 standard api parameter
18 -- defaults to FND_API.G_FALSE, set to
19 -- FND_API.G_TRUE to have api initialize message list
20 -- p_simulate varchar2 standard api parameter
21 -- defaults to FND_API.G_FALSE, set to
22 -- FND_API.G_TRUE for simulation mode (api will not
23 -- commit any changes)
24 -- p_commit varchar2 standard api parameter
25 -- defaults to FND_API.G_FALSE, set to
26 -- FND_API.G_TRUE to have api commit changes
27 -- p_commit is ignored if p_simulate = FND_API.G_TRUE
28 -- p_validation_level number standard api parameter
29 -- defaults to FND_API.G_VALID_LEVEL_FULL
30 -- p_template varchar2
31 -- p_template must be provided to the api. This is the
32 -- parent of the template relationship being inserted
33 -- p_related_template
34 -- p_related_template must be provided to the api.
35 -- This is the child of the template relationship
36 -- being inserted
37 -- p_relationship_type varchar2
38 -- this is a required parameter and must be a valid
39 -- relationship based on the ICX_RELATION lookup type
40 -- p_created_by number
41 -- this is a required parameter which must correspond
42 -- to the user who is inserting the template relation
43 --
44 -- OUT : p_return_status varchar2(1) standard api parameter
45 -- S = api completed successfully,
46 -- E and U = api errored
47 -- p_msg_count number standard api parameter
48 -- records how many messages were placed on the
49 -- message stack during the api call. If p_msg_count
50 -- is 1 then the message is held in p_msg_data,
51 -- otherwise api caller must use fnd_msg_pub.get to
52 -- retrieve one message at a time.
53 -- p_msg_data varchar2(240) standard api parameter
54 -- if p_msg_count = 1 then p_msg_data holds the message
55 --
56 -- Delete_Relation
57 -- Parameters :
58 -- IN : p_api_version_number number current version = 1.0
59 -- p_init_msg_list varchar2 standard api parameter
60 -- defaults to FND_API.G_FALSE, set to
61 -- FND_API.G_TRUE to have api initialize message list
62 -- p_simulate varchar2 standard api parameter
63 -- defaults to FND_API.G_FALSE, set to
64 -- FND_API.G_TRUE for simulation mode (api will not
65 -- commit any changes)
66 -- p_commit varchar2 standard api parameter
67 -- defaults to FND_API.G_FALSE, set to
68 -- FND_API.G_TRUE to have api commit changes
69 -- p_commit is ignored if p_simulate = FND_API.G_TRUE
70 -- p_validation_level number standard api parameter
71 -- defaults to FND_API.G_VALID_LEVEL_FULL
72 -- p_template varchar2
73 -- p_template must be provided to the api. This is the
74 -- parent of the template relationship being deleted
75 -- p_related_template
76 -- p_related_template must be provided to the api.
77 -- This is the child of the template relationship
78 -- being inserted
79 --
80 -- OUT : p_return_status varchar2(1) standard api parameter
81 -- S = api completed successfully,
82 -- E and U = api errored
83 -- p_msg_count number standard api parameter
84 -- records how many messages were placed on the
85 -- message stack during the api call. If p_msg_count
86 -- is 1 then the message is held in p_msg_data,
87 -- otherwise api caller must use fnd_msg_pub.get to
88 -- retrieve one message at a time.
89 -- p_msg_data varchar2(240) standard api parameter
90 -- if p_msg_count = 1 then p_msg_data holds the message
91 --
92 --
93 -- End Of Comments
94
95
96 -- Global constants holding the package and file names to be used by
97 -- messaging routines in the case of an unexpected error.
98
99 G_PKG_NAME CONSTANT VARCHAR2(30):='ICX_Related_Templates_PUB';
100
101
102 PROCEDURE Insert_Relation
103 ( p_api_version_number IN NUMBER ,
104 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
105 p_simulate IN VARCHAR2 := FND_API.G_FALSE ,
106 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
107 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
108 p_return_status OUT VARCHAR2 ,
109 p_msg_count OUT NUMBER ,
110 p_msg_data OUT VARCHAR2 ,
111 p_template IN VARCHAR2 DEFAULT NULL ,
112 p_related_template IN VARCHAR2 DEFAULT NULL ,
113 p_relationship_type IN VARCHAR2 ,
114 p_created_by IN NUMBER
115 );
116
117
118 PROCEDURE Delete_Relation
119 ( p_api_version_number IN NUMBER ,
120 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
121 p_simulate IN VARCHAR2 := FND_API.G_FALSE ,
122 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
123 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
124 p_return_status OUT VARCHAR2 ,
125 p_msg_count OUT NUMBER ,
126 p_msg_data OUT VARCHAR2 ,
127 p_template IN VARCHAR2 DEFAULT NULL ,
128 p_related_template IN VARCHAR2 DEFAULT NULL
129 );
130
131
132 END ICX_Related_Templates_PUB; -- ICX_Related_Templates_PUB