APPS.OKL_MLA_CREATE_UPDATE_PUB_W dependencies on FND_API

Line 11: if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;

7:
8: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
9: function rosetta_g_miss_date_in_map(d date) return date as
10: begin
11: if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;
12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:

Line 12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;

8: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
9: function rosetta_g_miss_date_in_map(d date) return date as
10: begin
11: if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;
12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: function rosetta_g_miss_num_map(n number) return number as

Line 17: a number := fnd_api.g_miss_num;

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

Line 975: , p5_a1 VARCHAR2 := fnd_api.g_miss_char

971: , p6_a7 out nocopy DATE
972: , p6_a8 out nocopy VARCHAR2
973: , p6_a9 out nocopy NUMBER
974: , p5_a0 NUMBER := 0-1962.0724
975: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
976: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
977: , p5_a3 DATE := fnd_api.g_miss_date
978: , p5_a4 DATE := fnd_api.g_miss_date
979: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

Line 976: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

972: , p6_a8 out nocopy VARCHAR2
973: , p6_a9 out nocopy NUMBER
974: , p5_a0 NUMBER := 0-1962.0724
975: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
976: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
977: , p5_a3 DATE := fnd_api.g_miss_date
978: , p5_a4 DATE := fnd_api.g_miss_date
979: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
980: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

Line 977: , p5_a3 DATE := fnd_api.g_miss_date

973: , p6_a9 out nocopy NUMBER
974: , p5_a0 NUMBER := 0-1962.0724
975: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
976: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
977: , p5_a3 DATE := fnd_api.g_miss_date
978: , p5_a4 DATE := fnd_api.g_miss_date
979: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
980: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
981: , p5_a7 DATE := fnd_api.g_miss_date

Line 978: , p5_a4 DATE := fnd_api.g_miss_date

974: , p5_a0 NUMBER := 0-1962.0724
975: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
976: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
977: , p5_a3 DATE := fnd_api.g_miss_date
978: , p5_a4 DATE := fnd_api.g_miss_date
979: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
980: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
981: , p5_a7 DATE := fnd_api.g_miss_date
982: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 979: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

975: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
976: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
977: , p5_a3 DATE := fnd_api.g_miss_date
978: , p5_a4 DATE := fnd_api.g_miss_date
979: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
980: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
981: , p5_a7 DATE := fnd_api.g_miss_date
982: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
983: , p5_a9 NUMBER := 0-1962.0724

Line 980: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

976: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
977: , p5_a3 DATE := fnd_api.g_miss_date
978: , p5_a4 DATE := fnd_api.g_miss_date
979: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
980: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
981: , p5_a7 DATE := fnd_api.g_miss_date
982: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
983: , p5_a9 NUMBER := 0-1962.0724
984: )

Line 981: , p5_a7 DATE := fnd_api.g_miss_date

977: , p5_a3 DATE := fnd_api.g_miss_date
978: , p5_a4 DATE := fnd_api.g_miss_date
979: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
980: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
981: , p5_a7 DATE := fnd_api.g_miss_date
982: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
983: , p5_a9 NUMBER := 0-1962.0724
984: )
985:

Line 982: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

978: , p5_a4 DATE := fnd_api.g_miss_date
979: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
980: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
981: , p5_a7 DATE := fnd_api.g_miss_date
982: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
983: , p5_a9 NUMBER := 0-1962.0724
984: )
985:
986: as

Line 1169: , p5_a1 VARCHAR2 := fnd_api.g_miss_char

1165: , p6_a21 out nocopy NUMBER
1166: , p6_a22 out nocopy NUMBER
1167: , p6_a23 out nocopy NUMBER
1168: , p5_a0 NUMBER := 0-1962.0724
1169: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1170: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1171: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1172: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1173: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

Line 1170: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

1166: , p6_a22 out nocopy NUMBER
1167: , p6_a23 out nocopy NUMBER
1168: , p5_a0 NUMBER := 0-1962.0724
1169: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1170: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1171: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1172: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1173: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1174: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

Line 1171: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

1167: , p6_a23 out nocopy NUMBER
1168: , p5_a0 NUMBER := 0-1962.0724
1169: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1170: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1171: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1172: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1173: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1174: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1175: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

Line 1172: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

1168: , p5_a0 NUMBER := 0-1962.0724
1169: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1170: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1171: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1172: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1173: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1174: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1175: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1176: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 1173: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

1169: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
1170: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1171: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1172: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1173: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1174: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1175: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1176: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1177: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

Line 1174: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

1170: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1171: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1172: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1173: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1174: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1175: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1176: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1177: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a10 VARCHAR2 := fnd_api.g_miss_char

Line 1175: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

1171: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1172: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1173: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1174: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1175: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1176: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1177: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

Line 1176: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

1172: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1173: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1174: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1175: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1176: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1177: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

Line 1177: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

1173: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1174: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1175: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1176: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1177: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

Line 1178: , p5_a10 VARCHAR2 := fnd_api.g_miss_char

1174: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1175: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1176: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1177: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a14 VARCHAR2 := fnd_api.g_miss_char

Line 1179: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

1175: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1176: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1177: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1183: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

Line 1180: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

1176: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1177: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1183: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1184: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

Line 1181: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

1177: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1183: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1184: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1185: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

Line 1182: , p5_a14 VARCHAR2 := fnd_api.g_miss_char

1178: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1183: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1184: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1185: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1186: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

Line 1183: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

1179: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1183: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1184: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1185: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1186: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1187: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

Line 1184: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

1180: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1183: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1184: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1185: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1186: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1187: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1188: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

Line 1185: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

1181: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1183: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1184: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1185: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1186: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1187: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1188: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1189: , p5_a21 NUMBER := 0-1962.0724

Line 1186: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

1182: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1183: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1184: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1185: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1186: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1187: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1188: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1189: , p5_a21 NUMBER := 0-1962.0724
1190: , p5_a22 NUMBER := 0-1962.0724

Line 1187: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

1183: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1184: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1185: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1186: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1187: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1188: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1189: , p5_a21 NUMBER := 0-1962.0724
1190: , p5_a22 NUMBER := 0-1962.0724
1191: , p5_a23 NUMBER := 0-1962.0724

Line 1188: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

1184: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1185: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1186: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1187: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1188: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1189: , p5_a21 NUMBER := 0-1962.0724
1190: , p5_a22 NUMBER := 0-1962.0724
1191: , p5_a23 NUMBER := 0-1962.0724
1192: )