DBA Data[Home] [Help]

APPS.CSD_GROUP_SERIAL_NUMBER_PVT SQL Statements

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

Line: 67

PROCEDURE Update_Serial_Number(
  P_Api_Version_Number      IN      NUMBER,
  P_Init_Msg_List           IN      VARCHAR2,
  P_Commit                  IN      VARCHAR2,
  p_validation_level        IN      NUMBER,
  x_MRO_Serial_Number_rec   IN  OUT NOCOPY CSD_GROUP_SERIAL_NUMBER_PVT.SERIAL_NUMBER_Rec_Type,
  X_Return_Status           OUT NOCOPY     VARCHAR2,
  X_Msg_Count               OUT NOCOPY     NUMBER,
  X_Msg_Data                OUT NOCOPY     VARCHAR2
  )
IS
--

--
BEGIN

NULL;
Line: 85

 End Update_Serial_Number;
Line: 88

PROCEDURE Delete_Serial_Number(
  P_Api_Version_Number         IN   NUMBER,
  P_Init_Msg_List              IN   VARCHAR2,
  P_Commit                     IN   VARCHAR2,
  p_validation_level           IN   NUMBER,
  p_MRO_Serial_Number_ID       IN   NUMBER,
  X_Return_Status              OUT NOCOPY  VARCHAR2,
  x_Msg_Count                  OUT NOCOPY  NUMBER,
  x_Msg_Data                   OUT NOCOPY  VARCHAR2
  )
iS
--
--
BEGIN
--
-- Standard Start of API savepoint
null;
Line: 105

 End Delete_Serial_Number;