APPS.RCV_SETUP_S2 SQL Statements

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

Line: 16

  SELECT ood.name
  INTO   x_org_name
  FROM   HR_ORGANIZATION_UNITS ood
  WHERE  ood.organization_id = p_org_id;

Line: 53

   SELECT BLIND_RECEIVING_FLAG , ALLOW_EXPRESS_DELIVERY_FLAG,
          ALLOW_CASCADE_TRANSACTIONS, ALLOW_UNORDERED_RECEIPTS_FLAG
   INTO   x_blind, x_express, x_cascade, x_unordered
   FROM   rcv_parameters
   WHERE  organization_id = x_org_id;

Line: 104

                             x_update_date          OUT NOCOPY DATE,
                             x_coa_id               OUT NOCOPY NUMBER,
                             x_org_locator_control  OUT NOCOPY NUMBER,
                             x_negative_inv_receipt_code OUT NOCOPY NUMBER,
                             x_gl_set_of_bks_id     OUT NOCOPY VARCHAR2,
                             x_blind_Receiving_flag OUT NOCOPY VARCHAR2,
			     x_allow_unordered      OUT NOCOPY VARCHAR2 ) is

/*
**  Procedure calls the above hidden procedures within RCV_SETUP_S to get
**  startup values.
*/

x_progress VARCHAR2(3) := '';

Line: 128

   select  organization_name
   into    x_org_name
   FROM   org_organization_definitions
   WHERE  organization_id = x_org_id ;

Line: 172

   po_core_s.get_global_values(x_user_id,x_logonid,x_update_date,x_creation_date);