PACKAGE: APPS.AMS_LIST_SRC_TYPE_ASSOCS_PKG

Source

1 PACKAGE AMS_LIST_SRC_TYPE_ASSOCS_PKG AS
2 /* $Header: amststas.pls 120.0 2005/05/31 17:53:25 appldev noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 --          AMS_LIST_SRC_TYPE_ASSOCS_PKG
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15 
16 PROCEDURE Insert_Row(
17           px_list_source_type_assoc_id   IN OUT NOCOPY NUMBER,
18           p_last_update_date    DATE,
19           p_last_updated_by    NUMBER,
20           p_creation_date    DATE,
21           p_created_by    NUMBER,
22           p_last_update_login    NUMBER,
23           px_object_version_number   IN OUT NOCOPY NUMBER,
24           p_master_source_type_id    NUMBER,
25           p_sub_source_type_id    NUMBER,
26           p_sub_source_type_pk_column    VARCHAR2,
27           p_enabled_flag    VARCHAR2,
28           p_description    VARCHAR2,
29           p_master_source_type_pk_column varchar2);
30 
31 PROCEDURE Update_Row(
32           p_list_source_type_assoc_id    NUMBER,
33           p_last_update_date    DATE,
34           p_last_updated_by    NUMBER,
35           p_creation_date    DATE,
36           p_created_by    NUMBER,
37           p_last_update_login    NUMBER,
38           p_object_version_number    NUMBER,
39           p_master_source_type_id    NUMBER,
40           p_sub_source_type_id    NUMBER,
41           p_sub_source_type_pk_column    VARCHAR2,
42           p_enabled_flag    VARCHAR2,
43           p_description    VARCHAR2,
44           p_master_source_type_pk_column varchar2);
45 
46 PROCEDURE Delete_Row(
47     p_LIST_SOURCE_TYPE_ASSOC_ID  NUMBER);
48 PROCEDURE Lock_Row(
49           p_list_source_type_assoc_id    NUMBER,
50           p_last_update_date    DATE,
51           p_last_updated_by    NUMBER,
52           p_creation_date    DATE,
53           p_created_by    NUMBER,
54           p_last_update_login    NUMBER,
55           p_object_version_number    NUMBER,
56           p_master_source_type_id    NUMBER,
57           p_sub_source_type_id    NUMBER,
58           p_sub_source_type_pk_column    VARCHAR2,
59           p_enabled_flag    VARCHAR2,
60           p_description    VARCHAR2,
61           p_master_source_type_pk_column varchar2);
62 
63 PROCEDURE load_row (
64   x_list_source_type_assoc_id IN NUMBER,
65   x_enabled_flag IN VARCHAR2,
66   x_master_source_type_id IN NUMBER,
67   x_sub_source_type_id IN NUMBER,
68   x_sub_source_type_pk_column IN VARCHAR2,
69   x_description IN VARCHAR2,
70   x_owner IN VARCHAR2,
71   x_custom_mode IN VARCHAR2,
72   x_master_source_type_pk_column in varchar2);
73 
74 
75 END AMS_LIST_SRC_TYPE_ASSOCS_PKG;