PACKAGE: APPS.CAC_SR_OBJECT_CAPACITY_PKG

Source

1 package CAC_SR_OBJECT_CAPACITY_PKG as
2 /* $Header: cacsrocts.pls 120.1 2005/07/02 02:18:44 appldev noship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out nocopy VARCHAR2,
5   X_OBJECT_CAPACITY_ID in NUMBER,
6   X_OBJECT_VERSION_NUMBER in NUMBER,
7   X_OBJECT_TYPE in VARCHAR2,
8   X_OBJECT_ID in NUMBER,
9   X_START_DATE_TIME in DATE,
10   X_END_DATE_TIME in DATE,
11   X_AVAILABLE_HOURS in NUMBER,
12   X_AVAILABLE_HOURS_BEFORE in NUMBER,
13   X_AVAILABLE_HOURS_AFTER in NUMBER,
14   X_SCHEDULE_DETAIL_ID in NUMBER,
15   X_STATUS in NUMBER,
16   X_CREATION_DATE in DATE,
17   X_CREATED_BY in NUMBER,
18   X_LAST_UPDATE_DATE in DATE,
19   X_LAST_UPDATED_BY in NUMBER,
20   X_LAST_UPDATE_LOGIN in NUMBER
21 );
22 
23 procedure LOCK_ROW (
24   X_OBJECT_CAPACITY_ID in NUMBER,
25   X_OBJECT_VERSION_NUMBER in NUMBER,
26   X_OBJECT_TYPE in VARCHAR2,
27   X_OBJECT_ID in NUMBER,
28   X_START_DATE_TIME in DATE,
29   X_END_DATE_TIME in DATE,
30   X_AVAILABLE_HOURS in NUMBER,
31   X_AVAILABLE_HOURS_BEFORE in NUMBER,
32   X_AVAILABLE_HOURS_AFTER in NUMBER,
33   X_SCHEDULE_DETAIL_ID in NUMBER,
34   X_STATUS in NUMBER
35 );
36 
37 procedure UPDATE_ROW (
38   X_OBJECT_CAPACITY_ID in NUMBER,
39   X_OBJECT_VERSION_NUMBER in NUMBER,
40   X_OBJECT_TYPE in VARCHAR2,
41   X_OBJECT_ID in NUMBER,
42   X_START_DATE_TIME in DATE,
43   X_END_DATE_TIME in DATE,
44   X_AVAILABLE_HOURS in NUMBER,
45   X_AVAILABLE_HOURS_BEFORE in NUMBER,
46   X_AVAILABLE_HOURS_AFTER in NUMBER,
47   X_SCHEDULE_DETAIL_ID in NUMBER,
48   X_STATUS in NUMBER,
49   X_CREATION_DATE in DATE,
50   X_CREATED_BY in NUMBER,
51   X_LAST_UPDATE_DATE in DATE,
52   X_LAST_UPDATED_BY in NUMBER,
53   X_LAST_UPDATE_LOGIN in NUMBER
54 );
55 
56 procedure DELETE_ROW (
57   X_OBJECT_CAPACITY_ID in NUMBER
58 );
59 
60 end CAC_SR_OBJECT_CAPACITY_PKG;