[Home] [Help]
PACKAGE: APPS.AMS_TEMPLATE_RES_PVT_W
Source
1 package ams_template_res_pvt_w AUTHID CURRENT_USER as
2 /* $Header: amswptrs.pls 115.2 2002/11/15 21:04:47 abhola ship $ */
3 procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_template_res_pvt.template_res_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_DATE_TABLE
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_DATE_TABLE
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_NUMBER_TABLE
12 , a9 JTF_NUMBER_TABLE
13 );
14 procedure rosetta_table_copy_out_p3(t ams_template_res_pvt.template_res_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
15 , a1 OUT NOCOPY JTF_NUMBER_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_DATE_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_NUMBER_TABLE
24 );
25
26 procedure create_template_res(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_templ_responsibility_id OUT NOCOPY NUMBER
34 , p7_a0 NUMBER := 0-1962.0724
35 , p7_a1 NUMBER := 0-1962.0724
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 DATE := fnd_api.g_miss_date
40 , p7_a6 NUMBER := 0-1962.0724
41 , p7_a7 NUMBER := 0-1962.0724
42 , p7_a8 NUMBER := 0-1962.0724
43 , p7_a9 NUMBER := 0-1962.0724
44 );
45 procedure update_template_res(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 , p7_a0 NUMBER := 0-1962.0724
53 , p7_a1 NUMBER := 0-1962.0724
54 , p7_a2 NUMBER := 0-1962.0724
55 , p7_a3 DATE := fnd_api.g_miss_date
56 , p7_a4 NUMBER := 0-1962.0724
57 , p7_a5 DATE := fnd_api.g_miss_date
58 , p7_a6 NUMBER := 0-1962.0724
59 , p7_a7 NUMBER := 0-1962.0724
60 , p7_a8 NUMBER := 0-1962.0724
61 , p7_a9 NUMBER := 0-1962.0724
62 );
63 procedure validate_template_res(p_api_version_number NUMBER
64 , p_init_msg_list VARCHAR2
65 , p_validation_level NUMBER
66 , p_validation_mode VARCHAR2
67 , x_return_status OUT NOCOPY VARCHAR2
68 , x_msg_count OUT NOCOPY NUMBER
69 , x_msg_data OUT NOCOPY VARCHAR2
70 , p3_a0 NUMBER := 0-1962.0724
71 , p3_a1 NUMBER := 0-1962.0724
72 , p3_a2 NUMBER := 0-1962.0724
73 , p3_a3 DATE := fnd_api.g_miss_date
74 , p3_a4 NUMBER := 0-1962.0724
75 , p3_a5 DATE := fnd_api.g_miss_date
76 , p3_a6 NUMBER := 0-1962.0724
77 , p3_a7 NUMBER := 0-1962.0724
78 , p3_a8 NUMBER := 0-1962.0724
79 , p3_a9 NUMBER := 0-1962.0724
80 );
81 procedure check_template_res_items(p_validation_mode VARCHAR2
82 , x_return_status OUT NOCOPY VARCHAR2
83 , p0_a0 NUMBER := 0-1962.0724
84 , p0_a1 NUMBER := 0-1962.0724
85 , p0_a2 NUMBER := 0-1962.0724
86 , p0_a3 DATE := fnd_api.g_miss_date
87 , p0_a4 NUMBER := 0-1962.0724
88 , p0_a5 DATE := fnd_api.g_miss_date
89 , p0_a6 NUMBER := 0-1962.0724
90 , p0_a7 NUMBER := 0-1962.0724
91 , p0_a8 NUMBER := 0-1962.0724
92 , p0_a9 NUMBER := 0-1962.0724
93 );
94 procedure validate_template_res_rec(p_api_version_number NUMBER
95 , p_init_msg_list VARCHAR2
96 , x_return_status OUT NOCOPY VARCHAR2
97 , x_msg_count OUT NOCOPY NUMBER
98 , x_msg_data OUT NOCOPY VARCHAR2
99 , p5_a0 NUMBER := 0-1962.0724
100 , p5_a1 NUMBER := 0-1962.0724
101 , p5_a2 NUMBER := 0-1962.0724
102 , p5_a3 DATE := fnd_api.g_miss_date
103 , p5_a4 NUMBER := 0-1962.0724
104 , p5_a5 DATE := fnd_api.g_miss_date
105 , p5_a6 NUMBER := 0-1962.0724
106 , p5_a7 NUMBER := 0-1962.0724
107 , p5_a8 NUMBER := 0-1962.0724
108 , p5_a9 NUMBER := 0-1962.0724
109 );
110 end ams_template_res_pvt_w;