eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.AMS_DM_TARGET_VALUE_PVT_W

Source


1 package ams_dm_target_value_pvt_w AUTHID CURRENT_USER as
2   /* $Header: amswdtvs.pls 115.5 2002/11/16 00:07:24 nyostos noship $ */
3   procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_dm_target_value_pvt.dm_target_value_tbl_type, a0 JTF_NUMBER_TABLE
4     , a1 JTF_DATE_TABLE
5     , a2 JTF_NUMBER_TABLE
6     , a3 JTF_DATE_TABLE
7     , a4 JTF_NUMBER_TABLE
8     , a5 JTF_NUMBER_TABLE
9     , a6 JTF_NUMBER_TABLE
10     , a7 JTF_NUMBER_TABLE
11     , a8 JTF_NUMBER_TABLE
12     , a9 JTF_VARCHAR2_TABLE_100
13     , a10 JTF_VARCHAR2_TABLE_100
14     , a11 JTF_VARCHAR2_TABLE_100
15     , a12 JTF_VARCHAR2_TABLE_4000
16     );
17   procedure rosetta_table_copy_out_p3(t ams_dm_target_value_pvt.dm_target_value_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
18     , a1 OUT NOCOPY JTF_DATE_TABLE
19     , a2 OUT NOCOPY JTF_NUMBER_TABLE
20     , a3 OUT NOCOPY JTF_DATE_TABLE
21     , a4 OUT NOCOPY JTF_NUMBER_TABLE
22     , a5 OUT NOCOPY JTF_NUMBER_TABLE
23     , a6 OUT NOCOPY JTF_NUMBER_TABLE
24     , a7 OUT NOCOPY JTF_NUMBER_TABLE
25     , a8 OUT NOCOPY JTF_NUMBER_TABLE
26     , a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
27     , a10 OUT NOCOPY JTF_VARCHAR2_TABLE_100
28     , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
29     , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_4000
30     );
31 
32   procedure create_dm_target_value(p_api_version_number  NUMBER
33     , p_init_msg_list  VARCHAR2
34     , p_commit  VARCHAR2
35     , p_validation_level  NUMBER
36     , x_return_status OUT NOCOPY  VARCHAR2
37     , x_msg_count OUT NOCOPY  NUMBER
38     , x_msg_data OUT NOCOPY  VARCHAR2
39     , x_target_value_id OUT NOCOPY  NUMBER
40     , p7_a0  NUMBER := 0-1962.0724
41     , p7_a1  DATE := fnd_api.g_miss_date
42     , p7_a2  NUMBER := 0-1962.0724
43     , p7_a3  DATE := fnd_api.g_miss_date
44     , p7_a4  NUMBER := 0-1962.0724
45     , p7_a5  NUMBER := 0-1962.0724
46     , p7_a6  NUMBER := 0-1962.0724
47     , p7_a7  NUMBER := 0-1962.0724
48     , p7_a8  NUMBER := 0-1962.0724
49     , p7_a9  VARCHAR2 := fnd_api.g_miss_char
50     , p7_a10  VARCHAR2 := fnd_api.g_miss_char
51     , p7_a11  VARCHAR2 := fnd_api.g_miss_char
52     , p7_a12  VARCHAR2 := fnd_api.g_miss_char
53   );
54   procedure update_dm_target_value(p_api_version_number  NUMBER
55     , p_init_msg_list  VARCHAR2
56     , p_commit  VARCHAR2
57     , p_validation_level  NUMBER
58     , x_return_status OUT NOCOPY  VARCHAR2
59     , x_msg_count OUT NOCOPY  NUMBER
60     , x_msg_data OUT NOCOPY  VARCHAR2
61     , x_object_version_number OUT NOCOPY  NUMBER
62     , p7_a0  NUMBER := 0-1962.0724
63     , p7_a1  DATE := fnd_api.g_miss_date
64     , p7_a2  NUMBER := 0-1962.0724
65     , p7_a3  DATE := fnd_api.g_miss_date
66     , p7_a4  NUMBER := 0-1962.0724
67     , p7_a5  NUMBER := 0-1962.0724
68     , p7_a6  NUMBER := 0-1962.0724
69     , p7_a7  NUMBER := 0-1962.0724
70     , p7_a8  NUMBER := 0-1962.0724
71     , p7_a9  VARCHAR2 := fnd_api.g_miss_char
72     , p7_a10  VARCHAR2 := fnd_api.g_miss_char
73     , p7_a11  VARCHAR2 := fnd_api.g_miss_char
74     , p7_a12  VARCHAR2 := fnd_api.g_miss_char
75   );
76   procedure validate_dm_target_value(p_api_version_number  NUMBER
77     , p_init_msg_list  VARCHAR2
78     , p_validation_level  NUMBER
79     , p_validation_mode  VARCHAR2
80     , x_return_status OUT NOCOPY  VARCHAR2
81     , x_msg_count OUT NOCOPY  NUMBER
82     , x_msg_data OUT NOCOPY  VARCHAR2
83     , p3_a0  NUMBER := 0-1962.0724
84     , p3_a1  DATE := fnd_api.g_miss_date
85     , p3_a2  NUMBER := 0-1962.0724
86     , p3_a3  DATE := fnd_api.g_miss_date
87     , p3_a4  NUMBER := 0-1962.0724
88     , p3_a5  NUMBER := 0-1962.0724
89     , p3_a6  NUMBER := 0-1962.0724
90     , p3_a7  NUMBER := 0-1962.0724
91     , p3_a8  NUMBER := 0-1962.0724
92     , p3_a9  VARCHAR2 := fnd_api.g_miss_char
93     , p3_a10  VARCHAR2 := fnd_api.g_miss_char
94     , p3_a11  VARCHAR2 := fnd_api.g_miss_char
95     , p3_a12  VARCHAR2 := fnd_api.g_miss_char
96   );
97   procedure check_dm_target_value_items(p_validation_mode  VARCHAR2
98     , x_return_status OUT NOCOPY  VARCHAR2
99     , p0_a0  NUMBER := 0-1962.0724
100     , p0_a1  DATE := fnd_api.g_miss_date
101     , p0_a2  NUMBER := 0-1962.0724
102     , p0_a3  DATE := fnd_api.g_miss_date
103     , p0_a4  NUMBER := 0-1962.0724
104     , p0_a5  NUMBER := 0-1962.0724
105     , p0_a6  NUMBER := 0-1962.0724
106     , p0_a7  NUMBER := 0-1962.0724
107     , p0_a8  NUMBER := 0-1962.0724
108     , p0_a9  VARCHAR2 := fnd_api.g_miss_char
109     , p0_a10  VARCHAR2 := fnd_api.g_miss_char
110     , p0_a11  VARCHAR2 := fnd_api.g_miss_char
111     , p0_a12  VARCHAR2 := fnd_api.g_miss_char
112   );
113   procedure validate_dm_target_value_rec(p_api_version_number  NUMBER
114     , p_init_msg_list  VARCHAR2
115     , x_return_status OUT NOCOPY  VARCHAR2
116     , x_msg_count OUT NOCOPY  NUMBER
117     , x_msg_data OUT NOCOPY  VARCHAR2
118     , p5_a0  NUMBER := 0-1962.0724
119     , p5_a1  DATE := fnd_api.g_miss_date
120     , p5_a2  NUMBER := 0-1962.0724
121     , p5_a3  DATE := fnd_api.g_miss_date
122     , p5_a4  NUMBER := 0-1962.0724
123     , p5_a5  NUMBER := 0-1962.0724
124     , p5_a6  NUMBER := 0-1962.0724
125     , p5_a7  NUMBER := 0-1962.0724
126     , p5_a8  NUMBER := 0-1962.0724
127     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
128     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
129     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
130     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
131   );
132 end ams_dm_target_value_pvt_w;