[Home] [Help]
PACKAGE: APPS.OZF_NA_RULE_LINE_PVT_W
Source
1 package ozf_na_rule_line_pvt_w as
2 /* $Header: ozfwdnls.pls 120.1 2005/10/26 14:19 rssharma noship $ */
3 procedure rosetta_table_copy_in_p2(t out nocopy ozf_na_rule_line_pvt.na_rule_line_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_VARCHAR2_TABLE_100
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_DATE_TABLE
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_DATE_TABLE
11 , a8 JTF_NUMBER_TABLE
12 , a9 JTF_NUMBER_TABLE
13 );
14 procedure rosetta_table_copy_out_p2(t ozf_na_rule_line_pvt.na_rule_line_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_VARCHAR2_TABLE_100
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_DATE_TABLE
22 , a8 out nocopy JTF_NUMBER_TABLE
23 , a9 out nocopy JTF_NUMBER_TABLE
24 );
25
26 procedure create_na_rule_line(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_na_rule_line_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 VARCHAR2 := fnd_api.g_miss_char
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 DATE := fnd_api.g_miss_date
42 , p7_a8 NUMBER := 0-1962.0724
43 , p7_a9 NUMBER := 0-1962.0724
44 );
45 procedure update_na_rule_line(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 VARCHAR2 := fnd_api.g_miss_char
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 DATE := fnd_api.g_miss_date
60 , p7_a8 NUMBER := 0-1962.0724
61 , p7_a9 NUMBER := 0-1962.0724
62 );
63 procedure validate_na_rule_line(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 VARCHAR2 := fnd_api.g_miss_char
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 DATE := fnd_api.g_miss_date
78 , p3_a8 NUMBER := 0-1962.0724
79 , p3_a9 NUMBER := 0-1962.0724
80 );
81 procedure check_na_rule_ln_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 VARCHAR2 := fnd_api.g_miss_char
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 DATE := fnd_api.g_miss_date
91 , p0_a8 NUMBER := 0-1962.0724
92 , p0_a9 NUMBER := 0-1962.0724
93 );
94 procedure validate_na_rule_line_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 VARCHAR2 := fnd_api.g_miss_char
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 DATE := fnd_api.g_miss_date
107 , p5_a8 NUMBER := 0-1962.0724
108 , p5_a9 NUMBER := 0-1962.0724
109 );
110 end ozf_na_rule_line_pvt_w;