APPS.ECX_UTIL_API SQL Statements

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

Line: 42

l_Select	VARCHAR2(500);

Line: 53

	   l_Select := 'SELECT 	1 ' ||
		       ' FROM 	ecx_lookup_values' ||
		       ' WHERE 	lookup_type = ' || '''' || 'PARTY_TYPE' || '''' ||
		       ' AND 	lookup_code = :party_type ' ||
		       ' AND 	enabled_flag = ' || '''' || 'Y' || '''' ||
		       ' AND 	to_date(sysdate, ' || '''' || 'DD-MON-RRRR' || '''' || ') between' ||
		       '	to_date(nvl(start_date_active, sysdate), ' || '''' || 'DD-MON-RRRR' || '''' || ') ' ||
		       ' AND    to_date(nvl(end_date_active, sysdate), ' || '''' || 'DD-MON-RRRR' || '''' || ')';

Line: 62

	   l_Select := 'SELECT 1 ' ||
		       ' FROM	wf_lookups' ||
		       ' WHERE	lookup_type = ' || '''' || 'PARTY_TYPE' || '''' ||
		       ' AND    lookup_code = :party_type ';

Line: 69

	DBMS_SQL.PARSE(l_CursorID, l_Select, DBMS_SQL.V7);

Line: 101

l_Select	VARCHAR2(500);

Line: 110

	   l_Select := 'SELECT 1 FROM hz_parties hz ' ||
		       'WHERE  hz.party_id  = :party_id ' ||
		       'AND    hz.party_type = ' || '''' || 'ORGANIZATION' || '''' ||
		       ' AND    hz.status = ' || '''' || 'A' || '''' ||
		       ' AND EXISTS ( SELECT  hzc.party_id FROM hz_cust_accounts hzc' ||
		       '	     WHERE   hzc.party_id = hz.party_id)' ;

Line: 117

	   l_Select := 'SELECT 1 FROM hz_parties hz' ||
		       ' WHERE  hz.party_id = :party_id' ;

Line: 120

	   l_Select := 'SELECT 1 FROM po_vendors' ||
			' WHERE   vendor_id = :party_id' ;

Line: 123

	   l_Select := 'SELECT 1 FROM ce_bank_branches_v' ||
		       ' WHERE  branch_party_id = :party_id' ;

Line: 126

	   l_Select := 'SELECT 1 FROM hr_locations' ||
		       ' WHERE  location_id = :party_id' ;

Line: 133

           l_Select := ' SELECT 1 FROM hz_parties hp,' ||
                       '               hz_code_assignments hca' ||
                       ' WHERE  hp.status = ' || '''' || 'A' || '''' ||
                       ' AND    hp.party_id = hca.owner_table_id' ||
                       ' AND    hca.owner_table_name = ' || '''' ||
                                     'HZ_PARTIES' || '''' ||
                       ' AND    hca.class_category = ' || '''' ||
                                     'TRANSPORTATION_PROVIDERS' || '''' ||
                       ' AND    hca.class_code = ' || '''' ||
                                     'CARRIER' || '''' ||
                       ' AND    nvl(hca.start_date_active, ' ||
                                'sysdate) <= sysdate' ||
                       ' AND    nvl(hca.end_date_active, sysdate) >= sysdate' ||
                       ' AND    hp.party_id = :party_id';

Line: 151

	   DBMS_SQL.PARSE(l_CursorID, l_Select, DBMS_SQL.V7);

Line: 180

l_Select	VARCHAR2(500);

Line: 189

	   l_Select := 'SELECT  1' ||
		       ' FROM   hz_party_sites hps,' ||
		       '	hz_locations hzl' ||
		       ' WHERE  hps.party_id  = :party_id' ||
		       ' AND    hps.party_site_id = :party_site_id' ||
		       ' AND    hzl.location_id = hps.location_id';

Line: 196

           l_Select := 'SELECT 1 FROM ce_bank_branches_v' ||
                       ' WHERE  branch_party_id = :party_site_id' ;

Line: 199

	   l_Select := 'SELECT  1' ||
		       ' FROM 	po_vendor_sites' ||
		       ' WHERE  vendor_id = :party_id' ||
		       ' AND    vendor_site_id = :party_site_id';

Line: 204

	   l_Select := 'SELECT  1' ||
		       ' FROM   hr_locations' ||
		       ' WHERE  location_id = :party_id' ;

Line: 212

	   l_Select := 'SELECT  1' ||
		       ' FROM   hz_party_sites hps,' ||
		       '	hz_locations hzl' ||
		       ' WHERE  hps.party_id  = :party_id' ||
		       ' AND    hps.party_site_id = :party_site_id' ||
		       ' AND    hzl.location_id = hps.location_id';

Line: 222

	   DBMS_SQL.PARSE(l_CursorID, l_Select, DBMS_SQL.V7);

Line: 302

       select ascii(l_char) into l_ascPasswd from dual;

Line: 326

l_Select	VARCHAR2(500);

Line: 337

	   l_Select := 'SELECT 	1 ' ||
		       ' FROM 	ecx_lookup_values' ||
		       ' WHERE 	lookup_type = ' || '''' || 'CONFIRMATION_CODE' || '''' ||
		       ' AND 	lookup_code = :confirmation ' ||
		       ' AND 	enabled_flag = ' || '''' || 'Y' || '''' ||
		       ' AND 	to_date(sysdate, ' || '''' || 'DD-MON-RRRR' || '''' || ') between' ||
		       '	to_date(nvl(start_date_active, sysdate), ' || '''' || 'DD-MON-RRRR' || '''' || ') ' ||
		       ' AND    to_date(nvl(end_date_active, sysdate), ' || '''' || 'DD-MON-RRRR' || '''' || ')';

Line: 346

	   l_Select := 'SELECT 1 ' ||
		       ' FROM	wf_lookups' ||
		       ' WHERE	lookup_type = ' || '''' || 'CONFIRMATION_CODE' || '''' ||
		       ' AND    lookup_code = :confirmation ';

Line: 353

	DBMS_SQL.PARSE(l_CursorID, l_Select, DBMS_SQL.V7);

Line: 376

l_Select	VARCHAR2(500);

Line: 387

	   l_Select := 'SELECT 	1 ' ||
		       ' FROM 	ecx_lookup_values' ||
		       ' WHERE 	lookup_type = ' || '''' || 'COMM_METHOD' || '''' ||
		       ' AND 	lookup_code = :protocol_type ' ||
		       ' AND 	enabled_flag = ' || '''' || 'Y' || '''' ||
		       ' AND 	to_date(sysdate, ' || '''' || 'DD-MON-RRRR' || '''' || ') between' ||
		       '	to_date(nvl(start_date_active, sysdate), ' || '''' || 'DD-MON-RRRR' || '''' || ') ' ||
		       ' AND    to_date(nvl(end_date_active, sysdate), ' || '''' || 'DD-MON-RRRR' || '''' || ')';

Line: 396

	   l_Select := 'SELECT 1 ' ||
		       ' FROM	wf_lookups' ||
		       ' WHERE	lookup_type = ' || '''' || 'COMM_METHOD' || '''' ||
		       ' AND    lookup_code = :protocol_type ';

Line: 403

	DBMS_SQL.PARSE(l_CursorID, l_Select, DBMS_SQL.V7);

Line: 426

select 	count(*)
from 	wf_agents
where  	queue_name = p_queue_name;

Line: 457

   select count(*) from ecx_tp_headers
   where tp_header_id = p_tp_header_id;

Line: 597

   l_select          VARCHAR2(400);

Line: 603

   l_select := 'select customer_id' ||
               ' from fnd_user where user_name = :user_name' ||
               ' AND description = :description';

Line: 609

      dbms_sql.parse(l_cursor, l_select, dbms_sql.native);

Line: 698

              select v$nls_parameters.value into l_DBcharset
              from v$nls_parameters
              where v$nls_parameters.parameter='NLS_CHARACTERSET';