PACKAGE: APPS.BOM_MIXED_MODEL_MAP_PVT

Source

1 PACKAGE BOM_Mixed_Model_Map_PVT AUTHID CURRENT_USER AS
2 /* $Header: BOMMMMCS.pls 115.7 2002/11/27 10:11:51 nrajpal ship $ */
3 /*==========================================================================+
4 |   Copyright (c) 1997 Oracle Corporation Redwood Shores, California, USA   |
5 |                          All rights reserved.                             |
6 +===========================================================================+
7 |                                                                           |
8 | File Name    : BOMMMMCS.pls                                               |
9 | DESCRIPTION  : This package contains functions used to calculate values   |
10 |                for the Mixed Model Map form		                    |
11 | History:                                                                  |
12 |    08/09/97   Julie Maeyama   Creation				    |
13 +===========================================================================*/
14 PROCEDURE GetProcessLineOp (
15     p_mmm_id            NUMBER,
16     p_org_id            NUMBER,
17     p_line_id           NUMBER,
18     p_family_item_id    NUMBER,
19     p_operation_type    NUMBER,
20     p_order             NUMBER,
21     p_user_id           NUMBER,
22     x_err_text     OUT  NOCOPY	VARCHAR2
23 );
24 
25 
26 PROCEDURE GetDetails (
27     p_mmm_id		NUMBER,
28     p_line_id		NUMBER,
29     p_family_item_id	NUMBER,
30     p_org_id		NUMBER,
31     p_user_id		NUMBER,
32     p_start_date	DATE,
33     p_end_date		DATE,
34     p_demand_type	NUMBER,
35     p_demand_code	VARCHAR2,
36     p_hours_per_day	NUMBER,
37     p_demand_days	NUMBER,
38     p_boost_percent	NUMBER,
39     p_operation_type	NUMBER,
40     p_time_uom		NUMBER,
41     p_calendar_code	VARCHAR2,
42     p_exception_set_id  NUMBER,
43     p_last_calendar_date DATE,
44     x_err_text     OUT  NOCOPY	VARCHAR2);
45 
46 
47 PROCEDURE GetCells (
48     p_mmm_id            NUMBER,
49     p_group_number      NUMBER,
50     p_line_id		NUMBER,
51     p_family_item_id    NUMBER,
52     p_org_id            NUMBER,
53     p_user_id           NUMBER,
54     p_start_date        DATE,
55     p_end_date          DATE,
56     p_demand_type       NUMBER,
57     p_demand_code       VARCHAR2,
58     p_process_line_op	NUMBER,
59     p_hours_per_day     NUMBER,
60     p_demand_days       NUMBER,
61     p_boost_percent     NUMBER,
62     p_operation_type    NUMBER,
63     p_time_type         NUMBER,
64     p_ipk_value         NUMBER,
65     p_time_uom          NUMBER,
66     p_calendar_code	VARCHAR2,
67     p_exception_set_id  NUMBER,
68     p_last_calendar_date DATE,
69     p_op_code1          VARCHAR2,
70     p_op_code2          VARCHAR2,
71     p_op_code3          VARCHAR2,
72     p_op_code4          VARCHAR2,
73     p_op_code5          VARCHAR2,
74     x_line_takt    OUT  NOCOPY	NUMBER,
75     x_err_text     OUT  NOCOPY	VARCHAR2)
76 ;
77 
78 PROCEDURE GetDemand (
79         p_org_id        NUMBER,
80         p_demand_type   NUMBER,
81         p_line_id       NUMBER,
82         p_assembly_item_id      NUMBER,
83         p_calendar_code VARCHAR2,
84         p_start_date    DATE,
85         p_end_date      DATE,
86         p_last_calendar_date    DATE,
87         p_exception_set_id      NUMBER,
88         p_demand_code   VARCHAR2,
89         o_demand        OUT NOCOPY	NUMBER,
90         o_stmt_num      OUT NOCOPY	NUMBER);
91 
92 END BOM_Mixed_Model_Map_PVT;