APPS.XDP_PROCEDURE_BUILDER SQL Statements

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

Line: 60

g_SelectStmt varchar2(20) := 'SELECT';

Line: 61

g_InsertStmt varchar2(20) := 'INSERT';

Line: 62

g_DeleteStmt varchar2(20) := 'DELETE';

Line: 63

g_UpdateStmt varchar2(20) := 'UPDATE';

Line: 70

select meaning
from fnd_lookups
where lookup_type = 'XDP_PROCEDURE_TYPE'
and lookup_code = code;

Line: 76

select meaning
from fnd_lookups
where lookup_type = 'XDP_OBJECTS'
and lookup_code = code;

Line: 82

select application_mode, display_name
from xdp_adapter_types_vl
where adapter_type = g_AdapterType;

Line: 227

    select proc_type
    from xdp_proc_body
    where proc_name = p_ProcName
      and proc_type <> p_ProcType;

Line: 919

 if instr(upper(p_ProcBody), 'SELECT ', 1, 1) > 0 then
	l_SQLStmt := g_SelectStmt;

Line: 922

 if instr(upper(p_ProcBody), 'INSERT ', 1, 1) > 0 then
	if l_SQLStmt is null then
		l_SQLStmt := g_InsertStmt;

Line: 926

		l_SQLStmt := l_SQLStmt || ',' || g_InsertStmt;

Line: 929

 if instr(upper(p_ProcBody), 'UPDATE ', 1, 1) > 0 then
	if l_SQLStmt is null then
		l_SQLStmt := g_UpdateStmt;

Line: 933

		l_SQLStmt := l_SQLStmt || ',' || g_UpdateStmt;

Line: 936

 if instr(upper(p_ProcBody), 'DELETE ', 1, 1) > 0 then
	if l_SQLStmt is null then
		l_SQLStmt := g_DeleteStmt;

Line: 940

		l_SQLStmt := l_SQLStmt || ',' || g_DeleteStmt;