1 PACKAGE CSTPPCIC AUTHID CURRENT_USER AS
2 /* $Header: CSTPCICS.pls 115.7 2002/11/09 00:28:31 awwang ship $ */
3
4
5 /*---------------------------------------------------------------------------
6 This function returns the conversion rate between the 2 Uoms
7 This returned rate will be multiplied with the cost to get the new cost
8 which will be inserted into CST_ITEM_COSTS in procedure copy_item_period_cost()
9 ----------------------------------------------------------------------------*/
10
11 FUNCTION get_uom_conv_rate(
12 i_item_id IN NUMBER,
13 i_from_org_id IN NUMBER,
14 i_to_org_id IN NUMBER)
15 return NUMBER ;
16
17
18 /*---------------------------------------------------------------------------*
19 | PUBLIC PROCEDURE |
20 | copy_item_period_cost |
21 | |
22 | p_copy_option: |
23 | 1: Merge and update |
24 | 2: New cost only |
25 | 3: remove and replace |
26 | p_range: |
27 | 1: All items |
28 | 2: Specific Item |
29 | 5: Category Items |
30 | |
31 *----------------------------------------------------------------------------*/
32 PROCEDURE copy_item_period_cost(
33 errbuf OUT NOCOPY VARCHAR2,
34 retcode OUT NOCOPY NUMBER,
35 p_legal_entity IN NUMBER,
36 p_from_cost_type_id IN NUMBER,
37 p_from_cost_group_id IN NUMBER,
38 p_period_id IN NUMBER,
39 p_to_org_id IN NUMBER,
40 p_to_cost_type_id IN NUMBER,
41 p_material IN NUMBER,
42 p_material_overhead IN NUMBER,
43 p_resource IN NUMBER,
44 p_outside_processing IN NUMBER,
45 p_overhead IN NUMBER,
46 p_copy_option IN NUMBER,
47 p_range IN NUMBER,
48 p_item_dummy IN NUMBER,
49 p_category_dummy IN NUMBER,
50 p_specific_item_id IN NUMBER,
51 p_category_set_id IN NUMBER,
52 p_category_validate_flag IN VARCHAR2,
53 p_category_structure IN NUMBER,
54 p_category_id IN NUMBER,
55 p_last_updated_by IN NUMBER,
56 p_full_validate IN NUMBER);
57
58
59 END CSTPPCIC;