1 PACKAGE csd_mass_rcv_pvt AS
2 /* $Header: csdvmsss.pls 120.1.12010000.2 2008/09/16 20:31:31 swai 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 );
20
21 -- This procedure will be called from the Serial number capture screen, when user
22 -- clicks the OK button
23 -- It is a wrapper API, which subsequntly calls other API
24 PROCEDURE mass_create_ro (
25 p_api_version IN NUMBER,
26 p_commit IN VARCHAR2,
27 p_init_msg_list IN VARCHAR2,
28 p_validation_level IN NUMBER,
29 x_return_status OUT NOCOPY VARCHAR2,
30 x_msg_count OUT NOCOPY NUMBER,
31 x_msg_data OUT NOCOPY VARCHAR2,
32 p_repair_order_line_id IN NUMBER,
33 p_add_to_order_flag IN VARCHAR2
34 );
35
36 -- This procedure will be called from mass_create_ro to create repair orders
37 PROCEDURE process_ro (
38 p_api_version IN NUMBER,
39 p_commit IN VARCHAR2,
40 p_init_msg_list IN VARCHAR2,
41 p_validation_level IN NUMBER,
42 x_return_status OUT NOCOPY VARCHAR2,
43 x_msg_count OUT NOCOPY NUMBER,
44 x_msg_data OUT NOCOPY VARCHAR2,
45 p_repair_line_id IN NUMBER,
46 p_prod_txn_tbl IN OUT NOCOPY csd_process_pvt.product_txn_tbl,
47 p_add_to_order_flag IN VARCHAR2,
48 p_mass_ro_sn_id IN NUMBER,
49 p_serial_number IN VARCHAR2,
50 p_instance_id IN NUMBER,
51 x_new_repln_id OUT NOCOPY NUMBER
52 ) ;
53
54 -- This api would be called from the serial number capture screen. If user enters
55 -- serialized and ib
56 -- trackable item, and the serial number does not exist in IB, then message pops .
57 -- If users clicks OK
58 -- button then this API would be called to create a new instance.
59 PROCEDURE create_item_instance (
60 p_api_version IN NUMBER,
61 p_init_msg_list IN VARCHAR2,
62 p_commit IN VARCHAR2,
63 p_validation_level IN NUMBER,
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_msg_data OUT NOCOPY VARCHAR2,
67 px_instance_rec IN OUT NOCOPY instance_rec_type,
68 x_instance_id OUT NOCOPY NUMBER
69 );
70
71
72 -- THis API will create the product transaction/charge line/submits and
73 -- books chargeline.
74 PROCEDURE create_product_txn (
75 p_api_version IN NUMBER,
76 p_commit IN VARCHAR2,
77 p_init_msg_list IN VARCHAR2,
78 p_validation_level IN NUMBER,
79 x_return_status OUT NOCOPY VARCHAR2,
80 x_msg_count OUT NOCOPY NUMBER,
81 x_msg_data OUT NOCOPY VARCHAR2,
82 p_product_txn_rec IN OUT NOCOPY csd_process_pvt.product_txn_rec,
83 p_add_to_order_flag IN VARCHAR2
84 );
85
86 --This api will identify if the item is ib trackable
87 FUNCTION is_item_ib_trackable (p_inv_item_id IN NUMBER)
88 RETURN BOOLEAN;
89 END csd_mass_rcv_pvt; -- Package spec