APPS.CSP_PC_FORM_PICKHEADERS SQL Statements

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

Line: 31

       p_LAST_UPDATED_BY           IN      NUMBER := FND_API.G_MISS_NUM,
       p_LAST_UPDATE_DATE          IN      DATE := FND_API.G_MISS_DATE,
       p_LAST_UPDATE_LOGIN         IN      NUMBER := FND_API.G_MISS_NUM,
       p_ORGANIZATION_ID           IN      NUMBER := FND_API.G_MISS_NUM,
       p_PICKLIST_NUMBER           IN      VARCHAR2 := FND_API.G_MISS_CHAR,
       p_PICKLIST_STATUS           IN      VARCHAR2 := FND_API.G_MISS_CHAR,
       p_DATE_CREATED              IN      DATE := FND_API.G_MISS_DATE,
       p_DATE_CONFIRMED            IN      DATE := FND_API.G_MISS_DATE,
       p_ATTRIBUTE_CATEGORY        IN      VARCHAR2 := FND_API.G_MISS_CHAR,
       p_ATTRIBUTE1                IN      VARCHAR2 := FND_API.G_MISS_CHAR,
       p_ATTRIBUTE2                IN      VARCHAR2 := FND_API.G_MISS_CHAR,
       p_ATTRIBUTE3                IN      VARCHAR2 := FND_API.G_MISS_CHAR,
       p_ATTRIBUTE4                IN      VARCHAR2 := FND_API.G_MISS_CHAR,
       p_ATTRIBUTE5                IN      VARCHAR2 := FND_API.G_MISS_CHAR,
       p_ATTRIBUTE6                IN      VARCHAR2 := FND_API.G_MISS_CHAR,
       p_ATTRIBUTE7                IN      VARCHAR2 := FND_API.G_MISS_CHAR,
       p_ATTRIBUTE8                IN      VARCHAR2 := FND_API.G_MISS_CHAR,
       p_ATTRIBUTE9                IN      VARCHAR2 := FND_API.G_MISS_CHAR,
       p_ATTRIBUTE10               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
       p_ATTRIBUTE11               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
       p_ATTRIBUTE12               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
       p_ATTRIBUTE13               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
       p_ATTRIBUTE14               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
       p_ATTRIBUTE15               IN      VARCHAR2,
       X_Return_Status           OUT NOCOPY     VARCHAR2,
       X_Msg_Count               OUT NOCOPY     NUMBER,
       X_Msg_Data                OUT NOCOPY     VARCHAR2
    )
 IS
    l_api_version_number        CONSTANT NUMBER  := 1.0;

Line: 73

    l_last_update_date          DATE := p_last_update_date;

Line: 77

    l_last_update_login         NUMBER := p_last_update_login;

Line: 78

    l_last_updated_by           NUMBER := p_last_updated_by;

Line: 80

       Select creation_date
       From csp_picklist_headers
       Where picklist_header_id = px_PICKLIST_HEADER_ID;

Line: 112

                  SELECT picklist_header_id INTO l_check_existence
                  FROM CSP_PICKLIST_HEADERS
                  WHERE picklist_header_id = px_picklist_header_id
                  AND organization_id = p_organization_id;

Line: 142

                  select distinct lookup_code into l_check_var
                  from fnd_lookups
                  where lookup_type = 'CSP_PICKLIST_STATUS'
                  and lookup_code = p_PICKLIST_STATUS;

Line: 170

                        select organization_id into l_check_existence
                        from mtl_parameters
                        where organization_id = p_organization_id;

Line: 193

         IF nvl(l_last_update_date, fnd_api.g_miss_date) = fnd_api.g_miss_date THEN
              l_last_update_date := sysdate;

Line: 201

         IF nvl(l_last_update_login, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
              l_last_update_login := g_login_id;

Line: 205

         IF nvl(l_last_updated_by, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
              l_last_updated_by := g_user_id;

Line: 221

                  select picklist_header_id into l_check_existence
                  from csp_picklist_headers
                  where picklist_header_id = px_picklist_header_id;

Line: 243

                  select distinct lookup_code into l_check_var
                  from fnd_lookups
                  where lookup_type = 'CSP_PICKLIST_STATUS'
                  and lookup_code = p_PICKLIST_STATUS;

Line: 266

                    select organization_id into l_check_existence
                    from mtl_parameters
                    where organization_id = p_organization_id;

Line: 300

           IF nvl(l_last_update_date, fnd_api.g_miss_date) = fnd_api.g_miss_date THEN
              l_last_update_date := sysdate;

Line: 312

                  select picklist_header_id/0 into l_check_existence
                  from csp_picklist_headers
                  where picklist_header_id = px_picklist_header_id;

Line: 337

            l_pick_header_rec.LAST_UPDATED_BY                 := nvl(l_LAST_UPDATED_BY, fnd_api.g_miss_num);

Line: 338

            l_pick_header_rec.LAST_UPDATE_DATE                := l_LAST_UPDATE_DATE;

Line: 339

            l_pick_header_rec.LAST_UPDATE_LOGIN               := l_LAST_UPDATE_LOGIN;

Line: 379

               CSP_PICKLIST_HEADER_PVT.Update_picklist_header(
                    P_Api_Version_Number         => P_Api_Version_Number,
                    P_Init_Msg_List              => P_Init_Msg_List,
                    P_Commit                     => l_Commit,
                    p_validation_level           => l_validation_level,
                    P_PICK_HEADER_Rec            => l_PICK_HEADER_Rec,
                    X_Return_Status              => l_Return_Status,
                    X_Msg_Count                  => l_Msg_Count,
                    X_Msg_Data                   => l_Msg_Data
                    );

Line: 392

            CSP_PICKLIST_HEADER_PVT.Delete_picklist_header(
                    P_Api_Version_Number         => P_Api_Version_Number,
                    P_Init_Msg_List              => P_Init_Msg_List,
                    P_Commit                     => l_Commit,
                    p_validation_level           => l_validation_level,
                    P_PICK_HEADER_Rec            => l_PICK_HEADER_Rec,
                    X_Return_Status              => l_Return_Status,
                    X_Msg_Count                  => l_Msg_Count,
                    X_Msg_Data                   => l_Msg_Data
                    );