[Home] [Help]
PACKAGE: APPS.AMS_CODE_DEFINITION_PVT_W
Source
1 package ams_code_definition_pvt_w as
2 /* $Header: amswcdns.pls 120.1 2005/06/27 05:42:55 appldev ship $ */
3 procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_code_definition_pvt.code_def_tbl_type, a0 JTF_DATE_TABLE
4 , a1 JTF_DATE_TABLE
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_VARCHAR2_TABLE_100
9 , a6 JTF_VARCHAR2_TABLE_100
10 , a7 JTF_VARCHAR2_TABLE_100
11 , a8 JTF_NUMBER_TABLE
12 , a9 JTF_NUMBER_TABLE
13 );
14 procedure rosetta_table_copy_out_p3(t ams_code_definition_pvt.code_def_tbl_type, a0 OUT NOCOPY JTF_DATE_TABLE
15 , a1 OUT NOCOPY JTF_DATE_TABLE
16 , a2 OUT NOCOPY JTF_NUMBER_TABLE
17 , a3 OUT NOCOPY JTF_NUMBER_TABLE
18 , a4 OUT NOCOPY JTF_NUMBER_TABLE
19 , a5 OUT NOCOPY JTF_VARCHAR2_TABLE_100
20 , a6 OUT NOCOPY JTF_VARCHAR2_TABLE_100
21 , a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
22 , a8 OUT NOCOPY JTF_NUMBER_TABLE
23 , a9 OUT NOCOPY JTF_NUMBER_TABLE
24 );
25
26 procedure create_code_definition(p_api_version_number NUMBER
27 , p_init_msg_list VARCHAR2
28 , p_commit VARCHAR2
29 , p_validation_level NUMBER
30 , x_return_status OUT NOCOPY VARCHAR2
31 , x_msg_count OUT NOCOPY NUMBER
32 , x_msg_data OUT NOCOPY VARCHAR2
33 , x_code_definition_id OUT NOCOPY NUMBER
34 , p7_a0 DATE := fnd_api.g_miss_date
35 , p7_a1 DATE := fnd_api.g_miss_date
36 , p7_a2 NUMBER := 0-1962.0724
37 , p7_a3 NUMBER := 0-1962.0724
38 , p7_a4 NUMBER := 0-1962.0724
39 , p7_a5 VARCHAR2 := fnd_api.g_miss_char
40 , p7_a6 VARCHAR2 := fnd_api.g_miss_char
41 , p7_a7 VARCHAR2 := fnd_api.g_miss_char
42 , p7_a8 NUMBER := 0-1962.0724
43 , p7_a9 NUMBER := 0-1962.0724
44 );
45 procedure update_code_definition(p_api_version_number NUMBER
46 , p_init_msg_list VARCHAR2
47 , p_commit VARCHAR2
48 , p_validation_level NUMBER
49 , x_return_status OUT NOCOPY VARCHAR2
50 , x_msg_count OUT NOCOPY NUMBER
51 , x_msg_data OUT NOCOPY VARCHAR2
52 , x_object_version_number OUT NOCOPY NUMBER
53 , p7_a0 DATE := fnd_api.g_miss_date
54 , p7_a1 DATE := fnd_api.g_miss_date
55 , p7_a2 NUMBER := 0-1962.0724
56 , p7_a3 NUMBER := 0-1962.0724
57 , p7_a4 NUMBER := 0-1962.0724
58 , p7_a5 VARCHAR2 := fnd_api.g_miss_char
59 , p7_a6 VARCHAR2 := fnd_api.g_miss_char
60 , p7_a7 VARCHAR2 := fnd_api.g_miss_char
61 , p7_a8 NUMBER := 0-1962.0724
62 , p7_a9 NUMBER := 0-1962.0724
63 );
64 procedure validate_code_definition(p_api_version_number NUMBER
65 , p_init_msg_list VARCHAR2
66 , p_validation_level NUMBER
67 , p_validation_mode VARCHAR2
68 , x_return_status OUT NOCOPY VARCHAR2
69 , x_msg_count OUT NOCOPY NUMBER
70 , x_msg_data OUT NOCOPY VARCHAR2
71 , p3_a0 DATE := fnd_api.g_miss_date
72 , p3_a1 DATE := fnd_api.g_miss_date
73 , p3_a2 NUMBER := 0-1962.0724
74 , p3_a3 NUMBER := 0-1962.0724
75 , p3_a4 NUMBER := 0-1962.0724
76 , p3_a5 VARCHAR2 := fnd_api.g_miss_char
77 , p3_a6 VARCHAR2 := fnd_api.g_miss_char
78 , p3_a7 VARCHAR2 := fnd_api.g_miss_char
79 , p3_a8 NUMBER := 0-1962.0724
80 , p3_a9 NUMBER := 0-1962.0724
81 );
82 procedure check_code_def_items(p_validation_mode VARCHAR2
83 , x_return_status OUT NOCOPY VARCHAR2
84 , p0_a0 DATE := fnd_api.g_miss_date
85 , p0_a1 DATE := fnd_api.g_miss_date
86 , p0_a2 NUMBER := 0-1962.0724
87 , p0_a3 NUMBER := 0-1962.0724
88 , p0_a4 NUMBER := 0-1962.0724
89 , p0_a5 VARCHAR2 := fnd_api.g_miss_char
90 , p0_a6 VARCHAR2 := fnd_api.g_miss_char
91 , p0_a7 VARCHAR2 := fnd_api.g_miss_char
92 , p0_a8 NUMBER := 0-1962.0724
93 , p0_a9 NUMBER := 0-1962.0724
94 );
95 procedure validate_code_def_rec(p_api_version_number NUMBER
96 , p_init_msg_list VARCHAR2
97 , x_return_status OUT NOCOPY VARCHAR2
98 , x_msg_count OUT NOCOPY NUMBER
99 , x_msg_data OUT NOCOPY VARCHAR2
100 , p5_a0 DATE := fnd_api.g_miss_date
101 , p5_a1 DATE := fnd_api.g_miss_date
102 , p5_a2 NUMBER := 0-1962.0724
103 , p5_a3 NUMBER := 0-1962.0724
104 , p5_a4 NUMBER := 0-1962.0724
105 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
106 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
107 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
108 , p5_a8 NUMBER := 0-1962.0724
109 , p5_a9 NUMBER := 0-1962.0724
110 );
111 end ams_code_definition_pvt_w;