APPS.CSP_TO_FORM_MOLINES SQL Statements

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

Line: 28

          p_LAST_UPDATED_BY         IN        NUMBER := FND_API.G_MISS_NUM,
          p_LAST_UPDATE_DATE        IN        DATE := FND_API.G_MISS_DATE,
          p_LAST_UPDATED_LOGIN      IN        NUMBER := FND_API.G_MISS_NUM,
          p_HEADER_ID               IN        NUMBER := FND_API.G_MISS_NUM,
          p_CUSTOMER_PO             IN        VARCHAR2 := FND_API.G_MISS_CHAR,
          p_INCIDENT_ID             IN        NUMBER := FND_API.G_MISS_NUM,
          p_TASK_ID                 IN        NUMBER := FND_API.G_MISS_NUM,
          p_TASK_ASSIGNMENT_ID      IN        NUMBER := FND_API.G_MISS_NUM,
          p_COMMENTS                IN        VARCHAR2 := FND_API.G_MISS_CHAR,
          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 := FND_API.G_MISS_CHAR,
          X_Return_Status           OUT NOCOPY       VARCHAR2,
          X_Msg_Count               OUT NOCOPY       NUMBER,
          X_Msg_Data                OUT NOCOPY       VARCHAR2
    )

IS
    l_mol_rec   CSP_ORDERLINES_PVT.MOL_Rec_Type;

Line: 75

    l_last_update_date          DATE := p_last_update_date;

Line: 77

    l_last_update_login         NUMBER := p_last_updated_login;

Line: 78

    l_last_updated_by           NUMBER := p_last_updated_by;

Line: 80

      Select creation_date
      From csp_moveorder_lines
      Where line_id = p_LINE_ID;

Line: 84

      Select line_id
      From csp_moveorder_lines
      Where line_id = p_LINE_ID;

Line: 123

                    SELECT header_id INTO l_check_existence
                    FROM mtl_txn_request_headers --csp_moveorder_headers
                    WHERE header_id = p_header_id;

Line: 154

                          SELECT line_id INTO l_check_existence
                          FROM mtl_txn_request_lines
                          WHERE line_id = p_line_id
                          AND header_id = p_header_id;

Line: 183

                    SELECT task_id INTO l_check_existence
                    FROM jtf_tasks_vl
                    WHERE task_id = p_task_id;

Line: 206

                        SELECT task_assignment_id INTO l_check_existence
                        FROM jtf_task_assignments
                        WHERE task_assignment_id = p_task_assignment_id
                        AND task_id = p_task_id;

Line: 227

                        SELECT task_assignment_id INTO l_check_existence
                        FROM jtf_task_assignments
                        WHERE task_assignment_id = p_task_assignment_id;

Line: 250

                    SELECT incident_id INTO l_check_existence
                    FROM cs_incidents_all
                    WHERE incident_id = p_incident_id;

Line: 274

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

Line: 282

         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: 286

         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: 298

                    SELECT line_id INTO l_check_existence
                    FROM csp_moveorder_lines
                    WHERE line_id = p_line_id;

Line: 321

                  SELECT header_id INTO l_check_existence
                  FROM csp_moveorder_headers
                  WHERE header_id = p_header_id;

Line: 343

                    SELECT task_id INTO l_check_existence
                    FROM jtf_tasks_vl
                    WHERE task_id = l_task_id;

Line: 362

                    SELECT nvl(task_assignment_id, fnd_api.g_miss_num) INTO l_task_assignment_id
                    FROM csp_moveorder_lines
                    WHERE line_id = p_line_id;

Line: 368

                          SELECT task_assignment_id INTO l_check_existence
                          FROM jtf_task_assignments
                          WHERE task_assignment_id = l_task_assignment_id
                          AND task_id = l_task_id;

Line: 394

                    SELECT nvl(task_id, fnd_api.g_miss_num) INTO l_task_id
                    FROM csp_moveorder_lines
                   WHERE line_id = p_line_id;

Line: 402

                        SELECT task_assignment_id INTO l_check_existence
                        FROM jtf_task_assignments
                        WHERE task_assignment_id = p_task_assignment_id
                        AND task_id = l_task_id;

Line: 423

                            SELECT task_assignment_id INTO l_check_existence
                            FROM jtf_task_assignments
                            WHERE task_assignment_id = p_task_assignment_id;

Line: 446

                SELECT incident_id INTO l_check_existence
                FROM cs_incidents_all
                WHERE incident_id = p_incident_id;

Line: 481

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

Line: 492

                    SELECT line_id INTO l_check_existence
                    FROM csp_moveorder_lines
                    WHERE line_id = p_line_id;

Line: 516

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

Line: 517

          l_mol_rec.LAST_UPDATE_DATE    := l_LAST_UPDATE_DATE;

Line: 518

          l_mol_rec.LAST_UPDATED_LOGIN  := l_LAST_UPDATE_LOGIN;

Line: 555

         elsif p_action_code = 1 then   -- call the update procedure

                 CSP_ORDERLINES_PVT.Update_orderlines(
                      P_Api_Version_Number => P_api_version_number,
                      P_Init_Msg_List     => P_Init_Msg_List,
                      P_Commit          => l_Commit,
                      p_validation_level   => p_validation_level,
                      P_Identity_Salesforce_Id   => NULL,
                      P_MOL_Rec      => l_mol_rec,
                      X_Return_Status => X_return_status,
                      X_Msg_Count => X_Msg_Count,
                      X_Msg_Data  => X_Msg_Data);

Line: 568

          else -- call the delete procedure
               CSP_ORDERLINES_PVT.Delete_orderlines(
                      P_Api_Version_Number => P_api_version_number,
                      P_Init_Msg_List     => P_Init_Msg_List,
                      P_Commit          => l_Commit,
                      p_validation_level   => p_validation_level,
                      P_Identity_Salesforce_Id   => NULL,
                      P_MOL_Rec      => l_mol_rec,
                      X_Return_Status => X_return_status,
                      X_Msg_Count => X_Msg_Count,
                      X_Msg_Data  => X_Msg_Data);