APPS.HZ_TIMEZONE_MAPPING_PKG dependencies on HZ_TIMEZONE_MAPPING

Line 1: PACKAGE BODY HZ_TIMEZONE_MAPPING_PKG as

1: PACKAGE BODY HZ_TIMEZONE_MAPPING_PKG as
2: /*$Header: ARHTZMPB.pls 120.2 2005/10/30 03:55:20 appldev ship $ */
3:
4:
5: PROCEDURE Insert_Row(

Line 21: CURSOR C IS SELECT rowid FROM HZ_TIMEZONE_MAPPING

17: x_LAST_UPDATE_DATE DATE,
18: x_LAST_UPDATED_BY NUMBER,
19: x_LAST_UPDATE_LOGIN NUMBER
20: ) IS
21: CURSOR C IS SELECT rowid FROM HZ_TIMEZONE_MAPPING
22: WHERE MAPPING_ID = x_MAPPING_ID;
23: CURSOR C2 IS SELECT HZ_TIMEZONE_MAP_s.nextval FROM sys.dual;
24: v_MAPPING_ID number;
25: v_ROWID varchar2(30);

Line 32: INSERT INTO HZ_TIMEZONE_MAPPING(

28: OPEN C2;
29: FETCH C2 INTO v_MAPPING_ID;
30: CLOSE C2;
31: End If;
32: INSERT INTO HZ_TIMEZONE_MAPPING(
33: MAPPING_ID,
34: AREA_CODE,
35: POSTAL_CODE,
36: CITY,

Line 73: DELETE FROM HZ_TIMEZONE_MAPPING

69:
70: PROCEDURE Delete_Row( x_MAPPING_ID NUMBER
71: ) IS
72: BEGIN
73: DELETE FROM HZ_TIMEZONE_MAPPING
74: WHERE MAPPING_ID = x_MAPPING_ID;
75: If (SQL%NOTFOUND) then
76: RAISE NO_DATA_FOUND;
77: End If;

Line 99: Update HZ_TIMEZONE_MAPPING

95: x_LAST_UPDATED_BY NUMBER,
96: x_LAST_UPDATE_LOGIN NUMBER
97: ) IS
98: BEGIN
99: Update HZ_TIMEZONE_MAPPING
100: SET
101: MAPPING_ID = decode( x_MAPPING_ID, FND_API.G_MISS_NUM,MAPPING_ID,x_MAPPING_ID),
102: AREA_CODE = decode( x_AREA_CODE, FND_API.G_MISS_CHAR,AREA_CODE,x_AREA_CODE),
103: POSTAL_CODE = decode( x_POSTAL_CODE, FND_API.G_MISS_CHAR,POSTAL_CODE,x_POSTAL_CODE),

Line 144: FROM HZ_TIMEZONE_MAPPING

140: x_LAST_UPDATE_LOGIN NUMBER
141: ) IS
142: CURSOR C IS
143: SELECT *
144: FROM HZ_TIMEZONE_MAPPING
145: WHERE rowid = x_Rowid
146: FOR UPDATE of MAPPING_ID NOWAIT;
147: Recinfo C%ROWTYPE;
148: BEGIN

Line 205: END HZ_TIMEZONE_MAPPING_PKG;

201: APP_EXCEPTION.RAISE_EXCEPTION;
202: End If;
203: END Lock_Row;
204:
205: END HZ_TIMEZONE_MAPPING_PKG;