PACKAGE: APPS.AMS_MET_TPL_HEADERS_B_PKG

Source

1 PACKAGE AMS_MET_TPL_HEADERS_B_PKG AUTHID CURRENT_USER AS
2 /* $Header: amslmths.pls 115.12 2003/10/16 11:26:17 sunkumar ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 --          AMS_MET_TPL_HEADERS_B_PKG
7 -- Purpose
8 --
9 -- History
10 --   03/05/2002  dmvincen  Created.
11 --   03/07/2002  dmvincen  Added LOAD_ROW.
12 --   08/19/2002  dmvincen  Added add_language for MLS compliance. BUG2501425.
13 --   08-Sep-2003 Sunkumar  Bug#3130095 Metric Template UI Enh. 11510
14 --
15 -- NOTE
16 --
17 -- End of Comments
18 -- ===============================================================
19 
20 PROCEDURE Insert_Row(
21           px_metric_tpl_header_id   NUMBER,
22           p_last_update_date    DATE,
23           p_last_updated_by    NUMBER,
24           p_creation_date    DATE,
25           p_created_by    NUMBER,
26           p_last_update_login    NUMBER,
27           px_object_version_number   NUMBER,
28           p_enabled_flag    VARCHAR2,
29           p_application_id    NUMBER,
30           p_metric_tpl_header_name VARCHAR2,
31           p_description VARCHAR2,
32           p_object_type VARCHAR2,
33           p_association_type VARCHAR2,
34           p_used_by_id NUMBER,
35           p_used_by_code VARCHAR2);
36 
37 PROCEDURE Update_Row(
38           p_metric_tpl_header_id    NUMBER,
39           p_last_update_date    DATE,
40           p_last_updated_by    NUMBER,
41           p_last_update_login    NUMBER,
42           p_object_version_number    NUMBER,
43           p_enabled_flag    VARCHAR2,
44           p_application_id    NUMBER,
45           p_metric_tpl_header_name VARCHAR2,
46           p_description VARCHAR2,
47 	  p_object_type VARCHAR2,
48           p_association_type VARCHAR2,
49           p_used_by_id NUMBER,
50           p_used_by_code VARCHAR2);
51 
52 PROCEDURE Delete_Row(
53     p_METRIC_TPL_HEADER_ID  NUMBER);
54 PROCEDURE Lock_Row(
55           p_metric_tpl_header_id    NUMBER,
56           p_last_update_date    DATE,
57           p_last_updated_by    NUMBER,
58           p_creation_date    DATE,
59           p_created_by    NUMBER,
60           p_last_update_login    NUMBER,
61           p_object_version_number    NUMBER,
62           p_enabled_flag    VARCHAR2,
63           p_application_id    NUMBER);
64 
65 PROCEDURE LOAD_ROW (
66         X_METRIC_TPL_HEADER_ID NUMBER,
67         X_OBJECT_VERSION_NUMBER NUMBER,
68         X_METRIC_TPL_HEADER_NAME VARCHAR2,
69         X_DESCRIPTION VARCHAR2,
70         X_ENABLED_FLAG VARCHAR2,
71 	X_APPLICATION_ID NUMBER,
72         X_Owner   VARCHAR2,
73         X_CUSTOM_MODE VARCHAR2,
74 	X_OBJECT_TYPE IN VARCHAR2,
75 	X_ASSOCIATION_TYPE IN VARCHAR2,
76 	X_USED_BY_ID IN NUMBER,
77 	X_USED_BY_CODE IN VARCHAR2
78 );
79 
80 
81 PROCEDURE ADD_LANGUAGE;
82 
83 procedure TRANSLATE_ROW(
84        X_METRIC_TPL_HEADER_ID    in NUMBER
85      , X_METRIC_TPL_HEADER_NAME  in VARCHAR2
86      , X_DESCRIPTION    in VARCHAR2
87      , x_owner   in VARCHAR2
88  );
89 
90 END AMS_MET_TPL_HEADERS_B_PKG;