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
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
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: );
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
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
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
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
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
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
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
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
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
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
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: );
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
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
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
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
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
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
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: );
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
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
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
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
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
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
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: );
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;