APPS.OKL_MISC_TRANS_PUB_W dependencies on FND_API

Line 9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;

5:
6: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7: function rosetta_g_miss_date_in_map(d date) return date as
8: begin
9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: function rosetta_g_miss_num_map(n number) return number as

Line 14: a number := fnd_api.g_miss_num;

10: return d;
11: end;
12:
13: function rosetta_g_miss_num_map(n number) return number as
14: a number := fnd_api.g_miss_num;
15: b number := 0-1962.0724;
16: begin
17: if n=a then return b; end if;
18: if n=b then return a; end if;

Line 81: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

77: , p5_a4 NUMBER := 0-1962.0724
78: , p5_a5 NUMBER := 0-1962.0724
79: , p5_a6 NUMBER := 0-1962.0724
80: , p5_a7 NUMBER := 0-1962.0724
81: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a9 NUMBER := 0-1962.0724
83: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a11 NUMBER := 0-1962.0724
85: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

Line 83: , p5_a10 VARCHAR2 := fnd_api.g_miss_char

79: , p5_a6 NUMBER := 0-1962.0724
80: , p5_a7 NUMBER := 0-1962.0724
81: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a9 NUMBER := 0-1962.0724
83: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a11 NUMBER := 0-1962.0724
85: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
86: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
87: , p5_a14 VARCHAR2 := fnd_api.g_miss_char

Line 85: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

81: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a9 NUMBER := 0-1962.0724
83: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a11 NUMBER := 0-1962.0724
85: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
86: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
87: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
88: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
89: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

Line 86: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

82: , p5_a9 NUMBER := 0-1962.0724
83: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a11 NUMBER := 0-1962.0724
85: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
86: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
87: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
88: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
89: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
90: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

Line 87: , p5_a14 VARCHAR2 := fnd_api.g_miss_char

83: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a11 NUMBER := 0-1962.0724
85: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
86: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
87: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
88: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
89: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
90: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
91: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

Line 88: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

84: , p5_a11 NUMBER := 0-1962.0724
85: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
86: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
87: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
88: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
89: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
90: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
91: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

Line 89: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

85: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
86: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
87: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
88: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
89: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
90: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
91: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
93: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

Line 90: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

86: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
87: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
88: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
89: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
90: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
91: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
93: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
94: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

Line 91: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

87: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
88: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
89: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
90: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
91: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
93: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
94: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a22 VARCHAR2 := fnd_api.g_miss_char

Line 92: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

88: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
89: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
90: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
91: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
93: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
94: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
96: , p5_a23 VARCHAR2 := fnd_api.g_miss_char

Line 93: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

89: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
90: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
91: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
93: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
94: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
96: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
97: , p5_a24 VARCHAR2 := fnd_api.g_miss_char

Line 94: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

90: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
91: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
93: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
94: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
96: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
97: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
98: , p5_a25 VARCHAR2 := fnd_api.g_miss_char

Line 95: , p5_a22 VARCHAR2 := fnd_api.g_miss_char

91: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
93: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
94: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
96: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
97: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
98: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
99: , p5_a26 VARCHAR2 := fnd_api.g_miss_char

Line 96: , p5_a23 VARCHAR2 := fnd_api.g_miss_char

92: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
93: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
94: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
96: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
97: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
98: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
99: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
100: , p5_a27 VARCHAR2 := fnd_api.g_miss_char

Line 97: , p5_a24 VARCHAR2 := fnd_api.g_miss_char

93: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
94: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
96: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
97: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
98: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
99: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
100: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
101: , p5_a28 VARCHAR2 := fnd_api.g_miss_char

Line 98: , p5_a25 VARCHAR2 := fnd_api.g_miss_char

94: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
96: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
97: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
98: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
99: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
100: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
101: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
102: , p5_a29 VARCHAR2 := fnd_api.g_miss_char

Line 99: , p5_a26 VARCHAR2 := fnd_api.g_miss_char

95: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
96: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
97: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
98: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
99: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
100: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
101: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
102: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
103: , p5_a30 VARCHAR2 := fnd_api.g_miss_char

Line 100: , p5_a27 VARCHAR2 := fnd_api.g_miss_char

96: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
97: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
98: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
99: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
100: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
101: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
102: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
103: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
104: , p5_a31 NUMBER := 0-1962.0724

Line 101: , p5_a28 VARCHAR2 := fnd_api.g_miss_char

97: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
98: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
99: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
100: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
101: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
102: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
103: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
104: , p5_a31 NUMBER := 0-1962.0724
105: , p5_a32 DATE := fnd_api.g_miss_date

Line 102: , p5_a29 VARCHAR2 := fnd_api.g_miss_char

98: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
99: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
100: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
101: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
102: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
103: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
104: , p5_a31 NUMBER := 0-1962.0724
105: , p5_a32 DATE := fnd_api.g_miss_date
106: , p5_a33 NUMBER := 0-1962.0724

Line 103: , p5_a30 VARCHAR2 := fnd_api.g_miss_char

99: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
100: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
101: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
102: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
103: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
104: , p5_a31 NUMBER := 0-1962.0724
105: , p5_a32 DATE := fnd_api.g_miss_date
106: , p5_a33 NUMBER := 0-1962.0724
107: , p5_a34 DATE := fnd_api.g_miss_date

Line 105: , p5_a32 DATE := fnd_api.g_miss_date

101: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
102: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
103: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
104: , p5_a31 NUMBER := 0-1962.0724
105: , p5_a32 DATE := fnd_api.g_miss_date
106: , p5_a33 NUMBER := 0-1962.0724
107: , p5_a34 DATE := fnd_api.g_miss_date
108: , p5_a35 NUMBER := 0-1962.0724
109: , p5_a36 NUMBER := 0-1962.0724

Line 107: , p5_a34 DATE := fnd_api.g_miss_date

103: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
104: , p5_a31 NUMBER := 0-1962.0724
105: , p5_a32 DATE := fnd_api.g_miss_date
106: , p5_a33 NUMBER := 0-1962.0724
107: , p5_a34 DATE := fnd_api.g_miss_date
108: , p5_a35 NUMBER := 0-1962.0724
109: , p5_a36 NUMBER := 0-1962.0724
110: , p5_a37 NUMBER := 0-1962.0724
111: , p5_a38 NUMBER := 0-1962.0724

Line 112: , p5_a39 DATE := fnd_api.g_miss_date

108: , p5_a35 NUMBER := 0-1962.0724
109: , p5_a36 NUMBER := 0-1962.0724
110: , p5_a37 NUMBER := 0-1962.0724
111: , p5_a38 NUMBER := 0-1962.0724
112: , p5_a39 DATE := fnd_api.g_miss_date
113: , p5_a40 NUMBER := 0-1962.0724
114: , p5_a41 NUMBER := 0-1962.0724
115: , p5_a42 NUMBER := 0-1962.0724
116: , p5_a43 NUMBER := 0-1962.0724

Line 118: , p5_a45 VARCHAR2 := fnd_api.g_miss_char

114: , p5_a41 NUMBER := 0-1962.0724
115: , p5_a42 NUMBER := 0-1962.0724
116: , p5_a43 NUMBER := 0-1962.0724
117: , p5_a44 NUMBER := 0-1962.0724
118: , p5_a45 VARCHAR2 := fnd_api.g_miss_char
119: )
120:
121: as
122: ddp_tclv_rec okl_misc_trans_pub.tclv_rec_type;

Line 272: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

268: , p5_a0 NUMBER := 0-1962.0724
269: , p5_a1 NUMBER := 0-1962.0724
270: , p5_a2 NUMBER := 0-1962.0724
271: , p5_a3 NUMBER := 0-1962.0724
272: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
273: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
274: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
275: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a8 DATE := fnd_api.g_miss_date

Line 273: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

269: , p5_a1 NUMBER := 0-1962.0724
270: , p5_a2 NUMBER := 0-1962.0724
271: , p5_a3 NUMBER := 0-1962.0724
272: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
273: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
274: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
275: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a8 DATE := fnd_api.g_miss_date
277: )

Line 274: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

270: , p5_a2 NUMBER := 0-1962.0724
271: , p5_a3 NUMBER := 0-1962.0724
272: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
273: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
274: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
275: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a8 DATE := fnd_api.g_miss_date
277: )
278:

Line 275: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

271: , p5_a3 NUMBER := 0-1962.0724
272: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
273: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
274: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
275: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a8 DATE := fnd_api.g_miss_date
277: )
278:
279: as

Line 276: , p5_a8 DATE := fnd_api.g_miss_date

272: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
273: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
274: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
275: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
276: , p5_a8 DATE := fnd_api.g_miss_date
277: )
278:
279: as
280: ddp_jrnl_hdr_rec okl_misc_trans_pvt.jrnl_hdr_rec_type;

Line 361: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

357: , p5_a0 NUMBER := 0-1962.0724
358: , p5_a1 NUMBER := 0-1962.0724
359: , p5_a2 NUMBER := 0-1962.0724
360: , p5_a3 NUMBER := 0-1962.0724
361: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
362: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
363: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
364: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
365: , p5_a8 DATE := fnd_api.g_miss_date

Line 362: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

358: , p5_a1 NUMBER := 0-1962.0724
359: , p5_a2 NUMBER := 0-1962.0724
360: , p5_a3 NUMBER := 0-1962.0724
361: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
362: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
363: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
364: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
365: , p5_a8 DATE := fnd_api.g_miss_date
366: )

Line 363: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

359: , p5_a2 NUMBER := 0-1962.0724
360: , p5_a3 NUMBER := 0-1962.0724
361: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
362: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
363: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
364: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
365: , p5_a8 DATE := fnd_api.g_miss_date
366: )
367:

Line 364: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

360: , p5_a3 NUMBER := 0-1962.0724
361: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
362: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
363: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
364: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
365: , p5_a8 DATE := fnd_api.g_miss_date
366: )
367:
368: as

Line 365: , p5_a8 DATE := fnd_api.g_miss_date

361: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
362: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
363: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
364: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
365: , p5_a8 DATE := fnd_api.g_miss_date
366: )
367:
368: as
369: ddp_jrnl_hdr_rec okl_misc_trans_pvt.jrnl_hdr_rec_type;