1 PACKAGE EDR_EVENT_RELATIONSHIP_PVT AUTHID CURRENT_USER AS
2 /* $Header: EDRVRELS.pls 120.0.12000000.1 2007/01/18 05:56:42 appldev ship $*/
3
4 /* Global Constants */
5 G_PKG_NAME CONSTANT varchar2(30) := 'EDR_EVENT_RELATIONSHIP_PVT';
6
7 -- Start of comments
8 -- API name : STORE_INTER_EVENT
9 -- Type : Private.
10 -- Function : Validates the realtionship data in current session context
11 -- then calls local API to store Relationship data to the databse
12 -- in an autonomous manner.
13 -- Pre-reqs : None.
14 -- Parameters :
15 -- IN :p_api_version IN NUMBER Required
16 -- p_init_msg_list IN VARCHAR2 Optional
17 -- Default = FND_API.G_FALSE
18 -- p_inter_event_tbl IN INTER_EVENT_TBL_TYPE Required
19 --
20 -- OUT :x_return_status OUT VARCHAR2
21 -- x_msg_count OUT NUMBER
22 -- x_msg_data OUT VARCHAR2
23 --
24 -- Version :Current version 1.0
25 -- Initial version 1.0
26 --
27 -- Notes :Due to its autonomous nature this is a private api used by
28 -- the ERES team to do internal processing only
29 --
30 -- End of comments
31
32 PROCEDURE STORE_INTER_EVENT
33 ( p_api_version IN NUMBER ,
34 p_init_msg_list IN VARCHAR2
35 default FND_API.G_FALSE ,
36 x_return_status OUT NOCOPY VARCHAR2 ,
37 x_msg_count OUT NOCOPY NUMBER ,
38 x_msg_data OUT NOCOPY VARCHAR2 ,
39 p_inter_event_tbl IN
40 EDR_EVENT_RELATIONSHIP_PUB.INTER_EVENT_TBL_TYPE
41 );
42
43 -- Bug 3667036: Start
44 -- Start of comments
45 -- API name : ESTABLISH_RELATIONSHIP
46 -- Type : Private.
47 -- Function : Create a relationship between the specified set of parent and child erecords
48 -- Pre-reqs : None.
49 -- Parameters :
50 -- IN : PARENT_CHILD_RECORD IN PARENT_CHILD_TBL: The table of parent-child erecord data
51 -- OUT : None
52 --
53 -- Version :Current version 1.0
54 -- Initial version 1.0
55 --
56 -- End of comments
57
58 PROCEDURE ESTABLISH_RELATIONSHIP
59 (
60 PARENT_CHILD_RECORD IN PARENT_CHILD_TBL
61 );
62
63 -- Start of comments
64 -- API name : VALIDATE_PARENT
65 -- Type : Private.
66 -- Function : This API validated the parent e-record details.
67 -- Pre-reqs : None.
68 -- Parameters :
69 -- IN : P_PARENT_EVENT_NAME IN VARCHAR2: The parent event name
70 -- : P_PARENT_EVENT_KEY IN VARCHAR2: The parent event key
71 -- : P_PARENT_ERECORD_ID IN NUMBER: The parent e-record ID
72 -- OUT : None
73 --
74 -- Version :Current version 1.0
75 -- Initial version 1.0
76 --
77 -- End of comments
78
79 PROCEDURE VALIDATE_PARENT(P_PARENT_EVENT_NAME IN VARCHAR2,
80 P_PARENT_EVENT_KEY IN VARCHAR2,
81 P_PARENT_ERECORD_ID IN NUMBER
82 );
83
84 -- Start of comments
85 -- API name : VALIDATE_CHILDREN
86 -- Type : Private.
87 -- Function : This API validated the child e-record ids used in inter event.
88 -- Pre-reqs : None.
89 -- Parameters :
90 -- IN : P_CHILD_ERECORD_IDS IN FND_TABLE_OF_VARCHAR2_255: This holds the array of child e-record
91 -- ids.
92 -- P_PARENT_EVENT_NAME IN VARCHAR2: This holds the parent event name.
93 -- OUT : None
94 --
95 -- Version :Current version 1.0
96 -- Initial version 1.0
97 --
98 -- End of comments
99 PROCEDURE VALIDATE_CHILDREN(P_CHILD_ERECORD_IDS IN FND_TABLE_OF_VARCHAR2_255,
100 P_PARENT_EVENT_NAME IN VARCHAR2
101 );
102
103
104 -- Bug 3667036: End
105
106
107 --Bug 4122622: Start
108 -- Start of comments
109 -- API name : VALIDATE_CHILDREN
110 -- Type : Private.
111 -- Function : This is a wrapper over the existing validate_children procedure.
112 -- Pre-reqs : None.
113 -- Parameters :
114 -- IN : P_CHILD_ERECORD_IDS EDR_ERES_EVENT_PUB.ERECORD_ID_TBL_TYPE: This holds the array of child e-record ids.
115 -- P_PARENT_EVENT_NAME IN VARCHAR2: This holds the parent event name.
116 -- OUT : None
117 --
118 -- Version :Current version 1.0
119 -- Initial version 1.0
120 --
121 -- End of comments
122 PROCEDURE VALIDATE_CHILDREN(P_CHILD_ERECORD_IDS IN EDR_ERES_EVENT_PUB.ERECORD_ID_TBL_TYPE,
123 P_PARENT_EVENT_NAME IN VARCHAR2);
124 --Bug 4122622: End
125
126
127 end EDR_EVENT_RELATIONSHIP_PVT;