APPS.BIS_COLLECTION_UTILITIES SQL Statements

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

Line: 4

PROCEDURE UPDATE_DATE IS
l_count number;

Line: 8

	SELECT count(1) INTO l_count from BIS_SYSTEM_DATE;

Line: 10

	IF (l_count = 0) THEN /* INSERT DATE */

		INSERT INTO BIS_SYSTEM_DATE(current_date_id)
		values (trunc(sysdate));

Line: 15

	ELSIF (l_count = 1) THEN /* Exists, update if needed */

		UPDATE  BIS_SYSTEM_DATE
		set current_date_id = trunc(sysdate)
		WHERE trunc(sysdate) <> trunc(current_date_id);

Line: 49

	SELECT value into l_dir
	FROM v$parameter where upper(name) = 'UTL_FILE_DIR';

Line: 137

    /* Update the System Date table if necessary */

    UPDATE_DATE ;

Line: 186

insert into bis_refresh_log(
Request_id,
Concurrent_id,
Object_name,
Status,
Start_date,
Period_from,
Period_to,
Number_processed_record,
Exception_message,
Creation_date,
Created_by,
Last_update_date,
Last_update_login,
Last_updated_by,
Attribute1, Attribute2, Attribute3, Attribute4,
Attribute5, Attribute6, Attribute7, Attribute8,
Attribute9, Attribute10 )
values
(g_request_id,
g_concurrent_id,
g_object_name,
l_status,
g_start_date,
p_period_from,
p_period_to,
p_count,
p_message,
sysdate,
g_user_id,
sysdate,
g_login_id,
g_user_id,
p_attribute1, p_attribute2, p_attribute3, p_attribute4,
p_attribute5, p_attribute6, p_attribute7, p_attribute8,
p_attribute9, p_attribute10 );

Line: 233

  select 'Y'
  into l_exist_flag
  from fnd_concurrent_programs
  where concurrent_program_name=p_program_short_name
  and application_id=p_program_application_id;

Line: 343

    SELECT MAX(period_to) INTO l_date
    FROM bis_refresh_log
    WHERE   object_name = p_object_name AND
	    status='SUCCESS' AND
	    last_update_date =
		(SELECT MAX(last_update_date)
		 FROM bis_refresh_log
		 WHERE object_name= p_object_name AND
		       status='SUCCESS' ) ;

Line: 374

    select start_date, last_update_date, period_from, period_to
	from bis_refresh_log
	where object_name = p_obj_name and status='SUCCESS'
	and last_update_date =( select max(last_update_date)
     	from bis_refresh_log
          where object_name= p_obj_name and  status='SUCCESS' ) ;

Line: 410

 select attribute1, attribute2,  attribute3, attribute4, attribute5,
   attribute6,attribute7, attribute8, attribute9, attribute10,
   attribute1||attribute2||attribute3||attribute4||attribute5||
   attribute6||attribute7||attribute8||attribute9||attribute10
 into p_attribute_table(1), p_attribute_table(2), p_attribute_table(3),
	p_attribute_table(4), p_attribute_table(5), p_attribute_table(6),
	p_attribute_table(7), p_attribute_table(8), p_attribute_table(9),
	p_attribute_table(10), l_allattribute
 from bis_refresh_log
	where object_name = p_object_name and status='SUCCESS'
	and last_update_date =( select max(last_update_date)
     	from bis_refresh_log
          where object_name= p_object_name and  status='SUCCESS' ) ;

Line: 431

	    p_attribute_table.delete;

Line: 434

	    p_attribute_table.delete;

Line: 648

SELECT user_conversion_type
FROM gl_daily_conversion_types
WHERE conversion_type = p_rate_type;

Line: 856

Procedure deleteLogForObject(p_object_name varchar2) IS

BEGIN
	EXECUTE IMMEDIATE 'delete from bis_refresh_log where upper(object_name)=upper(:1) and error_type is null' using p_object_name;

Line: 871

	OPEN cv for  'SELECT ORACLE_USERNAME from fnd_oracle_userid where oracle_id=900';

Line: 1076

    SELECT MAX(period_to) INTO l_date
    FROM bis_refresh_log
    WHERE  object_name = p_object_name AND
           status='FAILURE' AND
           last_update_date = (
             SELECT MAX(last_update_date)
             FROM bis_refresh_log
             WHERE object_name= p_object_name AND
                   status='FAILURE' ) ;

Line: 1115

    SELECT period_to, period_from INTO l_date_to,l_date_from
    FROM bis_refresh_log
    WHERE  object_name = p_object_name AND
           status='FAILURE' AND
           last_update_date = (
             SELECT MAX(last_update_date)
             FROM bis_refresh_log
             WHERE object_name= p_object_name AND
                   status='FAILURE' )AND
		rownum = 1
    ORDER BY period_to desc ;