DBA Data[Home] [Help]

APPS.FLM_FLMRFLIN_XMLP_PKG SQL Statements

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

Line: 24

select o.organization_name
into   P_ORGANIZATION
from   org_organization_definitions o
where  o.organization_id = P_ORG_ID;
Line: 35

select mrp_form_query_s.nextval
into P_QUERY_ID
from dual;
Line: 40

select to_number(to_char(to_date('25-10-99','DD-MM-RR'),'D'))
into l_org_offset
from dual;
Line: 44

select to_number(to_char(P_DATE_FROM,'D'))
into l_date_offset
from dual;
Line: 65

  MODE="SELECT"
  DISPLAY="ALL"
');
Line: 75

  MODE="SELECT"
  DISPLAY="ALL"
');*/
Line: 84

    DELETE FROM MRP_FORM_QUERY
     WHERE QUERY_ID = P_QUERY_ID;