PACKAGE: APPS.RRS_SITESTH_PKG

Source

1 package RRS_SITESTH_PKG as
2 /* $Header: RRSSTHPS.pls 120.2 2005/12/29 06:31 pfarkade noship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out nocopy VARCHAR2,
5   X_SITE_ID in NUMBER,
6   X_SITE_IDENTIFICATION_NUMBER in VARCHAR2,
7   X_SITE_TYPE_CODE in VARCHAR2,
8   X_SITE_STATUS_CODE in VARCHAR2,
9   X_BRANDNAME_CODE in VARCHAR2,
10   X_CALENDAR_CODE in VARCHAR2,
11   X_LOCATION_ID in NUMBER,
12   X_SITE_PARTY_ID in NUMBER,
13   X_PARTY_SITE_ID in NUMBER,
14   X_LE_PARTY_ID in NUMBER,
15   X_PROPERTY_LOCATION_ID in NUMBER,
16   X_TEMPLATE_COUNTRY in VARCHAR2,
17   X_START_DATE in DATE,
18   X_END_DATE in DATE,
19   X_IS_TEMPLATE_FLAG in VARCHAR2,
20   X_OBJECT_VERSION_NUMBER in NUMBER,
21   X_NAME in VARCHAR2,
22   X_CREATION_DATE in DATE,
23   X_CREATED_BY in NUMBER,
24   X_LAST_UPDATE_DATE in DATE,
25   X_LAST_UPDATED_BY in NUMBER,
26   X_LAST_UPDATE_LOGIN in NUMBER,
27   X_ORGANIZATION_ID in NUMBER,
28   X_DESCRIPTION in VARCHAR2
29   );
30 procedure LOCK_ROW (
31   X_SITE_ID in NUMBER,
32   X_SITE_IDENTIFICATION_NUMBER in VARCHAR2,
33   X_SITE_TYPE_CODE in VARCHAR2,
34   X_SITE_STATUS_CODE in VARCHAR2,
35   X_BRANDNAME_CODE in VARCHAR2,
36   X_CALENDAR_CODE in VARCHAR2,
37   X_LOCATION_ID in NUMBER,
38   X_SITE_PARTY_ID in NUMBER,
39   X_PARTY_SITE_ID in NUMBER,
40   X_LE_PARTY_ID in NUMBER,
41   X_PROPERTY_LOCATION_ID in NUMBER,
42   X_TEMPLATE_COUNTRY in VARCHAR2,
43   X_START_DATE in DATE,
44   X_END_DATE in DATE,
45   X_IS_TEMPLATE_FLAG in VARCHAR2,
46   X_OBJECT_VERSION_NUMBER in NUMBER,
47   X_NAME in VARCHAR2,
48   X_ORGANIZATION_ID in NUMBER,
49   X_DESCRIPTION in VARCHAR2
50 );
51 procedure UPDATE_ROW (
52   X_SITE_ID in NUMBER,
53   X_SITE_IDENTIFICATION_NUMBER in VARCHAR2,
54   X_SITE_TYPE_CODE in VARCHAR2,
55   X_SITE_STATUS_CODE in VARCHAR2,
56   X_BRANDNAME_CODE in VARCHAR2,
57   X_CALENDAR_CODE in VARCHAR2,
58   X_LOCATION_ID in NUMBER,
59   X_SITE_PARTY_ID in NUMBER,
60   X_PARTY_SITE_ID in NUMBER,
61   X_LE_PARTY_ID in NUMBER,
62   X_PROPERTY_LOCATION_ID in NUMBER,
63   X_TEMPLATE_COUNTRY in VARCHAR2,
64   X_START_DATE in DATE,
65   X_END_DATE in DATE,
66   X_IS_TEMPLATE_FLAG in VARCHAR2,
67   X_OBJECT_VERSION_NUMBER in NUMBER,
68   X_NAME in VARCHAR2,
69   X_LAST_UPDATE_DATE in DATE,
70   X_LAST_UPDATED_BY in NUMBER,
71   X_LAST_UPDATE_LOGIN in NUMBER,
72   X_ORGANIZATION_ID in NUMBER,
73   X_DESCRIPTION in VARCHAR2
74 );
75 procedure DELETE_ROW (
76   X_SITE_ID in NUMBER
77 );
78 procedure ADD_LANGUAGE;
79 end RRS_SITESTH_PKG;