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 ,
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 ,
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 ,
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(
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 ,
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 ,
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 ,
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 ,