17: , p0_a0 NUMBER := 0-1962.0724
18: , p0_a1 NUMBER := 0-1962.0724
19: , p0_a2 NUMBER := 0-1962.0724
20: , p0_a3 NUMBER := 0-1962.0724
21: , p0_a4 DATE := fnd_api.g_miss_date
22: , p0_a5 DATE := fnd_api.g_miss_date
23: , p0_a6 NUMBER := 0-1962.0724
24: , p0_a7 DATE := fnd_api.g_miss_date
25: , p0_a8 NUMBER := 0-1962.0724
18: , p0_a1 NUMBER := 0-1962.0724
19: , p0_a2 NUMBER := 0-1962.0724
20: , p0_a3 NUMBER := 0-1962.0724
21: , p0_a4 DATE := fnd_api.g_miss_date
22: , p0_a5 DATE := fnd_api.g_miss_date
23: , p0_a6 NUMBER := 0-1962.0724
24: , p0_a7 DATE := fnd_api.g_miss_date
25: , p0_a8 NUMBER := 0-1962.0724
26: , p0_a9 DATE := fnd_api.g_miss_date
20: , p0_a3 NUMBER := 0-1962.0724
21: , p0_a4 DATE := fnd_api.g_miss_date
22: , p0_a5 DATE := fnd_api.g_miss_date
23: , p0_a6 NUMBER := 0-1962.0724
24: , p0_a7 DATE := fnd_api.g_miss_date
25: , p0_a8 NUMBER := 0-1962.0724
26: , p0_a9 DATE := fnd_api.g_miss_date
27: , p0_a10 NUMBER := 0-1962.0724
28: );
22: , p0_a5 DATE := fnd_api.g_miss_date
23: , p0_a6 NUMBER := 0-1962.0724
24: , p0_a7 DATE := fnd_api.g_miss_date
25: , p0_a8 NUMBER := 0-1962.0724
26: , p0_a9 DATE := fnd_api.g_miss_date
27: , p0_a10 NUMBER := 0-1962.0724
28: );
29: procedure insert_dqualitys(p_api_version NUMBER
30: , p_init_msg_list VARCHAR2
43: , p7_a9 out nocopy DATE
44: , p7_a10 out nocopy NUMBER
45: , p5_a0 NUMBER := 0-1962.0724
46: , p5_a1 NUMBER := 0-1962.0724
47: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
48: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
49: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
50: , p5_a5 DATE := fnd_api.g_miss_date
51: , p5_a6 DATE := fnd_api.g_miss_date
44: , p7_a10 out nocopy NUMBER
45: , p5_a0 NUMBER := 0-1962.0724
46: , p5_a1 NUMBER := 0-1962.0724
47: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
48: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
49: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
50: , p5_a5 DATE := fnd_api.g_miss_date
51: , p5_a6 DATE := fnd_api.g_miss_date
52: , p5_a7 NUMBER := 0-1962.0724
45: , p5_a0 NUMBER := 0-1962.0724
46: , p5_a1 NUMBER := 0-1962.0724
47: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
48: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
49: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
50: , p5_a5 DATE := fnd_api.g_miss_date
51: , p5_a6 DATE := fnd_api.g_miss_date
52: , p5_a7 NUMBER := 0-1962.0724
53: , p5_a8 DATE := fnd_api.g_miss_date
46: , p5_a1 NUMBER := 0-1962.0724
47: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
48: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
49: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
50: , p5_a5 DATE := fnd_api.g_miss_date
51: , p5_a6 DATE := fnd_api.g_miss_date
52: , p5_a7 NUMBER := 0-1962.0724
53: , p5_a8 DATE := fnd_api.g_miss_date
54: , p5_a9 NUMBER := 0-1962.0724
47: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
48: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
49: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
50: , p5_a5 DATE := fnd_api.g_miss_date
51: , p5_a6 DATE := fnd_api.g_miss_date
52: , p5_a7 NUMBER := 0-1962.0724
53: , p5_a8 DATE := fnd_api.g_miss_date
54: , p5_a9 NUMBER := 0-1962.0724
55: , p5_a10 DATE := fnd_api.g_miss_date
49: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
50: , p5_a5 DATE := fnd_api.g_miss_date
51: , p5_a6 DATE := fnd_api.g_miss_date
52: , p5_a7 NUMBER := 0-1962.0724
53: , p5_a8 DATE := fnd_api.g_miss_date
54: , p5_a9 NUMBER := 0-1962.0724
55: , p5_a10 DATE := fnd_api.g_miss_date
56: , p5_a11 NUMBER := 0-1962.0724
57: , p6_a0 NUMBER := 0-1962.0724
51: , p5_a6 DATE := fnd_api.g_miss_date
52: , p5_a7 NUMBER := 0-1962.0724
53: , p5_a8 DATE := fnd_api.g_miss_date
54: , p5_a9 NUMBER := 0-1962.0724
55: , p5_a10 DATE := fnd_api.g_miss_date
56: , p5_a11 NUMBER := 0-1962.0724
57: , p6_a0 NUMBER := 0-1962.0724
58: , p6_a1 NUMBER := 0-1962.0724
59: , p6_a2 NUMBER := 0-1962.0724
57: , p6_a0 NUMBER := 0-1962.0724
58: , p6_a1 NUMBER := 0-1962.0724
59: , p6_a2 NUMBER := 0-1962.0724
60: , p6_a3 NUMBER := 0-1962.0724
61: , p6_a4 DATE := fnd_api.g_miss_date
62: , p6_a5 DATE := fnd_api.g_miss_date
63: , p6_a6 NUMBER := 0-1962.0724
64: , p6_a7 DATE := fnd_api.g_miss_date
65: , p6_a8 NUMBER := 0-1962.0724
58: , p6_a1 NUMBER := 0-1962.0724
59: , p6_a2 NUMBER := 0-1962.0724
60: , p6_a3 NUMBER := 0-1962.0724
61: , p6_a4 DATE := fnd_api.g_miss_date
62: , p6_a5 DATE := fnd_api.g_miss_date
63: , p6_a6 NUMBER := 0-1962.0724
64: , p6_a7 DATE := fnd_api.g_miss_date
65: , p6_a8 NUMBER := 0-1962.0724
66: , p6_a9 DATE := fnd_api.g_miss_date
60: , p6_a3 NUMBER := 0-1962.0724
61: , p6_a4 DATE := fnd_api.g_miss_date
62: , p6_a5 DATE := fnd_api.g_miss_date
63: , p6_a6 NUMBER := 0-1962.0724
64: , p6_a7 DATE := fnd_api.g_miss_date
65: , p6_a8 NUMBER := 0-1962.0724
66: , p6_a9 DATE := fnd_api.g_miss_date
67: , p6_a10 NUMBER := 0-1962.0724
68: );
62: , p6_a5 DATE := fnd_api.g_miss_date
63: , p6_a6 NUMBER := 0-1962.0724
64: , p6_a7 DATE := fnd_api.g_miss_date
65: , p6_a8 NUMBER := 0-1962.0724
66: , p6_a9 DATE := fnd_api.g_miss_date
67: , p6_a10 NUMBER := 0-1962.0724
68: );
69: procedure insert_dqualitys(p_api_version NUMBER
70: , p_init_msg_list VARCHAR2
94: , p7_a9 out nocopy JTF_DATE_TABLE
95: , p7_a10 out nocopy JTF_NUMBER_TABLE
96: , p5_a0 NUMBER := 0-1962.0724
97: , p5_a1 NUMBER := 0-1962.0724
98: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
99: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
100: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
101: , p5_a5 DATE := fnd_api.g_miss_date
102: , p5_a6 DATE := fnd_api.g_miss_date
95: , p7_a10 out nocopy JTF_NUMBER_TABLE
96: , p5_a0 NUMBER := 0-1962.0724
97: , p5_a1 NUMBER := 0-1962.0724
98: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
99: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
100: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
101: , p5_a5 DATE := fnd_api.g_miss_date
102: , p5_a6 DATE := fnd_api.g_miss_date
103: , p5_a7 NUMBER := 0-1962.0724
96: , p5_a0 NUMBER := 0-1962.0724
97: , p5_a1 NUMBER := 0-1962.0724
98: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
99: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
100: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
101: , p5_a5 DATE := fnd_api.g_miss_date
102: , p5_a6 DATE := fnd_api.g_miss_date
103: , p5_a7 NUMBER := 0-1962.0724
104: , p5_a8 DATE := fnd_api.g_miss_date
97: , p5_a1 NUMBER := 0-1962.0724
98: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
99: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
100: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
101: , p5_a5 DATE := fnd_api.g_miss_date
102: , p5_a6 DATE := fnd_api.g_miss_date
103: , p5_a7 NUMBER := 0-1962.0724
104: , p5_a8 DATE := fnd_api.g_miss_date
105: , p5_a9 NUMBER := 0-1962.0724
98: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
99: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
100: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
101: , p5_a5 DATE := fnd_api.g_miss_date
102: , p5_a6 DATE := fnd_api.g_miss_date
103: , p5_a7 NUMBER := 0-1962.0724
104: , p5_a8 DATE := fnd_api.g_miss_date
105: , p5_a9 NUMBER := 0-1962.0724
106: , p5_a10 DATE := fnd_api.g_miss_date
100: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
101: , p5_a5 DATE := fnd_api.g_miss_date
102: , p5_a6 DATE := fnd_api.g_miss_date
103: , p5_a7 NUMBER := 0-1962.0724
104: , p5_a8 DATE := fnd_api.g_miss_date
105: , p5_a9 NUMBER := 0-1962.0724
106: , p5_a10 DATE := fnd_api.g_miss_date
107: , p5_a11 NUMBER := 0-1962.0724
108: );
102: , p5_a6 DATE := fnd_api.g_miss_date
103: , p5_a7 NUMBER := 0-1962.0724
104: , p5_a8 DATE := fnd_api.g_miss_date
105: , p5_a9 NUMBER := 0-1962.0724
106: , p5_a10 DATE := fnd_api.g_miss_date
107: , p5_a11 NUMBER := 0-1962.0724
108: );
109: procedure delete_dqualitys(p_api_version NUMBER
110: , p_init_msg_list VARCHAR2
123: , p6_a9 JTF_DATE_TABLE
124: , p6_a10 JTF_NUMBER_TABLE
125: , p5_a0 NUMBER := 0-1962.0724
126: , p5_a1 NUMBER := 0-1962.0724
127: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
128: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
129: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
130: , p5_a5 DATE := fnd_api.g_miss_date
131: , p5_a6 DATE := fnd_api.g_miss_date
124: , p6_a10 JTF_NUMBER_TABLE
125: , p5_a0 NUMBER := 0-1962.0724
126: , p5_a1 NUMBER := 0-1962.0724
127: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
128: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
129: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
130: , p5_a5 DATE := fnd_api.g_miss_date
131: , p5_a6 DATE := fnd_api.g_miss_date
132: , p5_a7 NUMBER := 0-1962.0724
125: , p5_a0 NUMBER := 0-1962.0724
126: , p5_a1 NUMBER := 0-1962.0724
127: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
128: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
129: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
130: , p5_a5 DATE := fnd_api.g_miss_date
131: , p5_a6 DATE := fnd_api.g_miss_date
132: , p5_a7 NUMBER := 0-1962.0724
133: , p5_a8 DATE := fnd_api.g_miss_date
126: , p5_a1 NUMBER := 0-1962.0724
127: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
128: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
129: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
130: , p5_a5 DATE := fnd_api.g_miss_date
131: , p5_a6 DATE := fnd_api.g_miss_date
132: , p5_a7 NUMBER := 0-1962.0724
133: , p5_a8 DATE := fnd_api.g_miss_date
134: , p5_a9 NUMBER := 0-1962.0724
127: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
128: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
129: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
130: , p5_a5 DATE := fnd_api.g_miss_date
131: , p5_a6 DATE := fnd_api.g_miss_date
132: , p5_a7 NUMBER := 0-1962.0724
133: , p5_a8 DATE := fnd_api.g_miss_date
134: , p5_a9 NUMBER := 0-1962.0724
135: , p5_a10 DATE := fnd_api.g_miss_date
129: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
130: , p5_a5 DATE := fnd_api.g_miss_date
131: , p5_a6 DATE := fnd_api.g_miss_date
132: , p5_a7 NUMBER := 0-1962.0724
133: , p5_a8 DATE := fnd_api.g_miss_date
134: , p5_a9 NUMBER := 0-1962.0724
135: , p5_a10 DATE := fnd_api.g_miss_date
136: , p5_a11 NUMBER := 0-1962.0724
137: );
131: , p5_a6 DATE := fnd_api.g_miss_date
132: , p5_a7 NUMBER := 0-1962.0724
133: , p5_a8 DATE := fnd_api.g_miss_date
134: , p5_a9 NUMBER := 0-1962.0724
135: , p5_a10 DATE := fnd_api.g_miss_date
136: , p5_a11 NUMBER := 0-1962.0724
137: );
138: end okl_setupdqualitys_pub_w;