1 PACKAGE csd_mass_rcv_pvt AUTHID CURRENT_USER AS
2 /* $Header: csdvmsss.pls 120.1.12010000.3 2009/08/27 09:11:28 subhat ship $ */
3
4 TYPE instance_rec_type IS RECORD (
5 inventory_item_id NUMBER,
6 item_revision VARCHAR2(3), --swai: bug 7152053 (FP of 7134021)
7 instance_id NUMBER,
8 instance_number VARCHAR2 (30),
9 serial_number VARCHAR2 (30),
10 lot_number VARCHAR2 (80), -- fix for bug#4625226
11 quantity NUMBER,
12 uom VARCHAR2 (3),
13 party_site_use_id NUMBER,
14 party_id NUMBER,
15 account_id NUMBER,
16 mfg_serial_number_flag VARCHAR2 (1),-- This indicates if the serial number being created
17 -- is manufacted serial number. The value for this
18 -- should always be 'N' for a new instance.
19 external_reference VARCHAR2(30) -- subhat, external reference support.
20 );
21
22 -- This procedure will be called from the Serial number capture screen, when user
23 -- clicks the OK button
24 -- It is a wrapper API, which subsequntly calls other API
25 PROCEDURE mass_create_ro (
26 p_api_version IN NUMBER,
27 p_commit IN VARCHAR2,
28 p_init_msg_list IN VARCHAR2,
29 p_validation_level IN NUMBER,
30 x_return_status OUT NOCOPY VARCHAR2,
31 x_msg_count OUT NOCOPY NUMBER,
32 x_msg_data OUT NOCOPY VARCHAR2,
33 p_repair_order_line_id IN NUMBER,
34 p_add_to_order_flag IN VARCHAR2
35 );
36
37 -- This procedure will be called from mass_create_ro to create repair orders
38 PROCEDURE process_ro (
39 p_api_version IN NUMBER,
40 p_commit IN VARCHAR2,
41 p_init_msg_list IN VARCHAR2,
42 p_validation_level IN NUMBER,
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2,
46 p_repair_line_id IN NUMBER,
47 p_prod_txn_tbl IN OUT NOCOPY csd_process_pvt.product_txn_tbl,
48 p_add_to_order_flag IN VARCHAR2,
49 p_mass_ro_sn_id IN NUMBER,
50 p_serial_number IN VARCHAR2,
51 p_instance_id IN NUMBER,
52 x_new_repln_id OUT NOCOPY NUMBER
53 ) ;
54
55 -- This api would be called from the serial number capture screen. If user enters
56 -- serialized and ib
57 -- trackable item, and the serial number does not exist in IB, then message pops .
58 -- If users clicks OK
59 -- button then this API would be called to create a new instance.
60 PROCEDURE create_item_instance (
61 p_api_version IN NUMBER,
62 p_init_msg_list IN VARCHAR2,
63 p_commit IN VARCHAR2,
64 p_validation_level IN NUMBER,
65 x_return_status OUT NOCOPY VARCHAR2,
66 x_msg_count OUT NOCOPY NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2,
68 px_instance_rec IN OUT NOCOPY instance_rec_type,
69 x_instance_id OUT NOCOPY NUMBER
70 );
71
72
73 -- THis API will create the product transaction/charge line/submits and
74 -- books chargeline.
75 PROCEDURE create_product_txn (
76 p_api_version IN NUMBER,
77 p_commit IN VARCHAR2,
78 p_init_msg_list IN VARCHAR2,
79 p_validation_level IN NUMBER,
80 x_return_status OUT NOCOPY VARCHAR2,
81 x_msg_count OUT NOCOPY NUMBER,
82 x_msg_data OUT NOCOPY VARCHAR2,
83 p_product_txn_rec IN OUT NOCOPY csd_process_pvt.product_txn_rec,
84 p_add_to_order_flag IN VARCHAR2
85 );
86
87 --This api will identify if the item is ib trackable
88 FUNCTION is_item_ib_trackable (p_inv_item_id IN NUMBER)
89 RETURN BOOLEAN;
90 END csd_mass_rcv_pvt; -- Package spec