[Home] [Help]
PACKAGE: APPS.MRP_MANAGER_PK
Source
1 PACKAGE mrp_manager_pk AUTHID CURRENT_USER AS
2 /* $Header: MRPPPMGS.pls 115.10 2003/03/04 01:49:09 schaudha ship $ */
3
4 PROCEDURE compute_sales_order_changes(
5 arg_request_id IN NUMBER,
6 arg_user_id IN NUMBER);
7
8 PROCEDURE update_sales_orders(
9 arg_request_id IN NUMBER,
10 arg_user_id IN NUMBER);
11
12 PROCEDURE create_forecast_items(
13 arg_request_id IN NUMBER,
14 arg_user_id IN NUMBER,
15 arg_desig IN VARCHAR2);
16
17 PROCEDURE explode_in_process(
18 arg_in_process_id OUT NOCOPY NUMBER,
19 arg_request_id IN NUMBER,
20 arg_user_id IN NUMBER);
21
22 PROCEDURE mds_explode_in_process(
23 arg_in_process_id OUT NOCOPY NUMBER,
24 arg_request_id IN NUMBER,
25 arg_user_id IN NUMBER);
26
27 PROCEDURE update_forecast_desc_flex(
28 arg_row_count IN OUT NOCOPY NUMBER);
29
30 PROCEDURE update_schedule_desc_flex(
31 arg_row_count IN OUT NOCOPY NUMBER,
32 arg_schedule_count IN NUMBER,
33 arg_forecast_count IN NUMBER,
34 arg_so_count IN NUMBER,
35 arg_interorg_count IN NUMBER);
36
37 FUNCTION get_customer_name(
38 p_customer_id IN NUMBER)RETURN VARCHAR2;
39
40 FUNCTION get_ship_address(
41 p_ship_id IN NUMBER)RETURN VARCHAR2;
42
43 FUNCTION get_bill_address(
44 p_bill_id IN NUMBER)RETURN VARCHAR2;
45
46 FUNCTION get_project_id(
47 p_demand_id IN NUMBER)RETURN NUMBER;
48
49 FUNCTION get_task_id(
50 p_demand_id IN NUMBER)RETURN NUMBER;
51
52 FUNCTION get_unit_number(
53 p_demand_id IN NUMBER)RETURN VARCHAR2;
54
55 PRAGMA RESTRICT_REFERENCES(get_customer_name, WNDS, WNPS);
56 PRAGMA RESTRICT_REFERENCES(get_ship_address, WNDS, WNPS);
57 PRAGMA RESTRICT_REFERENCES(get_bill_address, WNDS, WNPS);
58 PRAGMA RESTRICT_REFERENCES(get_project_id, WNDS, WNPS);
59 PRAGMA RESTRICT_REFERENCES(get_task_id, WNDS, WNPS);
60 -- Removed because 8.1.5 does not need this
61 -- PRAGMA RESTRICT_REFERENCES(get_unit_number, WNDS, WNPS);
62
63 /*------------------------------------------------------------------+
64 | Define constants |
65 +------------------------------------------------------------------*/
66 var_watch_id NUMBER;
67
68 VERSION CONSTANT CHAR(80) := '$Header: MRPPPMGS.pls 115.10 2003/03/04 01:49:09 schaudha ship $';
69
70 NO_PLANNING CONSTANT INTEGER := 6; /* planning */
71
72 ITEM_TYPE_MODEL CONSTANT INTEGER := 1; /* BOM Item type */
73 ITEM_TYPE_OPTION_CLASS CONSTANT INTEGER := 2;
74 ITEM_TYPE_PLANNING CONSTANT INTEGER := 3;
75 ITEM_TYPE_STANDARD CONSTANT INTEGER := 4;
76 ITEM_TYPE_PRODUCT_FAMILY CONSTANT INTEGER := 5;
77
78 MAGIC_STRING CONSTANT VARCHAR2(10) := '734jkhJK24';
79
80 SYS_YES CONSTANT INTEGER := 1; /* sys yes no */
81 SYS_NO CONSTANT INTEGER := 2;
82
83 MTL_SALES_ORDER CONSTANT INTEGER := 2; /* sales order */
84 MTL_INT_SALES_ORDER CONSTANT INTEGER := 8; /* internal sales
85 order */
86
87 DO_NOT_PROCESS CONSTANT INTEGER := 1;
88 TO_BE_PROCESSED CONSTANT INTEGER := 2; /* process status */
89 ALREADY_PROCESSED CONSTANT INTEGER := 5;
90 IN_PROCESS CONSTANT INTEGER := 3;
91
92 UPDATE_BATCH_SIZE CONSTANT INTEGER := 100000;
93
94 ATO_NONE CONSTANT INTEGER := 3;
95 END mrp_manager_pk;