APPS.GML_RCV_STD_RCPT_APIS SQL Statements

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

Line: 31

  FUNCTION insert_txn_interface(
    p_rcv_transaction_rec  IN OUT NOCOPY  rcv_transaction_rec_tp
  , p_rcv_rcpt_rec         IN OUT NOCOPY  rcv_enter_receipts_rec_tp
  , p_group_id             IN             NUMBER
  , p_transaction_type     IN             VARCHAR2
  , p_organization_id      IN             NUMBER
  , p_location_id          IN             NUMBER
  , p_source_type          IN             VARCHAR2
  , p_qa_routing_id        IN             NUMBER DEFAULT -1
  , p_project_id           IN             NUMBER DEFAULT NULL
  , p_task_id              IN             NUMBER DEFAULT NULL

  )
    RETURN NUMBER IS
  BEGIN

   NULL;

Line: 51

  END insert_txn_interface;

Line: 358

	 SELECT MAX(rti.interface_transaction_id)
	   FROM rcv_transactions_interface rti
	  WHERE rti.group_id = INV_rcv_common_apis.g_rcv_global_var.interface_group_id
	  GROUP BY decode(p_source_type,'ASNEXP',rti.interface_transaction_id,'SHIPMENTEXP',rti.interface_transaction_id,null) ;

Line: 434

  PROCEDURE rcv_update_rti_from_header(
    p_shipment_num                      VARCHAR
  , p_freight_carrier_code              VARCHAR2
  , p_bill_of_lading                    VARCHAR2
  , p_packing_slip                      VARCHAR2
  , p_num_of_containers                 NUMBER
  , p_waybill_airbill_num               VARCHAR2
  , x_return_status         OUT NOCOPY  VARCHAR2
  , x_msg_count             OUT NOCOPY  NUMBER
  , x_msg_data              OUT NOCOPY  VARCHAR2
  ) IS
    l_return_status  VARCHAR2(1)    := fnd_api.g_ret_sts_success;

Line: 453

  END rcv_update_rti_from_header;

Line: 456

  PROCEDURE rcv_update_header_interface(
    p_organization_id                     NUMBER
  , p_header_intf_id                      NUMBER
  , p_source_type                         VARCHAR2
  , p_receipt_num                         VARCHAR2
  , p_vendor_id                           NUMBER
  , p_vendor_site_id                      NUMBER
  , p_shipment_num                        VARCHAR2
  , p_ship_to_location_id                 NUMBER
  , p_bill_of_lading                      VARCHAR2
  , p_packing_slip                        VARCHAR2
  , p_shipped_date                        DATE
  , p_freight_carrier_code                VARCHAR2
  , p_expected_receipt_date               DATE
  , p_num_of_containers                   NUMBER
  , p_waybill_airbill_num                 VARCHAR2
  , p_comments                            VARCHAR2
  , p_ussgl_transaction_code              VARCHAR2
  , p_program_request_id                  NUMBER
  , p_customer_id                         NUMBER
  , p_customer_site_id                    NUMBER
  , x_return_status           OUT NOCOPY  VARCHAR2
  , x_msg_count               OUT NOCOPY  NUMBER
  , x_msg_data                OUT NOCOPY  VARCHAR2
  ) IS

    l_sysdate       DATE                           := SYSDATE;

Line: 495

  END rcv_update_header_interface;

Line: 497

  PROCEDURE rcv_insert_header_interface(
    p_organization_id                     NUMBER
  , p_source_type                         VARCHAR2
  , p_receipt_num             OUT NOCOPY  VARCHAR2
  , p_vendor_id                           NUMBER
  , p_vendor_site_id                      NUMBER
  , p_shipment_num                        VARCHAR2
  , p_ship_to_location_id                 NUMBER
  , p_bill_of_lading                      VARCHAR2
  , p_packing_slip                        VARCHAR2
  , p_shipped_date                        DATE
  , p_freight_carrier_code                VARCHAR2
  , p_expected_receipt_date               DATE
  , p_num_of_containers                   NUMBER
  , p_waybill_airbill_num                 VARCHAR2
  , p_comments                            VARCHAR2
  , p_ussgl_transaction_code              VARCHAR2
  , p_government_context                  VARCHAR2
  , p_request_id                          NUMBER
  , p_program_application_id              NUMBER
  , p_program_id                          NUMBER
  , p_program_update_date                 DATE
  , p_customer_id                         NUMBER
  , p_customer_site_id                    NUMBER
  , x_return_status           OUT NOCOPY  VARCHAR2
  , x_msg_count               OUT NOCOPY  NUMBER
  , x_msg_data                OUT NOCOPY  VARCHAR2
  ) IS
    l_header        rcv_headers_interface%ROWTYPE;

Line: 540

  END rcv_insert_header_interface;

Line: 542

PROCEDURE rcv_insert_update_header
  (p_organization_id        IN     NUMBER,
   p_shipment_header_id     IN OUT NOCOPY NUMBER,
   p_source_type            IN     VARCHAR2,
   p_receipt_num            IN OUT NOCOPY VARCHAR2,
   p_vendor_id              IN     NUMBER,
   p_vendor_site_id         IN     NUMBER,
   p_shipment_num           IN     VARCHAR2,
   p_ship_to_location_id    IN     NUMBER,
   p_bill_of_lading         IN     VARCHAR2,
   p_packing_slip           IN     VARCHAR2,
   p_shipped_date           IN     DATE,
   p_freight_carrier_code   IN     VARCHAR2,
   p_expected_receipt_date  IN     DATE,
   p_num_of_containers      IN     NUMBER,
   p_waybill_airbill_num    IN     VARCHAR2,
   p_comments               IN     VARCHAR2,
   p_ussgl_transaction_code IN     VARCHAR2,
   p_government_context     IN     VARCHAR2,
   p_request_id             IN     NUMBER,
   p_program_application_id IN     NUMBER,
   p_program_id             IN     NUMBER,
   p_program_update_date    IN     DATE,
   p_customer_id            IN     NUMBER,
   p_customer_site_id       IN     NUMBER,
   x_return_status       OUT       NOCOPY VARCHAR2,
   x_msg_count           OUT       NOCOPY NUMBER,
   x_msg_data            OUT       NOCOPY VARCHAR2
  )
  IS
     l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

Line: 585

END rcv_insert_update_header;

Line: 795

PROCEDURE update_LPN_Org (
   p_organization_id IN NUMBER,
   p_lpn_id    IN NUMBER,
   x_return_status OUT NOCOPY VARCHAR2,
   x_msg_count OUT NOCOPY NUMBER,
   x_msg_data  OUT NOCOPY VARCHAR2
)
IS

BEGIN
 NULL;

Line: 809

END update_LPN_Org;