[Home] [Help]
PACKAGE: APPS.AMS_MET_TPL_DTL_PVT_W
Source
1 package ams_met_tpl_dtl_pvt_w as
2 /* $Header: amswmtds.pls 120.0 2005/06/01 01:45:16 appldev noship $ */
3 procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_met_tpl_dtl_pvt.met_tpl_dtl_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 );
14 procedure rosetta_table_copy_out_p3(t ams_met_tpl_dtl_pvt.met_tpl_dtl_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
15 , a1 OUT NOCOPY JTF_DATE_TABLE
16 , a2 OUT NOCOPY JTF_NUMBER_TABLE
17 , a3 OUT NOCOPY JTF_DATE_TABLE
18 , a4 OUT NOCOPY JTF_NUMBER_TABLE
19 , a5 OUT NOCOPY JTF_NUMBER_TABLE
20 , a6 OUT NOCOPY JTF_NUMBER_TABLE
21 , a7 OUT NOCOPY JTF_NUMBER_TABLE
22 , a8 OUT NOCOPY JTF_NUMBER_TABLE
23 , a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
24 );
25
26 procedure create_met_tpl_dtl(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_metric_template_detail_id OUT NOCOPY NUMBER
34 , p7_a0 NUMBER := 0-1962.0724
35 , p7_a1 DATE := fnd_api.g_miss_date
36 , p7_a2 NUMBER := 0-1962.0724
37 , p7_a3 DATE := fnd_api.g_miss_date
38 , p7_a4 NUMBER := 0-1962.0724
39 , p7_a5 NUMBER := 0-1962.0724
40 , p7_a6 NUMBER := 0-1962.0724
41 , p7_a7 NUMBER := 0-1962.0724
42 , p7_a8 NUMBER := 0-1962.0724
43 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
44 );
45 procedure update_met_tpl_dtl(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 NUMBER := 0-1962.0724
54 , p7_a1 DATE := fnd_api.g_miss_date
55 , p7_a2 NUMBER := 0-1962.0724
56 , p7_a3 DATE := fnd_api.g_miss_date
57 , p7_a4 NUMBER := 0-1962.0724
58 , p7_a5 NUMBER := 0-1962.0724
59 , p7_a6 NUMBER := 0-1962.0724
60 , p7_a7 NUMBER := 0-1962.0724
61 , p7_a8 NUMBER := 0-1962.0724
62 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
63 );
64 procedure validate_met_tpl_dtl(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 NUMBER := 0-1962.0724
72 , p3_a1 DATE := fnd_api.g_miss_date
73 , p3_a2 NUMBER := 0-1962.0724
74 , p3_a3 DATE := fnd_api.g_miss_date
75 , p3_a4 NUMBER := 0-1962.0724
76 , p3_a5 NUMBER := 0-1962.0724
77 , p3_a6 NUMBER := 0-1962.0724
78 , p3_a7 NUMBER := 0-1962.0724
79 , p3_a8 NUMBER := 0-1962.0724
80 , p3_a9 VARCHAR2 := fnd_api.g_miss_char
81 );
82 procedure check_met_tpl_dtl_items(p_validation_mode VARCHAR2
83 , x_return_status OUT NOCOPY VARCHAR2
84 , p0_a0 NUMBER := 0-1962.0724
85 , p0_a1 DATE := fnd_api.g_miss_date
86 , p0_a2 NUMBER := 0-1962.0724
87 , p0_a3 DATE := fnd_api.g_miss_date
88 , p0_a4 NUMBER := 0-1962.0724
89 , p0_a5 NUMBER := 0-1962.0724
90 , p0_a6 NUMBER := 0-1962.0724
91 , p0_a7 NUMBER := 0-1962.0724
92 , p0_a8 NUMBER := 0-1962.0724
93 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
94 );
95 procedure validate_met_tpl_dtl_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 NUMBER := 0-1962.0724
101 , p5_a1 DATE := fnd_api.g_miss_date
102 , p5_a2 NUMBER := 0-1962.0724
103 , p5_a3 DATE := fnd_api.g_miss_date
104 , p5_a4 NUMBER := 0-1962.0724
105 , p5_a5 NUMBER := 0-1962.0724
106 , p5_a6 NUMBER := 0-1962.0724
107 , p5_a7 NUMBER := 0-1962.0724
108 , p5_a8 NUMBER := 0-1962.0724
109 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
110 );
111 end ams_met_tpl_dtl_pvt_w;