[Home] [Help]
PACKAGE: APPS.MTL_MVT_STATS_RULES_PKG
Source
1 PACKAGE MTL_MVT_STATS_RULES_PKG AUTHID CURRENT_USER AS
2 -- $Header: INVGMVRS.pls 115.2 2002/12/03 21:50:24 vma ship $
3 --+=======================================================================+
4 --| Copyright (c) 1998 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| INVGMVRS.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_MVT_STATS_RULES |
14 --| |
15 --| HISTORY |
16 --| 07/14/00 ksaini Created |
17 --| 09/18/00 ksaini Delete_Row procedure corrected |
18 --| 11/22/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 --PUBLIC PROCEDURE
25 --==================
26 --========================================================================
27 --PRECEDURE : Insert_Row Public
28 --PARAMETERS: see below
29 --COMMENT : table handler for inserting data to table MTL_MVT_STATS_RULES
30 --========================================================================
31 PROCEDURE Insert_Row
32 ( x_rowid IN OUT NOCOPY VARCHAR2
33 , p_rule_set_code IN VARCHAR2
34 , p_rule_number IN NUMBER
35 , p_source_type IN VARCHAR2
36 , p_attribute_code IN VARCHAR2
37 , p_attribute_property_code IN VARCHAR2
38 , p_attribute_lookup_type IN VARCHAR2
39 , p_commodity_code IN VARCHAR2
40 , p_creation_date IN DATE
41 , p_created_by IN NUMBER
42 , p_last_update_date IN DATE
43 , p_last_updated_by IN NUMBER
44 , p_last_update_login IN NUMBER
45 );
46
47 --========================================================================
48 --PRECEDURE : Lock_Row Public
49 --PARAMETERS: see below
50 --COMMENT : table handler for locking table MTL_MVT_STATS_RULES
51 --========================================================================
52 PROCEDURE Lock_Row
53 ( p_rowid IN VARCHAR2
54 , p_rule_set_code IN VARCHAR2
55 , p_rule_number IN NUMBER
56 , p_source_type IN VARCHAR2
57 , p_attribute_code IN VARCHAR2
58 , p_attribute_property_code IN VARCHAR2
59 , p_attribute_lookup_type IN VARCHAR2
60 , p_commodity_code IN VARCHAR2
61 );
62
63 --========================================================================
64 --PRECEDURE : Update_Row Public
65 --PARAMETERS: see below
66 -- initial version 1.0
67 --COMMENT : table handler for updating data of table MTL_MVT_STATS_RULES
68 --========================================================================
69 PROCEDURE Update_Row
70 ( p_rowid IN VARCHAR2
71 , p_rule_set_code IN VARCHAR2
72 , p_rule_number IN NUMBER
73 , p_source_type IN VARCHAR2
74 , p_attribute_code IN VARCHAR2
75 , p_attribute_property_code IN VARCHAR2
76 , p_attribute_lookup_type IN VARCHAR2
77 , p_commodity_code IN VARCHAR2
78 , p_last_update_date IN DATE
79 , p_last_updated_by IN NUMBER
80 , p_last_update_login IN NUMBER
81 );
82
83 --========================================================================
84 --PRECEDURE : Delete_Row Public
85 --PARAMETERS: see below
86 --COMMENT : table handler for deleting data from table MTL_MVT_STATS_RULES
87 --========================================================================
88 PROCEDURE Delete_Row
89 ( p_rule_set_code IN VARCHAR2
90 );
91
92 END MTL_MVT_STATS_RULES_PKG;