[Home] [Help]
PACKAGE: APPS.INV_RCV_DIR_RCPT_APIS
Source
1 PACKAGE inv_rcv_dir_rcpt_apis AUTHID CURRENT_USER AS
2 /* $Header: INVDIRDS.pls 120.0.12000000.1 2007/01/17 16:13:41 appldev ship $*/
3
4 /*******************************************************
5 * Name: create_direct_rti_rec
6 *
7 * Description:
8 *
9 * This API create record in RCV_TRANSACTIONS_INTERFACE for
10 * direct delivery transaction.
11 *
12 * This API takes PO_header_id, item_id, received_qty, received_UOM,
13 * received_location, deliver to subinventory and deliver to locator
14 * as input. It calls the matching algorithm API
15 * to detail the receipt to PO_line_locations.
16 *
17 * Then it calls insert API, insert_txn_interface, to inserts PO line
18 * location record into RCV_TRANSACTION_INTERFACE
19 *
20 * Flow:
21 *
22 * 1. query po_startup_value and other initial values
23 * 2. query a join of RCV_ENTER_RECEIPTS_V and PO_DISTRIBUTIONS table
24 * to populate DB items in rcv_transaction block
25 * before calling matching algorithm
26 * 3. call matching algorithm to detail the receipt
27 * 4. call insert API
28 *
29 * Parameters:
30 *
31 * p_organization_id
32 * p_po_header_id
33 * p_item_id
34 * p_location_id
35 * p_rcv_qty
36 * p_rcv_uom
37 * p_source_type
38 * p_subinventory
39 * p_locator_id
40 *
41 *******************************************************/
42 --Bug #4147209 - Added the DFF attribute category and the attributes
43 --as input parameters
44 PROCEDURE create_direct_rti_rec(p_move_order_header_id IN OUT NOCOPY NUMBER,
45 p_organization_id IN NUMBER,
46 p_po_header_id IN NUMBER,
47 p_po_release_id IN NUMBER,
48 p_po_line_id IN NUMBER,
49 p_shipment_header_id IN NUMBER,
50 p_oe_order_header_id IN NUMBER,
51 p_item_id IN NUMBER,
52 p_rcv_qty IN NUMBER,
53 p_rcv_uom IN VARCHAR2,
54 p_rcv_uom_code IN VARCHAR2,
55 p_source_type IN VARCHAR2,
56 p_subinventory IN VARCHAR2,
57 p_locator_id IN NUMBER,
58 p_transaction_temp_id IN NUMBER,
59 p_lot_control_code IN NUMBER,
60 p_serial_control_code IN NUMBER,
61 p_lpn_id IN NUMBER,
62 p_revision IN VARCHAR2,
63 x_status OUT NOCOPY VARCHAR2,
64 x_message OUT NOCOPY VARCHAR2,
65 p_inv_item_id IN NUMBER DEFAULT NULL,
66 p_item_desc IN VARCHAR2 DEFAULT NULL,
67 p_location_id IN NUMBER DEFAULT NULL,
68 p_is_expense IN VARCHAR2 DEFAULT NULL,
69 p_project_id IN NUMBER DEFAULT NULL,
70 p_task_id IN NUMBER DEFAULT NULL,
71 p_country_code IN VARCHAR2 DEFAULT NULL,
72 p_from_lpn_id IN NUMBER DEFAULT NULL,
73 p_secondary_rcv_qty IN NUMBER DEFAULT NULL,
74 p_rcv_sec_uom IN VARCHAR2 DEFAULT NULL,--OPM Convergence
75 p_rcv_sec_uom_code IN VARCHAR2 DEFAULT NULL --OPM Convergence
76 , p_attribute_category IN VARCHAR2 DEFAULT NULL
77 , p_attribute1 IN VARCHAR2 DEFAULT NULL
78 , p_attribute2 IN VARCHAR2 DEFAULT NULL
79 , p_attribute3 IN VARCHAR2 DEFAULT NULL
80 , p_attribute4 IN VARCHAR2 DEFAULT NULL
81 , p_attribute5 IN VARCHAR2 DEFAULT NULL
82 , p_attribute6 IN VARCHAR2 DEFAULT NULL
83 , p_attribute7 IN VARCHAR2 DEFAULT NULL
84 , p_attribute8 IN VARCHAR2 DEFAULT NULL
85 , p_attribute9 IN VARCHAR2 DEFAULT NULL
86 , p_attribute10 IN VARCHAR2 DEFAULT NULL
87 , p_attribute11 IN VARCHAR2 DEFAULT NULL
88 , p_attribute12 IN VARCHAR2 DEFAULT NULL
89 , p_attribute13 IN VARCHAR2 DEFAULT NULL
90 , p_attribute14 IN VARCHAR2 DEFAULT NULL
91 , p_attribute15 IN VARCHAR2 DEFAULT NULL);
92
93
94 --PROCEDURE pack_lpn_txn;
95
96 -- MANEESH - BEGIN CHANGES - FOR OUTSIDE PROCESSING ITEM
97
98 --Bug #4147209 - Added the DFF attribute category and the attributes
99 --as input parameters
100 PROCEDURE create_osp_direct_rti_rec(p_move_order_header_id IN OUT NOCOPY NUMBER,
101 p_organization_id IN NUMBER,
102 p_po_header_id IN NUMBER,
103 p_po_release_id IN NUMBER,
104 p_po_line_id IN NUMBER,
105 p_item_id IN NUMBER,
106 p_rcv_qty IN NUMBER,
107 p_rcv_uom IN VARCHAR2,
108 p_rcv_uom_code IN VARCHAR2,
109 p_source_type IN VARCHAR2,
110 p_transaction_temp_id IN NUMBER,
111 p_revision IN VARCHAR2,
112 p_po_distribution_id IN NUMBER,
113 x_status OUT NOCOPY VARCHAR2,
114 x_message OUT NOCOPY VARCHAR2,
115 p_attribute_category IN VARCHAR2 DEFAULT NULL
116 , p_attribute1 IN VARCHAR2 DEFAULT NULL
117 , p_attribute2 IN VARCHAR2 DEFAULT NULL
118 , p_attribute3 IN VARCHAR2 DEFAULT NULL
119 , p_attribute4 IN VARCHAR2 DEFAULT NULL
120 , p_attribute5 IN VARCHAR2 DEFAULT NULL
121 , p_attribute6 IN VARCHAR2 DEFAULT NULL
122 , p_attribute7 IN VARCHAR2 DEFAULT NULL
123 , p_attribute8 IN VARCHAR2 DEFAULT NULL
124 , p_attribute9 IN VARCHAR2 DEFAULT NULL
125 , p_attribute10 IN VARCHAR2 DEFAULT NULL
126 , p_attribute11 IN VARCHAR2 DEFAULT NULL
127 , p_attribute12 IN VARCHAR2 DEFAULT NULL
128 , p_attribute13 IN VARCHAR2 DEFAULT NULL
129 , p_attribute14 IN VARCHAR2 DEFAULT NULL
130 , p_attribute15 IN VARCHAR2 DEFAULT NULL );
131
132 -- MANEESH - END CHANGES - FOR OUTSIDE PROCESSING ITEM
133
134 END inv_rcv_dir_rcpt_apis;