1 PACKAGE MTL_COUNTRY_ASSIGNMENTS_PKG AUTHID CURRENT_USER AS
2 -- $Header: INVGCTRS.pls 115.4 2002/12/03 21:36:17 vma ship $
3 --+=======================================================================+
4 --| Copyright (c) 1998 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| INVGCTRS.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_COUNTRY_ASSIGNMENTS|
14 --| |
15 --| HISTORY |
16 --| 12/18/98 yawang Created |
17 --| 11/22/02 vma Added NOCOPY to IN OUT parameter of |
18 --| to improve performance. |
19 --| |
20 --+======================================================================*/
21
22 --==================
23 --PUBLIC PROCEDURE
24 --==================
25 --========================================================================
26 --PRECEDURE : Insert_Row Public
27 --PARAMETERS: see below
28 --COMMENT : table handler for inserting data to table mtl_country_
29 -- assignments
30 --========================================================================
31 PROCEDURE Insert_Row
32 ( x_rowid IN OUT NOCOPY VARCHAR2
33 , p_zone_code IN VARCHAR2
34 , p_territory_code IN VARCHAR2
35 , p_territory_short_name IN VARCHAR2
36 , p_start_date IN DATE
37 , p_end_date IN DATE
38 , p_creation_date IN DATE
39 , p_created_by IN NUMBER
40 , p_last_update_date IN DATE
41 , p_last_updated_by IN NUMBER
42 , p_last_update_login IN NUMBER
43 );
44
45 --========================================================================
46 --PRECEDURE : Lock_Row Public
47 --PARAMETERS: see below
48 --COMMENT : table handler for locking table mtl_country_assignments
49 --========================================================================
50 PROCEDURE Lock_Row
51 ( p_rowid IN VARCHAR2
52 , p_zone_code IN VARCHAR2
53 , p_territory_code IN VARCHAR2
54 , p_start_date IN DATE
55 , p_end_date IN DATE
56 );
57
58 --========================================================================
59 --PRECEDURE : Update_Row Public
60 --PARAMETERS: see below
61 -- initial version 1.0
62 --COMMENT : table handler for updating data of table mtl_country_
63 -- assignments
64 --========================================================================
65 PROCEDURE Update_Row
66 ( p_rowid IN VARCHAR2
67 , p_zone_code IN VARCHAR2
68 , p_territory_code IN VARCHAR2
69 , p_start_date IN DATE
70 , p_end_date IN DATE
71 , p_last_update_date IN DATE
72 , p_last_updated_by IN NUMBER
73 , p_last_update_login IN NUMBER
74 );
75
76 --========================================================================
77 --PRECEDURE : Delete_Row Public
78 --PARAMETERS: see below
79 --COMMENT : table handler for deleting data from table mtl_country_
80 -- assignments
81 --========================================================================
82 PROCEDURE Delete_Row
83 ( p_rowid IN VARCHAR2
84 );
85
86 END MTL_COUNTRY_ASSIGNMENTS_PKG;