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