1 PACKAGE GMF_get_transfer_price_PUB AS
2 /* $Header: GMFGXFRS.pls 120.1 2005/06/17 13:12:06 umoogala noship $ */
3
4 G_SKIP_IC_PARAM_FOR_PD_XFER CONSTANT VARCHAR2(1) := 'N';
5
6 Procedure get_transfer_price
7 ( p_api_version IN NUMBER
8 , p_init_msg_list IN VARCHAR2
9
10 , p_inventory_item_id IN NUMBER
11 , p_transaction_qty IN NUMBER
12 , p_transaction_uom IN VARCHAR2
13
14 , p_transaction_id IN NUMBER /* Order Line Id for now */
15 , p_global_procurement_flag IN VARCHAR2
16 , p_drop_ship_flag IN VARCHAR2
17
18 , p_from_organization_id IN NUMBER
19 , p_from_ou IN NUMBER /* from OU */
20 , p_to_organization_id IN NUMBER
21 , p_to_ou IN NUMBER /* to OU */
22
23 , p_transfer_type IN VARCHAR2
24 , p_transfer_source IN VARCHAR2 /* INTORG, INTORD, INTREQ */
25
26 , x_return_status OUT NOCOPY VARCHAR2
27 , x_msg_data OUT NOCOPY VARCHAR2
28 , x_msg_count OUT NOCOPY NUMBER
29
30 , x_transfer_price OUT NOCOPY NUMBER /* In Txn UOM */
31 , x_transfer_price_priuom OUT NOCOPY NUMBER /* In Item Primary UOM */
32 , x_currency_code OUT NOCOPY VARCHAR2
33 , x_incr_transfer_price OUT NOCOPY NUMBER
34 , x_incr_currency_code OUT NOCOPY VARCHAR2
35 )
36 ;
37
38 Procedure get_xfer_price_basic (
39 x_transfer_price OUT NOCOPY NUMBER
40 , x_transfer_price_code OUT NOCOPY NUMBER
41 , x_pricelist_currency OUT NOCOPY VARCHAR2
42 , x_return_status OUT NOCOPY VARCHAR2
43 , x_msg_count OUT NOCOPY NUMBER
44 , x_msg_data OUT NOCOPY VARCHAR2
45 );
46
47 Procedure get_xfer_price_qp (
48 x_transfer_price OUT NOCOPY NUMBER
49 , x_currency_code OUT NOCOPY VARCHAR2
50 , x_transfer_price_code OUT NOCOPY NUMBER
51 , x_return_status OUT NOCOPY VARCHAR2
52 , x_msg_data OUT NOCOPY VARCHAR2
53 , x_msg_count OUT NOCOPY NUMBER
54 );
55
56 PROCEDURE G_Hdr_Initialize;
57 PROCEDURE copy_Header_to_request( p_header_rec INV_IC_ORDER_PUB.Header_Rec_Type
58 , p_Request_Type_Code VARCHAR2
59 , px_line_index IN OUT NOCOPY NUMBER )
60 ;
61
62 PROCEDURE G_Line_Initialize;
63 PROCEDURE copy_Line_to_request ( p_Line_rec INV_IC_ORDER_PUB.Line_Rec_Type
64 , p_pricing_events VARCHAR2
65 , p_request_type_code VARCHAR2
66 , px_line_index IN OUT NOCOPY NUMBER )
67 ;
68 PROCEDURE Populate_Temp_Table ( x_return_status OUT NOCOPY VARCHAR2
69 );
70 PROCEDURE Populate_Results( p_line_index NUMBER
71 , x_return_status OUT NOCOPY VARCHAR2
72 , x_msg_data OUT NOCOPY VARCHAR2
73 );
74
75 END GMF_get_transfer_price_PUB;