APPS.CSI_ORG_UNIT_VLD_PVT SQL Statements

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

Line: 31

      SELECT  '1'
      INTO    l_instance_id
      FROM    csi_item_instances
      WHERE   instance_id = p_instance_id
      AND     ((active_end_date is NULL) OR (active_end_date  >= SYSDATE));

Line: 39

        IF p_event = 'INSERT' THEN
            IF ( p_stack_err_msg = TRUE ) THEN
               FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_ID');

Line: 46

        ELSIF p_event = 'UPDATE' THEN
            IF ( p_stack_err_msg = TRUE ) THEN
               FND_MESSAGE.SET_NAME('CSI','CSI_API_EXPIRED_INSTANCE_ID');

Line: 61

/* Function Name :  Val_inst_id_for_update                  */
/*                                                          */
/* Description  :  This function checks if  instance        */
/*                 ids can be updated                       */
/*----------------------------------------------------------*/

FUNCTION Val_inst_id_for_update
              (p_instance_id_new    IN      NUMBER
               ,p_instance_id_old   IN      NUMBER
               ,p_stack_err_msg     IN      BOOLEAN )
RETURN BOOLEAN
IS
  l_instance_id            NUMBER;

Line: 95

END Val_inst_id_for_update;

Line: 112

      SELECT active_start_date,
             active_end_date
      FROM csi_item_instances
      WHERE instance_id = p_instance_id ;

Line: 188

       SELECT active_end_date,
           active_start_date
       FROM csi_item_instances
       WHERE instance_id = p_instance_id ;

Line: 211

         SELECT MAX(t.transaction_date)
         INTO   l_transaction_date
         FROM   csi_i_org_assignments_h s,
                csi_transactions t
         WHERE  s.instance_ou_id=p_instance_ou_id
         AND    s.transaction_id=t.transaction_id
	    AND    t.transaction_id <> p_txn_id;

Line: 272

             SELECT  '1'
             INTO    l_operating_unit_id
             FROM    hr_operating_units
             WHERE   organization_id = p_operating_unit_id ;

Line: 306

      SELECT  '1'
      INTO    l_relationship_type_code
      FROM    csi_lookups
      WHERE   lookup_type = l_rltn_lookup_type
      AND     lookup_code = p_relationship_type_code;

Line: 350

     SELECT  '1'
     INTO    l_dummy
     FROM    csi_i_org_assignments
     WHERE   instance_id = p_instance_id
   --  AND     operating_unit_id = p_operating_unit_id -- Fix for Bug # 3918188
     AND     instance_ou_id <> l_instance_ou_id
     AND     relationship_type_code = p_relationship_type_code;

Line: 393

     SELECT  '1'
     INTO    l_instance_ou_id
     FROM    csi_i_org_assignments
     WHERE   instance_ou_id = p_instance_ou_id;

Line: 429

     SELECT instance_ou_id ,
            instance_id ,
            operating_unit_id,
            relationship_type_code,
            active_start_date,
            active_end_date,
            context,
            attribute1 ,
            attribute2,
            attribute3,
            attribute4,
            attribute5,
            attribute6,
            attribute7,
            attribute8,
            attribute9,
            attribute10,
            attribute11,
            attribute12,
            attribute13,
            attribute14,
            attribute15,
            object_version_number
     INTO   p_org_unit_rec.instance_ou_id ,
            p_org_unit_rec.instance_id,
            p_org_unit_rec.operating_unit_id,
            p_org_unit_rec.relationship_type_code,
            p_org_unit_rec.active_start_date,
            p_org_unit_rec.active_end_date,
            p_org_unit_rec.context,
            p_org_unit_rec.attribute1,
            p_org_unit_rec.attribute2,
            p_org_unit_rec.attribute3,
            p_org_unit_rec.attribute4,
            p_org_unit_rec.attribute5,
            p_org_unit_rec.attribute6,
            p_org_unit_rec.attribute7,
            p_org_unit_rec.attribute8,
            p_org_unit_rec.attribute9,
            p_org_unit_rec.attribute10,
            p_org_unit_rec.attribute11,
            p_org_unit_rec.attribute12,
            p_org_unit_rec.attribute13,
            p_org_unit_rec.attribute14,
            p_org_unit_rec.attribute15,
            p_org_unit_rec.object_version_number
     FROM    csi_i_org_assignments
     WHERE   instance_ou_id = p_instance_ou_id;

Line: 581

      SELECT  csi_i_org_assignments_s.nextval
      INTO    l_instance_ou_id
      FROM    dual;

Line: 608

      SELECT  csi_i_org_assignments_h_s.nextval
      INTO    l_cis_i_org_assign_h_id
      FROM    dual;