1 PACKAGE CSTPUMEC AUTHID CURRENT_USER AS
2 /* $Header: CSTPUMES.pls 115.5 2004/06/15 21:34:59 lfreyes ship $ */
3
4 PROCEDURE CSTPECPC (
5 I_ORGANIZATION_ID IN NUMBER,
6 I_COST_TYPE_ID IN NUMBER,
7 I_FROM_COST_TYPE IN NUMBER,
8 I_LIST_ID IN NUMBER,
9 I_USER_ID IN NUMBER,
10 I_REQ_ID IN NUMBER,
11 I_PRGM_ID IN NUMBER,
12 I_PRGM_APPL_ID IN NUMBER,
13 O_RETURN_CODE OUT NOCOPY NUMBER);
14
15 PROCEDURE CSTPEIIC (
16 I_ORGANIZATION_ID IN NUMBER,
17 I_COST_TYPE_ID IN NUMBER,
18 I_LIST_ID IN NUMBER,
19 I_RESOURCE_ID IN NUMBER,
20 I_USER_ID IN NUMBER,
21 I_REQ_ID IN NUMBER,
22 I_PRGM_ID IN NUMBER,
23 I_PRGM_APPL_ID IN NUMBER,
24 O_RETURN_CODE OUT NOCOPY NUMBER);
25
26 PROCEDURE CSTPERIC (
27 I_ORGANIZATION_ID IN NUMBER,
28 I_COST_TYPE_ID IN NUMBER,
29 I_LIST_ID IN NUMBER,
30 I_USER_ID IN NUMBER,
31 I_REQ_ID IN NUMBER,
32 I_PRGM_ID IN NUMBER,
33 I_PRGM_APPL_ID IN NUMBER,
34 O_RETURN_CODE OUT NOCOPY NUMBER);
35
36
37 -- Start of comments
38 --
39 -- PROCEDURE
40 -- set_cost_controls Invoked from the Mass Edit Menu as a concurrent
41 -- request. This function allows the user to set
42 -- the values of the following three fields in
43 -- cst_item_costs:
44 -- BASED_ON_ROLLUP_FLAG
45 -- DEFAULTED_FLAG
46 -- LOT_SIZE
47 --
48 --
49 --
50 -- PARAMETERS
51 -- O_Err_Num output parameter for errors
52 -- O_Err_Msg output parameter for errors
53 -- i_org_id organization
54 -- i_cost_type target cost type
55 -- i_range All items, specific item, item range, category range
56 -- i_specific_item Will contain an inventory_item_id
57 -- i_category_set Contains the category set ID # for the category set the user selected
58 -- i_cat_strct Contains the default category_structure assigned to the above category set
59 -- i_category_from Contains the category ID for the FROM category that the user selected
60 -- i_category_to Contains the category ID for the TO category that the user selected
61 -- i_item_from A character string containing the flexfield concatenated segs (segment1||...)
62 -- i_item_to A character string containing the flexfield concatenated segs (segment1||...)
63 -- i_copy_option Choices are: 1. From system item definition - meaning copy the fields from the
64 -- MSI table for the chosen item(s) and organization.
65 -- 2. From cost type - meaning copy the fields from the CIC table for the chosen
66 -- item(s), organization, and cost type.
67 -- i_co_dummy NULL unless copy option = From cost type (used to enable the src_cost_type param)
68 -- i_src_cost_type Source cost type when copy option = From cost type
69 -- i_bor_flag Based on rollup flag setting (flag indicating whether cost is rolled up):
70 -- 1 = Set to 1(YES), 2 = Set to 2(NO), 3 = Copy(from MSI or CIC), 4 = keep current
71 -- i_def_flag Defaulted flag setting (flag indicating whether the cost of the item is
72 -- defaulted from the default cost type during cost rollup):
73 -- 1 = Set to 1(YES), 2 = Set to 2(NO), 3 = Copy(from CIC), 4 = keep current
74 -- i_lotsz_lov Selection made from lot size LOV: 1 = Set to #(which is provided in i_lot_size)
75 -- 2 = Copy (from MSI or CIC), 3 = keep current
76 -- i_lot_size lot size (ignored unless the lot size selection = 1)
77 --
78 -- End of comments
79
80 procedure set_cost_controls(
81 O_Err_Num OUT NOCOPY NUMBER,
82 O_Err_Msg OUT NOCOPY VARCHAR2,
83 i_org_id IN NUMBER,
84 i_cost_type IN NUMBER,
85 i_range IN NUMBER,
86 i_item_dummy IN NUMBER,
87 i_specific_item IN NUMBER,
88 i_category_set IN NUMBER,
89 i_cat_strct IN NUMBER,
90 i_category_from IN VARCHAR2,
91 i_category_to IN VARCHAR2,
92 i_item_from IN VARCHAR2,
93 i_item_to IN VARCHAR2,
94 i_copy_option IN NUMBER,
95 i_co_dummy IN NUMBER,
96 i_src_cost_type IN NUMBER,
97 i_bor_flag IN NUMBER,
98 i_def_flag IN NUMBER,
99 i_lotsz_lov IN NUMBER,
100 i_lot_size IN NUMBER
101 );
102
103 END CSTPUMEC;