1 PACKAGE gml_rcv_dir_rcpt_apis AUTHID CURRENT_USER AS
2 /* $Header: GMLDIRDS.pls 120.0 2005/05/25 16:45:31 appldev noship $*/
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 PROCEDURE create_direct_rti_rec(p_move_order_header_id IN OUT NOCOPY NUMBER,
43 p_organization_id IN NUMBER,
44 p_po_header_id IN NUMBER,
45 p_po_release_id IN NUMBER,
46 p_po_line_id IN NUMBER,
47 p_shipment_header_id IN NUMBER,
48 p_oe_order_header_id IN NUMBER,
49 p_item_id IN NUMBER,
50 p_rcv_qty IN NUMBER,
51 p_rcv_sec_qty IN NUMBER,
52 p_rcv_uom IN VARCHAR2,
53 p_rcv_uom_code IN VARCHAR2,
54 p_rcv_sec_uom IN VARCHAR2,
55 p_rcv_sec_uom_code IN VARCHAR2,
56 p_source_type IN VARCHAR2,
57 p_subinventory IN VARCHAR2,
58 p_locator_id IN NUMBER,
59 p_transaction_temp_id IN NUMBER,
60 p_lot_control_code IN NUMBER,
61 p_serial_control_code IN NUMBER,
62 p_lpn_id IN NUMBER,
63 p_revision IN VARCHAR2,
64 x_status OUT NOCOPY VARCHAR2,
65 x_message OUT NOCOPY VARCHAR2,
66 p_inv_item_id IN NUMBER DEFAULT NULL,
67 p_item_desc IN VARCHAR2 DEFAULT NULL,
68 p_location_id IN NUMBER DEFAULT NULL,
69 p_is_expense IN VARCHAR2 DEFAULT NULL,
70 p_project_id IN NUMBER DEFAULT NULL,
71 p_task_id IN NUMBER DEFAULT NULL,
72 p_country_code IN VARCHAR2 DEFAULT NULL);
73
74
75 --PROCEDURE pack_lpn_txn;
76
77 -- MANEESH - BEGIN CHANGES - FOR OUTSIDE PROCESSING ITEM
78
79 PROCEDURE create_osp_direct_rti_rec(p_move_order_header_id IN OUT NOCOPY NUMBER,
80 p_organization_id IN NUMBER,
81 p_po_header_id IN NUMBER,
82 p_po_release_id IN NUMBER,
83 p_po_line_id IN NUMBER,
84 p_item_id IN NUMBER,
85 p_rcv_qty IN NUMBER,
86 p_rcv_uom IN VARCHAR2,
87 p_rcv_uom_code IN VARCHAR2,
88 p_source_type IN VARCHAR2,
89 p_transaction_temp_id IN NUMBER,
90 p_revision IN VARCHAR2,
91 p_po_distribution_id IN NUMBER,
92 x_status OUT NOCOPY VARCHAR2,
93 x_message OUT NOCOPY VARCHAR2);
94
95 -- MANEESH - END CHANGES - FOR OUTSIDE PROCESSING ITEM
96
97 END gml_rcv_dir_rcpt_apis;