APPS.BSC_COLOR_PVT dependencies on BSC_COLOR_PUB

Line 30: ,x_Bsc_Color_Rec OUT NOCOPY BSC_COLOR_PUB.Bsc_Color_Rec

26: PROCEDURE Retrieve_Color(
27: p_commit IN VARCHAR2:= FND_API.G_FALSE
28: ,p_Bsc_Color_Id IN NUMBER
29: ,p_Bsc_Color_SN IN VARCHAR2
30: ,x_Bsc_Color_Rec OUT NOCOPY BSC_COLOR_PUB.Bsc_Color_Rec
31: ,x_return_status OUT NOCOPY VARCHAR2
32: ,x_msg_count OUT NOCOPY NUMBER
33: ,x_msg_data OUT NOCOPY VARCHAR2
34: );

Line 40: ,p_Bsc_Color_Rec IN BSC_COLOR_PUB.Bsc_Color_Rec

36: /************************************************************************************
37: ************************************************************************************/
38: PROCEDURE Create_Color(
39: p_commit IN VARCHAR2 := FND_API.G_FALSE
40: ,p_Bsc_Color_Rec IN BSC_COLOR_PUB.Bsc_Color_Rec
41: ,x_return_status OUT NOCOPY VARCHAR2
42: ,x_msg_count OUT NOCOPY NUMBER
43: ,x_msg_data OUT NOCOPY VARCHAR2
44: ) IS

Line 136: ,p_Bsc_Color_Rec IN BSC_COLOR_PUB.Bsc_Color_Rec

132: ************************************************************************************/
133: -- API To be called from UI.
134: PROCEDURE Update_Color(
135: p_commit IN VARCHAR2 := FND_API.G_FALSE
136: ,p_Bsc_Color_Rec IN BSC_COLOR_PUB.Bsc_Color_Rec
137: ,x_return_status OUT NOCOPY VARCHAR2
138: ,x_msg_count OUT NOCOPY NUMBER
139: ,x_msg_data OUT NOCOPY VARCHAR2
140: ) IS

Line 142: l_Bsc_Color_Rec BSC_COLOR_PUB.Bsc_Color_Rec;

138: ,x_msg_count OUT NOCOPY NUMBER
139: ,x_msg_data OUT NOCOPY VARCHAR2
140: ) IS
141: l_color_id NUMBER;
142: l_Bsc_Color_Rec BSC_COLOR_PUB.Bsc_Color_Rec;
143:
144: l_user_id NUMBER;
145: l_login_id NUMBER;
146: BEGIN

Line 253: ,p_Bsc_Color_Rec IN BSC_COLOR_PUB.Bsc_Color_Rec

249: /************************************************************************************
250: ************************************************************************************/
251: PROCEDURE Translate_Color(
252: p_commit IN VARCHAR2:= FND_API.G_FALSE
253: ,p_Bsc_Color_Rec IN BSC_COLOR_PUB.Bsc_Color_Rec
254: ,x_return_status OUT NOCOPY VARCHAR2
255: ,x_msg_count OUT NOCOPY NUMBER
256: ,x_msg_data OUT NOCOPY VARCHAR2
257: ) IS

Line 258: l_Bsc_Color_Rec BSC_COLOR_PUB.Bsc_Color_Rec;

254: ,x_return_status OUT NOCOPY VARCHAR2
255: ,x_msg_count OUT NOCOPY NUMBER
256: ,x_msg_data OUT NOCOPY VARCHAR2
257: ) IS
258: l_Bsc_Color_Rec BSC_COLOR_PUB.Bsc_Color_Rec;
259: l_user_id NUMBER;
260: l_login_id NUMBER;
261: BEGIN
262: SAVEPOINT BscColorPvt_TrnsColor;

Line 332: ,p_Bsc_Color_Rec IN BSC_COLOR_PUB.Bsc_Color_Rec

328: /************************************************************************************
329: ************************************************************************************/
330: PROCEDURE Load_Translated_Color(
331: p_commit IN VARCHAR2:= FND_API.G_FALSE
332: ,p_Bsc_Color_Rec IN BSC_COLOR_PUB.Bsc_Color_Rec
333: ,x_return_status OUT NOCOPY VARCHAR2
334: ,x_msg_count OUT NOCOPY NUMBER
335: ,x_msg_data OUT NOCOPY VARCHAR2
336: ) IS

Line 337: l_Bsc_Color_Rec BSC_COLOR_PUB.Bsc_Color_Rec;

333: ,x_return_status OUT NOCOPY VARCHAR2
334: ,x_msg_count OUT NOCOPY NUMBER
335: ,x_msg_data OUT NOCOPY VARCHAR2
336: ) IS
337: l_Bsc_Color_Rec BSC_COLOR_PUB.Bsc_Color_Rec;
338: l_user_id NUMBER;
339: l_login_id NUMBER;
340: BEGIN
341: FND_MSG_PUB.Initialize;

Line 414: ,x_Bsc_Color_Rec OUT NOCOPY BSC_COLOR_PUB.Bsc_Color_Rec

410: PROCEDURE Retrieve_Color(
411: p_commit IN VARCHAR2:= FND_API.G_FALSE
412: ,p_Bsc_Color_Id IN NUMBER
413: ,p_Bsc_Color_SN IN VARCHAR2
414: ,x_Bsc_Color_Rec OUT NOCOPY BSC_COLOR_PUB.Bsc_Color_Rec
415: ,x_return_status OUT NOCOPY VARCHAR2
416: ,x_msg_count OUT NOCOPY NUMBER
417: ,x_msg_data OUT NOCOPY VARCHAR2
418: ) IS

Line 495: ,p_Bsc_Color_Rec IN BSC_COLOR_PUB.Bsc_Color_Rec

491: /************************************************************************************
492: ************************************************************************************/
493: PROCEDURE Load_Color(
494: p_commit IN VARCHAR2:= FND_API.G_FALSE
495: ,p_Bsc_Color_Rec IN BSC_COLOR_PUB.Bsc_Color_Rec
496: ,x_return_status OUT NOCOPY VARCHAR2
497: ,x_msg_count OUT NOCOPY NUMBER
498: ,x_msg_data OUT NOCOPY VARCHAR2
499: ) IS

Line 500: l_Bsc_Color_Rec BSC_COLOR_PUB.Bsc_Color_Rec;

496: ,x_return_status OUT NOCOPY VARCHAR2
497: ,x_msg_count OUT NOCOPY NUMBER
498: ,x_msg_data OUT NOCOPY VARCHAR2
499: ) IS
500: l_Bsc_Color_Rec BSC_COLOR_PUB.Bsc_Color_Rec;
501: l_user_id NUMBER;
502: l_login_id NUMBER;
503: l_count NUMBER;
504: BEGIN