1 PACKAGE CS_TM_LABOR_SCHEDULE_PVT AUTHID CURRENT_USER AS
2 /* $Header: csxvtmss.pls 120.1 2006/02/09 18:05:55 mviswana noship $ */
3
4
5 -- PL/SQL Specification
6 -- Datastructure Definitions
7
8 -- Time and Material Labor Schedule record type
9 TYPE TM_SCHEDULE_REC_TYPE IS RECORD
10 ( TM_LABOR_SCHEDULE_ID NUMBER,
11 BUSINESS_PROCESS_ID NUMBER,
12 START_TIME DATE,
13 END_TIME DATE,
14 MONDAY_FLAG VARCHAR2(1),
15 TUESDAY_FLAG VARCHAR2(1),
16 WEDNESDAY_FLAG VARCHAR2(1),
17 THURSDAY_FLAG VARCHAR2(1),
18 FRIDAY_FLAG VARCHAR2(1),
19 SATURDAY_FLAG VARCHAR2(1),
20 SUNDAY_FLAG VARCHAR2(1),
21 HOLIDAY_FLAG VARCHAR2(1),
22 INVENTORY_ITEM_ID NUMBER,
23 ATTRIBUTE_CATEGORY VARCHAR2(30),
24 ATTRIBUTE1 VARCHAR2(240),
25 ATTRIBUTE2 VARCHAR2(240),
26 ATTRIBUTE3 VARCHAR2(240),
27 ATTRIBUTE4 VARCHAR2(240),
28 ATTRIBUTE5 VARCHAR2(240),
29 ATTRIBUTE6 VARCHAR2(240),
30 ATTRIBUTE7 VARCHAR2(240),
31 ATTRIBUTE8 VARCHAR2(240),
32 ATTRIBUTE9 VARCHAR2(240),
33 ATTRIBUTE10 VARCHAR2(240),
34 ATTRIBUTE11 VARCHAR2(240),
35 ATTRIBUTE12 VARCHAR2(240),
36 ATTRIBUTE13 VARCHAR2(240),
37 ATTRIBUTE14 VARCHAR2(240),
38 ATTRIBUTE15 VARCHAR2(240)
39 );
40
41 TYPE TM_SCHEDULE_TBL_TYPE IS TABLE OF TM_SCHEDULE_REC_TYPE INDEX BY BINARY_INTEGER;
42 -- Time and Material Labor Coverage record type
43 TYPE TM_COVERAGE_REC_TYPE IS RECORD
44 ( LABOR_START_DATE_TIME DATE,
45 LABOR_END_DATE_TIME DATE,
46 INVENTORY_ITEM_ID NUMBER
47 );
48
49 TYPE TM_COVERAGE_TBL_TYPE IS TABLE OF TM_COVERAGE_REC_TYPE INDEX BY BINARY_INTEGER;
50
51 -- Global variable
52 G_PKG_NAME CONSTANT VARCHAR2(30) := 'CS_TM_LABOR_SCHEDULE_PVT';
53
54 -- API specifications
55
56 -- Procedure to validate that a labor schedule is not overlapping with other existing -- labor schedules for a specific business process.
57 -- Note: The labor schedule being validated may not exist in the TM Labor Schedule -- Table
58
59
60 PROCEDURE VALIDATE_SCHEDULE_OVERLAP(
61 P_LABOR_SCHEDULE_TBL IN TM_SCHEDULE_TBL_TYPE,
62 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
63 X_MSG_COUNT OUT NOCOPY NUMBER,
64 X_MSG_DATA OUT NOCOPY VARCHAR2,
65 P_API_VERSION IN NUMBER,
66 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
67 );
68
69 -- Procedure to validate if there is a completed labor schedule defines for a specific business -- process.
70 -- Note: Passing in a complete set of records each represents schedule line from the TM Labor -- Schedule Setup UI for a specific business process
71
72 PROCEDURE VALIDATE_SCHEDULE_MISSING(
73 P_LABOR_SCHEDULE_TBL IN TM_SCHEDULE_TBL_TYPE,
74 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
75 X_MSG_COUNT OUT NOCOPY NUMBER,
76 X_MSG_DATA OUT NOCOPY VARCHAR2,
77 P_API_VERSION IN NUMBER,
78 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
79 );
80
81 -- Procedure to break down a service debrief labor activity into several labor coverage time segments -- based on the time and material labor schedule
82
83 PROCEDURE GET_LABOR_COVERAGES(
84 P_BUSINESS_PROCESS_ID IN NUMBER,
85 P_ACTIVITY_START_DATE_TIME IN DATE,
86 P_ACTIVITY_END_DATE_TIME IN DATE,
87 X_LABOR_COVERAGE_TBL OUT NOCOPY TM_COVERAGE_TBL_TYPE,
88 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
89 X_MSG_COUNT OUT NOCOPY NUMBER,
90 X_MSG_DATA OUT NOCOPY VARCHAR2,
91 P_API_VERSION IN NUMBER,
92 P_INIT_MSG_LIST IN VARCHAR2
93 );
94
95
96 END CS_TM_LABOR_SCHEDULE_PVT;