DBA Data[Home] [Help]

APPS.JTF_DPF_W dependencies on FND_API

Line 7: a number := fnd_api.g_miss_num;

3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:
6: function rosetta_g_miss_num_map(n number) return number as
7: a number := fnd_api.g_miss_num;
8: b number := 0-1962.0724;
9: begin
10: if n=a then return b; end if;
11: if n=b then return a; end if;

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

14:
15: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
16: function rosetta_g_miss_date_in_map(d date) return date as
17: begin
18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p9(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.new_rule_param_tbl, a0 JTF_VARCHAR2_TABLE_100

Line 1073: , p1_a0 VARCHAR2 := fnd_api.g_miss_char

1069: );
1070: end;
1071:
1072: function rule_update(p_rule_id NUMBER
1073: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
1074: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
1075: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
1076: ) return number
1077: as

Line 1074: , p1_a1 VARCHAR2 := fnd_api.g_miss_char

1070: end;
1071:
1072: function rule_update(p_rule_id NUMBER
1073: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
1074: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
1075: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
1076: ) return number
1077: as
1078: ddupd jtf_dpf.rule_update_rec;

Line 1075: , p1_a2 VARCHAR2 := fnd_api.g_miss_char

1071:
1072: function rule_update(p_rule_id NUMBER
1073: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
1074: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
1075: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
1076: ) return number
1077: as
1078: ddupd jtf_dpf.rule_update_rec;
1079: ddindx binary_integer; indx binary_integer;

Line 1161: , p1_a0 VARCHAR2 := fnd_api.g_miss_char

1157:
1158: end;
1159:
1160: function phys_update(p_ppid NUMBER
1161: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
1162: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
1163: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
1164: ) return number
1165: as

Line 1162: , p1_a1 VARCHAR2 := fnd_api.g_miss_char

1158: end;
1159:
1160: function phys_update(p_ppid NUMBER
1161: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
1162: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
1163: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
1164: ) return number
1165: as
1166: ddupd jtf_dpf.phys_update_rec;

Line 1163: , p1_a2 VARCHAR2 := fnd_api.g_miss_char

1159:
1160: function phys_update(p_ppid NUMBER
1161: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
1162: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
1163: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
1164: ) return number
1165: as
1166: ddupd jtf_dpf.phys_update_rec;
1167: ddindx binary_integer; indx binary_integer;

Line 1211: , p1_a0 VARCHAR2 := fnd_api.g_miss_char

1207:
1208: end;
1209:
1210: function flow_update(p_logical_flow_id NUMBER
1211: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
1212: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
1213: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
1214: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
1215: , p1_a4 VARCHAR2 := fnd_api.g_miss_char

Line 1212: , p1_a1 VARCHAR2 := fnd_api.g_miss_char

1208: end;
1209:
1210: function flow_update(p_logical_flow_id NUMBER
1211: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
1212: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
1213: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
1214: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
1215: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
1216: , p1_a5 VARCHAR2 := fnd_api.g_miss_char

Line 1213: , p1_a2 VARCHAR2 := fnd_api.g_miss_char

1209:
1210: function flow_update(p_logical_flow_id NUMBER
1211: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
1212: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
1213: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
1214: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
1215: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
1216: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
1217: , p1_a6 NUMBER := 0-1962.0724

Line 1214: , p1_a3 VARCHAR2 := fnd_api.g_miss_char

1210: function flow_update(p_logical_flow_id NUMBER
1211: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
1212: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
1213: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
1214: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
1215: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
1216: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
1217: , p1_a6 NUMBER := 0-1962.0724
1218: , p1_a7 NUMBER := 0-1962.0724

Line 1215: , p1_a4 VARCHAR2 := fnd_api.g_miss_char

1211: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
1212: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
1213: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
1214: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
1215: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
1216: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
1217: , p1_a6 NUMBER := 0-1962.0724
1218: , p1_a7 NUMBER := 0-1962.0724
1219: ) return number

Line 1216: , p1_a5 VARCHAR2 := fnd_api.g_miss_char

1212: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
1213: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
1214: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
1215: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
1216: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
1217: , p1_a6 NUMBER := 0-1962.0724
1218: , p1_a7 NUMBER := 0-1962.0724
1219: ) return number
1220: as

Line 1248: , p1_a0 VARCHAR2 := fnd_api.g_miss_char

1244: return ddrosetta_retval;
1245: end;
1246:
1247: function logical_update(p_logical_page_id NUMBER
1248: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
1249: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
1250: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
1251: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
1252: , p1_a4 VARCHAR2 := fnd_api.g_miss_char

Line 1249: , p1_a1 VARCHAR2 := fnd_api.g_miss_char

1245: end;
1246:
1247: function logical_update(p_logical_page_id NUMBER
1248: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
1249: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
1250: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
1251: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
1252: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
1253: , p1_a5 VARCHAR2 := fnd_api.g_miss_char

Line 1250: , p1_a2 VARCHAR2 := fnd_api.g_miss_char

1246:
1247: function logical_update(p_logical_page_id NUMBER
1248: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
1249: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
1250: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
1251: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
1252: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
1253: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
1254: , p1_a6 NUMBER := 0-1962.0724

Line 1251: , p1_a3 VARCHAR2 := fnd_api.g_miss_char

1247: function logical_update(p_logical_page_id NUMBER
1248: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
1249: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
1250: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
1251: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
1252: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
1253: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
1254: , p1_a6 NUMBER := 0-1962.0724
1255: ) return number

Line 1252: , p1_a4 VARCHAR2 := fnd_api.g_miss_char

1248: , p1_a0 VARCHAR2 := fnd_api.g_miss_char
1249: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
1250: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
1251: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
1252: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
1253: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
1254: , p1_a6 NUMBER := 0-1962.0724
1255: ) return number
1256: as

Line 1253: , p1_a5 VARCHAR2 := fnd_api.g_miss_char

1249: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
1250: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
1251: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
1252: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
1253: , p1_a5 VARCHAR2 := fnd_api.g_miss_char
1254: , p1_a6 NUMBER := 0-1962.0724
1255: ) return number
1256: as
1257: ddupd jtf_dpf.logical_update_rec;