[Home] [Help]
PACKAGE: APPS.WIP_INFRESSCHED_GRP
Source
1 package wip_infResSched_grp AUTHID CURRENT_USER as
2 /* $Header: wipinrss.pls 120.0.12010000.1 2008/07/24 05:22:54 appldev ship $ */
3
4 type num_tbl_t is table of number;
5 type date_tbl_t is table of date;
6
7
8 /*
9 type op_res_usage_rectbl_t is record(startDate date_tbl_t,
10 endDate date_tbl_t,
11 cumMinProcTime num_tbl_t);--cumulative proc time in minutes
12
13 type op_res_usage_tbl_t is table of op_res_usage_rectbl_t index by binary_integer;
14 */
15 type op_res_rectbl_t is record(opSeqNum num_tbl_t,
16 resID num_tbl_t,
17 deptID num_tbl_t,
18 resSeqNum num_tbl_t,
19 schedSeqNum num_tbl_t,
20 schedFlag num_tbl_t,
21 avail24Flag num_tbl_t,
22 startDate date_tbl_t,
23 endDate date_tbl_t,
24 totalDaysUsg num_tbl_t,
25 usgStartIdx num_tbl_t,
26 usgEndIdx num_tbl_t,
27 usgStartDate date_tbl_t,
28 usgEndDate date_tbl_t,
29 usgCumMinProcTime num_tbl_t);
30
31
32
33 procedure schedule(p_orgID IN NUMBER,
34 p_repLineID NUMBER := null,
35 p_startDate DATE := null,
36 p_endDate DATE := null,
37 p_opSeqNum NUMBER := null,
38 p_resSeqNum NUMBER := null,
39 p_endDebug VARCHAR2 := null,
40 x_resTbls IN OUT NOCOPY OP_RES_RECTBL_T,
41 x_returnStatus OUT NOCOPY VARCHAR2);
42
43 procedure dumpResources(p_resTbls IN OP_RES_RECTBL_T);
44
45 end wip_infResSched_grp;