1 PACKAGE AMS_physical_fulfillment_PUB AS
2 /* $Header: amsvfuls.pls 120.1 2005/08/11 11:49:18 appldev ship $ */
3 TYPE order_header_rec_type IS RECORD
4 (
5 cust_party_id NUMBER
6 , cust_account_id NUMBER
7 , sold_to_contact_id NUMBER
8 , inv_party_id NUMBER
9 , inv_party_site_id NUMBER
10 , ship_party_site_id NUMBER
11 , quote_source_code VARCHAR2(240)
12 , marketing_source_code_id NUMBER
13 , order_type_id NUMBER
14 , employee_id NUMBER
15 , collateral_id NUMBER
16 , cover_letter_id NUMBER
17 , uom_code VARCHAR2(3)
18 , line_category_code VARCHAR2(30)
19 , inv_organization_id NUMBER
20 , SHIP_FROM_ORG_ID NUMBER
21 , organization_id NUMBER --by: musman: MOAC uptake bug:4421261 Fix
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 , SHIP_FROM_ORG_ID NUMBER
32 );
33
34 TYPE order_line_tbl_type IS TABLE OF order_line_rec_type
35 INDEX BY BINARY_INTEGER;
36
37 PROCEDURE fulfill_collateral_request
38 (
39 p_init_msg_list IN VARCHAR2
40 ,p_api_version IN NUMBER
41 ,p_commit IN VARCHAR2
42 ,x_return_status OUT NOCOPY VARCHAR2
43 ,x_msg_count OUT NOCOPY NUMBER
44 ,x_msg_data OUT NOCOPY VARCHAR2
45 ,p_order_header_rec IN ORDER_HEADER_REC_TYPE
46 ,p_order_line_tbl IN ORDER_LINE_TBL_TYPE
47 ,x_order_header_rec OUT NOCOPY ASO_ORDER_INT.order_header_rec_type
48 );
49 END AMS_physical_fulfillment_PUB;