[Home] [Help]
PACKAGE: APPS.AMS_MET_TPL_DETAILS_PKG
Source
1 PACKAGE Ams_Met_Tpl_Details_Pkg AUTHID CURRENT_USER AS
2 /* $Header: amslmtds.pls 115.9 2003/03/07 22:46:00 dmvincen ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_MET_TPL_DETAILS_PKG
7 -- Purpose
8 --
9 -- History
10 -- 03/05/2002 dmvincen Created.
11 -- 03/07/2002 dmvincen Added LOAD_ROW.
12 --
13 -- NOTE
14 --
15 -- End of Comments
16 -- ===============================================================
17
18 PROCEDURE Insert_Row(
19 px_metric_template_detail_id NUMBER,
20 p_last_update_date DATE,
21 p_last_updated_by NUMBER,
22 p_creation_date DATE,
23 p_created_by NUMBER,
24 p_last_update_login NUMBER,
25 px_object_version_number NUMBER,
26 p_metric_tpl_header_id NUMBER,
27 p_metric_id NUMBER,
28 p_enabled_flag VARCHAR2);
29
30 PROCEDURE Update_Row(
31 p_metric_template_detail_id NUMBER,
32 p_last_update_date DATE,
33 p_last_updated_by NUMBER,
34 p_last_update_login NUMBER,
35 p_object_version_number NUMBER,
36 p_metric_tpl_header_id NUMBER,
37 p_metric_id NUMBER,
38 p_enabled_flag VARCHAR2);
39
40 PROCEDURE Delete_Row(
41 p_METRIC_TEMPLATE_DETAIL_ID NUMBER);
42 PROCEDURE Lock_Row(
43 p_metric_template_detail_id NUMBER,
44 p_last_update_date DATE,
45 p_last_updated_by NUMBER,
46 p_creation_date DATE,
47 p_created_by NUMBER,
48 p_last_update_login NUMBER,
49 p_object_version_number NUMBER,
50 p_metric_tpl_header_id NUMBER,
51 p_metric_id NUMBER,
52 p_enabled_flag VARCHAR2);
53
54 PROCEDURE LOAD_ROW (
55 X_METRIC_TEMPLATE_DETAIL_ID NUMBER,
56 X_OBJECT_VERSION_NUMBER NUMBER,
57 X_METRIC_TPL_HEADER_ID NUMBER,
58 X_METRIC_ID NUMBER,
59 X_ENABLED_FLAG VARCHAR2,
60 X_Owner VARCHAR2,
61 X_CUSTOM_MODE VARCHAR2
62 );
63 END Ams_Met_Tpl_Details_Pkg;