APPS.CSI_JAVA_INTERFACE_PKG SQL Statements

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

Line: 192

            select meaning into x_output_contracts(l_index).status_text from OKC_STATUSES_V where code = l_output_contracts(l_index).sts_code;

Line: 564

    Select *
    From   csi_search_oks_temp
    Where  creation_date < sysdate
    and    rownum <= 1
    For Update NoWait;

Line: 597

       DELETE csi_search_oks_temp
       WHERE creation_date < sysdate -1;

Line: 632

       SELECT csi_search_oks_temp_S.NEXTVAL, sysdate
       INTO   l_Seq, l_Creation_Date
       FROM   dual;

Line: 658

          Insert into csi_search_oks_temp
           (
             id,
             creation_date,
             covered_level_id,
             covered_level_code
           )
           Values
           (
             l_Seq
            ,l_Creation_Date
            ,l_ent_contracts(l_rec_count).coverage_level_id
            ,l_ent_contracts(l_rec_count).coverage_level_code
           );

Line: 922

                l_contract_where_clause := l_instance_table_name || 'instance_id in ( select instance_id from csi_i_parties where party_id in ( '
                                           ||l_covered_party_id||' ) )' ;

Line: 927

                                           l_instance_table_name || 'instance_id in ( select instance_id from csi_i_parties where party_id in ( '
                                           ||l_covered_party_id||' ) )' ;

Line: 951

                   l_contract_where_clause := l_instance_table_name || 'instance_id in ( select instance_id from ' ||
                     ' csi_i_parties p, csi_ip_accounts a where a.instance_party_id = p.instance_party_id ' ||
                     ' and a.party_account_id IN ( '||l_covered_acct_id  ||' ) )'  ;

Line: 956

                     l_instance_table_name || 'instance_id in ( select instance_id from ' ||
                     ' csi_i_parties p, csi_ip_accounts a where a.instance_party_id = p.instance_party_id ' ||
                     ' and a.party_account_id IN ( '||l_covered_acct_id  ||' ) )'  ;

Line: 1114

      SELECT 'x'
      INTO   l_dummy
      FROM   csi_item_instances_h
      WHERE  transaction_id = p_transaction_id
      AND    ROWNUM = 1;

Line: 1149

      SELECT 'x'
      INTO   l_dummy
      FROM   csi_i_assets_h
      WHERE  transaction_id = p_transaction_id
      AND    ROWNUM = 1;

Line: 1182

      SELECT 'x'
      INTO   l_dummy
      FROM   csi_i_parties_h
      WHERE  transaction_id = p_transaction_id
      AND    ROWNUM = 1;

Line: 1216

      SELECT 'x'
      INTO   l_dummy
      FROM   csi_ip_accounts_h
      WHERE  transaction_id = p_transaction_id
      AND    rownum=1;

Line: 1251

      SELECT 'x'
      INTO   l_dummy
      FROM   csi_i_org_assignments_h
      WHERE  transaction_id = p_transaction_id
      AND    ROWNUM = 1;

Line: 1286

      SELECT 'x'
      INTO   l_dummy
      FROM   csi_iea_values_h
      WHERE  transaction_id = p_transaction_id
      AND    ROWNUM = 1;

Line: 1321

      SELECT 'x'
      INTO   l_dummy
      FROM   csi_ii_relationships_h
      WHERE  transaction_id = p_transaction_id
      AND    rownum=1;

Line: 1355

      SELECT 'x'
      INTO   l_dummy
      FROM   csi_i_version_labels_h
      WHERE  transaction_id = p_transaction_id
      AND    ROWNUM = 1;

Line: 1686

        insert into csi_configuration_temp_tbl (object_id,subject_id) values ( p_connected_relationship_tbl(i).object_id, p_connected_relationship_tbl(i).subject_id);

Line: 1719

  delete from csi_configuration_temp_tbl;

Line: 1739

          insert into csi_configuration_temp_tbl
            (
            object_id,
            subject_id
        )
        values
        (
            l_rel_tbl(l_var).object_id,
            l_rel_tbl(l_var).subject_id
        );

Line: 1789

        insert into csi_configuration_temp_tbl (object_id,subject_id) values ( l_rel_tbl1(i).object_id, l_rel_tbl1(i).subject_id);

Line: 1868

SELECT
    org_id into l_org_id
FROM
    oe_order_lines_all oeol
WHERE
    line_id=p_last_oe_order_line_id;

Line: 1882

    SELECT
        oe_sys_parameters.value('MASTER_ORGANIZATION_ID', l_org_id)
    INTO l_config_id
    FROM DUAL;

Line: 1910

    SELECT serial_number
    FROM   csi_item_instances
    WHERE  instance_id =l_instance_id ;

Line: 1915

   SELECT CIIH.INSTANCE_ID FROM
   CSI_ITEM_INSTANCES_H ciih,
   csi_item_instances cii
   WHERE
   cii.instance_id =ciih.instance_id
   AND cii.SERIAL_NUMBER IS  NULL
    and  ciiH.INSTANCE_ID NOT IN n_instance_id
   AND  TRANSACTION_ID IN
   ( SELECT MAX(TRANSACTION_ID) FROM CSI_ITEM_INSTANCES_H WHERE INSTANCE_ID
    = n_instance_id);

Line: 1958

		--p_instance_tbl.DELETE(i_dx);

Line: 2012

PROCEDURE delete_search_oks_temp
 (
        p_sequence_id          IN  NUMBER
       ,x_return_status        OUT NOCOPY VARCHAR2
       ,x_msg_count            OUT NOCOPY NUMBER
       ,x_msg_data             OUT NOCOPY VARCHAR2
 ) IS

    l_api_name               CONSTANT VARCHAR2(30)   := 'delete_search_oks_temp';

Line: 2032

     DELETE csi_search_oks_temp where id = p_sequence_id ;

Line: 2051

END delete_search_oks_temp;

Line: 2070

    SELECT
        relationship_id, object_version_number INTO l_relationship_id, l_object_version_number
    FROM
        csi_ii_relationships
    WHERE
        subject_id = p_subject_id
        and (active_end_date IS NULL OR active_end_date > sysdate);