eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIS_CUSTOM_CAUSE_EFFECT_PVT dependencies on BIS_CUSTOM_CAUSE_EFFECT_RELS

Line 6: ,p_Cause_Short_Name IN bis_custom_cause_effect_rels.cause_short_name%TYPE

2: /* $Header: BISVCECB.pls 120.0 2006/08/04 17:13:46 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

Line 7: ,p_Effect_Short_Name IN bis_custom_cause_effect_rels.effect_short_name%TYPE

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

Line 8: ,p_Cause_Sequence IN bis_custom_cause_effect_rels.cause_sequence%TYPE

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

Line 9: ,p_Effect_Sequence IN bis_custom_cause_effect_rels.effect_sequence%TYPE

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: ) IS

Line 43: INSERT INTO BIS_CUSTOM_CAUSE_EFFECT_RELS

39: FND_MSG_PUB.ADD;
40: RAISE FND_API.G_EXC_ERROR;
41: END IF;
42:
43: INSERT INTO BIS_CUSTOM_CAUSE_EFFECT_RELS
44: (
45: ID,
46: CAUSE_SHORT_NAME,
47: EFFECT_SHORT_NAME,

Line 86: ,p_Cause_Short_Name IN bis_custom_cause_effect_rels.cause_short_name%TYPE

82: END Create_Custom_Cause_Effect_Rel;
83:
84: PROCEDURE Update_Custom_Cause_Effect_Rel(
85: p_commit IN VARCHAR2 := FND_API.G_FALSE
86: ,p_Cause_Short_Name IN bis_custom_cause_effect_rels.cause_short_name%TYPE
87: ,p_Effect_Short_Name IN bis_custom_cause_effect_rels.effect_short_name%TYPE
88: ,p_Cause_Sequence IN bis_custom_cause_effect_rels.cause_sequence%TYPE
89: ,p_Effect_Sequence IN bis_custom_cause_effect_rels.effect_sequence%TYPE
90: ,x_return_status OUT NOCOPY VARCHAR2

Line 87: ,p_Effect_Short_Name IN bis_custom_cause_effect_rels.effect_short_name%TYPE

83:
84: PROCEDURE Update_Custom_Cause_Effect_Rel(
85: p_commit IN VARCHAR2 := FND_API.G_FALSE
86: ,p_Cause_Short_Name IN bis_custom_cause_effect_rels.cause_short_name%TYPE
87: ,p_Effect_Short_Name IN bis_custom_cause_effect_rels.effect_short_name%TYPE
88: ,p_Cause_Sequence IN bis_custom_cause_effect_rels.cause_sequence%TYPE
89: ,p_Effect_Sequence IN bis_custom_cause_effect_rels.effect_sequence%TYPE
90: ,x_return_status OUT NOCOPY VARCHAR2
91: ,x_msg_count OUT NOCOPY NUMBER

Line 88: ,p_Cause_Sequence IN bis_custom_cause_effect_rels.cause_sequence%TYPE

84: PROCEDURE Update_Custom_Cause_Effect_Rel(
85: p_commit IN VARCHAR2 := FND_API.G_FALSE
86: ,p_Cause_Short_Name IN bis_custom_cause_effect_rels.cause_short_name%TYPE
87: ,p_Effect_Short_Name IN bis_custom_cause_effect_rels.effect_short_name%TYPE
88: ,p_Cause_Sequence IN bis_custom_cause_effect_rels.cause_sequence%TYPE
89: ,p_Effect_Sequence IN bis_custom_cause_effect_rels.effect_sequence%TYPE
90: ,x_return_status OUT NOCOPY VARCHAR2
91: ,x_msg_count OUT NOCOPY NUMBER
92: ,x_msg_data OUT NOCOPY VARCHAR2

Line 89: ,p_Effect_Sequence IN bis_custom_cause_effect_rels.effect_sequence%TYPE

85: p_commit IN VARCHAR2 := FND_API.G_FALSE
86: ,p_Cause_Short_Name IN bis_custom_cause_effect_rels.cause_short_name%TYPE
87: ,p_Effect_Short_Name IN bis_custom_cause_effect_rels.effect_short_name%TYPE
88: ,p_Cause_Sequence IN bis_custom_cause_effect_rels.cause_sequence%TYPE
89: ,p_Effect_Sequence IN bis_custom_cause_effect_rels.effect_sequence%TYPE
90: ,x_return_status OUT NOCOPY VARCHAR2
91: ,x_msg_count OUT NOCOPY NUMBER
92: ,x_msg_data OUT NOCOPY VARCHAR2
93: )IS

Line 96: CURSOR rec_Count(x_cause_short_name IN bis_custom_cause_effect_rels.cause_short_name%TYPE,x_effect_short_name IN bis_custom_cause_effect_rels.effect_short_name%TYPE)

92: ,x_msg_data OUT NOCOPY VARCHAR2
93: )IS
94:
95: l_count NUMBER := 0;
96: CURSOR rec_Count(x_cause_short_name IN bis_custom_cause_effect_rels.cause_short_name%TYPE,x_effect_short_name IN bis_custom_cause_effect_rels.effect_short_name%TYPE)
97: IS
98: SELECT COUNT(1)
99: FROM bis_custom_cause_effect_rels
100: WHERE cause_short_name = x_cause_short_name

Line 99: FROM bis_custom_cause_effect_rels

95: l_count NUMBER := 0;
96: CURSOR rec_Count(x_cause_short_name IN bis_custom_cause_effect_rels.cause_short_name%TYPE,x_effect_short_name IN bis_custom_cause_effect_rels.effect_short_name%TYPE)
97: IS
98: SELECT COUNT(1)
99: FROM bis_custom_cause_effect_rels
100: WHERE cause_short_name = x_cause_short_name
101: AND effect_short_name = x_effect_short_name;
102:
103: BEGIN

Line 136: UPDATE bis_custom_cause_effect_rels

132: FETCH rec_Count INTO l_count;
133: CLOSE rec_Count;
134:
135: IF l_count > 0 THEN
136: UPDATE bis_custom_cause_effect_rels
137: SET
138: cause_sequence = p_Cause_Sequence
139: , effect_sequence = p_Effect_Sequence
140: , last_updated_by = FND_GLOBAL.USER_ID

Line 165: ,p_Cause_Short_Name IN bis_custom_cause_effect_rels.cause_short_name%TYPE

161:
162:
163: PROCEDURE Delete_Custom_Cause_Effect_Rel(
164: p_commit IN VARCHAR2 := FND_API.G_FALSE
165: ,p_Cause_Short_Name IN bis_custom_cause_effect_rels.cause_short_name%TYPE
166: ,p_Effect_Short_Name IN bis_custom_cause_effect_rels.effect_short_name%TYPE
167: ,x_return_status OUT NOCOPY VARCHAR2
168: ,x_msg_count OUT NOCOPY NUMBER
169: ,x_msg_data OUT NOCOPY VARCHAR2

Line 166: ,p_Effect_Short_Name IN bis_custom_cause_effect_rels.effect_short_name%TYPE

162:
163: PROCEDURE Delete_Custom_Cause_Effect_Rel(
164: p_commit IN VARCHAR2 := FND_API.G_FALSE
165: ,p_Cause_Short_Name IN bis_custom_cause_effect_rels.cause_short_name%TYPE
166: ,p_Effect_Short_Name IN bis_custom_cause_effect_rels.effect_short_name%TYPE
167: ,x_return_status OUT NOCOPY VARCHAR2
168: ,x_msg_count OUT NOCOPY NUMBER
169: ,x_msg_data OUT NOCOPY VARCHAR2
170: ) IS

Line 172: CURSOR rec_Count(x_cause_short_name IN bis_custom_cause_effect_rels.cause_short_name%TYPE,x_effect_short_name IN bis_custom_cause_effect_rels.effect_short_name%TYPE)

168: ,x_msg_count OUT NOCOPY NUMBER
169: ,x_msg_data OUT NOCOPY VARCHAR2
170: ) IS
171: l_count NUMBER := 0;
172: CURSOR rec_Count(x_cause_short_name IN bis_custom_cause_effect_rels.cause_short_name%TYPE,x_effect_short_name IN bis_custom_cause_effect_rels.effect_short_name%TYPE)
173: IS
174: SELECT COUNT(1)
175: FROM bis_custom_cause_effect_rels
176: WHERE cause_short_name = x_cause_short_name

Line 175: FROM bis_custom_cause_effect_rels

171: l_count NUMBER := 0;
172: CURSOR rec_Count(x_cause_short_name IN bis_custom_cause_effect_rels.cause_short_name%TYPE,x_effect_short_name IN bis_custom_cause_effect_rels.effect_short_name%TYPE)
173: IS
174: SELECT COUNT(1)
175: FROM bis_custom_cause_effect_rels
176: WHERE cause_short_name = x_cause_short_name
177: AND effect_short_name = x_effect_short_name;
178:
179: BEGIN

Line 200: DELETE FROM bis_custom_cause_effect_rels

196: FETCH rec_Count INTO l_count;
197: CLOSE rec_Count;
198:
199: IF l_count > 0 THEN
200: DELETE FROM bis_custom_cause_effect_rels
201: WHERE
202: cause_short_name = p_Cause_Short_Name AND
203: effect_short_name = p_Effect_Short_Name;
204: END IF;

Line 231: l_Cause_Short_Name bis_custom_cause_effect_rels.cause_short_name%TYPE;

227: ,x_msg_count OUT NOCOPY NUMBER
228: ,x_msg_data OUT NOCOPY VARCHAR2
229: )
230: IS
231: l_Cause_Short_Name bis_custom_cause_effect_rels.cause_short_name%TYPE;
232: l_Effect_Short_Name bis_custom_cause_effect_rels.cause_short_name%TYPE;
233:
234: CURSOR c_short_Name(l_dataset_id NUMBER)
235: IS

Line 232: l_Effect_Short_Name bis_custom_cause_effect_rels.cause_short_name%TYPE;

228: ,x_msg_data OUT NOCOPY VARCHAR2
229: )
230: IS
231: l_Cause_Short_Name bis_custom_cause_effect_rels.cause_short_name%TYPE;
232: l_Effect_Short_Name bis_custom_cause_effect_rels.cause_short_name%TYPE;
233:
234: CURSOR c_short_Name(l_dataset_id NUMBER)
235: IS
236: SELECT