eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MTL_MVT_STATS_RULES_PKG dependencies on MTL_MVT_STATS_RULES

Line 1: PACKAGE BODY MTL_MVT_STATS_RULES_PKG AS

1: PACKAGE BODY MTL_MVT_STATS_RULES_PKG AS
2: -- $Header: INVGMVRB.pls 115.2 2002/12/03 21:48:40 vma ship $
3: --+=======================================================================+
4: --| Copyright (c) 1998 Oracle Corporation |
5: --| Redwood Shores, CA, USA |

Line 13: --| row, locking row and deleting row on tables MTL_MVT_STATS_RULES |

9: --| INVGMVRB.pls |
10: --| |
11: --| DESCRIPTION |
12: --| Use this package to create procedure for inserting row, updating |
13: --| row, locking row and deleting row on tables MTL_MVT_STATS_RULES |
14: --| |
15: --| PROCEDURE LIST |
16: --| PROCEDURE Insert_Row |
17: --| PROCEDURE Update_Row |

Line 32: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MTL_MVT_STATS_RULES_PKG';

28:
29: --==================
30: --CONSTANTS
31: --==================
32: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MTL_MVT_STATS_RULES_PKG';
33:
34: --==================
35: --PUBLIC PROCEDURE
36: --==================

Line 40: --COMMENT : table handler for inserting data to table mtl_mvt_stats_rules

36: --==================
37: --========================================================================
38: --PRECEDURE : Insert_Row Public
39: --PARAMETERS: see below
40: --COMMENT : table handler for inserting data to table mtl_mvt_stats_rules
41: -- assignments
42: --========================================================================
43: PROCEDURE Insert_Row
44: ( x_rowid IN OUT NOCOPY VARCHAR2

Line 63: mtl_mvt_stats_rules

59: CURSOR c IS
60: SELECT
61: rowid
62: FROM
63: mtl_mvt_stats_rules
64: WHERE rule_set_code = p_rule_set_code
65: AND rule_number = p_rule_number;
66:
67: BEGIN

Line 68: INSERT INTO mtl_mvt_stats_rules

64: WHERE rule_set_code = p_rule_set_code
65: AND rule_number = p_rule_number;
66:
67: BEGIN
68: INSERT INTO mtl_mvt_stats_rules
69: ( rule_set_code
70: , rule_number
71: , source_type
72: , attribute_code

Line 119: --COMMENT : table handler for locking table mtl_mvt_stats_rules

115:
116: --========================================================================
117: --PRECEDURE : Lock_Row Public
118: --PARAMETERS: see below
119: --COMMENT : table handler for locking table mtl_mvt_stats_rules
120: --EXCEPTION : record_changed
121: --========================================================================
122: PROCEDURE Lock_Row
123: ( p_rowid IN VARCHAR2

Line 136: mtl_mvt_stats_rules

132: IS
133: cursor c IS
134: SELECT *
135: FROM
136: mtl_mvt_stats_rules
137: WHERE
138: rowid = p_rowid
139: FOR UPDATE OF rule_set_code nowait;
140: recinfo c%ROWTYPE;

Line 190: --COMMENT : table handler for updating data of table MTL_MVT_STATS_RULES

186:
187: --========================================================================
188: --PRECEDURE : Update_Row Public
189: --PARAMETERS: see below
190: --COMMENT : table handler for updating data of table MTL_MVT_STATS_RULES
191: --========================================================================
192: PROCEDURE Update_Row
193: ( p_rowid IN VARCHAR2
194: , p_rule_set_code IN VARCHAR2

Line 207: UPDATE mtl_mvt_stats_rules

203: , p_last_update_login IN NUMBER
204: )
205: IS
206: BEGIN
207: UPDATE mtl_mvt_stats_rules
208: SET rule_set_code = p_rule_set_code
209: , rule_number = p_rule_number
210: , source_type = p_source_type
211: , attribute_code = p_attribute_code

Line 237: --COMMENT : table handler for deleting data from table MTL_MVT_STATS_RULES

233:
234: --========================================================================
235: --PRECEDURE : Delete_Row Public
236: --PARAMETERS: see below
237: --COMMENT : table handler for deleting data from table MTL_MVT_STATS_RULES
238: --========================================================================
239: PROCEDURE Delete_row
240: ( p_rule_set_code IN VARCHAR2
241: )

Line 245: mtl_mvt_stats_rules

241: )
242: IS
243: BEGIN
244: DELETE FROM
245: mtl_mvt_stats_rules
246: WHERE
247: rule_set_code = p_rule_set_code;
248: IF (SQL%NOTFOUND)
249: THEN

Line 265: END MTL_MVT_STATS_RULES_PKG;

261: RAISE;
262:
263: END Delete_row;
264:
265: END MTL_MVT_STATS_RULES_PKG;