1 PACKAGE JTF_Fulfillment_PUB AUTHID CURRENT_USER AS
2 /* $Header: jtfgfmps.pls 120.0 2005/05/11 08:14:40 appldev ship $ */
3
4 -- For physical fulfillment
5 TYPE order_header_rec_type IS RECORD
6 (
7 cust_party_id NUMBER
8 , cust_account_id NUMBER
9 , sold_to_contact_id NUMBER
10 , inv_party_id NUMBER
11 , inv_party_site_id NUMBER
12 , ship_party_site_id NUMBER
13 , quote_source_code VARCHAR2(240)
14 , marketing_source_code_id NUMBER
15 , order_type_id NUMBER
16 , employee_id NUMBER
17 , collateral_id NUMBER
18 , cover_letter_id NUMBER
19 , uom_code VARCHAR2(3)
20 , line_category_code VARCHAR2(30)
21 , inv_organization_id NUMBER
22 );
23
24
25 TYPE order_line_rec_type IS RECORD
26 (
27 ship_party_id NUMBER
28 ,ship_party_site_id NUMBER
29 ,ship_method_code VARCHAR2(30)
30 , quantity NUMBER
31 );
32
33 TYPE order_line_tbl_type IS TABLE OF order_line_rec_type
34 INDEX BY BINARY_INTEGER;
35
36
37
38
39 PROCEDURE create_fulfill_physical
40 (
41 p_init_msg_list IN VARCHAR2
42 ,p_api_version IN NUMBER
43 ,p_commit IN VARCHAR2
44 ,x_return_status OUT NOCOPY VARCHAR2
45 ,x_msg_count OUT NOCOPY NUMBER
46 ,x_msg_data OUT NOCOPY VARCHAR2
47 ,p_order_header_rec IN ORDER_HEADER_REC_TYPE
48 ,p_order_line_tbl IN ORDER_LINE_TBL_TYPE
49 ,x_order_header_rec OUT NOCOPY ASO_ORDER_INT.order_header_rec_type
50 ,x_request_history_id OUT NOCOPY NUMBER
51 );
52
53
54
55
56
57
58
59 END JTF_Fulfillment_PUB;