[Home] [Help]
PACKAGE: APPS.HZ_TIMEZONE_MAPPING_PKG
Source
1 PACKAGE HZ_TIMEZONE_MAPPING_PKG AUTHID CURRENT_USER as
2 /*$Header: ARHTZMPS.pls 120.2 2005/10/30 03:55:21 appldev ship $ */
3
4 PROCEDURE Insert_Row(
5 x_Rowid VARCHAR2,
6 x_MAPPING_ID NUMBER,
7 x_AREA_CODE VARCHAR2,
8 x_POSTAL_CODE VARCHAR2,
9 x_CITY VARCHAR2,
10 x_STATE VARCHAR2,
11 x_PROVINCE VARCHAR2,
12 x_COUNTRY VARCHAR2,
13 x_TIMEZONE_ID NUMBER,
14 x_CREATION_DATE DATE,
15 x_CREATED_BY NUMBER,
16 x_LAST_UPDATE_DATE DATE,
17 x_LAST_UPDATED_BY NUMBER,
18 x_LAST_UPDATE_LOGIN NUMBER);
19
20
21
22 PROCEDURE Lock_Row(
23 x_Rowid VARCHAR2,
24 x_MAPPING_ID NUMBER,
25 x_AREA_CODE VARCHAR2,
26 x_POSTAL_CODE VARCHAR2,
27 x_CITY VARCHAR2,
28 x_STATE VARCHAR2,
29 x_PROVINCE VARCHAR2,
30 x_COUNTRY VARCHAR2,
31 x_TIMEZONE_ID NUMBER,
32 x_CREATION_DATE DATE,
33 x_CREATED_BY NUMBER,
34 x_LAST_UPDATE_DATE DATE,
35 x_LAST_UPDATED_BY NUMBER,
36 x_LAST_UPDATE_LOGIN NUMBER);
37
38
39
40 PROCEDURE Update_Row(
41 x_Rowid VARCHAR2,
42 x_MAPPING_ID NUMBER,
43 x_AREA_CODE VARCHAR2,
44 x_POSTAL_CODE VARCHAR2,
45 x_CITY VARCHAR2,
46 x_STATE VARCHAR2,
47 x_PROVINCE VARCHAR2,
48 x_COUNTRY VARCHAR2,
49 x_TIMEZONE_ID NUMBER,
50 x_CREATION_DATE DATE,
51 x_CREATED_BY NUMBER,
52 x_LAST_UPDATE_DATE DATE,
53 x_LAST_UPDATED_BY NUMBER,
54 x_LAST_UPDATE_LOGIN NUMBER);
55
56
57
58 PROCEDURE Delete_Row( x_MAPPING_ID NUMBER);
59
60 END HZ_TIMEZONE_MAPPING_PKG;