16: , p3_a11 out nocopy NUMBER
17: , p0_a0 NUMBER := 0-1962.0724
18: , p0_a1 NUMBER := 0-1962.0724
19: , p0_a2 NUMBER := 0-1962.0724
20: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
21: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
22: , p0_a5 DATE := fnd_api.g_miss_date
23: , p0_a6 DATE := fnd_api.g_miss_date
24: , p0_a7 NUMBER := 0-1962.0724
17: , p0_a0 NUMBER := 0-1962.0724
18: , p0_a1 NUMBER := 0-1962.0724
19: , p0_a2 NUMBER := 0-1962.0724
20: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
21: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
22: , p0_a5 DATE := fnd_api.g_miss_date
23: , p0_a6 DATE := fnd_api.g_miss_date
24: , p0_a7 NUMBER := 0-1962.0724
25: , p0_a8 DATE := fnd_api.g_miss_date
18: , p0_a1 NUMBER := 0-1962.0724
19: , p0_a2 NUMBER := 0-1962.0724
20: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
21: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
22: , p0_a5 DATE := fnd_api.g_miss_date
23: , p0_a6 DATE := fnd_api.g_miss_date
24: , p0_a7 NUMBER := 0-1962.0724
25: , p0_a8 DATE := fnd_api.g_miss_date
26: , p0_a9 NUMBER := 0-1962.0724
19: , p0_a2 NUMBER := 0-1962.0724
20: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
21: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
22: , p0_a5 DATE := fnd_api.g_miss_date
23: , p0_a6 DATE := fnd_api.g_miss_date
24: , p0_a7 NUMBER := 0-1962.0724
25: , p0_a8 DATE := fnd_api.g_miss_date
26: , p0_a9 NUMBER := 0-1962.0724
27: , p0_a10 DATE := fnd_api.g_miss_date
21: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
22: , p0_a5 DATE := fnd_api.g_miss_date
23: , p0_a6 DATE := fnd_api.g_miss_date
24: , p0_a7 NUMBER := 0-1962.0724
25: , p0_a8 DATE := fnd_api.g_miss_date
26: , p0_a9 NUMBER := 0-1962.0724
27: , p0_a10 DATE := fnd_api.g_miss_date
28: , p0_a11 NUMBER := 0-1962.0724
29: );
23: , p0_a6 DATE := fnd_api.g_miss_date
24: , p0_a7 NUMBER := 0-1962.0724
25: , p0_a8 DATE := fnd_api.g_miss_date
26: , p0_a9 NUMBER := 0-1962.0724
27: , p0_a10 DATE := fnd_api.g_miss_date
28: , p0_a11 NUMBER := 0-1962.0724
29: );
30: procedure insert_pqyvalues(p_api_version NUMBER
31: , p_init_msg_list VARCHAR2
45: , p7_a10 out nocopy DATE
46: , p7_a11 out nocopy NUMBER
47: , p5_a0 NUMBER := 0-1962.0724
48: , p5_a1 NUMBER := 0-1962.0724
49: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
50: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
51: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
52: , p5_a5 DATE := fnd_api.g_miss_date
53: , p5_a6 DATE := fnd_api.g_miss_date
46: , p7_a11 out nocopy NUMBER
47: , p5_a0 NUMBER := 0-1962.0724
48: , p5_a1 NUMBER := 0-1962.0724
49: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
50: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
51: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
52: , p5_a5 DATE := fnd_api.g_miss_date
53: , p5_a6 DATE := fnd_api.g_miss_date
54: , p5_a7 NUMBER := 0-1962.0724
47: , p5_a0 NUMBER := 0-1962.0724
48: , p5_a1 NUMBER := 0-1962.0724
49: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
50: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
51: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
52: , p5_a5 DATE := fnd_api.g_miss_date
53: , p5_a6 DATE := fnd_api.g_miss_date
54: , p5_a7 NUMBER := 0-1962.0724
55: , p5_a8 DATE := fnd_api.g_miss_date
48: , p5_a1 NUMBER := 0-1962.0724
49: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
50: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
51: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
52: , p5_a5 DATE := fnd_api.g_miss_date
53: , p5_a6 DATE := fnd_api.g_miss_date
54: , p5_a7 NUMBER := 0-1962.0724
55: , p5_a8 DATE := fnd_api.g_miss_date
56: , p5_a9 NUMBER := 0-1962.0724
49: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
50: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
51: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
52: , p5_a5 DATE := fnd_api.g_miss_date
53: , p5_a6 DATE := fnd_api.g_miss_date
54: , p5_a7 NUMBER := 0-1962.0724
55: , p5_a8 DATE := fnd_api.g_miss_date
56: , p5_a9 NUMBER := 0-1962.0724
57: , p5_a10 DATE := fnd_api.g_miss_date
51: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
52: , p5_a5 DATE := fnd_api.g_miss_date
53: , p5_a6 DATE := fnd_api.g_miss_date
54: , p5_a7 NUMBER := 0-1962.0724
55: , p5_a8 DATE := fnd_api.g_miss_date
56: , p5_a9 NUMBER := 0-1962.0724
57: , p5_a10 DATE := fnd_api.g_miss_date
58: , p5_a11 NUMBER := 0-1962.0724
59: , p6_a0 NUMBER := 0-1962.0724
53: , p5_a6 DATE := fnd_api.g_miss_date
54: , p5_a7 NUMBER := 0-1962.0724
55: , p5_a8 DATE := fnd_api.g_miss_date
56: , p5_a9 NUMBER := 0-1962.0724
57: , p5_a10 DATE := fnd_api.g_miss_date
58: , p5_a11 NUMBER := 0-1962.0724
59: , p6_a0 NUMBER := 0-1962.0724
60: , p6_a1 NUMBER := 0-1962.0724
61: , p6_a2 NUMBER := 0-1962.0724
58: , p5_a11 NUMBER := 0-1962.0724
59: , p6_a0 NUMBER := 0-1962.0724
60: , p6_a1 NUMBER := 0-1962.0724
61: , p6_a2 NUMBER := 0-1962.0724
62: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
63: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
64: , p6_a5 DATE := fnd_api.g_miss_date
65: , p6_a6 DATE := fnd_api.g_miss_date
66: , p6_a7 NUMBER := 0-1962.0724
59: , p6_a0 NUMBER := 0-1962.0724
60: , p6_a1 NUMBER := 0-1962.0724
61: , p6_a2 NUMBER := 0-1962.0724
62: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
63: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
64: , p6_a5 DATE := fnd_api.g_miss_date
65: , p6_a6 DATE := fnd_api.g_miss_date
66: , p6_a7 NUMBER := 0-1962.0724
67: , p6_a8 DATE := fnd_api.g_miss_date
60: , p6_a1 NUMBER := 0-1962.0724
61: , p6_a2 NUMBER := 0-1962.0724
62: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
63: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
64: , p6_a5 DATE := fnd_api.g_miss_date
65: , p6_a6 DATE := fnd_api.g_miss_date
66: , p6_a7 NUMBER := 0-1962.0724
67: , p6_a8 DATE := fnd_api.g_miss_date
68: , p6_a9 NUMBER := 0-1962.0724
61: , p6_a2 NUMBER := 0-1962.0724
62: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
63: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
64: , p6_a5 DATE := fnd_api.g_miss_date
65: , p6_a6 DATE := fnd_api.g_miss_date
66: , p6_a7 NUMBER := 0-1962.0724
67: , p6_a8 DATE := fnd_api.g_miss_date
68: , p6_a9 NUMBER := 0-1962.0724
69: , p6_a10 DATE := fnd_api.g_miss_date
63: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
64: , p6_a5 DATE := fnd_api.g_miss_date
65: , p6_a6 DATE := fnd_api.g_miss_date
66: , p6_a7 NUMBER := 0-1962.0724
67: , p6_a8 DATE := fnd_api.g_miss_date
68: , p6_a9 NUMBER := 0-1962.0724
69: , p6_a10 DATE := fnd_api.g_miss_date
70: , p6_a11 NUMBER := 0-1962.0724
71: );
65: , p6_a6 DATE := fnd_api.g_miss_date
66: , p6_a7 NUMBER := 0-1962.0724
67: , p6_a8 DATE := fnd_api.g_miss_date
68: , p6_a9 NUMBER := 0-1962.0724
69: , p6_a10 DATE := fnd_api.g_miss_date
70: , p6_a11 NUMBER := 0-1962.0724
71: );
72: procedure update_pqyvalues(p_api_version NUMBER
73: , p_init_msg_list VARCHAR2
87: , p7_a10 out nocopy DATE
88: , p7_a11 out nocopy NUMBER
89: , p5_a0 NUMBER := 0-1962.0724
90: , p5_a1 NUMBER := 0-1962.0724
91: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
93: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
94: , p5_a5 DATE := fnd_api.g_miss_date
95: , p5_a6 DATE := fnd_api.g_miss_date
88: , p7_a11 out nocopy NUMBER
89: , p5_a0 NUMBER := 0-1962.0724
90: , p5_a1 NUMBER := 0-1962.0724
91: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
93: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
94: , p5_a5 DATE := fnd_api.g_miss_date
95: , p5_a6 DATE := fnd_api.g_miss_date
96: , p5_a7 NUMBER := 0-1962.0724
89: , p5_a0 NUMBER := 0-1962.0724
90: , p5_a1 NUMBER := 0-1962.0724
91: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
93: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
94: , p5_a5 DATE := fnd_api.g_miss_date
95: , p5_a6 DATE := fnd_api.g_miss_date
96: , p5_a7 NUMBER := 0-1962.0724
97: , p5_a8 DATE := fnd_api.g_miss_date
90: , p5_a1 NUMBER := 0-1962.0724
91: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
93: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
94: , p5_a5 DATE := fnd_api.g_miss_date
95: , p5_a6 DATE := fnd_api.g_miss_date
96: , p5_a7 NUMBER := 0-1962.0724
97: , p5_a8 DATE := fnd_api.g_miss_date
98: , p5_a9 NUMBER := 0-1962.0724
91: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
93: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
94: , p5_a5 DATE := fnd_api.g_miss_date
95: , p5_a6 DATE := fnd_api.g_miss_date
96: , p5_a7 NUMBER := 0-1962.0724
97: , p5_a8 DATE := fnd_api.g_miss_date
98: , p5_a9 NUMBER := 0-1962.0724
99: , p5_a10 DATE := fnd_api.g_miss_date
93: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
94: , p5_a5 DATE := fnd_api.g_miss_date
95: , p5_a6 DATE := fnd_api.g_miss_date
96: , p5_a7 NUMBER := 0-1962.0724
97: , p5_a8 DATE := fnd_api.g_miss_date
98: , p5_a9 NUMBER := 0-1962.0724
99: , p5_a10 DATE := fnd_api.g_miss_date
100: , p5_a11 NUMBER := 0-1962.0724
101: , p6_a0 NUMBER := 0-1962.0724
95: , p5_a6 DATE := fnd_api.g_miss_date
96: , p5_a7 NUMBER := 0-1962.0724
97: , p5_a8 DATE := fnd_api.g_miss_date
98: , p5_a9 NUMBER := 0-1962.0724
99: , p5_a10 DATE := fnd_api.g_miss_date
100: , p5_a11 NUMBER := 0-1962.0724
101: , p6_a0 NUMBER := 0-1962.0724
102: , p6_a1 NUMBER := 0-1962.0724
103: , p6_a2 NUMBER := 0-1962.0724
100: , p5_a11 NUMBER := 0-1962.0724
101: , p6_a0 NUMBER := 0-1962.0724
102: , p6_a1 NUMBER := 0-1962.0724
103: , p6_a2 NUMBER := 0-1962.0724
104: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
105: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
106: , p6_a5 DATE := fnd_api.g_miss_date
107: , p6_a6 DATE := fnd_api.g_miss_date
108: , p6_a7 NUMBER := 0-1962.0724
101: , p6_a0 NUMBER := 0-1962.0724
102: , p6_a1 NUMBER := 0-1962.0724
103: , p6_a2 NUMBER := 0-1962.0724
104: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
105: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
106: , p6_a5 DATE := fnd_api.g_miss_date
107: , p6_a6 DATE := fnd_api.g_miss_date
108: , p6_a7 NUMBER := 0-1962.0724
109: , p6_a8 DATE := fnd_api.g_miss_date
102: , p6_a1 NUMBER := 0-1962.0724
103: , p6_a2 NUMBER := 0-1962.0724
104: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
105: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
106: , p6_a5 DATE := fnd_api.g_miss_date
107: , p6_a6 DATE := fnd_api.g_miss_date
108: , p6_a7 NUMBER := 0-1962.0724
109: , p6_a8 DATE := fnd_api.g_miss_date
110: , p6_a9 NUMBER := 0-1962.0724
103: , p6_a2 NUMBER := 0-1962.0724
104: , p6_a3 VARCHAR2 := fnd_api.g_miss_char
105: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
106: , p6_a5 DATE := fnd_api.g_miss_date
107: , p6_a6 DATE := fnd_api.g_miss_date
108: , p6_a7 NUMBER := 0-1962.0724
109: , p6_a8 DATE := fnd_api.g_miss_date
110: , p6_a9 NUMBER := 0-1962.0724
111: , p6_a10 DATE := fnd_api.g_miss_date
105: , p6_a4 VARCHAR2 := fnd_api.g_miss_char
106: , p6_a5 DATE := fnd_api.g_miss_date
107: , p6_a6 DATE := fnd_api.g_miss_date
108: , p6_a7 NUMBER := 0-1962.0724
109: , p6_a8 DATE := fnd_api.g_miss_date
110: , p6_a9 NUMBER := 0-1962.0724
111: , p6_a10 DATE := fnd_api.g_miss_date
112: , p6_a11 NUMBER := 0-1962.0724
113: );
107: , p6_a6 DATE := fnd_api.g_miss_date
108: , p6_a7 NUMBER := 0-1962.0724
109: , p6_a8 DATE := fnd_api.g_miss_date
110: , p6_a9 NUMBER := 0-1962.0724
111: , p6_a10 DATE := fnd_api.g_miss_date
112: , p6_a11 NUMBER := 0-1962.0724
113: );
114: end okl_setuppqyvalues_pvt_w;