[Home] [Help]
PACKAGE BODY: APPS.RCV_INSERT_RTI_SV
Source
1 PACKAGE BODY RCV_INSERT_RTI_SV as
2 /* $Header: RCVRTIB.pls 120.2 2005/07/19 00:47:10 usethura noship $*/
3
4 /*========================= RCV_INSERT_RTI_SV =============================*/
5 /*===========================================================================
6
7 PROCEDURE NAME: insert_into_rti
8
9 ===========================================================================*/
10
11 PROCEDURE insert_into_rti(
12 X_group_id IN NUMBER,
13 X_transaction_type IN VARCHAR2,
14 X_transaction_date IN DATE,
15 X_processing_status_code IN VARCHAR2,
16 X_processing_mode_code IN VARCHAR2,
17 X_transaction_status_code IN VARCHAR2,
18 X_last_update_date IN DATE,
19 X_last_updated_by IN NUMBER,
20 X_last_update_login IN NUMBER,
21 X_interface_source_code IN VARCHAR2,
22 X_creation_date IN DATE,
23 X_created_by IN NUMBER,
24 X_auto_transact_code IN VARCHAR2,
25 X_receipt_source_code IN VARCHAR2,
26 X_po_header_id IN NUMBER,
27 X_po_release_id IN NUMBER,
28 X_po_line_id IN NUMBER,
29 X_shipment_line_id IN NUMBER,
30 X_shipment_header_id IN NUMBER,
31 X_po_line_location_id IN NUMBER,
32 X_deliver_to_location_id IN NUMBER,
33 X_to_organization_id IN NUMBER,
34 X_item_id IN NUMBER,
35 X_quantity_shipped IN NUMBER,
36 X_source_document_code IN VARCHAR2,
37 X_category_id IN NUMBER,
38 X_unit_of_measure IN VARCHAR2,
39 X_item_description IN VARCHAR2,
40 X_employee_id IN NUMBER,
41 X_destination_type_code IN VARCHAR2,
42 X_destination_context IN VARCHAR2,
43 X_subinventory IN VARCHAR2,
44 X_routing_header_id IN NUMBER,
45 X_primary_unit_of_measure IN VARCHAR2,
46 X_ship_to_location_id IN NUMBER,
47 X_vendor_id IN NUMBER,
48 p_operating_unit_id IN MO_GLOB_ORG_ACCESS_TMP.ORGANIZATION_ID%TYPE DEFAULT NULL-- New Parameter <R12 MOAC>
49
50 ) IS
51
52 X_primary_quantity NUMBER;
53
54 BEGIN
55
56 PO_UOM_S.uom_convert(X_quantity_shipped, X_unit_of_measure, X_item_id,
57 X_primary_unit_of_measure, X_primary_quantity);
58
59
60 INSERT INTO RCV_TRANSACTIONS_INTERFACE (
61 INTERFACE_TRANSACTION_ID ,
62 GROUP_ID ,
63 LAST_UPDATE_DATE ,
64 LAST_UPDATED_BY ,
65 LAST_UPDATE_LOGIN ,
66 CREATION_DATE ,
67 CREATED_BY ,
68 TRANSACTION_TYPE ,
69 TRANSACTION_DATE ,
70 PROCESSING_STATUS_CODE ,
71 PROCESSING_MODE_CODE ,
72 TRANSACTION_STATUS_CODE ,
73 CATEGORY_ID ,
74 QUANTITY ,
75 UNIT_OF_MEASURE ,
76 INTERFACE_SOURCE_CODE ,
77 ITEM_ID ,
78 ITEM_DESCRIPTION ,
79 EMPLOYEE_ID ,
80 AUTO_TRANSACT_CODE ,
81 SHIP_TO_LOCATION_ID ,
82 PRIMARY_QUANTITY ,
83 PRIMARY_UNIT_OF_MEASURE ,
84 RECEIPT_SOURCE_CODE ,
85 VENDOR_ID ,
86 TO_ORGANIZATION_ID ,
87 ROUTING_HEADER_ID ,
88 SOURCE_DOCUMENT_CODE ,
89 PO_HEADER_ID ,
90 PO_LINE_ID ,
91 PO_LINE_LOCATION_ID ,
92 DESTINATION_TYPE_CODE ,
93 LOCATION_ID ,
94 SUBINVENTORY ,
95 DESTINATION_CONTEXT ,
96 SHIPMENT_HEADER_ID ,
97 SHIPMENT_LINE_ID ,
98 ORG_ID) --<R12 MOAC>
99 VALUES (
100 RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL,
101 X_group_id,
102 X_last_update_date,
103 X_last_updated_by,
104 X_last_update_login,
105 X_creation_date,
106 X_created_by,
107 X_transaction_type,
108 X_transaction_date,
109 X_processing_status_code,
110 X_processing_mode_code,
111 X_transaction_status_code,
112 X_category_id,
113 X_quantity_shipped,
114 X_unit_of_measure,
115 X_interface_source_code,
116 X_item_id,
117 X_item_description,
118 X_employee_id,
119 X_auto_transact_code,
120 X_ship_to_location_id,
121 X_primary_quantity,
122 X_primary_unit_of_measure,
123 X_receipt_source_code,
124 X_vendor_id,
125 X_to_organization_id,
126 X_routing_header_id,
127 X_source_document_code,
128 X_po_header_id,
129 X_po_line_id,
130 X_po_line_location_id,
131 X_destination_type_code,
132 X_deliver_to_location_id,
133 X_subinventory,
134 X_destination_context,
135 X_shipment_header_id,
136 X_shipment_line_id,
137 p_operating_unit_id --<R12 MOAC>
138 );
139
140 END insert_into_rti;
141
142 END RCV_INSERT_RTI_SV;