1 PACKAGE GMF_get_transfer_price_PUB AUTHID CURRENT_USER AS
2 /* $Header: GMFGXFRS.pls 120.3.12020000.2 2012/07/24 14:36:13 spabolu ship $ */
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 , p_transaction_date IN DATE DEFAULT NULL /* Bug 9189961 */
26
27 , x_return_status OUT NOCOPY VARCHAR2
28 , x_msg_data OUT NOCOPY VARCHAR2
29 , x_msg_count OUT NOCOPY NUMBER
30
31 , x_transfer_price OUT NOCOPY NUMBER /* In Txn UOM */
32 , x_transfer_price_priuom OUT NOCOPY NUMBER /* In Item Primary UOM */
33 , x_currency_code OUT NOCOPY VARCHAR2
34 , x_incr_transfer_price OUT NOCOPY NUMBER
35 , x_incr_currency_code OUT NOCOPY VARCHAR2
36 )
37 ;
38
39 Procedure get_xfer_price_basic (
40 x_transfer_price OUT NOCOPY NUMBER
41 , x_transfer_price_code OUT NOCOPY NUMBER
42 , x_pricelist_currency OUT NOCOPY VARCHAR2
43 , x_return_status OUT NOCOPY VARCHAR2
44 , x_msg_count OUT NOCOPY NUMBER
45 , x_msg_data OUT NOCOPY VARCHAR2
46 );
47
48 Procedure get_xfer_price_qp (
49 x_transfer_price OUT NOCOPY NUMBER
50 , x_currency_code OUT NOCOPY VARCHAR2
51 , x_transfer_price_code OUT NOCOPY NUMBER
52 , x_return_status OUT NOCOPY VARCHAR2
53 , x_msg_data OUT NOCOPY VARCHAR2
54 , x_msg_count OUT NOCOPY NUMBER
55 );
56
57 PROCEDURE G_Hdr_Initialize;
58 PROCEDURE copy_Header_to_request( p_header_rec INV_IC_ORDER_PUB.Header_Rec_Type
59 , p_Request_Type_Code VARCHAR2
60 , px_line_index IN OUT NOCOPY NUMBER )
61 ;
62
63 PROCEDURE G_Line_Initialize;
64 PROCEDURE copy_Line_to_request ( p_Line_rec INV_IC_ORDER_PUB.Line_Rec_Type
65 , p_pricing_events VARCHAR2
66 , p_request_type_code VARCHAR2
67 , px_line_index IN OUT NOCOPY NUMBER )
68 ;
69 PROCEDURE Populate_Temp_Table ( x_return_status OUT NOCOPY VARCHAR2
70 );
71 PROCEDURE Populate_Results( p_line_index NUMBER
72 , x_return_status OUT NOCOPY VARCHAR2
73 , x_msg_data OUT NOCOPY VARCHAR2
74 );
75
76 END GMF_get_transfer_price_PUB;