[Home] [Help]
PACKAGE: APPS.OKL_SETUPDQUALITYS_PVT_W
Source
1 package okl_setupdqualitys_pvt_w AUTHID CURRENT_USER as
2 /* $Header: OKLESDQS.pls 120.2 2007/03/04 10:08:58 dcshanmu ship $ */
3 procedure get_rec(x_no_data_found out nocopy number
4 , x_return_status out nocopy VARCHAR2
5 , p3_a0 out nocopy NUMBER
6 , p3_a1 out nocopy NUMBER
7 , p3_a2 out nocopy NUMBER
8 , p3_a3 out nocopy NUMBER
9 , p3_a4 out nocopy DATE
10 , p3_a5 out nocopy DATE
11 , p3_a6 out nocopy NUMBER
12 , p3_a7 out nocopy DATE
13 , p3_a8 out nocopy NUMBER
14 , p3_a9 out nocopy DATE
15 , p3_a10 out nocopy NUMBER
16 , p0_a0 NUMBER := 0-1962.0724
17 , p0_a1 NUMBER := 0-1962.0724
18 , p0_a2 NUMBER := 0-1962.0724
19 , p0_a3 NUMBER := 0-1962.0724
20 , p0_a4 DATE := fnd_api.g_miss_date
21 , p0_a5 DATE := fnd_api.g_miss_date
22 , p0_a6 NUMBER := 0-1962.0724
23 , p0_a7 DATE := fnd_api.g_miss_date
24 , p0_a8 NUMBER := 0-1962.0724
25 , p0_a9 DATE := fnd_api.g_miss_date
26 , p0_a10 NUMBER := 0-1962.0724
27 );
28 procedure insert_dqualitys(p_api_version NUMBER
29 , p_init_msg_list VARCHAR2
30 , x_return_status out nocopy VARCHAR2
31 , x_msg_count out nocopy NUMBER
32 , x_msg_data out nocopy VARCHAR2
33 , p7_a0 out nocopy NUMBER
34 , p7_a1 out nocopy NUMBER
35 , p7_a2 out nocopy NUMBER
36 , p7_a3 out nocopy NUMBER
37 , p7_a4 out nocopy DATE
38 , p7_a5 out nocopy DATE
39 , p7_a6 out nocopy NUMBER
40 , p7_a7 out nocopy DATE
41 , p7_a8 out nocopy NUMBER
42 , p7_a9 out nocopy DATE
43 , p7_a10 out nocopy NUMBER
44 , p5_a0 NUMBER := 0-1962.0724
45 , p5_a1 NUMBER := 0-1962.0724
46 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
47 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
48 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
49 , p5_a5 DATE := fnd_api.g_miss_date
50 , p5_a6 DATE := fnd_api.g_miss_date
51 , p5_a7 NUMBER := 0-1962.0724
52 , p5_a8 DATE := fnd_api.g_miss_date
53 , p5_a9 NUMBER := 0-1962.0724
54 , p5_a10 DATE := fnd_api.g_miss_date
55 , p5_a11 NUMBER := 0-1962.0724
56 , p6_a0 NUMBER := 0-1962.0724
57 , p6_a1 NUMBER := 0-1962.0724
58 , p6_a2 NUMBER := 0-1962.0724
59 , p6_a3 NUMBER := 0-1962.0724
60 , p6_a4 DATE := fnd_api.g_miss_date
61 , p6_a5 DATE := fnd_api.g_miss_date
62 , p6_a6 NUMBER := 0-1962.0724
63 , p6_a7 DATE := fnd_api.g_miss_date
64 , p6_a8 NUMBER := 0-1962.0724
65 , p6_a9 DATE := fnd_api.g_miss_date
66 , p6_a10 NUMBER := 0-1962.0724
67 );
68 procedure insert_dqualitys(p_api_version NUMBER
69 , p_init_msg_list VARCHAR2
70 , x_return_status out nocopy VARCHAR2
71 , x_msg_count out nocopy NUMBER
72 , x_msg_data out nocopy VARCHAR2
73 , p6_a0 JTF_NUMBER_TABLE
74 , p6_a1 JTF_NUMBER_TABLE
75 , p6_a2 JTF_NUMBER_TABLE
76 , p6_a3 JTF_NUMBER_TABLE
77 , p6_a4 JTF_DATE_TABLE
78 , p6_a5 JTF_DATE_TABLE
79 , p6_a6 JTF_NUMBER_TABLE
80 , p6_a7 JTF_DATE_TABLE
81 , p6_a8 JTF_NUMBER_TABLE
82 , p6_a9 JTF_DATE_TABLE
83 , p6_a10 JTF_NUMBER_TABLE
84 , p7_a0 out nocopy JTF_NUMBER_TABLE
85 , p7_a1 out nocopy JTF_NUMBER_TABLE
86 , p7_a2 out nocopy JTF_NUMBER_TABLE
87 , p7_a3 out nocopy JTF_NUMBER_TABLE
88 , p7_a4 out nocopy JTF_DATE_TABLE
89 , p7_a5 out nocopy JTF_DATE_TABLE
90 , p7_a6 out nocopy JTF_NUMBER_TABLE
91 , p7_a7 out nocopy JTF_DATE_TABLE
92 , p7_a8 out nocopy JTF_NUMBER_TABLE
93 , p7_a9 out nocopy JTF_DATE_TABLE
94 , p7_a10 out nocopy JTF_NUMBER_TABLE
95 , p5_a0 NUMBER := 0-1962.0724
96 , p5_a1 NUMBER := 0-1962.0724
97 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
98 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
99 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
100 , p5_a5 DATE := fnd_api.g_miss_date
101 , p5_a6 DATE := fnd_api.g_miss_date
102 , p5_a7 NUMBER := 0-1962.0724
103 , p5_a8 DATE := fnd_api.g_miss_date
104 , p5_a9 NUMBER := 0-1962.0724
105 , p5_a10 DATE := fnd_api.g_miss_date
106 , p5_a11 NUMBER := 0-1962.0724
107 );
108 procedure delete_dqualitys(p_api_version NUMBER
109 , p_init_msg_list VARCHAR2
110 , x_return_status out nocopy VARCHAR2
111 , x_msg_count out nocopy NUMBER
112 , x_msg_data out nocopy VARCHAR2
113 , p6_a0 JTF_NUMBER_TABLE
114 , p6_a1 JTF_NUMBER_TABLE
115 , p6_a2 JTF_NUMBER_TABLE
116 , p6_a3 JTF_NUMBER_TABLE
117 , p6_a4 JTF_DATE_TABLE
118 , p6_a5 JTF_DATE_TABLE
119 , p6_a6 JTF_NUMBER_TABLE
120 , p6_a7 JTF_DATE_TABLE
121 , p6_a8 JTF_NUMBER_TABLE
122 , p6_a9 JTF_DATE_TABLE
123 , p6_a10 JTF_NUMBER_TABLE
124 , p5_a0 NUMBER := 0-1962.0724
125 , p5_a1 NUMBER := 0-1962.0724
126 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
127 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
128 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
129 , p5_a5 DATE := fnd_api.g_miss_date
130 , p5_a6 DATE := fnd_api.g_miss_date
131 , p5_a7 NUMBER := 0-1962.0724
132 , p5_a8 DATE := fnd_api.g_miss_date
133 , p5_a9 NUMBER := 0-1962.0724
134 , p5_a10 DATE := fnd_api.g_miss_date
135 , p5_a11 NUMBER := 0-1962.0724
136 );
137 end okl_setupdqualitys_pvt_w;