2: /* $Header: BISVCECS.pls 120.0 2006/08/04 17:14:01 appldev noship $ */
3:
4: PROCEDURE Create_Custom_Cause_Effect_Rel(
5: p_commit IN VARCHAR2 := FND_API.G_FALSE
6: ,p_Cause_Short_Name IN bis_custom_cause_effect_rels.cause_short_name%TYPE
7: ,p_Effect_Short_Name IN bis_custom_cause_effect_rels.effect_short_name%TYPE
8: ,p_Cause_Sequence IN bis_custom_cause_effect_rels.cause_sequence%TYPE
9: ,p_Effect_Sequence IN bis_custom_cause_effect_rels.effect_sequence%TYPE
10: ,x_return_status OUT NOCOPY VARCHAR2
3:
4: PROCEDURE Create_Custom_Cause_Effect_Rel(
5: p_commit IN VARCHAR2 := FND_API.G_FALSE
6: ,p_Cause_Short_Name IN bis_custom_cause_effect_rels.cause_short_name%TYPE
7: ,p_Effect_Short_Name IN bis_custom_cause_effect_rels.effect_short_name%TYPE
8: ,p_Cause_Sequence IN bis_custom_cause_effect_rels.cause_sequence%TYPE
9: ,p_Effect_Sequence IN bis_custom_cause_effect_rels.effect_sequence%TYPE
10: ,x_return_status OUT NOCOPY VARCHAR2
11: ,x_msg_count OUT NOCOPY NUMBER
4: PROCEDURE Create_Custom_Cause_Effect_Rel(
5: p_commit IN VARCHAR2 := FND_API.G_FALSE
6: ,p_Cause_Short_Name IN bis_custom_cause_effect_rels.cause_short_name%TYPE
7: ,p_Effect_Short_Name IN bis_custom_cause_effect_rels.effect_short_name%TYPE
8: ,p_Cause_Sequence IN bis_custom_cause_effect_rels.cause_sequence%TYPE
9: ,p_Effect_Sequence IN bis_custom_cause_effect_rels.effect_sequence%TYPE
10: ,x_return_status OUT NOCOPY VARCHAR2
11: ,x_msg_count OUT NOCOPY NUMBER
12: ,x_msg_data OUT NOCOPY VARCHAR2
5: p_commit IN VARCHAR2 := FND_API.G_FALSE
6: ,p_Cause_Short_Name IN bis_custom_cause_effect_rels.cause_short_name%TYPE
7: ,p_Effect_Short_Name IN bis_custom_cause_effect_rels.effect_short_name%TYPE
8: ,p_Cause_Sequence IN bis_custom_cause_effect_rels.cause_sequence%TYPE
9: ,p_Effect_Sequence IN bis_custom_cause_effect_rels.effect_sequence%TYPE
10: ,x_return_status OUT NOCOPY VARCHAR2
11: ,x_msg_count OUT NOCOPY NUMBER
12: ,x_msg_data OUT NOCOPY VARCHAR2
13: );
13: );
14:
15: PROCEDURE Update_Custom_Cause_Effect_Rel(
16: p_commit IN VARCHAR2 := FND_API.G_FALSE
17: ,p_Cause_Short_Name IN bis_custom_cause_effect_rels.cause_short_name%TYPE
18: ,p_Effect_Short_Name IN bis_custom_cause_effect_rels.effect_short_name%TYPE
19: ,p_Cause_Sequence IN bis_custom_cause_effect_rels.cause_sequence%TYPE
20: ,p_Effect_Sequence IN bis_custom_cause_effect_rels.effect_sequence%TYPE
21: ,x_return_status OUT NOCOPY VARCHAR2
14:
15: PROCEDURE Update_Custom_Cause_Effect_Rel(
16: p_commit IN VARCHAR2 := FND_API.G_FALSE
17: ,p_Cause_Short_Name IN bis_custom_cause_effect_rels.cause_short_name%TYPE
18: ,p_Effect_Short_Name IN bis_custom_cause_effect_rels.effect_short_name%TYPE
19: ,p_Cause_Sequence IN bis_custom_cause_effect_rels.cause_sequence%TYPE
20: ,p_Effect_Sequence IN bis_custom_cause_effect_rels.effect_sequence%TYPE
21: ,x_return_status OUT NOCOPY VARCHAR2
22: ,x_msg_count OUT NOCOPY NUMBER
15: PROCEDURE Update_Custom_Cause_Effect_Rel(
16: p_commit IN VARCHAR2 := FND_API.G_FALSE
17: ,p_Cause_Short_Name IN bis_custom_cause_effect_rels.cause_short_name%TYPE
18: ,p_Effect_Short_Name IN bis_custom_cause_effect_rels.effect_short_name%TYPE
19: ,p_Cause_Sequence IN bis_custom_cause_effect_rels.cause_sequence%TYPE
20: ,p_Effect_Sequence IN bis_custom_cause_effect_rels.effect_sequence%TYPE
21: ,x_return_status OUT NOCOPY VARCHAR2
22: ,x_msg_count OUT NOCOPY NUMBER
23: ,x_msg_data OUT NOCOPY VARCHAR2
16: p_commit IN VARCHAR2 := FND_API.G_FALSE
17: ,p_Cause_Short_Name IN bis_custom_cause_effect_rels.cause_short_name%TYPE
18: ,p_Effect_Short_Name IN bis_custom_cause_effect_rels.effect_short_name%TYPE
19: ,p_Cause_Sequence IN bis_custom_cause_effect_rels.cause_sequence%TYPE
20: ,p_Effect_Sequence IN bis_custom_cause_effect_rels.effect_sequence%TYPE
21: ,x_return_status OUT NOCOPY VARCHAR2
22: ,x_msg_count OUT NOCOPY NUMBER
23: ,x_msg_data OUT NOCOPY VARCHAR2
24: );
25:
26:
27: PROCEDURE Delete_Custom_Cause_Effect_Rel(
28: p_commit IN VARCHAR2 := FND_API.G_FALSE
29: ,p_Cause_Short_Name IN bis_custom_cause_effect_rels.cause_short_name%TYPE
30: ,p_Effect_Short_Name IN bis_custom_cause_effect_rels.effect_short_name%TYPE
31: ,x_return_status OUT NOCOPY VARCHAR2
32: ,x_msg_count OUT NOCOPY NUMBER
33: ,x_msg_data OUT NOCOPY VARCHAR2
26:
27: PROCEDURE Delete_Custom_Cause_Effect_Rel(
28: p_commit IN VARCHAR2 := FND_API.G_FALSE
29: ,p_Cause_Short_Name IN bis_custom_cause_effect_rels.cause_short_name%TYPE
30: ,p_Effect_Short_Name IN bis_custom_cause_effect_rels.effect_short_name%TYPE
31: ,x_return_status OUT NOCOPY VARCHAR2
32: ,x_msg_count OUT NOCOPY NUMBER
33: ,x_msg_data OUT NOCOPY VARCHAR2
34: );