1 PACKAGE WIP_DISCRETE_INIT AUTHID CURRENT_USER as
2 /* $Header: wipdjins.pls 115.9 2003/09/05 21:30:55 kboonyap ship $ */
3
4 /* This procedure is run whenever the Define Discrete Job form is started.
5 It fetches information from WIP_PARAMETERS, WIP_ACCOUNTING_CLASSES, and
6 MTL_PARAMETERS
7 */
8
9 PROCEDURE get_parameters(p_organization_id NUMBER,
10 p_default_class IN OUT NOCOPY VARCHAR2,
11 p_lot_number_default_type OUT NOCOPY NUMBER,
12 p_wip_param_count OUT NOCOPY NUMBER,
13 p_acct_class_flag IN OUT NOCOPY NUMBER,
14 p_disable_date OUT NOCOPY DATE,
15 p_default_ma OUT NOCOPY NUMBER,
16 p_default_mva OUT NOCOPY NUMBER,
17 p_default_moa OUT NOCOPY NUMBER,
18 p_default_ra OUT NOCOPY NUMBER,
19 p_default_rva OUT NOCOPY NUMBER,
20 p_default_opa OUT NOCOPY NUMBER,
21 p_default_opva OUT NOCOPY NUMBER,
22 p_default_oa OUT NOCOPY NUMBER,
23 p_default_ova OUT NOCOPY NUMBER,
24 p_default_scaa OUT NOCOPY NUMBER,
25 p_org_locator_control OUT NOCOPY NUMBER,
26 p_demand_class_mp OUT NOCOPY VARCHAR2,
27 p_mp_calendar_code OUT NOCOPY VARCHAR2,
28 p_mp_exception_set_id OUT NOCOPY NUMBER,
29 p_project_ref OUT NOCOPY NUMBER,
30 p_project_control OUT NOCOPY NUMBER,
31 p_pm_cost_collection OUT NOCOPY NUMBER,
32 p_primary_cost_method OUT NOCOPY NUMBER,
33 p_po_creation_time OUT NOCOPY NUMBER);
34
35 PROCEDURE get_parameters(p_organization_id NUMBER,
36 p_default_class IN OUT NOCOPY VARCHAR2,
37 p_lot_number_default_type OUT NOCOPY NUMBER,
38 p_wip_param_count OUT NOCOPY NUMBER,
39 p_acct_class_flag IN OUT NOCOPY NUMBER,
40 p_disable_date OUT NOCOPY DATE,
41 p_default_ma OUT NOCOPY NUMBER,
42 p_default_mva OUT NOCOPY NUMBER,
43 p_default_moa OUT NOCOPY NUMBER,
44 p_default_ra OUT NOCOPY NUMBER,
45 p_default_rva OUT NOCOPY NUMBER,
46 p_default_opa OUT NOCOPY NUMBER,
47 p_default_opva OUT NOCOPY NUMBER,
48 p_default_oa OUT NOCOPY NUMBER,
49 p_default_ova OUT NOCOPY NUMBER,
50 p_default_scaa OUT NOCOPY NUMBER,
51 p_org_locator_control OUT NOCOPY NUMBER,
52 p_demand_class_mp OUT NOCOPY VARCHAR2,
53 p_mp_calendar_code OUT NOCOPY VARCHAR2,
54 p_mp_exception_set_id OUT NOCOPY NUMBER,
55 p_project_ref OUT NOCOPY NUMBER,
56 p_project_control OUT NOCOPY NUMBER,
57 p_pm_cost_collection OUT NOCOPY NUMBER,
58 p_primary_cost_method OUT NOCOPY NUMBER,
59 p_po_creation_time OUT NOCOPY NUMBER,
60 p_def_serialization_start_op OUT NOCOPY NUMBER);
61
62 PROCEDURE get_parameters(p_organization_id NUMBER,
63 p_default_class IN OUT NOCOPY VARCHAR2,
64 p_lot_number_default_type OUT NOCOPY NUMBER,
65 p_wip_param_count OUT NOCOPY NUMBER,
66 p_acct_class_flag IN OUT NOCOPY NUMBER,
67 p_disable_date OUT NOCOPY DATE,
68 p_default_ma OUT NOCOPY NUMBER,
69 p_default_mva OUT NOCOPY NUMBER,
70 p_default_moa OUT NOCOPY NUMBER,
71 p_default_ra OUT NOCOPY NUMBER,
72 p_default_rva OUT NOCOPY NUMBER,
73 p_default_opa OUT NOCOPY NUMBER,
74 p_default_opva OUT NOCOPY NUMBER,
75 p_default_oa OUT NOCOPY NUMBER,
76 p_default_ova OUT NOCOPY NUMBER,
77 p_default_scaa OUT NOCOPY NUMBER,
78 p_org_locator_control OUT NOCOPY NUMBER,
79 p_demand_class_mp OUT NOCOPY VARCHAR2,
80 p_mp_calendar_code OUT NOCOPY VARCHAR2,
81 p_mp_exception_set_id OUT NOCOPY NUMBER,
82 p_project_ref OUT NOCOPY NUMBER,
83 p_project_control OUT NOCOPY NUMBER,
84 p_pm_cost_collection OUT NOCOPY NUMBER,
85 p_primary_cost_method OUT NOCOPY NUMBER,
86 p_po_creation_time OUT NOCOPY NUMBER,
87 p_def_serialization_start_op OUT NOCOPY NUMBER,
88 p_propagate_job_change_to_po OUT NOCOPY NUMBER);
89
90 END WIP_DISCRETE_INIT;