[Home] [Help]
PACKAGE: APPS.HZ_PHONE_FORMATS_PKG
Source
1 PACKAGE HZ_PHONE_FORMATS_PKG AS
2 /*$Header: ARHPHFPS.pls 120.1 2005/06/16 21:14:14 jhuang noship $ */
3 PROCEDURE Insert_Row(
4 p_rowid IN OUT NOCOPY VARCHAR2,
5 p_TERRITORY_CODE VARCHAR2,
6 p_PHONE_FORMAT_STYLE VARCHAR2,
7 p_COUNTRY_CODE_DISPLAY_FLAG VARCHAR2,
8 p_AREA_CODE_SIZE NUMBER,
9 p_FORMAT_NAME VARCHAR2,
10 p_DESCRIPTION VARCHAR2,
11 p_CREATED_BY NUMBER,
12 p_CREATION_DATE DATE,
13 p_LAST_UPDATE_LOGIN NUMBER,
14 p_LAST_UPDATE_DATE DATE,
15 p_LAST_UPDATED_BY NUMBER,
16 p_OBJECT_VERSION_NUMBER NUMBER);
17
18
19 PROCEDURE Lock_Row(
20 p_TERRITORY_CODE IN OUT NOCOPY VARCHAR2,
21 p_PHONE_FORMAT_STYLE IN OUT NOCOPY VARCHAR2,
22 p_OBJECT_VERSION_NUMBER IN NUMBER);
23
24 PROCEDURE Update_Row(
25 p_rowid VARCHAR2,
26 p_TERRITORY_CODE VARCHAR2,
27 p_PHONE_FORMAT_STYLE VARCHAR2,
28 p_COUNTRY_CODE_DISPLAY_FLAG VARCHAR2,
29 p_AREA_CODE_SIZE NUMBER,
30 p_FORMAT_NAME VARCHAR2,
31 p_DESCRIPTION VARCHAR2,
32 p_CREATED_BY NUMBER,
33 p_CREATION_DATE DATE,
34 p_LAST_UPDATE_LOGIN NUMBER,
35 p_LAST_UPDATE_DATE DATE,
36 p_LAST_UPDATED_BY NUMBER,
37 p_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER);
38
39
40 PROCEDURE Delete_Row(p_TERRITORY_CODE VARCHAR2, P_PHONE_FORMAT_STYLE VARCHAR2);
41
42 END HZ_PHONE_FORMATS_PKG;