PACKAGE: APPS.WIP_INFRESSCHED_GRP

Source

1 package wip_infResSched_grp 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;