APPS.ARP_ARXCOBL_MLS_PACKAGE SQL Statements

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

Line: 20

select_sql1_c 		number;

Line: 21

select_sql1 		varchar2(10000);

Line: 22

select_sql2_c           number;

Line: 23

select_sql2             varchar2(10000);

Line: 30

SELECT cust_acct.cust_account_id customer_id
  from hz_cust_accounts cust_acct,
       hz_parties party
  where cust_acct.party_id = party.party_id
    and upper(party.party_name) between
                 nvl(upper(p_customer_name_from),'A')
             and nvl(upper(p_customer_name_to),'Z');

Line: 38

TYPE select_rec_type IS RECORD
(language VARCHAR2(4));

Line: 41

select_rec1		select_rec_type;

Line: 42

null_rec       		CONSTANT select_rec_type := select_rec1;

Line: 47

   select  substr(userenv('LANG'),1,4)
   into    p_userenv_lang
   from    dual;

Line: 111

/* bug1946875: This cursor is not used. customer condition has already been included in select_sql1. */
   ---Customer Loop . For every customer the loop finds out the languages for corresponding Bill To addresses.


--  For Customer IN cusinfo(P_CUSTOMER_NAME_FROM,P_CUSTOMER_NAME_TO)
-- LOOP
select_sql1 :=
'select distinct(nvl(rtrim(substr(loc.language,1,4)), ''' || p_userenv_lang || ''')) language ' || cr ||
'from ' || p_table1 || cr ||
'where ' || cr || p_where2;

Line: 123

   arp_standard.debug('raxinv.select_sql1 =  ' || cr ||
                       select_sql1 || cr );

Line: 132

        arp_standard.debug( '  Parsing select_sql1 stmt');

Line: 133

        select_sql1_c := dbms_sql.open_cursor;

Line: 134

        dbms_sql.parse( select_sql1_c, select_sql1, dbms_sql.v7 );

Line: 138

          arp_standard.debug( 'EXCEPTION: Error parsing select_sql1 stmt' );

Line: 143

    arp_standard.debug( 'Completed parsing select stmts' );

Line: 145

    arp_standard.debug( 'define_columns for select_sql1_c');

Line: 146

    dbms_sql.define_column( select_sql1_c, 1, select_rec1.language, 4);

Line: 149

      dbms_sql.bind_variable(select_sql1_c, ':p_customer_name_from', p_customer_name_from);

Line: 152

      dbms_sql.bind_variable(select_sql1_c, ':p_customer_name_to', p_customer_name_to);

Line: 156

        arp_standard.debug( '  Executing select_sql1' );

Line: 158

       l_ignore := dbms_sql.execute( select_sql1_c );

Line: 162

            arp_standard.debug( 'EXCEPTION: Error executing select_sql1' );

Line: 170

   arp_standard.debug( '  Fetching select_sql1 stmt');

Line: 174

         if (dbms_sql.fetch_rows( select_sql1_c ) > 0)
         then

            arp_standard.debug('  fetched a row' );

Line: 178

            select_rec1 := null_rec;

Line: 182

            dbms_sql.column_value( select_sql1_c, 1, select_rec1.language );

Line: 183

            arp_standard.debug( 'Language code: ' || select_rec1.language );

Line: 186

               lang_str := select_rec1.language;

Line: 188

               lang_str := lang_str || ',' ||  select_rec1.language;

Line: 192

            arp_standard.debug('Done fetching select_sql1');