1 PACKAGE CSD_LOGISTICS_CUHK AUTHID CURRENT_USER AS
2 /* $Header: csdclogs.pls 120.0.12020000.3 2013/04/08 22:57:18 swai noship $ */
3 -- Start of Comments
4 -- Package name : CSD_LOGISTICS_CUHK
5 -- Purpose : User hook procedures for the logistics processing.
6 -- History : Mar-20-2011 subhat created
7 -- NOTE :
8 -- End of Comments
9
10 PROCEDURE service_item
11 (p_order_line_id IN NUMBER,
12 p_repair_line_id IN NUMBER,
13 x_return_status OUT NOCOPY VARCHAR2,
14 x_msg_data OUT NOCOPY VARCHAR2,
15 x_msg_count OUT NOCOPY NUMBER,
16 x_service_item_id OUT NOCOPY NUMBER
17 );
18
19 PROCEDURE source_parts
20 (p_repair_line_id IN NUMBER,
21 p_wip_entity_id IN JTF_NUMBER_TABLE,
22 p_item_id IN JTF_NUMBER_TABLE,
23 p_quantity IN JTF_NUMBER_TABLE,
24 p_requesting_org IN NUMBER,
25 p_op_seq_num IN JTF_NUMBER_TABLE,
26 x_use_custom_sourcing OUT NOCOPY BOOLEAN,
27 x_wip_entity_id OUT NOCOPY JTF_NUMBER_TABLE,
28 x_item_id OUT NOCOPY JTF_NUMBER_TABLE,
29 x_item_desc OUT NOCOPY JTF_VARCHAR2_TABLE_100,
30 x_uom_code OUT NOCOPY JTF_VARCHAR2_TABLE_100,
31 x_quantity OUT NOCOPY JTF_NUMBER_TABLE,
32 x_source_org_id OUT NOCOPY JTF_NUMBER_TABLE,
33 x_source_subinventory OUT NOCOPY JTF_VARCHAR2_TABLE_100,
34 x_op_seq_num OUT NOCOPY JTF_NUMBER_TABLE,
35 x_requisition_type OUT NOCOPY JTF_VARCHAR2_TABLE_100,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_data OUT NOCOPY VARCHAR2,
38 x_msg_count OUT NOCOPY NUMBER
39 );
40
41 END CSD_LOGISTICS_CUHK;