1 PACKAGE IBE_Prod_Relation_PVT AUTHID CURRENT_USER AS
2 /* $Header: IBEVCRLS.pls 115.19 2003/06/19 00:43:35 ljanakir ship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_Prod_Relation_PVT';
5 L_VIEW_APPLICATION_ID CONSTANT NUMBER := 0;
6 L_ORGANIZATION_ID CONSTANT NUMBER := FND_PROFILE.Value_Specific('IBE_ITEM_VALIDATION_ORGANIZATION', NULL, NULL, 671);
7
8 PROCEDURE Insert_Relationship(
9 p_api_version IN NUMBER ,
10 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
11 p_commit IN VARCHAR2 := FND_API.G_FALSE,
12 x_return_status OUT NOCOPY VARCHAR2 ,
13 x_msg_count OUT NOCOPY NUMBER ,
14 x_msg_data OUT NOCOPY VARCHAR2 ,
15 p_rel_type_code IN VARCHAR2 ,
16 p_description IN VARCHAR2 := NULL ,
17 p_start_date_active IN DATE := NULL ,
18 p_end_date_active IN DATE := NULL
19 );
20
21
22 PROCEDURE Update_Relationship(
23 p_api_version IN NUMBER ,
24 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
25 p_commit IN VARCHAR2 := 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 p_rel_type_code IN VARCHAR2 ,
30 p_description IN VARCHAR2 ,
31 p_start_date IN DATE ,
32 p_end_date IN DATE
33 );
34
35 PROCEDURE Update_Relationship_Detail(
36 p_api_version IN NUMBER ,
37 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
38 p_commit IN VARCHAR2 := FND_API.G_FALSE,
39 x_return_status OUT NOCOPY VARCHAR2 ,
40 x_msg_count OUT NOCOPY NUMBER ,
41 x_msg_data OUT NOCOPY VARCHAR2 ,
42 p_rel_type_code IN VARCHAR2 ,
43 p_meaning IN VARCHAR2 ,
44 p_description IN VARCHAR2 ,
45 p_start_date IN DATE ,
46 p_end_date IN DATE
47 );
48
49 PROCEDURE Delete_Relationships(
50 p_api_version IN NUMBER ,
51 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
52 p_commit IN VARCHAR2 := FND_API.G_FALSE,
53 x_return_status OUT NOCOPY VARCHAR2 ,
54 x_msg_count OUT NOCOPY NUMBER ,
55 x_msg_data OUT NOCOPY VARCHAR2 ,
56 p_rel_type_code_tbl IN JTF_Varchar2_Table_100
57 );
58
59
60 PROCEDURE Exclude_Related_Items(
61 p_api_version IN NUMBER ,
62 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
63 p_commit IN VARCHAR2 := FND_API.G_FALSE,
64 x_return_status OUT NOCOPY VARCHAR2 ,
65 x_msg_count OUT NOCOPY NUMBER ,
66 x_msg_data OUT NOCOPY VARCHAR2 ,
67 p_rel_type_code IN VARCHAR2 ,
68 p_inventory_item_id_tbl IN JTF_Number_Table ,
69 p_related_item_id_tbl IN JTF_Number_Table
70 );
71
72
73 PROCEDURE Include_Related_Items(
74 p_api_version IN NUMBER ,
75 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
76 p_commit IN VARCHAR2 := FND_API.G_FALSE,
77 x_return_status OUT NOCOPY VARCHAR2 ,
78 x_msg_count OUT NOCOPY NUMBER ,
79 x_msg_data OUT NOCOPY VARCHAR2 ,
80 p_rel_type_code IN VARCHAR2 ,
81 p_inventory_item_id_tbl IN JTF_Number_Table ,
82 p_related_item_id_tbl IN JTF_Number_Table
83 );
84
85
86 PROCEDURE Insert_Related_Items_Rows(
87 p_rel_type_code IN VARCHAR2,
88 p_rel_rule_id IN NUMBER ,
89 p_origin_object_type IN VARCHAR2,
90 p_dest_object_type IN VARCHAR2,
91 p_origin_object_id IN NUMBER ,
92 p_dest_object_id IN NUMBER
93 );
94
95 --Bug 2922902
96 PROCEDURE Insert_Related_Items_Rows(
97 p_rel_type_code IN VARCHAR2,
98 p_rel_rule_id IN NUMBER ,
99 p_origin_object_type IN VARCHAR2,
100 p_dest_object_type IN VARCHAR2,
101 p_origin_object_id IN NUMBER ,
102 p_dest_object_id IN NUMBER ,
103 p_organization_id IN NUMBER
104 );
105
106 PROCEDURE Item_Category_Inserted(
107 p_category_id IN NUMBER,
108 p_inventory_item_id IN NUMBER,
109 p_organization_id IN NUMBER DEFAULT NULL --Bug 2922902, 3001591
110 );
111
112
113 PROCEDURE Item_Section_Inserted(
114 p_section_id IN NUMBER,
115 p_inventory_item_id IN NUMBER,
116 p_organization_id IN NUMBER DEFAULT NULL --Bug 2922902, 3001591
117 );
118
119
120 PROCEDURE Item_Category_Deleted(
121 p_category_id IN NUMBER,
122 p_inventory_item_id IN NUMBER,
123 p_organization_id IN NUMBER DEFAULT NULL --Bug 2922902, 3001591
124 );
125
126
127 PROCEDURE Item_Section_Deleted(
128 p_section_id IN NUMBER,
129 p_inventory_item_id IN NUMBER,
130 p_organization_id IN NUMBER DEFAULT NULL --Bug 2922902, 3001591
131 );
132
133
134 PROCEDURE Category_Deleted(
135 p_category_id IN NUMBER
136 );
137
138
139 PROCEDURE Section_Deleted(
140 p_section_id IN NUMBER
141 );
142
143
144 PROCEDURE Item_Deleted(
145 p_organization_id IN NUMBER,
146 p_inventory_item_id IN NUMBER
147 );
148
149
150 PROCEDURE Remove_Invalid_Exclusions;
151
152 END IBE_Prod_Relation_PVT;