[Home] [Help]
PACKAGE: APPS.IBE_PROD_RELATION_RULE_PVT
Source
1 PACKAGE IBE_Prod_Relation_Rule_PVT AUTHID CURRENT_USER AS
2 /* $Header: IBEVCRRS.pls 115.14 2002/12/14 07:52:32 schak ship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_Prod_Relation_Rule_PVT';
5 L_ORGANIZATION_ID CONSTANT NUMBER := FND_PROFILE.Value_Specific('IBE_ITEM_VALIDATION_ORGANIZATION', NULL, NULL, 671);
6 L_USER_ID CONSTANT NUMBER := FND_GLOBAL.User_ID;
7
8 PROCEDURE Insert_SQL_Rule(
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_sql_statement IN VARCHAR2
17 );
18
19
20 PROCEDURE Insert_Mapping_Rules(
21 p_api_version IN NUMBER ,
22 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
23 p_commit IN VARCHAR2 := FND_API.G_FALSE,
24 x_return_status OUT NOCOPY VARCHAR2 ,
25 x_msg_count OUT NOCOPY NUMBER ,
26 x_msg_data OUT NOCOPY VARCHAR2 ,
27 p_rel_type_code IN VARCHAR2 ,
28 p_origin_object_type_tbl IN JTF_Varchar2_Table_100 ,
29 p_dest_object_type_tbl IN JTF_Varchar2_Table_100 ,
30 p_origin_object_id_tbl IN JTF_Number_Table ,
31 p_dest_object_id_tbl IN JTF_Number_Table ,
32 p_preview IN VARCHAR2 := FND_API.G_FALSE
33 );
34
35
36 PROCEDURE Update_Rule(
37 p_api_version IN NUMBER ,
38 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
39 p_commit IN VARCHAR2 := FND_API.G_FALSE,
40 x_return_status OUT NOCOPY VARCHAR2 ,
41 x_msg_count OUT NOCOPY NUMBER ,
42 x_msg_data OUT NOCOPY VARCHAR2 ,
43 p_rel_rule_id IN NUMBER ,
44 p_obj_ver_num IN NUMBER ,
45 p_sql_statement IN VARCHAR2 := NULL
46 );
47
48
49 PROCEDURE Delete_Rules(
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_rule_id_tbl IN JTF_Varchar2_Table_100 ,
57 p_obj_ver_num_tbl IN JTF_Varchar2_Table_100
58 );
59
60
61 FUNCTION Get_Rule_Type(p_origin_object_type IN VARCHAR2,
62 p_dest_object_type IN VARCHAR2)
63 RETURN VARCHAR2;
64
65 PRAGMA RESTRICT_REFERENCES(Get_Rule_Type, WNDS);
66
67
68 FUNCTION Get_Display_Name(p_object_type IN VARCHAR2,
69 p_object_id IN NUMBER)
70 RETURN VARCHAR2;
71
72 PRAGMA RESTRICT_REFERENCES(Get_Display_Name, WNDS, WNPS);
73
74
75 FUNCTION Is_SQL_Valid(p_sql_stmt IN VARCHAR2)
76 RETURN BOOLEAN;
77
78 END IBE_Prod_Relation_Rule_PVT;