1 PACKAGE GMF_LOT_COSTING_PUB AUTHID CURRENT_USER AS
2 /* $Header: GMFPLCRS.pls 120.5 2011/05/06 13:41:19 spabolu ship $ */
3 --****************************************************************************************************
4 --* *
5 --* Oracle Process Manufacturing *
6 --* ============================ *
7 --* *
8 --* Package GMF_LOT_COSTING_PUB *
9 --* --------------------------- *
10 --* This package contains a publically callable procedure ROLLUP_LOT_COSTS together with several *
11 --* utility procedures that are called by it. For individual procedures' descriptions, see the *
12 --* description in front of each one. *
13 --* *
14 --* Author: Paul J Schofield, OPM Development EMEA *
15 --* Date: September 2003 *
16 --* *
17 --* HISTORY *
18 --* ======= *
19 --* 12-Sep-2003 PJS Removed p_debug_level parameter in favour of the GMF_CONC_DEBUG profile *
20 --* option. Also created the audit trail in table GMF_LOT_COST_AUDIT and *
21 --* removed all code that supported the GMF_RESOURCE_LOT_COST_TXNS table. *
22 --* *
23 --* 30-Nov-2003 umoogala Now passing co_code to main routines ROLLUP_LOT_COSTS and removed *
24 --* calendar_code and user params. Using co_code where ever cldr was used. *
25 --* Also, using cm_mthd_mst.default_lot_cost_mthd for non-lot controlled items*
26 --* *
27 --* 05-Dec-2003 umoogala Enabling process for trail runs. Added flag p_final_run_flag to args list*
28 --* *
29 --* 08-Mar-2004 PJS Resequenced parameters for bug 3476427 *
30 --* *
31 --* 24-Feb-2005 - Dinesh Vadivel - Bug 4176690 - Added p_final_run_date parameter
32 --****************************************************************************************************
33
34 /*PROCEDURE rollup_lot_costs
35 ( errbuf OUT NOCOPY VARCHAR2
36 , retcode OUT NOCOPY VARCHAR2
37 , p_co_code IN VARCHAR2
38 , p_cost_method_code IN VARCHAR2
39 , p_final_run_flag IN VARCHAR2 -- umoogala 03-Dec-2003
40 , p_cost_class IN VARCHAR2
41 , p_item_no IN VARCHAR2
42 , p_lot_no IN VARCHAR2
43 , p_sublot_no IN VARCHAR2
44 , p_final_run_date IN VARCHAR2
45 );
46
47 /*
48 /* INVCONV sukarna Reddy June 2005 */
49
50
51 PROCEDURE rollup_lot_costs
52 ( errbuf OUT NOCOPY VARCHAR2
53 , retcode OUT NOCOPY VARCHAR2
54 , p_le_id IN NUMBER
55 , p_cost_type_id IN NUMBER
56 , p_final_run_flag IN VARCHAR2
57 , p_structure_id IN NUMBER /* dummy field value is passed from SRS but not used in the program*/
58 , p_category_id IN NUMBER
59 , p_orgn_id IN NUMBER
60 , p_item_id IN NUMBER
61 , p_lot_no IN VARCHAR2
62 , p_final_run_date IN VARCHAR2
63 );
64
65 -- umoogala
66 FUNCTION is_item_lot_costed
67 ( p_orgn_id IN NUMBER,
68 p_item_id IN NUMBER
69 )
70 RETURN NUMBER;
71
72 FUNCTION is_item_lot_costed1
73 ( p_orgn_id IN NUMBER,
74 p_item_id IN NUMBER
75 )
76 RETURN NUMBER;
77
78 END GMF_LOT_COSTING_PUB;