PACKAGE: APPS.AMS_DM_TARGET_VALUES_B_PKG

Source

1 PACKAGE AMS_DM_TARGET_VALUES_B_PKG AUTHID CURRENT_USER AS
2 /* $Header: amstdtvs.pls 115.5 2003/03/07 03:54:26 choang noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 --          AMS_DM_TARGET_VALUES_B_PKG
7 -- Purpose
8 --
9 -- History
10 -- 08-Oct-2002 nyostos  Added value_condition column
11 -- 16-Oct-2002 choang   Added target_operator and range_value, replacing value_condition
12 -- 06-Mar-2003 choang   Added x_custom_mode to load_row for bug 2819067.
13 --
14 -- NOTE
15 --
16 -- End of Comments
17 -- ===============================================================
18 
19 PROCEDURE Insert_Row(
20          px_target_value_id         IN OUT NOCOPY NUMBER,
21          p_last_update_date         DATE,
22          p_last_updated_by          NUMBER,
23          p_creation_date            DATE,
24          p_created_by               NUMBER,
25          p_last_update_login        NUMBER,
26          px_object_version_number   IN OUT NOCOPY NUMBER,
27          p_target_id                NUMBER,
28          p_target_value             VARCHAR2,
29          p_target_operator          IN VARCHAR2,
30          p_range_value              IN VARCHAR2,
31          p_description              VARCHAR2);
32 
33 PROCEDURE Update_Row(
34          p_target_value_id          NUMBER,
35          p_last_update_date         DATE,
36          p_last_updated_by          NUMBER,
37          p_last_update_login        NUMBER,
38          p_object_version_number    NUMBER,
39          p_target_id                NUMBER,
40          p_target_value             VARCHAR2,
41          p_target_operator          IN VARCHAR2,
42          p_range_value              IN VARCHAR2,
43          p_description              VARCHAR2);
44 
45 PROCEDURE Delete_Row(
46          p_TARGET_VALUE_ID  NUMBER);
47 
48 PROCEDURE Lock_Row(
49          p_target_value_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_target_id                NUMBER,
57          p_target_value             VARCHAR2);
58 
59 PROCEDURE add_language;
60 
61 PROCEDURE translate_row (
62          x_target_value_id IN NUMBER,
63          x_description  IN VARCHAR2,
64          x_owner     IN VARCHAR2
65 );
66 
67 PROCEDURE load_row (
68          x_target_value_id IN NUMBER,
69          x_target_id       IN NUMBER,
70          x_target_value    VARCHAR2,
71          x_target_operator IN VARCHAR2,
72          x_range_value     IN VARCHAR2,
73          x_description     VARCHAR2,
74          x_owner           IN VARCHAR2,
75          x_custom_mode     IN VARCHAR2
76 );
77 
78 
79 END AMS_DM_TARGET_VALUES_B_PKG;