[Home] [Help]
PACKAGE: APPS.AHL_PRD_OPERATIONS_PVT
Source
1 PACKAGE AHL_PRD_OPERATIONS_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVPROS.pls 120.1 2006/02/08 06:03:05 bachandr noship $ */
3 TYPE PRD_WORKOPERATION_REC IS RECORD
4 (
5 WORKORDER_OPERATION_ID NUMBER,
6 ORGANIZATION_ID NUMBER,
7 OPERATION_SEQUENCE_NUM NUMBER,
8 OPERATION_DESCRIPTION VARCHAR2(500),
9 WORKORDER_ID NUMBER,
10 WIP_ENTITY_ID NUMBER,
11 ROUTE_ID NUMBER,
12 OBJECT_VERSION_NUMBER NUMBER,
13 LAST_UPDATE_DATE DATE,
14 LAST_UPDATED_BY NUMBER,
15 CREATION_DATE DATE,
16 CREATED_BY NUMBER,
17 LAST_UPDATE_LOGIN NUMBER,
18 DEPARTMENT_ID NUMBER,
19 DEPARTMENT_NAME VARCHAR2(240),
20 STATUS_CODE VARCHAR2(30),
21 STATUS_MEANING VARCHAR2(80),
22 OPERATION_ID NUMBER,
23 OPERATION_CODE VARCHAR2(500),
24 OPERATION_TYPE_CODE VARCHAR2(40),
25 OPERATION_TYPE VARCHAR2(80),
26 REPLENISH VARCHAR2(1),
27 MINIMUM_TRANSFER_QUANTITY NUMBER,
28 COUNT_POINT_TYPE NUMBER,
29 SCHEDULED_START_DATE DATE,
30 SCHEDULED_START_HR NUMBER,
31 SCHEDULED_START_MI NUMBER,
32 SCHEDULED_END_DATE DATE,
33 SCHEDULED_END_HR NUMBER,
34 SCHEDULED_END_MI NUMBER,
35 ACTUAL_START_DATE DATE,
36 ACTUAL_START_HR NUMBER,
37 ACTUAL_START_MI NUMBER,
38 ACTUAL_END_DATE DATE,
39 ACTUAL_END_HR NUMBER,
40 ACTUAL_END_MI NUMBER,
41 PLAN_ID NUMBER,
42 COLLECTION_ID NUMBER,
43 PROPAGATE_FLAG VARCHAR2(1),
44 SECURITY_GROUP_ID NUMBER,
45 ATTRIBUTE_CATEGORY VARCHAR2(30),
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 DML_OPERATION VARCHAR2(1)
62 );
63
64 TYPE PRD_OPERATION_TBL IS TABLE OF PRD_WORKOPERATION_REC INDEX BY BINARY_INTEGER;
65
66
67 PROCEDURE PROCESS_OPERATIONS
68 (
69 p_api_version IN NUMBER := 1.0,
70 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
71 p_commit IN VARCHAR2 := FND_API.G_FALSE,
72 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
73 p_default IN VARCHAR2 := FND_API.G_FALSE,
74 p_module_type IN VARCHAR2,
75 p_wip_mass_load_flag IN VARCHAR2,
76 x_return_status OUT NOCOPY VARCHAR2,
77 x_msg_count OUT NOCOPY NUMBER,
78 x_msg_data OUT NOCOPY VARCHAR2,
79 p_x_prd_operation_tbl IN OUT NOCOPY PRD_OPERATION_TBL
80 );
81
82 END AHL_PRD_OPERATIONS_PVT;