[Home] [Help]
PACKAGE: APPS.AS_SCORECARD_RULES_PUB_W
Source
1 package as_scorecard_rules_pub_w as
2 /* $Header: asxwscos.pls 120.2 2006/03/09 15:41 solin ship $ */
3 procedure rosetta_table_copy_in_p2(t out nocopy as_scorecard_rules_pub.cardrule_qual_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_NUMBER_TABLE
13 , a10 JTF_NUMBER_TABLE
14 , a11 JTF_NUMBER_TABLE
15 , a12 JTF_VARCHAR2_TABLE_100
16 , a13 JTF_VARCHAR2_TABLE_100
17 , a14 JTF_VARCHAR2_TABLE_100
18 , a15 JTF_DATE_TABLE
19 , a16 JTF_DATE_TABLE
20 , a17 JTF_DATE_TABLE
21 , a18 JTF_DATE_TABLE
22 );
23 procedure rosetta_table_copy_out_p2(t as_scorecard_rules_pub.cardrule_qual_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
24 , a1 out nocopy JTF_DATE_TABLE
25 , a2 out nocopy JTF_NUMBER_TABLE
26 , a3 out nocopy JTF_DATE_TABLE
27 , a4 out nocopy JTF_NUMBER_TABLE
28 , a5 out nocopy JTF_NUMBER_TABLE
29 , a6 out nocopy JTF_NUMBER_TABLE
30 , a7 out nocopy JTF_NUMBER_TABLE
31 , a8 out nocopy JTF_NUMBER_TABLE
32 , a9 out nocopy JTF_NUMBER_TABLE
33 , a10 out nocopy JTF_NUMBER_TABLE
34 , a11 out nocopy JTF_NUMBER_TABLE
35 , a12 out nocopy JTF_VARCHAR2_TABLE_100
36 , a13 out nocopy JTF_VARCHAR2_TABLE_100
37 , a14 out nocopy JTF_VARCHAR2_TABLE_100
38 , a15 out nocopy JTF_DATE_TABLE
39 , a16 out nocopy JTF_DATE_TABLE
40 , a17 out nocopy JTF_DATE_TABLE
41 , a18 out nocopy JTF_DATE_TABLE
42 );
43
44 procedure create_scorecard(p_api_version NUMBER
45 , p_init_msg_list VARCHAR2
46 , p_commit VARCHAR2
47 , p_validation_level NUMBER
48 , x_return_status out nocopy VARCHAR2
49 , x_msg_count out nocopy NUMBER
50 , x_msg_data out nocopy VARCHAR2
51 , x_scorecard_id out nocopy NUMBER
52 , p7_a0 NUMBER := 0-1962.0724
53 , p7_a1 DATE := fnd_api.g_miss_date
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 NUMBER := 0-1962.0724
58 , p7_a6 VARCHAR2 := fnd_api.g_miss_char
59 , p7_a7 VARCHAR2 := fnd_api.g_miss_char
60 , p7_a8 DATE := fnd_api.g_miss_date
61 , p7_a9 DATE := fnd_api.g_miss_date
62 );
63 procedure update_scorecard(p_api_version NUMBER
64 , p_init_msg_list VARCHAR2
65 , p_commit VARCHAR2
66 , p_validation_level NUMBER
67 , x_return_status out nocopy VARCHAR2
68 , x_msg_count out nocopy NUMBER
69 , x_msg_data out nocopy VARCHAR2
70 , p7_a0 NUMBER := 0-1962.0724
71 , p7_a1 DATE := fnd_api.g_miss_date
72 , p7_a2 NUMBER := 0-1962.0724
73 , p7_a3 DATE := fnd_api.g_miss_date
74 , p7_a4 NUMBER := 0-1962.0724
75 , p7_a5 NUMBER := 0-1962.0724
76 , p7_a6 VARCHAR2 := fnd_api.g_miss_char
77 , p7_a7 VARCHAR2 := fnd_api.g_miss_char
78 , p7_a8 DATE := fnd_api.g_miss_date
79 , p7_a9 DATE := fnd_api.g_miss_date
80 );
81 procedure create_cardrule_qual(p_api_version NUMBER
82 , p_init_msg_list VARCHAR2
83 , p_commit VARCHAR2
84 , p_validation_level NUMBER
85 , x_return_status out nocopy VARCHAR2
86 , x_msg_count out nocopy NUMBER
87 , x_msg_data out nocopy VARCHAR2
88 , x_qual_value_id out nocopy NUMBER
89 , p7_a0 NUMBER := 0-1962.0724
90 , p7_a1 DATE := fnd_api.g_miss_date
91 , p7_a2 NUMBER := 0-1962.0724
92 , p7_a3 DATE := fnd_api.g_miss_date
93 , p7_a4 NUMBER := 0-1962.0724
94 , p7_a5 NUMBER := 0-1962.0724
95 , p7_a6 NUMBER := 0-1962.0724
96 , p7_a7 NUMBER := 0-1962.0724
97 , p7_a8 NUMBER := 0-1962.0724
98 , p7_a9 NUMBER := 0-1962.0724
99 , p7_a10 NUMBER := 0-1962.0724
100 , p7_a11 NUMBER := 0-1962.0724
101 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
102 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
103 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
104 , p7_a15 DATE := fnd_api.g_miss_date
105 , p7_a16 DATE := fnd_api.g_miss_date
106 , p7_a17 DATE := fnd_api.g_miss_date
107 , p7_a18 DATE := fnd_api.g_miss_date
108 );
109 procedure update_cardrule_qual(p_api_version NUMBER
110 , p_init_msg_list VARCHAR2
111 , p_commit VARCHAR2
112 , p_validation_level NUMBER
113 , x_return_status out nocopy VARCHAR2
114 , x_msg_count out nocopy NUMBER
115 , x_msg_data out nocopy VARCHAR2
116 , p7_a0 NUMBER := 0-1962.0724
117 , p7_a1 DATE := fnd_api.g_miss_date
118 , p7_a2 NUMBER := 0-1962.0724
119 , p7_a3 DATE := fnd_api.g_miss_date
120 , p7_a4 NUMBER := 0-1962.0724
121 , p7_a5 NUMBER := 0-1962.0724
122 , p7_a6 NUMBER := 0-1962.0724
123 , p7_a7 NUMBER := 0-1962.0724
124 , p7_a8 NUMBER := 0-1962.0724
125 , p7_a9 NUMBER := 0-1962.0724
126 , p7_a10 NUMBER := 0-1962.0724
127 , p7_a11 NUMBER := 0-1962.0724
128 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
129 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
130 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
131 , p7_a15 DATE := fnd_api.g_miss_date
132 , p7_a16 DATE := fnd_api.g_miss_date
133 , p7_a17 DATE := fnd_api.g_miss_date
134 , p7_a18 DATE := fnd_api.g_miss_date
135 );
136 end as_scorecard_rules_pub_w;