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,
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;
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,
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,
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,
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,
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,
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);