APPS.HZ_MOBILE_PREFIXES_PKG dependencies on HZ_MOBILE_PREFIXES

Line 1: PACKAGE BODY HZ_MOBILE_PREFIXES_PKG AS

1: PACKAGE BODY HZ_MOBILE_PREFIXES_PKG AS
2: /*$Header: ARHMOPRB.pls 120.2 2005/06/16 21:12:33 jhuang noship $ */
3: PROCEDURE Insert_Row(
4: p_rowid IN OUT NOCOPY VARCHAR2,
5: p_TERRITORY_CODE VARCHAR2,

Line 16: CURSOR C IS SELECT rowid FROM HZ_MOBILE_PREFIXES

12: p_LAST_UPDATE_DATE DATE,
13: p_LAST_UPDATED_BY NUMBER,
14: p_OBJECT_VERSION_NUMBER NUMBER) IS
15:
16: CURSOR C IS SELECT rowid FROM HZ_MOBILE_PREFIXES
17: WHERE TERRITORY_CODE = p_TERRITORY_CODE
18: AND MOBILE_PREFIX = p_MOBILE_PREFIX;
19:
20:

Line 23: insert into HZ_MOBILE_PREFIXES(

19:
20:
21: begin
22:
23: insert into HZ_MOBILE_PREFIXES(
24: TERRITORY_CODE,
25: MOBILE_PREFIX,
26: PHONE_COUNTRY_CODE,
27: DESCRIPTION ,

Line 72: UPDATE HZ_MOBILE_PREFIXES

68:
69: BEGIN
70:
71: l_object_version_number := NVL(p_object_version_number, 1) + 1;
72: UPDATE HZ_MOBILE_PREFIXES
73: SET
74: TERRITORY_CODE = decode(p_TERRITORY_CODE, FND_API.G_MISS_CHAR,
75: TERRITORY_CODE, p_TERRITORY_CODE),
76: MOBILE_PREFIX = decode(p_MOBILE_PREFIX, FND_API.G_MISS_CHAR,

Line 114: FROM HZ_MOBILE_PREFIXES

110: IS
111: CURSOR C IS
112:
113: SELECT OBJECT_VERSION_NUMBER
114: FROM HZ_MOBILE_PREFIXES
115: WHERE TERRITORY_CODE = p_TERRITORY_CODE
116: AND MOBILE_PREFIX = p_MOBILE_PREFIX
117: FOR UPDATE OF TERRITORY_CODE , MOBILE_PREFIX NOWAIT;
118: Recinfo C%ROWTYPE;

Line 144: DELETE FROM HZ_MOBILE_PREFIXES

140: END Lock_Row;
141:
142: PROCEDURE Delete_Row(p_TERRITORY_CODE VARCHAR2, P_MOBILE_PREFIX VARCHAR2 ) IS
143: BEGIN
144: DELETE FROM HZ_MOBILE_PREFIXES
145: WHERE TERRITORY_CODE = p_TERRITORY_CODE
146: AND MOBILE_PREFIX = p_MOBILE_PREFIX;
147:
148: If (SQL%NOTFOUND) then