APPS.MTL_STAT_TYPE_USAGES_PKG dependencies on MTL_STAT_TYPE_USAGES

Line 1: PACKAGE BODY MTL_STAT_TYPE_USAGES_PKG AS

1: PACKAGE BODY MTL_STAT_TYPE_USAGES_PKG AS
2: --$Header: INVGSTUB.pls 120.2.12000000.2 2007/04/17 06:26:13 nesoni ship $
3: --+=======================================================================+
4: --| Copyright (c) 1999, 2000 Oracle Corporation |
5: --| Redwood Shores, CA, USA |

Line 12: --| Body of package MTL_STAT_TYPE_USAGES_PKG, table |

8: --| FILENAME |
9: --| INVGSTUB.pls |
10: --| |
11: --| DESCRIPTION |
12: --| Body of package MTL_STAT_TYPE_USAGES_PKG, table |
13: --| handler for table MTL_STAT_TYPE_USAGES |
14: --| |
15: --| PROCEDURE LIST |
16: --| Insert_Row |

Line 13: --| handler for table MTL_STAT_TYPE_USAGES |

9: --| INVGSTUB.pls |
10: --| |
11: --| DESCRIPTION |
12: --| Body of package MTL_STAT_TYPE_USAGES_PKG, table |
13: --| handler for table MTL_STAT_TYPE_USAGES |
14: --| |
15: --| PROCEDURE LIST |
16: --| Insert_Row |
17: --| Lock_Row |

Line 24: --| MTL_STAT_TYPE_USAGES |

20: --| |
21: --| HISTORY |
22: --| 01/27/1999 Herman Poon Created |
23: --| 05/31/1999 Paolo Juvara Modified to reflect changes in |
24: --| MTL_STAT_TYPE_USAGES |
25: --| 06/15/2000 Paolo Juvara Added support for period_type |
26: --| 07/11/2000 Komal Saini Added 2 new columns for Rules Validation |
27: --| 09/19/2001 Yanping Wang Added support for triangulation_mode |
28: --| 01/11/2002 Yanping Wang Added support for reference period rule |

Line 43: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MTL_STAT_TYPE_USAGES_PKG';

39:
40: --===================
41: -- CONSTANTS
42: --===================
43: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MTL_STAT_TYPE_USAGES_PKG';
44: -- add your constants here if any
45:
46: --===================
47: -- GLOBAL VARIABLES

Line 115: MTL_STAT_TYPE_USAGES

111: CURSOR C IS
112: SELECT
113: rowid
114: FROM
115: MTL_STAT_TYPE_USAGES
116: WHERE Legal_Entity_ID = p_legal_entity_id
117: AND Zone_Code = p_zone_code
118: AND Usage_Type = p_usage_type
119: AND Stat_Type = p_stat_type;

Line 131: INSERT INTO MTL_STAT_TYPE_USAGES(

127: END IF;
128:
129: -- Bug:5920143.
130: -- New column include_establishments has been added to insert clause.
131: INSERT INTO MTL_STAT_TYPE_USAGES(
132: Legal_Entity_ID
133: , Zone_Code
134: , Usage_Type
135: , Stat_Type

Line 264: FROM MTL_STAT_TYPE_USAGES

260: l_period_type VARCHAR2(200);
261:
262: CURSOR C IS
263: SELECT *
264: FROM MTL_STAT_TYPE_USAGES
265: WHERE ROWID = p_rowid
266: FOR UPDATE OF Legal_Entity_ID NOWAIT;
267: Recinfo C%ROWTYPE;
268:

Line 453: UPDATE MTL_STAT_TYPE_USAGES

449: END IF;
450:
451: -- Bug:5920143.
452: -- New column include_establishments has been added to update clause.
453: UPDATE MTL_STAT_TYPE_USAGES
454: SET
455: Legal_Entity_ID = p_legal_entity_id
456: , zone_code = p_zone_code
457: , usage_type = p_usage_type

Line 511: DELETE FROM MTL_STAT_TYPE_USAGES

507: )
508: IS
509: BEGIN
510:
511: DELETE FROM MTL_STAT_TYPE_USAGES
512: WHERE ROWID = p_rowid;
513:
514: IF (SQL%NOTFOUND) THEN
515: RAISE NO_DATA_FOUND;

Line 520: END MTL_STAT_TYPE_USAGES_PKG;

516: END IF;
517:
518: END Delete_Row;
519:
520: END MTL_STAT_TYPE_USAGES_PKG;