APPS.CSI_ML_CREATE_PVT SQL Statements

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

Line: 64

     SELECT cii.*
     FROM   csi_instance_interface       cii
     WHERE  trunc(cii.source_transaction_date) between
                          nvl(pc_txn_from_date,trunc(cii.source_transaction_date)) and
                          nvl(pc_txn_to_date,trunc(cii.source_transaction_date))
     AND cii.process_status = 'X'
     AND source_system_name = nvl(pc_source_system_name,source_system_name)
     AND nvl(parallel_worker_id,-1) = nvl(pc_worker_id,nvl(parallel_worker_id,-1))
     AND rownum <= pc_commit_recs;

Line: 77

     SELECT cpi.*
     FROM   csi_i_party_interface          cpi
     WHERE  cpi.inst_interface_id = pc_interface_id;

Line: 84

     SELECT ceai.*
     FROM   csi_iea_value_interface     ceai
     WHERE  ceai.inst_interface_id = pc_interface_id;

Line: 90

     SELECT csia.*
     FROM   csi_i_asset_interface     csia
     WHERE  csia.inst_interface_id = pc_interface_id;

Line: 120

        SELECT internal_party_id
        INTO   l_int_party
        FROM  csi_install_parameters;

Line: 132

      UPDATE CSI_INSTANCE_INTERFACE cii
      SET    error_text =l_error_message
            ,process_status ='E'
      WHERE nvl(parallel_worker_id,-1) = nvl(p_worker_id,nvl(parallel_worker_id,-1))
      AND   cii.process_status = 'X'
      AND   cii.source_system_name = p_source_system_name
      AND   trunc(cii.source_transaction_date) BETWEEN nvl(l_txn_from_date,trunc(cii.source_transaction_date)) AND nvl(l_txn_to_date,trunc(cii.source_transaction_date))
      AND   cii.location_type_code in ('INVENTORY','PO','IN_TRANSIT','WIP','PROJECT');

Line: 149

      UPDATE CSI_INSTANCE_INTERFACE cii
      SET    error_text =l_error_message
            ,process_status ='E'
      WHERE nvl(parallel_worker_id,-1) = nvl(p_worker_id,nvl(parallel_worker_id,-1))
      AND   cii.process_status = 'X'
      AND   cii.source_system_name = p_source_system_name
      AND   trunc(cii.source_transaction_date) BETWEEN nvl(l_txn_from_date,trunc(cii.source_transaction_date)) AND nvl(l_txn_to_date,trunc(cii.source_transaction_date))
      AND   exists ( SELECT 1
                     FROM   csi_i_party_interface cipi
                           ,csi_i_asset_interface ciai
                     WHERE  cipi.inst_interface_id = ciai.inst_interface_id
                     AND    cipi.inst_interface_id = cii.inst_interface_id
                     AND    nvl(cipi.party_id,0) <> l_int_party
                     AND    cipi.party_relationship_type_code = 'OWNER'
                   );

Line: 173

      UPDATE CSI_INSTANCE_INTERFACE cii
      SET    error_text =l_error_message
            ,process_status ='E'
      WHERE nvl(parallel_worker_id,-1) = nvl(p_worker_id,nvl(parallel_worker_id,-1))
      AND   cii.process_status = 'X'
      AND   cii.source_system_name = p_source_system_name
      AND   trunc(cii.source_transaction_date) BETWEEN nvl(l_txn_from_date,trunc(cii.source_transaction_date)) AND nvl(l_txn_to_date,trunc(cii.source_transaction_date))
      AND   exists (SELECT 1
                         FROM csi_i_asset_interface ciai
                        WHERE cii.inst_interface_id = ciai.inst_interface_id
                          AND ciai.fa_asset_id IS NULL
                          AND ciai.fa_asset_number IS NULL
                         );

Line: 198

      UPDATE CSI_INSTANCE_INTERFACE cii
      SET    error_text =l_error_message
            ,process_status ='E'
      WHERE nvl(parallel_worker_id,-1) = nvl(p_worker_id,nvl(parallel_worker_id,-1))
      AND   cii.process_status = 'X'
      AND   cii.source_system_name = p_source_system_name
      AND   trunc(cii.source_transaction_date) BETWEEN nvl(l_txn_from_date,trunc(cii.source_transaction_date)) AND nvl(l_txn_to_date,trunc(cii.source_transaction_date))
      AND   cii.location_type_code  IN ('HZ_PARTY_SITES','HZ_LOCATIONS')
      AND   (exists (SELECT 1
                    FROM   csi_i_party_interface cipi
                    WHERE  cipi.inst_interface_id = cii.inst_interface_id
                    AND    nvl(cipi.party_id,0) = l_int_party
                    AND    cipi.party_relationship_type_code = 'OWNER'
                   )
              AND   not exists (SELECT 1
                                FROM csi_i_asset_interface ciai
                                WHERE  cii.inst_interface_id = ciai.inst_interface_id
                         ));

Line: 1432

         END IF;   -- End Create Update Party

Line: 2417

        IF c_assets_rec.update_status IS NULL THEN
           x_asset_assignment_tbl( asset_idx ).update_status :=l_fnd_g_char;

Line: 2420

           x_asset_assignment_tbl( asset_idx ).update_status :=
                                                c_assets_rec.update_status;

Line: 2461

     END IF; -- End of Update or Create If

Line: 2544

     SELECT ciri.REL_INTERFACE_ID
           ,ciri.PARALLEL_WORKER_ID
           ,ciri.SUBJECT_INTERFACE_ID
           ,ciri.OBJECT_INTERFACE_ID
           ,ciri.RELATIONSHIP_TYPE_CODE
           ,ciri.RELATIONSHIP_START_DATE
           ,ciri.RELATIONSHIP_END_DATE
           ,ciri.POSITION_REFERENCE
           ,ciri.DISPLAY_ORDER
           ,ciri.MANDATORY_FLAG
           ,ciri.RELATIONSHIP_DIRECTION
           ,ciri.ERROR_TEXT
           ,ciri.CONTEXT
           ,ciri.ATTRIBUTE1
           ,ciri.ATTRIBUTE2
           ,ciri.ATTRIBUTE3
           ,ciri.ATTRIBUTE4
           ,ciri.ATTRIBUTE5
           ,ciri.ATTRIBUTE6
           ,ciri.ATTRIBUTE7
           ,ciri.ATTRIBUTE8
           ,ciri.ATTRIBUTE9
           ,ciri.ATTRIBUTE10
           ,ciri.ATTRIBUTE11
           ,ciri.ATTRIBUTE12
           ,ciri.ATTRIBUTE13
           ,ciri.ATTRIBUTE14
           ,ciri.ATTRIBUTE15
           ,cii1.transaction_identifier transaction_identifier
           ,cii1.instance_id subject_instance_id
           ,cii2.instance_id object_instance_id
     FROM   csi_ii_relation_interface   ciri,
            csi_instance_interface   cii1,
            csi_instance_interface   cii2
     WHERE  trunc(cii1.source_transaction_date) between
                          nvl(pc_txn_from_date,trunc(cii1.source_transaction_date)) and
                          nvl(pc_txn_to_date,trunc(cii1.source_transaction_date))
     AND cii1.process_status in ('X','E')
     AND cii1.source_system_name = nvl(pc_source_system_name,cii1.source_system_name)
     AND ciri.subject_interface_id = cii1.inst_interface_id

     AND trunc(cii2.source_transaction_date) between
                          nvl(pc_txn_from_date,trunc(cii2.source_transaction_date)) and
                          nvl(pc_txn_to_date,trunc(cii2.source_transaction_date))
     AND cii2.process_status in ('X','E')
     AND cii2.source_system_name = nvl(pc_source_system_name,cii2.source_system_name)
     AND ciri.object_interface_id = cii2.inst_interface_id;