1 package CTO_TRANSFER_PRICE_PK AUTHID CURRENT_USER as
2 /* $Header: CTOTPRCS.pls 120.1 2005/10/28 15:15:30 rekannan noship $*/
3 /*----------------------------------------------------------------------------+
4 | Copyright (c) 1993 Oracle Corporation Belmont, California, USA
5 | All rights reserved.
6 | Oracle Manufacturing
7 |
8 |FILE NAME : CTOTPRCS.pls
9 |
10 |DESCRIPTION : Contains modules to :
11 | 1. Get the optional components of a configuration item from either the sales order or the BOM
12 | 2. Calculate Transfer Price for a configuration item
13 |
14 |HISTORY : Created on 29-AUG-2003 by Sajani Sheth
15 |
16 +-----------------------------------------------------------------------------*/
17
18 /***********************************************************************
19 This procedure returns the optional components of a configuration item
20 and its child configuration items, based on either a sales order or the
21 configuration BOM.
22 The optional components are populated in table bom_explosion_temp with
23 a unique group_id. The group_id is passed back to the calling application.
24 ***********************************************************************/
25 PROCEDURE get_config_details
26 (
27 p_item_id IN number,
28 p_org_id IN number default NULL,
29 p_mode_id IN number default 3,
30 p_configs_only IN varchar2 default 'N',
31 p_line_id IN Number default null,
32 x_group_id OUT NOCOPY number,
33 x_msg_count OUT NOCOPY number,
34 x_msg_data OUT NOCOPY varchar2,
35 x_return_status OUT NOCOPY varchar);
36
37
38 /***********************************************************************
39 This procedure returns the optional components of a configuration item
40 and its child configuration items, based on a sales order. The optional
41 components are populated in table bom_explosion_temp for input parameter
42 group_id.
43 ***********************************************************************/
44 PROCEDURE get_config_details_bcol
45 (p_line_id IN NUMBER,
46 p_grp_id IN NUMBER,
47 x_msg_count OUT NOCOPY NUMBER,
48 x_msg_data OUT NOCOPY VARCHAR2,
49 x_return_status OUT NOCOPY VARCHAR2);
50
51
52 /***********************************************************************
53 This procedure returns the optional components of a configuration item
54 and its child configuration items, based on the configuration BOM. The
55 optional components are populated in table bom_explosion_temp for
56 input parameter group_id.
57 ***********************************************************************/
58 PROCEDURE get_config_details_bom
59 (p_item_id IN NUMBER,
60 p_organization_id IN NUMBER,
61 p_grp_id IN NUMBER,
62 x_msg_count OUT NOCOPY NUMBER,
63 x_msg_data OUT NOCOPY VARCHAR2,
64 x_return_status OUT NOCOPY VARCHAR2);
65
66
67 /**************************************************************************
68 Procedure: Cto_Transfer_Price
69 Parameters: P_config_item_id
70 P_selling_oper_unit
71 P_shipping_oper_unit
72 P_transaction_uom
73 P_transaction_id
74 P_price_list_id
75 P_global_procurement_flag
76 P_from_organization_id
77 P_currency_code
78 X_transfer_price
79 X_return_status
80 X_msg_count
81 X_msg_data
82 Description: This API calculates the transfer price for a
83 configuration item by rolling up the transfer
84 prices of its optional components.
85
86 *****************************************************************************/
87 Procedure Cto_Transfer_Price (
88 p_config_item_id IN NUMBER,
89 p_selling_oper_unit IN NUMBER,
90 p_shipping_oper_unit IN NUMBER,
91 p_transaction_uom IN VARCHAR2,
92 p_transaction_id IN NUMBER,
93 p_price_list_id IN NUMBER,
94 p_global_procurement_flag IN VARCHAR2,
95 p_from_organization_id IN NUMBER DEFAULT NULL,
96 p_currency_code IN VARCHAR2 DEFAULT NULL,
97 x_transfer_price OUT NOCOPY NUMBER,
98 x_currency_code OUT NOCOPY varchar2,
99 x_return_status OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER,
101 x_msg_data OUT NOCOPY VARCHAR2);
102
103 END CTO_TRANSFER_PRICE_PK;