PACKAGE: APPS.AMS_MET_TPL_ASSOCS_PKG

Source

1 PACKAGE AMS_MET_TPL_ASSOCS_PKG AUTHID CURRENT_USER AS
2 /* $Header: amslmtas.pls 115.7 2003/03/07 22:45:56 dmvincen ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 --          AMS_MET_TPL_ASSOCS_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           p_metric_tpl_assoc_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   IN NUMBER,
26           p_metric_tpl_header_id    NUMBER,
27           p_association_type    VARCHAR2,
28           p_used_by_id    NUMBER,
29           p_used_by_code    VARCHAR2,
30           p_enabled_flag    VARCHAR2);
31 
32 PROCEDURE Update_Row(
33           p_metric_tpl_assoc_id    NUMBER,
34           p_last_update_date    DATE,
35           p_last_updated_by    NUMBER,
36           p_last_update_login    NUMBER,
37           p_object_version_number    NUMBER,
38           p_metric_tpl_header_id    NUMBER,
39           p_association_type    VARCHAR2,
40           p_used_by_id    NUMBER,
41           p_used_by_code    VARCHAR2,
42           p_enabled_flag    VARCHAR2);
43 
44 PROCEDURE Delete_Row(
45     p_METRIC_TPL_ASSOC_ID  NUMBER);
46 PROCEDURE Lock_Row(
47           p_metric_tpl_assoc_id    NUMBER,
48           p_last_update_date    DATE,
49           p_last_updated_by    NUMBER,
50           p_creation_date    DATE,
51           p_created_by    NUMBER,
52           p_last_update_login    NUMBER,
53           p_object_version_number    NUMBER,
54           p_metric_tpl_header_id    NUMBER,
55           p_association_type    VARCHAR2,
56           p_used_by_id    NUMBER,
57           p_used_by_code    VARCHAR2,
58           p_enabled_flag    VARCHAR2);
59 
60 PROCEDURE LOAD_ROW (
61         X_METRIC_TPL_ASSOC_ID NUMBER,
62         X_OBJECT_VERSION_NUMBER NUMBER,
63         X_METRIC_TPL_HEADER_ID NUMBER,
64         X_ASSOCIATION_TYPE VARCHAR2,
65         X_USED_BY_ID NUMBER,
66         X_USED_BY_CODE VARCHAR2,
67         X_ENABLED_FLAG VARCHAR2,
68         X_Owner   VARCHAR2,
69         X_CUSTOM_MODE VARCHAR2
70         );
71 
72 END AMS_MET_TPL_ASSOCS_PKG;