PACKAGE: APPS.AMS_ADV_FILTER_PKG

Source

1 PACKAGE AMS_ADV_FILTER_PKG  AS
2 /* $Header: amstadfs.pls 120.1 2005/06/27 05:39:23 appldev ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 --          AMS_ADV_FILTER_PKG
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15 PROCEDURE Insert_Row(
16           px_query_param_id  IN OUT NOCOPY    NUMBER,
17           p_query_id                   NUMBER,
18           p_parameter_name             VARCHAR2,
19           p_parameter_type             VARCHAR2,
20           p_parameter_value            VARCHAR2,
21           p_parameter_condition        VARCHAR2,
22           p_parameter_sequence         NUMBER,
23           p_created_by                 NUMBER,
24           p_last_updated_by            NUMBER,
25           p_last_update_date           DATE,
26           p_last_update_login          NUMBER,
27           p_security_group_id          NUMBER
28                      );
29 
30 PROCEDURE Update_Row(
31           px_query_param_id         NUMBER,
32           p_query_id                NUMBER,
33           p_parameter_name          VARCHAR2,
34           p_parameter_type          VARCHAR2,
35           p_parameter_value         VARCHAR2,
36           p_parameter_condition     VARCHAR2,
37           p_parameter_sequence      NUMBER,
38           p_last_updated_by         NUMBER,
39           p_last_update_date        DATE,
40           p_last_update_login       NUMBER,
41           p_security_group_id       NUMBER
42                  );
43 
44 PROCEDURE Delete_Row(
45     p_query_param_id NUMBER);
46 
47 END AMS_ADV_FILTER_PKG ;