[Home] [Help]
PACKAGE: APPS.MRP_FORECAST_INTERFACE_PK
Source
1 PACKAGE MRP_FORECAST_INTERFACE_PK AUTHID CURRENT_USER AS
2 /* $Header: MRPFAPIS.pls 115.10 2002/11/26 01:33:08 ichoudhu ship $ */
3
4 TYPE rec_forecast_designator IS
5 RECORD ( organization_id NUMBER, forecast_designator VARCHAR2(10),
6 inventory_item_id NUMBER DEFAULT NULL);
7 TYPE t_forecast_designator IS
8 TABLE of rec_forecast_designator INDEX BY BINARY_INTEGER;
9
10 TYPE quantity_per_day_rec_type IS RECORD
11 ( work_date DATE,
12 quantity NUMBER);
13
14 TYPE quantity_per_day_tbl_type IS TABLE OF quantity_per_day_rec_type
15 INDEX BY BINARY_INTEGER;
16
17 /* 1336039 - SVAIDYAN: Add attribute_category to the pl/sql table for
18 forecast interface. */
19
20 TYPE rec_forecast_interface IS
21 RECORD
22 (INVENTORY_ITEM_ID NUMBER,
23 FORECAST_DESIGNATOR VARCHAR2(10),
24 ORGANIZATION_ID NUMBER,
25 FORECAST_DATE DATE,
26 LAST_UPDATE_DATE DATE,
27 LAST_UPDATED_BY NUMBER,
28 CREATION_DATE DATE,
29 CREATED_BY NUMBER,
30 LAST_UPDATE_LOGIN NUMBER,
31 QUANTITY NUMBER,
32 PROCESS_STATUS NUMBER,
33 CONFIDENCE_PERCENTAGE NUMBER,
34 COMMENTS VARCHAR2(240),
35 ERROR_MESSAGE VARCHAR2(240),
36 REQUEST_ID NUMBER,
37 PROGRAM_APPLICATION_ID NUMBER,
38 PROGRAM_ID NUMBER,
39 PROGRAM_UPDATE_DATE DATE,
40 WORKDAY_CONTROL NUMBER,
41 BUCKET_TYPE NUMBER,
42 FORECAST_END_DATE DATE,
43 TRANSACTION_ID NUMBER,
44 SOURCE_CODE VARCHAR2(10),
45 SOURCE_LINE_ID NUMBER,
46 ATTRIBUTE1 VARCHAR2(150),
47 ATTRIBUTE2 VARCHAR2(150),
48 ATTRIBUTE3 VARCHAR2(150),
49 ATTRIBUTE4 VARCHAR2(150),
50 ATTRIBUTE5 VARCHAR2(150),
51 ATTRIBUTE6 VARCHAR2(150),
52 ATTRIBUTE7 VARCHAR2(150),
53 ATTRIBUTE8 VARCHAR2(150),
54 ATTRIBUTE9 VARCHAR2(150),
55 ATTRIBUTE10 VARCHAR2(150),
56 ATTRIBUTE11 VARCHAR2(150),
57 ATTRIBUTE12 VARCHAR2(150),
58 ATTRIBUTE13 VARCHAR2(150),
59 ATTRIBUTE14 VARCHAR2(150),
60 ATTRIBUTE15 VARCHAR2(150),
61 PROJECT_ID NUMBER,
62 TASK_ID NUMBER,
63 LINE_ID NUMBER,
64 ACTION VARCHAR2(1),
65 ATTRIBUTE_CATEGORY VARCHAR2(30));
66 TYPE t_forecast_interface IS
67 TABLE of rec_forecast_interface INDEX BY BINARY_INTEGER;
68
69 FUNCTION mrp_forecast_interface(
70 forecast_interface IN OUT NOCOPY t_forecast_interface,
71 forecast_designator IN OUT NOCOPY t_forecast_designator)
72 RETURN BOOLEAN;
73 FUNCTION mrp_forecast_interface(
74 forecast_interface IN OUT NOCOPY t_forecast_interface)
75 RETURN BOOLEAN;
76 FUNCTION mrp_forecast_interface(
77 forecast_designator IN OUT NOCOPY t_forecast_designator)
78 RETURN BOOLEAN;
79
80 PROCEDURE quantity_per_day(x_return_status OUT NOCOPY VARCHAR2,
81 x_msg_count OUT NOCOPY NUMBER,
82 x_msg_data OUT NOCOPY VARCHAR2,
83 p_organization_id IN NUMBER,
84 p_workday_control IN NUMBER,
85 p_start_date IN DATE,
86 p_end_date IN DATE,
87 p_quantity IN NUMBER,
88 x_workday_count OUT NOCOPY NUMBER,
89 x_quantity_per_day OUT NOCOPY QUANTITY_PER_DAY_TBL_TYPE);
90
91 END MRP_FORECAST_INTERFACE_PK;