[Home] [Help]
PACKAGE: APPS.INL_RULE_PVT
Source
1 PACKAGE INL_RULE_PVT AUTHID CURRENT_USER AS
2 /* $Header: INLVRULS.pls 120.0.12020000.3 2013/02/19 14:53:04 acferrei noship $ */
3
4 G_MODULE_NAME CONSTANT VARCHAR2(200):= 'INL.PLSQL.INL_RULE_PVT.';
5 G_PKG_NAME CONSTANT VARCHAR2(30) := 'INL_RULE_PVT';
6 G_CONDITION_CUSTOM VARCHAR2(1);
7
8 g_build_package_row NUMBER;
9 g_build_package_tbl DBMS_SQL.varchar2s;
10
11 FUNCTION Build_Query(p_api_version IN NUMBER,
12 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
13 p_commit IN VARCHAR2 := FND_API.G_FALSE,
14 p_rule_id IN NUMBER,
15 x_return_status OUT NOCOPY VARCHAR2,
16 x_msg_count OUT NOCOPY NUMBER,
17 x_msg_data OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
18
19 FUNCTION Validate_Rules(p_api_version IN NUMBER,
20 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
21 p_commit IN VARCHAR2 := FND_API.G_FALSE,
22 p_rule_id IN NUMBER,
23 x_message_name IN OUT NOCOPY VARCHAR2,
24 x_return_status OUT NOCOPY VARCHAR2,
25 x_msg_count OUT NOCOPY NUMBER,
26 x_msg_data OUT NOCOPY VARCHAR2)RETURN VARCHAR2;
27
28 PROCEDURE Build_ConditionPackage(p_api_version IN NUMBER,
29 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
30 p_commit IN VARCHAR2 := FND_API.G_FALSE,
31 p_rule_id IN NUMBER,
32 x_message_name IN OUT NOCOPY VARCHAR2,
33 x_return_status OUT NOCOPY VARCHAR2,
34 x_msg_count OUT NOCOPY NUMBER,
35 x_msg_data OUT NOCOPY VARCHAR2);
36
37 PROCEDURE Drop_ConditionPackage(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 p_rule_id IN NUMBER,
41 x_return_status OUT NOCOPY VARCHAR2,
42 x_msg_count OUT NOCOPY NUMBER,
43 x_msg_data OUT NOCOPY VARCHAR2);
44
45 FUNCTION Build_Condition(p_rule_id IN NUMBER,
46 x_return_status IN OUT NOCOPY VARCHAR2,
47 x_msg_count OUT NOCOPY NUMBER,
48 x_msg_data OUT NOCOPY VARCHAR2)RETURN VARCHAR2;
49
50 END INL_RULE_PVT;