[Home] [Help]
PACKAGE: APPS.HZ_PHONE_AREA_CODES_PKG
Source
1 PACKAGE HZ_PHONE_AREA_CODES_PKG AUTHID CURRENT_USER AS
2 /*$Header: ARHPHARS.pls 115.3 2003/09/06 01:40:10 awu noship $ */
3 PROCEDURE Insert_Row(
4 p_rowid IN OUT NOCOPY VARCHAR2,
5 p_TERRITORY_CODE VARCHAR2,
6 p_AREA_CODE VARCHAR2,
7 p_PHONE_COUNTRY_CODE VARCHAR2,
8 p_DESCRIPTION VARCHAR2,
9 p_CREATED_BY NUMBER,
10 p_CREATION_DATE DATE,
11 p_LAST_UPDATE_LOGIN NUMBER,
12 p_LAST_UPDATE_DATE DATE,
13 p_LAST_UPDATED_BY NUMBER,
14 p_OBJECT_VERSION_NUMBER NUMBER,
15 p_TIMEZONE_ID NUMBER DEFAULT NULL);
16
17
18 PROCEDURE Lock_Row(
19 p_TERRITORY_CODE IN OUT NOCOPY VARCHAR2,
20 p_AREA_CODE IN OUT NOCOPY VARCHAR2,
21 p_OBJECT_VERSION_NUMBER IN NUMBER);
22
23 PROCEDURE Update_Row(
24 p_rowid VARCHAR2,
25 p_TERRITORY_CODE VARCHAR2,
26 p_AREA_CODE VARCHAR2,
27 p_PHONE_COUNTRY_CODE VARCHAR2,
28 p_DESCRIPTION VARCHAR2,
29 p_CREATED_BY NUMBER,
30 p_CREATION_DATE DATE,
31 p_LAST_UPDATE_LOGIN NUMBER,
32 p_LAST_UPDATE_DATE DATE,
33 p_LAST_UPDATED_BY NUMBER,
34 p_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
35 p_TIMEZONE_ID NUMBER DEFAULT NULL);
36
37
38 PROCEDURE Delete_Row(p_TERRITORY_CODE VARCHAR2, P_AREA_CODE VARCHAR2);
39
40 END HZ_PHONE_AREA_CODES_PKG;