APPS.OKL_SIF_RETS_PUB_W dependencies on FND_API

Line 46: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

42: , p6_a34 out nocopy NUMBER
43: , p6_a35 out nocopy DATE
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 NUMBER := 0-1962.0724
48: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
49: , p5_a5 NUMBER := 0-1962.0724
50: , p5_a6 NUMBER := 0-1962.0724

Line 48: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

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 NUMBER := 0-1962.0724
48: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
49: , p5_a5 NUMBER := 0-1962.0724
50: , p5_a6 NUMBER := 0-1962.0724
51: , p5_a7 NUMBER := 0-1962.0724
52: , p5_a8 NUMBER := 0-1962.0724

Line 53: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

49: , p5_a5 NUMBER := 0-1962.0724
50: , p5_a6 NUMBER := 0-1962.0724
51: , p5_a7 NUMBER := 0-1962.0724
52: , p5_a8 NUMBER := 0-1962.0724
53: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
54: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
55: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
56: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
57: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

Line 54: , p5_a10 VARCHAR2 := fnd_api.g_miss_char

50: , p5_a6 NUMBER := 0-1962.0724
51: , p5_a7 NUMBER := 0-1962.0724
52: , p5_a8 NUMBER := 0-1962.0724
53: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
54: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
55: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
56: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
57: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
58: , p5_a14 VARCHAR2 := fnd_api.g_miss_char

Line 55: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

51: , p5_a7 NUMBER := 0-1962.0724
52: , p5_a8 NUMBER := 0-1962.0724
53: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
54: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
55: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
56: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
57: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
58: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
59: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

Line 56: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

52: , p5_a8 NUMBER := 0-1962.0724
53: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
54: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
55: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
56: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
57: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
58: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
59: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
60: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

Line 57: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

53: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
54: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
55: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
56: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
57: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
58: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
59: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
60: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
61: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

Line 58: , p5_a14 VARCHAR2 := fnd_api.g_miss_char

54: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
55: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
56: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
57: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
58: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
59: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
60: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
61: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
62: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

Line 59: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

55: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
56: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
57: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
58: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
59: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
60: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
61: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
62: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
63: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

Line 60: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

56: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
57: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
58: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
59: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
60: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
61: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
62: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
63: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
64: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

Line 61: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

57: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
58: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
59: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
60: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
61: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
62: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
63: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
64: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
65: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

Line 62: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

58: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
59: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
60: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
61: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
62: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
63: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
64: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
65: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
66: , p5_a22 VARCHAR2 := fnd_api.g_miss_char

Line 63: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

59: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
60: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
61: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
62: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
63: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
64: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
65: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
66: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
67: , p5_a23 VARCHAR2 := fnd_api.g_miss_char

Line 64: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

60: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
61: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
62: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
63: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
64: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
65: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
66: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
67: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
68: , p5_a24 NUMBER := 0-1962.0724

Line 65: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

61: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
62: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
63: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
64: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
65: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
66: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
67: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
68: , p5_a24 NUMBER := 0-1962.0724
69: , p5_a25 NUMBER := 0-1962.0724

Line 66: , p5_a22 VARCHAR2 := fnd_api.g_miss_char

62: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
63: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
64: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
65: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
66: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
67: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
68: , p5_a24 NUMBER := 0-1962.0724
69: , p5_a25 NUMBER := 0-1962.0724
70: , p5_a26 NUMBER := 0-1962.0724

Line 67: , p5_a23 VARCHAR2 := fnd_api.g_miss_char

63: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
64: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
65: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
66: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
67: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
68: , p5_a24 NUMBER := 0-1962.0724
69: , p5_a25 NUMBER := 0-1962.0724
70: , p5_a26 NUMBER := 0-1962.0724
71: , p5_a27 DATE := fnd_api.g_miss_date

Line 71: , p5_a27 DATE := fnd_api.g_miss_date

67: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
68: , p5_a24 NUMBER := 0-1962.0724
69: , p5_a25 NUMBER := 0-1962.0724
70: , p5_a26 NUMBER := 0-1962.0724
71: , p5_a27 DATE := fnd_api.g_miss_date
72: , p5_a28 DATE := fnd_api.g_miss_date
73: , p5_a29 NUMBER := 0-1962.0724
74: , p5_a30 NUMBER := 0-1962.0724
75: , p5_a31 DATE := fnd_api.g_miss_date

Line 72: , p5_a28 DATE := fnd_api.g_miss_date

68: , p5_a24 NUMBER := 0-1962.0724
69: , p5_a25 NUMBER := 0-1962.0724
70: , p5_a26 NUMBER := 0-1962.0724
71: , p5_a27 DATE := fnd_api.g_miss_date
72: , p5_a28 DATE := fnd_api.g_miss_date
73: , p5_a29 NUMBER := 0-1962.0724
74: , p5_a30 NUMBER := 0-1962.0724
75: , p5_a31 DATE := fnd_api.g_miss_date
76: , p5_a32 NUMBER := 0-1962.0724

Line 75: , p5_a31 DATE := fnd_api.g_miss_date

71: , p5_a27 DATE := fnd_api.g_miss_date
72: , p5_a28 DATE := fnd_api.g_miss_date
73: , p5_a29 NUMBER := 0-1962.0724
74: , p5_a30 NUMBER := 0-1962.0724
75: , p5_a31 DATE := fnd_api.g_miss_date
76: , p5_a32 NUMBER := 0-1962.0724
77: , p5_a33 NUMBER := 0-1962.0724
78: , p5_a34 NUMBER := 0-1962.0724
79: , p5_a35 DATE := fnd_api.g_miss_date

Line 79: , p5_a35 DATE := fnd_api.g_miss_date

75: , p5_a31 DATE := fnd_api.g_miss_date
76: , p5_a32 NUMBER := 0-1962.0724
77: , p5_a33 NUMBER := 0-1962.0724
78: , p5_a34 NUMBER := 0-1962.0724
79: , p5_a35 DATE := fnd_api.g_miss_date
80: );
81: procedure insert_sif_rets(p_api_version NUMBER
82: , p_init_msg_list VARCHAR2
83: , x_return_status out nocopy VARCHAR2

Line 166: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

162: , x_msg_count out nocopy NUMBER
163: , x_msg_data out nocopy VARCHAR2
164: , p5_a0 NUMBER := 0-1962.0724
165: , p5_a1 NUMBER := 0-1962.0724
166: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
167: , p5_a3 NUMBER := 0-1962.0724
168: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
169: , p5_a5 NUMBER := 0-1962.0724
170: , p5_a6 NUMBER := 0-1962.0724

Line 168: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

164: , p5_a0 NUMBER := 0-1962.0724
165: , p5_a1 NUMBER := 0-1962.0724
166: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
167: , p5_a3 NUMBER := 0-1962.0724
168: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
169: , p5_a5 NUMBER := 0-1962.0724
170: , p5_a6 NUMBER := 0-1962.0724
171: , p5_a7 NUMBER := 0-1962.0724
172: , p5_a8 NUMBER := 0-1962.0724

Line 173: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

169: , p5_a5 NUMBER := 0-1962.0724
170: , p5_a6 NUMBER := 0-1962.0724
171: , p5_a7 NUMBER := 0-1962.0724
172: , p5_a8 NUMBER := 0-1962.0724
173: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
174: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
175: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
176: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
177: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

Line 174: , p5_a10 VARCHAR2 := fnd_api.g_miss_char

170: , p5_a6 NUMBER := 0-1962.0724
171: , p5_a7 NUMBER := 0-1962.0724
172: , p5_a8 NUMBER := 0-1962.0724
173: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
174: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
175: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
176: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
177: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
178: , p5_a14 VARCHAR2 := fnd_api.g_miss_char

Line 175: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

171: , p5_a7 NUMBER := 0-1962.0724
172: , p5_a8 NUMBER := 0-1962.0724
173: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
174: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
175: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
176: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
177: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
178: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
179: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

Line 176: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

172: , p5_a8 NUMBER := 0-1962.0724
173: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
174: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
175: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
176: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
177: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
178: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
179: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
180: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

Line 177: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

173: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
174: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
175: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
176: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
177: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
178: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
179: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
180: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
181: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

Line 178: , p5_a14 VARCHAR2 := fnd_api.g_miss_char

174: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
175: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
176: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
177: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
178: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
179: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
180: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
181: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
182: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

Line 179: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

175: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
176: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
177: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
178: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
179: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
180: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
181: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
182: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
183: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

Line 180: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

176: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
177: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
178: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
179: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
180: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
181: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
182: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
183: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
184: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

Line 181: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

177: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
178: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
179: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
180: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
181: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
182: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
183: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
184: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
185: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

Line 182: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

178: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
179: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
180: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
181: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
182: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
183: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
184: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
185: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
186: , p5_a22 VARCHAR2 := fnd_api.g_miss_char

Line 183: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

179: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
180: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
181: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
182: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
183: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
184: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
185: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
186: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
187: , p5_a23 VARCHAR2 := fnd_api.g_miss_char

Line 184: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

180: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
181: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
182: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
183: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
184: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
185: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
186: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
187: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
188: , p5_a24 NUMBER := 0-1962.0724

Line 185: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

181: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
182: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
183: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
184: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
185: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
186: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
187: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
188: , p5_a24 NUMBER := 0-1962.0724
189: , p5_a25 NUMBER := 0-1962.0724

Line 186: , p5_a22 VARCHAR2 := fnd_api.g_miss_char

182: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
183: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
184: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
185: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
186: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
187: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
188: , p5_a24 NUMBER := 0-1962.0724
189: , p5_a25 NUMBER := 0-1962.0724
190: , p5_a26 NUMBER := 0-1962.0724

Line 187: , p5_a23 VARCHAR2 := fnd_api.g_miss_char

183: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
184: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
185: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
186: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
187: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
188: , p5_a24 NUMBER := 0-1962.0724
189: , p5_a25 NUMBER := 0-1962.0724
190: , p5_a26 NUMBER := 0-1962.0724
191: , p5_a27 DATE := fnd_api.g_miss_date

Line 191: , p5_a27 DATE := fnd_api.g_miss_date

187: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
188: , p5_a24 NUMBER := 0-1962.0724
189: , p5_a25 NUMBER := 0-1962.0724
190: , p5_a26 NUMBER := 0-1962.0724
191: , p5_a27 DATE := fnd_api.g_miss_date
192: , p5_a28 DATE := fnd_api.g_miss_date
193: , p5_a29 NUMBER := 0-1962.0724
194: , p5_a30 NUMBER := 0-1962.0724
195: , p5_a31 DATE := fnd_api.g_miss_date

Line 192: , p5_a28 DATE := fnd_api.g_miss_date

188: , p5_a24 NUMBER := 0-1962.0724
189: , p5_a25 NUMBER := 0-1962.0724
190: , p5_a26 NUMBER := 0-1962.0724
191: , p5_a27 DATE := fnd_api.g_miss_date
192: , p5_a28 DATE := fnd_api.g_miss_date
193: , p5_a29 NUMBER := 0-1962.0724
194: , p5_a30 NUMBER := 0-1962.0724
195: , p5_a31 DATE := fnd_api.g_miss_date
196: , p5_a32 NUMBER := 0-1962.0724

Line 195: , p5_a31 DATE := fnd_api.g_miss_date

191: , p5_a27 DATE := fnd_api.g_miss_date
192: , p5_a28 DATE := fnd_api.g_miss_date
193: , p5_a29 NUMBER := 0-1962.0724
194: , p5_a30 NUMBER := 0-1962.0724
195: , p5_a31 DATE := fnd_api.g_miss_date
196: , p5_a32 NUMBER := 0-1962.0724
197: , p5_a33 NUMBER := 0-1962.0724
198: , p5_a34 NUMBER := 0-1962.0724
199: , p5_a35 DATE := fnd_api.g_miss_date

Line 199: , p5_a35 DATE := fnd_api.g_miss_date

195: , p5_a31 DATE := fnd_api.g_miss_date
196: , p5_a32 NUMBER := 0-1962.0724
197: , p5_a33 NUMBER := 0-1962.0724
198: , p5_a34 NUMBER := 0-1962.0724
199: , p5_a35 DATE := fnd_api.g_miss_date
200: );
201: procedure lock_sif_rets(p_api_version NUMBER
202: , p_init_msg_list VARCHAR2
203: , x_return_status out nocopy VARCHAR2

Line 286: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

282: , p6_a34 out nocopy NUMBER
283: , p6_a35 out nocopy DATE
284: , p5_a0 NUMBER := 0-1962.0724
285: , p5_a1 NUMBER := 0-1962.0724
286: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
287: , p5_a3 NUMBER := 0-1962.0724
288: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
289: , p5_a5 NUMBER := 0-1962.0724
290: , p5_a6 NUMBER := 0-1962.0724

Line 288: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

284: , p5_a0 NUMBER := 0-1962.0724
285: , p5_a1 NUMBER := 0-1962.0724
286: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
287: , p5_a3 NUMBER := 0-1962.0724
288: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
289: , p5_a5 NUMBER := 0-1962.0724
290: , p5_a6 NUMBER := 0-1962.0724
291: , p5_a7 NUMBER := 0-1962.0724
292: , p5_a8 NUMBER := 0-1962.0724

Line 293: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

289: , p5_a5 NUMBER := 0-1962.0724
290: , p5_a6 NUMBER := 0-1962.0724
291: , p5_a7 NUMBER := 0-1962.0724
292: , p5_a8 NUMBER := 0-1962.0724
293: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
294: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
295: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
296: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
297: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

Line 294: , p5_a10 VARCHAR2 := fnd_api.g_miss_char

290: , p5_a6 NUMBER := 0-1962.0724
291: , p5_a7 NUMBER := 0-1962.0724
292: , p5_a8 NUMBER := 0-1962.0724
293: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
294: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
295: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
296: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
297: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
298: , p5_a14 VARCHAR2 := fnd_api.g_miss_char

Line 295: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

291: , p5_a7 NUMBER := 0-1962.0724
292: , p5_a8 NUMBER := 0-1962.0724
293: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
294: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
295: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
296: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
297: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
298: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
299: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

Line 296: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

292: , p5_a8 NUMBER := 0-1962.0724
293: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
294: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
295: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
296: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
297: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
298: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
299: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
300: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

Line 297: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

293: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
294: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
295: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
296: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
297: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
298: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
299: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
300: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
301: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

Line 298: , p5_a14 VARCHAR2 := fnd_api.g_miss_char

294: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
295: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
296: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
297: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
298: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
299: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
300: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
301: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
302: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

Line 299: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

295: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
296: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
297: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
298: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
299: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
300: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
301: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
302: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
303: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

Line 300: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

296: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
297: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
298: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
299: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
300: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
301: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
302: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
303: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
304: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

Line 301: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

297: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
298: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
299: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
300: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
301: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
302: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
303: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
304: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
305: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

Line 302: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

298: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
299: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
300: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
301: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
302: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
303: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
304: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
305: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
306: , p5_a22 VARCHAR2 := fnd_api.g_miss_char

Line 303: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

299: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
300: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
301: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
302: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
303: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
304: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
305: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
306: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
307: , p5_a23 VARCHAR2 := fnd_api.g_miss_char

Line 304: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

300: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
301: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
302: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
303: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
304: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
305: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
306: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
307: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
308: , p5_a24 NUMBER := 0-1962.0724

Line 305: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

301: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
302: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
303: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
304: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
305: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
306: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
307: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
308: , p5_a24 NUMBER := 0-1962.0724
309: , p5_a25 NUMBER := 0-1962.0724

Line 306: , p5_a22 VARCHAR2 := fnd_api.g_miss_char

302: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
303: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
304: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
305: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
306: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
307: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
308: , p5_a24 NUMBER := 0-1962.0724
309: , p5_a25 NUMBER := 0-1962.0724
310: , p5_a26 NUMBER := 0-1962.0724

Line 307: , p5_a23 VARCHAR2 := fnd_api.g_miss_char

303: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
304: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
305: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
306: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
307: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
308: , p5_a24 NUMBER := 0-1962.0724
309: , p5_a25 NUMBER := 0-1962.0724
310: , p5_a26 NUMBER := 0-1962.0724
311: , p5_a27 DATE := fnd_api.g_miss_date

Line 311: , p5_a27 DATE := fnd_api.g_miss_date

307: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
308: , p5_a24 NUMBER := 0-1962.0724
309: , p5_a25 NUMBER := 0-1962.0724
310: , p5_a26 NUMBER := 0-1962.0724
311: , p5_a27 DATE := fnd_api.g_miss_date
312: , p5_a28 DATE := fnd_api.g_miss_date
313: , p5_a29 NUMBER := 0-1962.0724
314: , p5_a30 NUMBER := 0-1962.0724
315: , p5_a31 DATE := fnd_api.g_miss_date

Line 312: , p5_a28 DATE := fnd_api.g_miss_date

308: , p5_a24 NUMBER := 0-1962.0724
309: , p5_a25 NUMBER := 0-1962.0724
310: , p5_a26 NUMBER := 0-1962.0724
311: , p5_a27 DATE := fnd_api.g_miss_date
312: , p5_a28 DATE := fnd_api.g_miss_date
313: , p5_a29 NUMBER := 0-1962.0724
314: , p5_a30 NUMBER := 0-1962.0724
315: , p5_a31 DATE := fnd_api.g_miss_date
316: , p5_a32 NUMBER := 0-1962.0724

Line 315: , p5_a31 DATE := fnd_api.g_miss_date

311: , p5_a27 DATE := fnd_api.g_miss_date
312: , p5_a28 DATE := fnd_api.g_miss_date
313: , p5_a29 NUMBER := 0-1962.0724
314: , p5_a30 NUMBER := 0-1962.0724
315: , p5_a31 DATE := fnd_api.g_miss_date
316: , p5_a32 NUMBER := 0-1962.0724
317: , p5_a33 NUMBER := 0-1962.0724
318: , p5_a34 NUMBER := 0-1962.0724
319: , p5_a35 DATE := fnd_api.g_miss_date

Line 319: , p5_a35 DATE := fnd_api.g_miss_date

315: , p5_a31 DATE := fnd_api.g_miss_date
316: , p5_a32 NUMBER := 0-1962.0724
317: , p5_a33 NUMBER := 0-1962.0724
318: , p5_a34 NUMBER := 0-1962.0724
319: , p5_a35 DATE := fnd_api.g_miss_date
320: );
321: procedure update_sif_rets(p_api_version NUMBER
322: , p_init_msg_list VARCHAR2
323: , x_return_status out nocopy VARCHAR2

Line 442: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

438: , p6_a34 out nocopy NUMBER
439: , p6_a35 out nocopy DATE
440: , p5_a0 NUMBER := 0-1962.0724
441: , p5_a1 NUMBER := 0-1962.0724
442: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
443: , p5_a3 NUMBER := 0-1962.0724
444: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
445: , p5_a5 NUMBER := 0-1962.0724
446: , p5_a6 NUMBER := 0-1962.0724

Line 444: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

440: , p5_a0 NUMBER := 0-1962.0724
441: , p5_a1 NUMBER := 0-1962.0724
442: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
443: , p5_a3 NUMBER := 0-1962.0724
444: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
445: , p5_a5 NUMBER := 0-1962.0724
446: , p5_a6 NUMBER := 0-1962.0724
447: , p5_a7 NUMBER := 0-1962.0724
448: , p5_a8 NUMBER := 0-1962.0724

Line 449: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

445: , p5_a5 NUMBER := 0-1962.0724
446: , p5_a6 NUMBER := 0-1962.0724
447: , p5_a7 NUMBER := 0-1962.0724
448: , p5_a8 NUMBER := 0-1962.0724
449: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
450: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
451: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
452: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
453: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

Line 450: , p5_a10 VARCHAR2 := fnd_api.g_miss_char

446: , p5_a6 NUMBER := 0-1962.0724
447: , p5_a7 NUMBER := 0-1962.0724
448: , p5_a8 NUMBER := 0-1962.0724
449: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
450: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
451: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
452: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
453: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
454: , p5_a14 VARCHAR2 := fnd_api.g_miss_char

Line 451: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

447: , p5_a7 NUMBER := 0-1962.0724
448: , p5_a8 NUMBER := 0-1962.0724
449: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
450: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
451: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
452: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
453: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
454: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
455: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

Line 452: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

448: , p5_a8 NUMBER := 0-1962.0724
449: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
450: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
451: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
452: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
453: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
454: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
455: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
456: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

Line 453: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

449: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
450: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
451: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
452: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
453: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
454: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
455: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
456: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
457: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

Line 454: , p5_a14 VARCHAR2 := fnd_api.g_miss_char

450: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
451: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
452: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
453: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
454: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
455: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
456: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
457: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
458: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

Line 455: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

451: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
452: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
453: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
454: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
455: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
456: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
457: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
458: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
459: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

Line 456: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

452: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
453: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
454: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
455: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
456: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
457: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
458: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
459: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
460: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

Line 457: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

453: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
454: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
455: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
456: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
457: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
458: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
459: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
460: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
461: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

Line 458: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

454: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
455: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
456: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
457: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
458: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
459: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
460: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
461: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
462: , p5_a22 VARCHAR2 := fnd_api.g_miss_char

Line 459: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

455: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
456: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
457: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
458: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
459: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
460: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
461: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
462: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
463: , p5_a23 VARCHAR2 := fnd_api.g_miss_char

Line 460: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

456: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
457: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
458: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
459: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
460: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
461: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
462: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
463: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
464: , p5_a24 NUMBER := 0-1962.0724

Line 461: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

457: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
458: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
459: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
460: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
461: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
462: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
463: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
464: , p5_a24 NUMBER := 0-1962.0724
465: , p5_a25 NUMBER := 0-1962.0724

Line 462: , p5_a22 VARCHAR2 := fnd_api.g_miss_char

458: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
459: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
460: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
461: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
462: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
463: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
464: , p5_a24 NUMBER := 0-1962.0724
465: , p5_a25 NUMBER := 0-1962.0724
466: , p5_a26 NUMBER := 0-1962.0724

Line 463: , p5_a23 VARCHAR2 := fnd_api.g_miss_char

459: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
460: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
461: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
462: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
463: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
464: , p5_a24 NUMBER := 0-1962.0724
465: , p5_a25 NUMBER := 0-1962.0724
466: , p5_a26 NUMBER := 0-1962.0724
467: , p5_a27 DATE := fnd_api.g_miss_date

Line 467: , p5_a27 DATE := fnd_api.g_miss_date

463: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
464: , p5_a24 NUMBER := 0-1962.0724
465: , p5_a25 NUMBER := 0-1962.0724
466: , p5_a26 NUMBER := 0-1962.0724
467: , p5_a27 DATE := fnd_api.g_miss_date
468: , p5_a28 DATE := fnd_api.g_miss_date
469: , p5_a29 NUMBER := 0-1962.0724
470: , p5_a30 NUMBER := 0-1962.0724
471: , p5_a31 DATE := fnd_api.g_miss_date

Line 468: , p5_a28 DATE := fnd_api.g_miss_date

464: , p5_a24 NUMBER := 0-1962.0724
465: , p5_a25 NUMBER := 0-1962.0724
466: , p5_a26 NUMBER := 0-1962.0724
467: , p5_a27 DATE := fnd_api.g_miss_date
468: , p5_a28 DATE := fnd_api.g_miss_date
469: , p5_a29 NUMBER := 0-1962.0724
470: , p5_a30 NUMBER := 0-1962.0724
471: , p5_a31 DATE := fnd_api.g_miss_date
472: , p5_a32 NUMBER := 0-1962.0724

Line 471: , p5_a31 DATE := fnd_api.g_miss_date

467: , p5_a27 DATE := fnd_api.g_miss_date
468: , p5_a28 DATE := fnd_api.g_miss_date
469: , p5_a29 NUMBER := 0-1962.0724
470: , p5_a30 NUMBER := 0-1962.0724
471: , p5_a31 DATE := fnd_api.g_miss_date
472: , p5_a32 NUMBER := 0-1962.0724
473: , p5_a33 NUMBER := 0-1962.0724
474: , p5_a34 NUMBER := 0-1962.0724
475: , p5_a35 DATE := fnd_api.g_miss_date

Line 475: , p5_a35 DATE := fnd_api.g_miss_date

471: , p5_a31 DATE := fnd_api.g_miss_date
472: , p5_a32 NUMBER := 0-1962.0724
473: , p5_a33 NUMBER := 0-1962.0724
474: , p5_a34 NUMBER := 0-1962.0724
475: , p5_a35 DATE := fnd_api.g_miss_date
476: );
477: procedure delete_sif_rets(p_api_version NUMBER
478: , p_init_msg_list VARCHAR2
479: , x_return_status out nocopy VARCHAR2

Line 598: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

594: , p6_a34 out nocopy NUMBER
595: , p6_a35 out nocopy DATE
596: , p5_a0 NUMBER := 0-1962.0724
597: , p5_a1 NUMBER := 0-1962.0724
598: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
599: , p5_a3 NUMBER := 0-1962.0724
600: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
601: , p5_a5 NUMBER := 0-1962.0724
602: , p5_a6 NUMBER := 0-1962.0724

Line 600: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

596: , p5_a0 NUMBER := 0-1962.0724
597: , p5_a1 NUMBER := 0-1962.0724
598: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
599: , p5_a3 NUMBER := 0-1962.0724
600: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
601: , p5_a5 NUMBER := 0-1962.0724
602: , p5_a6 NUMBER := 0-1962.0724
603: , p5_a7 NUMBER := 0-1962.0724
604: , p5_a8 NUMBER := 0-1962.0724

Line 605: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

601: , p5_a5 NUMBER := 0-1962.0724
602: , p5_a6 NUMBER := 0-1962.0724
603: , p5_a7 NUMBER := 0-1962.0724
604: , p5_a8 NUMBER := 0-1962.0724
605: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
606: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
607: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
608: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
609: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

Line 606: , p5_a10 VARCHAR2 := fnd_api.g_miss_char

602: , p5_a6 NUMBER := 0-1962.0724
603: , p5_a7 NUMBER := 0-1962.0724
604: , p5_a8 NUMBER := 0-1962.0724
605: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
606: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
607: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
608: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
609: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
610: , p5_a14 VARCHAR2 := fnd_api.g_miss_char

Line 607: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

603: , p5_a7 NUMBER := 0-1962.0724
604: , p5_a8 NUMBER := 0-1962.0724
605: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
606: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
607: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
608: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
609: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
610: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
611: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

Line 608: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

604: , p5_a8 NUMBER := 0-1962.0724
605: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
606: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
607: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
608: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
609: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
610: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
611: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
612: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

Line 609: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

605: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
606: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
607: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
608: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
609: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
610: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
611: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
612: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
613: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

Line 610: , p5_a14 VARCHAR2 := fnd_api.g_miss_char

606: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
607: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
608: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
609: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
610: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
611: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
612: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
613: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
614: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

Line 611: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

607: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
608: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
609: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
610: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
611: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
612: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
613: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
614: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
615: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

Line 612: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

608: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
609: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
610: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
611: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
612: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
613: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
614: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
615: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
616: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

Line 613: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

609: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
610: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
611: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
612: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
613: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
614: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
615: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
616: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
617: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

Line 614: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

610: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
611: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
612: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
613: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
614: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
615: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
616: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
617: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
618: , p5_a22 VARCHAR2 := fnd_api.g_miss_char

Line 615: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

611: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
612: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
613: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
614: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
615: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
616: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
617: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
618: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
619: , p5_a23 VARCHAR2 := fnd_api.g_miss_char

Line 616: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

612: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
613: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
614: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
615: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
616: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
617: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
618: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
619: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
620: , p5_a24 NUMBER := 0-1962.0724

Line 617: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

613: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
614: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
615: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
616: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
617: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
618: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
619: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
620: , p5_a24 NUMBER := 0-1962.0724
621: , p5_a25 NUMBER := 0-1962.0724

Line 618: , p5_a22 VARCHAR2 := fnd_api.g_miss_char

614: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
615: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
616: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
617: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
618: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
619: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
620: , p5_a24 NUMBER := 0-1962.0724
621: , p5_a25 NUMBER := 0-1962.0724
622: , p5_a26 NUMBER := 0-1962.0724

Line 619: , p5_a23 VARCHAR2 := fnd_api.g_miss_char

615: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
616: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
617: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
618: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
619: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
620: , p5_a24 NUMBER := 0-1962.0724
621: , p5_a25 NUMBER := 0-1962.0724
622: , p5_a26 NUMBER := 0-1962.0724
623: , p5_a27 DATE := fnd_api.g_miss_date

Line 623: , p5_a27 DATE := fnd_api.g_miss_date

619: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
620: , p5_a24 NUMBER := 0-1962.0724
621: , p5_a25 NUMBER := 0-1962.0724
622: , p5_a26 NUMBER := 0-1962.0724
623: , p5_a27 DATE := fnd_api.g_miss_date
624: , p5_a28 DATE := fnd_api.g_miss_date
625: , p5_a29 NUMBER := 0-1962.0724
626: , p5_a30 NUMBER := 0-1962.0724
627: , p5_a31 DATE := fnd_api.g_miss_date

Line 624: , p5_a28 DATE := fnd_api.g_miss_date

620: , p5_a24 NUMBER := 0-1962.0724
621: , p5_a25 NUMBER := 0-1962.0724
622: , p5_a26 NUMBER := 0-1962.0724
623: , p5_a27 DATE := fnd_api.g_miss_date
624: , p5_a28 DATE := fnd_api.g_miss_date
625: , p5_a29 NUMBER := 0-1962.0724
626: , p5_a30 NUMBER := 0-1962.0724
627: , p5_a31 DATE := fnd_api.g_miss_date
628: , p5_a32 NUMBER := 0-1962.0724

Line 627: , p5_a31 DATE := fnd_api.g_miss_date

623: , p5_a27 DATE := fnd_api.g_miss_date
624: , p5_a28 DATE := fnd_api.g_miss_date
625: , p5_a29 NUMBER := 0-1962.0724
626: , p5_a30 NUMBER := 0-1962.0724
627: , p5_a31 DATE := fnd_api.g_miss_date
628: , p5_a32 NUMBER := 0-1962.0724
629: , p5_a33 NUMBER := 0-1962.0724
630: , p5_a34 NUMBER := 0-1962.0724
631: , p5_a35 DATE := fnd_api.g_miss_date

Line 631: , p5_a35 DATE := fnd_api.g_miss_date

627: , p5_a31 DATE := fnd_api.g_miss_date
628: , p5_a32 NUMBER := 0-1962.0724
629: , p5_a33 NUMBER := 0-1962.0724
630: , p5_a34 NUMBER := 0-1962.0724
631: , p5_a35 DATE := fnd_api.g_miss_date
632: );
633: procedure validate_sif_rets(p_api_version NUMBER
634: , p_init_msg_list VARCHAR2
635: , x_return_status out nocopy VARCHAR2