PACKAGE: APPS.IEC_HZ_PHONE_AREA_CODES_PKG

Source

1 package IEC_HZ_PHONE_AREA_CODES_PKG as
2 /* $Header: IECHZACS.pls 120.1 2005/07/19 13:06:57 appldev noship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_TERRITORY_CODE in VARCHAR2,
7   X_PHONE_COUNTRY_CODE in VARCHAR2,
8   X_AREA_CODE in VARCHAR2,
9 	X_DESCRIPTION in VARCHAR2,
10   X_CREATED_BY in NUMBER,
11   X_CREATION_DATE in DATE,
12   X_LAST_UPDATED_BY in NUMBER,
13   X_LAST_UPDATE_DATE in DATE,
14   X_LAST_UPDATE_LOGIN in NUMBER,
15   X_OBJECT_VERSION_NUMBER in NUMBER
16 );
17 
18 procedure LOCK_ROW (
19   X_TERRITORY_CODE in VARCHAR2,
20   X_PHONE_COUNTRY_CODE in VARCHAR2,
21   X_AREA_CODE in VARCHAR2,
22 	X_DESCRIPTION in VARCHAR2,
23   X_OBJECT_VERSION_NUMBER in NUMBER
24 );
25 
26 procedure UPDATE_ROW (
27   X_TERRITORY_CODE in VARCHAR2,
28   X_PHONE_COUNTRY_CODE in VARCHAR2,
29   X_AREA_CODE in VARCHAR2,
30 	X_DESCRIPTION in VARCHAR2,
31   X_LAST_UPDATED_BY in NUMBER,
32   X_LAST_UPDATE_DATE in DATE,
33   X_LAST_UPDATE_LOGIN in NUMBER,
34   X_OBJECT_VERSION_NUMBER in NUMBER
35 );
36 
37 procedure DELETE_ROW (
38   X_TERRITORY_CODE in VARCHAR2,
39   X_AREA_CODE in VARCHAR2
40 );
41 
42 procedure LOAD_ROW (
43   X_TERRITORY_CODE in VARCHAR2,
44   X_PHONE_COUNTRY_CODE in VARCHAR2,
45   X_AREA_CODE in VARCHAR2,
46   X_DESCRIPTION in VARCHAR2,
47   X_OWNER in VARCHAR2
48 );
49 
50 procedure LOAD_SEED_ROW (
51   X_upload_mode	in VARCHAR2,
52   X_TERRITORY_CODE in VARCHAR2,
53   X_PHONE_COUNTRY_CODE in VARCHAR2,
54   X_AREA_CODE in VARCHAR2,
55   X_DESCRIPTION in VARCHAR2,
56   X_OWNER in VARCHAR2
57 );
58 
59 procedure TRANSLATE_ROW (
60   X_TERRITORY_CODE in VARCHAR2,
61   X_PHONE_COUNTRY_CODE in VARCHAR2,
62   X_AREA_CODE in VARCHAR2,
63 	X_DESCRIPTION in VARCHAR2,
64   X_OWNER in VARCHAR2
65 );
66 
67 end IEC_HZ_PHONE_AREA_CODES_PKG;