DBA Data[Home] [Help]

APPS.BSC_CAUSE_EFFECT_REL_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 50

PROCEDURE Delete_Cause_Effect_Rel(
  p_commit              	IN      VARCHAR2 := FND_API.G_FALSE
 ,p_Bsc_Cause_Effect_Rel_Rec  	IN      BSC_CAUSE_EFFECT_REL_PUB.Bsc_Cause_Effect_Rel_Rec
 ,x_return_status       	OUT NOCOPY     VARCHAR2
 ,x_msg_count           	OUT NOCOPY     NUMBER
 ,x_msg_data            	OUT NOCOPY     VARCHAR2
) IS

BEGIN

    BSC_CAUSE_EFFECT_REL_PVT.Delete_Cause_Effect_Rel(p_commit
                               ,p_Bsc_Cause_Effect_Rel_Rec
                               ,x_return_status
                               ,x_msg_count
                               ,x_msg_data);
Line: 88

END Delete_Cause_Effect_Rel;
Line: 93

PROCEDURE Delete_All_Cause_Effect_Rels(
  p_commit              	IN      VARCHAR2 := FND_API.G_FALSE
 ,p_indicator			IN	NUMBER
 ,p_level			IN	VARCHAR2
 ,x_return_status       	OUT NOCOPY     VARCHAR2
 ,x_msg_count			OUT NOCOPY	NUMBER
 ,x_msg_data			OUT NOCOPY	VARCHAR2
) IS

BEGIN

    BSC_CAUSE_EFFECT_REL_PVT.Delete_All_Cause_Effect_Rels(p_commit
                               ,p_indicator
                               ,p_level
                               ,x_return_status
                               ,x_msg_count
                               ,x_msg_data);
Line: 133

END Delete_All_Cause_Effect_Rels;