APPS.ARP_ARXCOBL_MLS_PACKAGE dependencies on DBMS_SQL

Line 133: select_sql1_c := dbms_sql.open_cursor;

129: ------------------------------------------------
130:
131: BEGIN
132: arp_standard.debug( ' Parsing select_sql1 stmt');
133: select_sql1_c := dbms_sql.open_cursor;
134: dbms_sql.parse( select_sql1_c, select_sql1, dbms_sql.v7 );
135: -- DBMS_SQL.BIND_VARIABLE(select_sql1_c,':l_customer_id',Customer.customer_id);
136: EXCEPTION
137: WHEN OTHERS THEN

Line 134: dbms_sql.parse( select_sql1_c, select_sql1, dbms_sql.v7 );

130:
131: BEGIN
132: arp_standard.debug( ' Parsing select_sql1 stmt');
133: select_sql1_c := dbms_sql.open_cursor;
134: dbms_sql.parse( select_sql1_c, select_sql1, dbms_sql.v7 );
135: -- DBMS_SQL.BIND_VARIABLE(select_sql1_c,':l_customer_id',Customer.customer_id);
136: EXCEPTION
137: WHEN OTHERS THEN
138: arp_standard.debug( 'EXCEPTION: Error parsing select_sql1 stmt' );

Line 135: -- DBMS_SQL.BIND_VARIABLE(select_sql1_c,':l_customer_id',Customer.customer_id);

131: BEGIN
132: arp_standard.debug( ' Parsing select_sql1 stmt');
133: select_sql1_c := dbms_sql.open_cursor;
134: dbms_sql.parse( select_sql1_c, select_sql1, dbms_sql.v7 );
135: -- DBMS_SQL.BIND_VARIABLE(select_sql1_c,':l_customer_id',Customer.customer_id);
136: EXCEPTION
137: WHEN OTHERS THEN
138: arp_standard.debug( 'EXCEPTION: Error parsing select_sql1 stmt' );
139: RAISE;

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

142:
143: arp_standard.debug( 'Completed parsing select stmts' );
144:
145: arp_standard.debug( 'define_columns for select_sql1_c');
146: dbms_sql.define_column( select_sql1_c, 1, select_rec1.language, 4);
147: -- Bug 5173488: use bind variable instead of hard code literal in where clause.
148: if p_customer_name_from is not null then
149: dbms_sql.bind_variable(select_sql1_c, ':p_customer_name_from', p_customer_name_from);
150: end if;

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

145: arp_standard.debug( 'define_columns for select_sql1_c');
146: dbms_sql.define_column( select_sql1_c, 1, select_rec1.language, 4);
147: -- Bug 5173488: use bind variable instead of hard code literal in where clause.
148: if p_customer_name_from is not null then
149: dbms_sql.bind_variable(select_sql1_c, ':p_customer_name_from', p_customer_name_from);
150: end if;
151: if p_customer_name_to is not null then
152: dbms_sql.bind_variable(select_sql1_c, ':p_customer_name_to', p_customer_name_to);
153: end if;

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

148: if p_customer_name_from is not null then
149: dbms_sql.bind_variable(select_sql1_c, ':p_customer_name_from', p_customer_name_from);
150: end if;
151: if p_customer_name_to is not null then
152: dbms_sql.bind_variable(select_sql1_c, ':p_customer_name_to', p_customer_name_to);
153: end if;
154:
155:
156: arp_standard.debug( ' Executing select_sql1' );

Line 158: l_ignore := dbms_sql.execute( select_sql1_c );

154:
155:
156: arp_standard.debug( ' Executing select_sql1' );
157: BEGIN
158: l_ignore := dbms_sql.execute( select_sql1_c );
159:
160: EXCEPTION
161: WHEN OTHERS THEN
162: arp_standard.debug( 'EXCEPTION: Error executing select_sql1' );

Line 174: if (dbms_sql.fetch_rows( select_sql1_c ) > 0)

170: arp_standard.debug( ' Fetching select_sql1 stmt');
171:
172: begin
173: loop
174: if (dbms_sql.fetch_rows( select_sql1_c ) > 0)
175: then
176:
177: arp_standard.debug(' fetched a row' );
178: select_rec1 := null_rec;

Line 182: dbms_sql.column_value( select_sql1_c, 1, select_rec1.language );

178: select_rec1 := null_rec;
179: ------------------------------------------------------
180: -- Get column values
181: ------------------------------------------------------
182: dbms_sql.column_value( select_sql1_c, 1, select_rec1.language );
183: arp_standard.debug( 'Language code: ' || select_rec1.language );
184:
185: if (lang_str is null) then
186: lang_str := select_rec1.language;