APPS.CSD_GROUP_SERIAL_NUMBER_PVT dependencies on CSD_GROUP_SERIAL_NUMBER_PVT

Line 1: PACKAGE BODY CSD_GROUP_SERIAL_NUMBER_PVT as

1: PACKAGE BODY CSD_GROUP_SERIAL_NUMBER_PVT as
2: /* $Header: csdvsrnb.pls 120.1.12000000.2 2007/02/20 22:43:27 takwong ship $*/
3: --
4: -- Package name : CSD_GROUP_SERIAL_NUMBER_PVT
5: -- Purpose : This package contains the private APIs for creating,

Line 4: -- Package name : CSD_GROUP_SERIAL_NUMBER_PVT

1: PACKAGE BODY CSD_GROUP_SERIAL_NUMBER_PVT as
2: /* $Header: csdvsrnb.pls 120.1.12000000.2 2007/02/20 22:43:27 takwong ship $*/
3: --
4: -- Package name : CSD_GROUP_SERIAL_NUMBER_PVT
5: -- Purpose : This package contains the private APIs for creating,
6: -- updating, deleting, locking serial numbers.
7: -- Access is restricted to Oracle Depot Rapair
8: -- Internal Development.

Line 13: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_GROUP_SERIAL_NUMBER_PVT';

9: -- History :
10: -- Version Date Name Description
11: -- 115.0 05/08/02 askumar Created.
12: --
13: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_GROUP_SERIAL_NUMBER_PVT';
14: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdvsrnb.pls';
15: --
16: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
17: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

Line 35: -- x_MRO_Serial_Number_Rec IN OUT NOCOPY CSD_GROUP_SERIAL_NUMBER_PVT.SERIAL_NUMBER_Rec_Type

31: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
32: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
33: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
34:
35: -- x_MRO_Serial_Number_Rec IN OUT NOCOPY CSD_GROUP_SERIAL_NUMBER_PVT.SERIAL_NUMBER_Rec_Type
36: -- x_return_status OUT NOCOPY VARCHAR2
37: -- x_msg_count OUT NOCOPY NUMBER
38: -- x_msg_data OUT NOCOPY VARCHAR2
39: --

Line 52: x_MRO_Serial_Number_rec IN OUT NOCOPY CSD_GROUP_SERIAL_NUMBER_PVT.SERIAL_NUMBER_Rec_Type,

48: P_Api_Version_Number IN NUMBER,
49: P_Init_Msg_List IN VARCHAR2,
50: P_Commit IN VARCHAR2,
51: p_validation_level IN NUMBER,
52: x_MRO_Serial_Number_rec IN OUT NOCOPY CSD_GROUP_SERIAL_NUMBER_PVT.SERIAL_NUMBER_Rec_Type,
53: X_Return_Status OUT NOCOPY VARCHAR2,
54: X_Msg_Count OUT NOCOPY NUMBER,
55: X_Msg_Data OUT NOCOPY VARCHAR2
56: )

Line 72: x_MRO_Serial_Number_rec IN OUT NOCOPY CSD_GROUP_SERIAL_NUMBER_PVT.SERIAL_NUMBER_Rec_Type,

68: P_Api_Version_Number IN NUMBER,
69: P_Init_Msg_List IN VARCHAR2,
70: P_Commit IN VARCHAR2,
71: p_validation_level IN NUMBER,
72: x_MRO_Serial_Number_rec IN OUT NOCOPY CSD_GROUP_SERIAL_NUMBER_PVT.SERIAL_NUMBER_Rec_Type,
73: X_Return_Status OUT NOCOPY VARCHAR2,
74: X_Msg_Count OUT NOCOPY NUMBER,
75: X_Msg_Data OUT NOCOPY VARCHAR2
76: )

Line 114: x_MRO_Serial_Number_rec IN CSD_GROUP_SERIAL_NUMBER_PVT.SERIAL_NUMBER_Rec_Type,

110: P_Api_Version_Number IN NUMBER,
111: P_Init_Msg_List IN VARCHAR2,
112: P_Commit IN VARCHAR2,
113: p_validation_level IN NUMBER,
114: x_MRO_Serial_Number_rec IN CSD_GROUP_SERIAL_NUMBER_PVT.SERIAL_NUMBER_Rec_Type,
115: X_Return_Status OUT NOCOPY VARCHAR2,
116: X_Msg_Count OUT NOCOPY NUMBER,
117: X_Msg_Data OUT NOCOPY VARCHAR2
118: )

Line 215: End CSD_GROUP_SERIAL_NUMBER_PVT;

211:
212: END Is_Duplicate_Serial_Num;
213:
214:
215: End CSD_GROUP_SERIAL_NUMBER_PVT;