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_PS_CNDCLSES_PVT_W

Source


1 package ams_ps_cndclses_pvt_w as
2   /* $Header: amswccls.pls 120.0 2005/05/31 16:22:07 appldev noship $ */
3   procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_ps_cndclses_pvt.ps_cndclses_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_VARCHAR2_TABLE_100
11     , a8 JTF_VARCHAR2_TABLE_100
12     , a9 JTF_VARCHAR2_TABLE_100
13     , a10 JTF_VARCHAR2_TABLE_100
14     , a11 JTF_VARCHAR2_TABLE_100
15     , a12 JTF_VARCHAR2_TABLE_1000
16     );
17   procedure rosetta_table_copy_out_p3(t ams_ps_cndclses_pvt.ps_cndclses_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_VARCHAR2_TABLE_100
25     , a8 OUT NOCOPY JTF_VARCHAR2_TABLE_100
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_1000
30     );
31 
32   procedure create_ps_cndclses(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_cnd_clause_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  VARCHAR2 := fnd_api.g_miss_char
48     , p7_a8  VARCHAR2 := fnd_api.g_miss_char
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_ps_cndclses(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  VARCHAR2 := fnd_api.g_miss_char
70     , p7_a8  VARCHAR2 := fnd_api.g_miss_char
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_ps_cndclses(p_api_version_number  NUMBER
77     , p_init_msg_list  VARCHAR2
78     , p_validation_level  NUMBER
79     , x_return_status OUT NOCOPY  VARCHAR2
80     , x_msg_count OUT NOCOPY  NUMBER
81     , x_msg_data OUT NOCOPY  VARCHAR2
82     , p3_a0  NUMBER := 0-1962.0724
83     , p3_a1  DATE := fnd_api.g_miss_date
84     , p3_a2  NUMBER := 0-1962.0724
85     , p3_a3  DATE := fnd_api.g_miss_date
86     , p3_a4  NUMBER := 0-1962.0724
87     , p3_a5  NUMBER := 0-1962.0724
88     , p3_a6  NUMBER := 0-1962.0724
89     , p3_a7  VARCHAR2 := fnd_api.g_miss_char
90     , p3_a8  VARCHAR2 := fnd_api.g_miss_char
91     , p3_a9  VARCHAR2 := fnd_api.g_miss_char
92     , p3_a10  VARCHAR2 := fnd_api.g_miss_char
93     , p3_a11  VARCHAR2 := fnd_api.g_miss_char
94     , p3_a12  VARCHAR2 := fnd_api.g_miss_char
95   );
96   procedure check_ps_cndclses_items(p_validation_mode  VARCHAR2
97     , x_return_status OUT NOCOPY  VARCHAR2
98     , p0_a0  NUMBER := 0-1962.0724
99     , p0_a1  DATE := fnd_api.g_miss_date
100     , p0_a2  NUMBER := 0-1962.0724
101     , p0_a3  DATE := fnd_api.g_miss_date
102     , p0_a4  NUMBER := 0-1962.0724
103     , p0_a5  NUMBER := 0-1962.0724
104     , p0_a6  NUMBER := 0-1962.0724
105     , p0_a7  VARCHAR2 := fnd_api.g_miss_char
106     , p0_a8  VARCHAR2 := fnd_api.g_miss_char
107     , p0_a9  VARCHAR2 := fnd_api.g_miss_char
108     , p0_a10  VARCHAR2 := fnd_api.g_miss_char
109     , p0_a11  VARCHAR2 := fnd_api.g_miss_char
110     , p0_a12  VARCHAR2 := fnd_api.g_miss_char
111   );
112   procedure validate_ps_cndclses_rec(p_api_version_number  NUMBER
113     , p_init_msg_list  VARCHAR2
114     , x_return_status OUT NOCOPY  VARCHAR2
115     , x_msg_count OUT NOCOPY  NUMBER
116     , x_msg_data OUT NOCOPY  VARCHAR2
117     , p5_a0  NUMBER := 0-1962.0724
118     , p5_a1  DATE := fnd_api.g_miss_date
119     , p5_a2  NUMBER := 0-1962.0724
120     , p5_a3  DATE := fnd_api.g_miss_date
121     , p5_a4  NUMBER := 0-1962.0724
122     , p5_a5  NUMBER := 0-1962.0724
123     , p5_a6  NUMBER := 0-1962.0724
124     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
125     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
126     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
127     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
128     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
129     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
130   );
131 end ams_ps_cndclses_pvt_w;