[Home] [Help]
PACKAGE: APPS.HZ_MOBILE_PREFIXES_PKG
Source
1 PACKAGE HZ_MOBILE_PREFIXES_PKG AS
2 /*$Header: ARHMOPRS.pls 120.1 2005/06/16 21:12:35 jhuang noship $ */
3
4 PROCEDURE Insert_Row(
5 p_rowid IN OUT NOCOPY VARCHAR2,
6 p_TERRITORY_CODE VARCHAR2,
7 p_MOBILE_PREFIX VARCHAR2,
8 p_PHONE_COUNTRY_CODE VARCHAR2,
9 p_DESCRIPTION VARCHAR2,
10 p_CREATED_BY NUMBER,
11 p_CREATION_DATE DATE,
12 p_LAST_UPDATE_LOGIN NUMBER,
13 p_LAST_UPDATE_DATE DATE,
14 p_LAST_UPDATED_BY NUMBER,
15 p_OBJECT_VERSION_NUMBER NUMBER);
16
17
18 PROCEDURE Lock_Row(
19 p_TERRITORY_CODE IN OUT NOCOPY VARCHAR2,
20 p_MOBILE_PREFIX 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_MOBILE_PREFIX 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
36
37 PROCEDURE Delete_Row(p_TERRITORY_CODE VARCHAR2, P_MOBILE_PREFIX VARCHAR2);
38
39 END HZ_MOBILE_PREFIXES_PKG;