[Home] [Help]
PACKAGE: APPS.RCV_INSERT_RTI_SV
Source
1 PACKAGE RCV_INSERT_RTI_SV 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;