[Home] [Help]
PACKAGE: APPS.MTL_ECONOMIC_ZONES_PKG
Source
1 PACKAGE MTL_ECONOMIC_ZONES_PKG AUTHID CURRENT_USER AS
2 -- $Header: INVGEZNS.pls 115.5 2002/12/03 21:44:48 vma ship $
3 --+=======================================================================+
4 --| Copyright (c) 1998,1999 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| INVGEZNS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Use this package to create procedure for inserting row, updateing |
13 --| row, locking row and deleting row on tables MTL_ECONOMIC_ZONES and|
14 --| MTL_ECONOMIC_ZONES_TL |
15 --| |
16 --| HISTORY |
17 --| 12/17/98 yawang Created |
18 --| 07/06/99 pjuvara added translate_row, uplaod_row |
19 --| 11/26/02 vma added NOCOPY to x_rowid of Insert_Row to |
20 --| comply with new PL/SQL standard for better |
21 --| performance |
22 --| |
23 --+======================================================================*/
24
25 --==================
26 --PUBLIC PROCEDURE
27 --==================
28 --========================================================================
29 --PRECEDURE : Insert_Row Public
30 --PARAMETERS: see below
31 --COMMENT : table handler for inserting data to table mtl_economic_zones
32 -- _b and table mtl_economic_zones_tl
33 --========================================================================
34 PROCEDURE Insert_Row
35 ( x_rowid IN OUT NOCOPY VARCHAR2
36 , p_zone_code IN VARCHAR2
37 , p_zone_display_name IN VARCHAR2
38 , p_zone_description IN VARCHAR2
39 , p_creation_date IN DATE
40 , p_created_by IN NUMBER
41 , p_last_update_date IN DATE
42 , p_last_updated_by IN NUMBER
43 , p_last_update_login IN NUMBER
44 );
45
46 --========================================================================
47 --PRECEDURE : Lock_Row Public
48 --PARAMETERS: see below
49 --COMMENT : table handler for locking table mtl_economic_zones_b and
50 -- table mtl_economic_zones_tl
51 --========================================================================
52 PROCEDURE Lock_Row
53 ( p_zone_code IN VARCHAR2
54 , p_zone_display_name IN VARCHAR2
55 , p_zone_description IN VARCHAR2
56 );
57
58 --========================================================================
59 --PRECEDURE : Update_Row Public
60 --PARAMETERS: see below
61 --COMMENT : table handler for updating data to table mtl_economic_zones
62 -- _b and table mtl_economic_zones_tl
63 --========================================================================
64 PROCEDURE Update_Row
65 ( p_zone_code IN VARCHAR2
66 , p_zone_display_name IN VARCHAR2
67 , p_zone_description IN VARCHAR2
68 , p_last_update_date IN DATE
69 , p_last_updated_by IN NUMBER
70 , p_last_update_login IN NUMBER
71 );
72
73 --========================================================================
74 --PRECEDURE : Delete_Row Public
75 --PARAMETERS: see below
76 --COMMENT : table handler for deleting data from table mtl_economic_zones
77 -- _b and table mtl_economic_zones_tl
78 --========================================================================
79 PROCEDURE Delete_Row
80 ( p_zone_code IN VARCHAR2
81 );
82
83 --========================================================================
84 --PRECEDURE : Add_Language Public
85 --PARAMETERS: none
86 --COMMENT : Called by NLADD script whenever a new language is added or
87 -- after any other operation
88 --========================================================================
89 PROCEDURE Add_Language;
90 --
91 --========================================================================
92 -- PROCEDURE : Translate_Row PUBLIC
93 -- PARAMETERS: p_zone_code economic zone code (develper's key)
94 -- p_zone_display_name economic zone name
95 -- p_zone_description description
96 -- p_owner user owning the row (SEED or other)
97 -- COMMENT : used to upload seed data in NLS mode
98 --========================================================================
99 PROCEDURE Translate_Row
100 ( p_zone_code IN VARCHAR2
101 , p_zone_display_name IN VARCHAR2
102 , p_zone_description IN VARCHAR2
103 , p_owner IN VARCHAR2
104 );
105
106 --========================================================================
107 -- PRECEDURE : Load_Row PUBLIC
108 -- PARAMETERS: p_zone_code economic zone code (develper's key)
109 -- p_owner user owning the row (SEED or other)
110 -- p_zone_display_name economic zone name
111 -- p_zone_description description
112 -- COMMENT : used to upload seed data in MLS mode
113 --========================================================================
114 PROCEDURE Load_Row
115 ( p_zone_code IN VARCHAR2
116 , p_owner IN VARCHAR2
117 , p_zone_display_name IN VARCHAR2
118 , p_zone_description IN VARCHAR2
119 );
120
121 END MTL_ECONOMIC_ZONES_PKG;