PACKAGE: APPS.BSC_CAUSE_EFFECT_REL_PUB

Source

1 PACKAGE BSC_CAUSE_EFFECT_REL_PUB AS
2 /* $Header: BSCPCAES.pls 120.0 2005/06/01 14:41:32 appldev noship $ */
3 
4 TYPE Bsc_Cause_Effect_Rel_Rec is RECORD(
5   Cause_Indicator		NUMBER
6  ,Cause_Level                	VARCHAR2(10)
7  ,Effect_Indicator		NUMBER
8  ,Effect_Level			VARCHAR2(10)
9 );
10 
11 TYPE Bsc_Cause_Effect_Rel_Tbl IS TABLE OF Bsc_Cause_Effect_Rel_Rec
12   INDEX BY BINARY_INTEGER;
13 
14 
15 PROCEDURE Create_Cause_Effect_Rel(
16   p_commit              	IN      VARCHAR2 := FND_API.G_FALSE
17  ,p_Bsc_Cause_Effect_Rel_Rec	IN	BSC_CAUSE_EFFECT_REL_PUB.Bsc_Cause_Effect_Rel_Rec
18  ,x_return_status       	OUT NOCOPY     VARCHAR2
19  ,x_msg_count           	OUT NOCOPY     NUMBER
20  ,x_msg_data            	OUT NOCOPY     VARCHAR2
21 );
22 
23 PROCEDURE Delete_Cause_Effect_Rel(
24   p_commit              	IN      VARCHAR2 := FND_API.G_FALSE
25  ,p_Bsc_Cause_Effect_Rel_Rec	IN	BSC_CAUSE_EFFECT_REL_PUB.Bsc_Cause_Effect_Rel_Rec
26  ,x_return_status       	OUT NOCOPY     VARCHAR2
27  ,x_msg_count			OUT NOCOPY	NUMBER
28  ,x_msg_data			OUT NOCOPY	VARCHAR2
29 );
30 
31 PROCEDURE Delete_All_Cause_Effect_Rels(
32   p_commit              	IN      VARCHAR2 := FND_API.G_FALSE
33  ,p_indicator			IN	NUMBER
34  ,p_level			IN	VARCHAR2
35  ,x_return_status       	OUT NOCOPY     VARCHAR2
36  ,x_msg_count			OUT NOCOPY	NUMBER
37  ,x_msg_data			OUT NOCOPY	VARCHAR2
38 );
39 
40 END BSC_CAUSE_EFFECT_REL_PUB;