DBA Data[Home] [Help]

PACKAGE: APPS.RCV_INSERT_RTI_SV

Source


1 PACKAGE  RCV_INSERT_RTI_SV AUTHID CURRENT_USER as
2 /* $Header: RCVRTIS.pls 120.2 2005/07/19 00:46:30 usethura noship $*/
3 
4 /*===========================================================================
5   PACKAGE NAME:		RCV_INSERT_RTI_SV
6 
7   DESCRIPTION:		This package contains the server side maintain
8                         shipments part to handle  ASN's
9 
10   CLIENT/SERVER:	Server
11 
12   OWNER:		Harsha Vadlamudi
13 
14   PROCEDURE NAMES:	insert_into_rti
15 
16 ===========================================================================*/
17 
18 /*===========================================================================
19   PROCEDURE NAME	insert_into_rti
20 
21   DESCRIPTION:		Insert into the rcv_transactions_interface table.
22 
23 
24   PARAMETERS:
25 
26 
27   DESIGN REFERENCES:
28 
29   ALGORITHM:
30 
31   NOTES:
32 
33   OPEN ISSUES:
34 
35   CLOSED ISSUES:
36 
37   CHANGE HISTORY:	HVADLAMU 06/03/97 CREATED
38 ===========================================================================*/
39 
40 PROCEDURE insert_into_rti (
41 X_group_id		 IN  NUMBER,
42 X_transaction_type	 IN  VARCHAR2,
43 X_transaction_date	 IN  DATE,
44 X_processing_status_code IN  VARCHAR2,
45 X_processing_mode_code	 IN  VARCHAR2,
46 X_transaction_status_code IN VARCHAR2,
47 X_last_update_date	 IN  DATE,
48 X_last_updated_by	 IN  NUMBER,
49 X_last_update_login	 IN  NUMBER,
50 X_interface_source_code  IN  VARCHAR2,
51 X_creation_date		 IN  DATE,
52 X_created_by		 IN  NUMBER,
53 X_auto_transact_code	 IN  VARCHAR2,
54 X_receipt_source_code	 IN  VARCHAR2,
55 X_po_header_id           IN  NUMBER,
56 X_po_release_id          IN  NUMBER,
57 X_po_line_id             IN  NUMBER,
58 X_shipment_line_id       IN  NUMBER,
59 X_shipment_header_id     IN  NUMBER,
60 X_po_line_location_id    IN  NUMBER,
61 X_deliver_to_location_id IN  NUMBER,
62 X_to_organization_id     IN  NUMBER,
63 X_item_id                IN  NUMBER,
64 X_quantity_shipped       IN  NUMBER,
65 X_source_document_code   IN  VARCHAR2,
66 X_category_id            IN  NUMBER,
67 X_unit_of_measure        IN  VARCHAR2,
68 X_item_description       IN  VARCHAR2,
69 X_employee_id            IN  NUMBER,
70 X_destination_type_code  IN  VARCHAR2,
71 X_destination_context    IN  VARCHAR2,
72 X_subinventory           IN  VARCHAR2,
73 X_routing_header_id      IN  NUMBER,
74 X_primary_unit_of_measure IN  VARCHAR2,
75 X_ship_to_location_id    IN  NUMBER,
76 X_vendor_id              IN  NUMBER,
77 p_operating_unit_id      IN  MO_GLOB_ORG_ACCESS_TMP.ORGANIZATION_ID%TYPE DEFAULT NULL-- New Parameter <R12 MOAC>
78 
79 );
80 
81 
82 END RCV_INSERT_RTI_SV;