PACKAGE: APPS.IEC_G_REGION_MAPPINGS_PKG

Source

1 package IEC_G_REGION_MAPPINGS_PKG AUTHID CURRENT_USER as
2 /* $Header: IECRGNMS.pls 120.1 2005/07/19 13:07:13 appldev noship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_TERRITORY_CODE in VARCHAR2,
7   X_PHONE_AREA_CODE in VARCHAR2,
8 	X_REGION_ID in NUMBER,
9   X_CREATED_BY in NUMBER,
10   X_CREATION_DATE in DATE,
11   X_LAST_UPDATED_BY in NUMBER,
12   X_LAST_UPDATE_DATE in DATE,
13   X_LAST_UPDATE_LOGIN in NUMBER,
14   X_OBJECT_VERSION_NUMBER in NUMBER
15 );
16 
17 procedure LOCK_ROW (
18   X_TERRITORY_CODE in VARCHAR2,
19   X_PHONE_AREA_CODE in VARCHAR2,
20 	X_REGION_ID in NUMBER,
21   X_OBJECT_VERSION_NUMBER in NUMBER
22 );
23 
24 procedure UPDATE_ROW (
25   X_TERRITORY_CODE in VARCHAR2,
26   X_PHONE_AREA_CODE in VARCHAR2,
27 	X_REGION_ID in NUMBER,
28   X_LAST_UPDATED_BY in NUMBER,
29   X_LAST_UPDATE_DATE in DATE,
30   X_LAST_UPDATE_LOGIN in NUMBER,
31   X_OBJECT_VERSION_NUMBER in NUMBER
32 );
33 
34 procedure DELETE_ROW (
35   X_TERRITORY_CODE in VARCHAR2,
36   X_PHONE_AREA_CODE in VARCHAR2
37 );
38 
39 procedure LOAD_ROW (
40   X_TERRITORY_CODE in VARCHAR2,
41   X_PHONE_AREA_CODE in VARCHAR2,
42   X_REGION_ID in NUMBER,
43   X_OWNER in VARCHAR2
44 );
45 
46 procedure LOAD_SEED_ROW (
47   X_upload_mode	in VARCHAR2,
48   X_TERRITORY_CODE in VARCHAR2,
49   X_PHONE_AREA_CODE in VARCHAR2,
50   X_REGION_ID in NUMBER,
51   X_OWNER in VARCHAR2
52 );
53 
54 procedure TRANSLATE_ROW (
55   X_TERRITORY_CODE in VARCHAR2,
56   X_PHONE_AREA_CODE in VARCHAR2,
57 	X_REGION_ID in NUMBER,
58   X_OWNER in VARCHAR2
59 );
60 
61 end IEC_G_REGION_MAPPINGS_PKG;