eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_LOC_TYPES_PVT_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 update_loc_type(p_api_version NUMBER

Line 30: , p7_a1 DATE := fnd_api.g_miss_date

26: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
27: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
28: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
29: , p7_a0 NUMBER := 0-1962.0724
30: , p7_a1 DATE := fnd_api.g_miss_date
31: , p7_a2 NUMBER := 0-1962.0724
32: , p7_a3 DATE := fnd_api.g_miss_date
33: , p7_a4 NUMBER := 0-1962.0724
34: , p7_a5 NUMBER := 0-1962.0724

Line 32: , p7_a3 DATE := fnd_api.g_miss_date

28: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
29: , p7_a0 NUMBER := 0-1962.0724
30: , p7_a1 DATE := fnd_api.g_miss_date
31: , p7_a2 NUMBER := 0-1962.0724
32: , p7_a3 DATE := fnd_api.g_miss_date
33: , p7_a4 NUMBER := 0-1962.0724
34: , p7_a5 NUMBER := 0-1962.0724
35: , p7_a6 NUMBER := 0-1962.0724
36: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

Line 36: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

32: , p7_a3 DATE := fnd_api.g_miss_date
33: , p7_a4 NUMBER := 0-1962.0724
34: , p7_a5 NUMBER := 0-1962.0724
35: , p7_a6 NUMBER := 0-1962.0724
36: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
37: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
38: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
39: )
40: as

Line 37: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

33: , p7_a4 NUMBER := 0-1962.0724
34: , p7_a5 NUMBER := 0-1962.0724
35: , p7_a6 NUMBER := 0-1962.0724
36: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
37: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
38: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
39: )
40: as
41: ddp_loc_type_rec jtf_loc_types_pvt.loc_type_rec_type;

Line 38: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

34: , p7_a5 NUMBER := 0-1962.0724
35: , p7_a6 NUMBER := 0-1962.0724
36: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
37: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
38: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
39: )
40: as
41: ddp_loc_type_rec jtf_loc_types_pvt.loc_type_rec_type;
42: ddindx binary_integer; indx binary_integer;

Line 87: , p2_a1 DATE := fnd_api.g_miss_date

83:
84: procedure check_items(p_validation_mode VARCHAR2
85: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
86: , p2_a0 NUMBER := 0-1962.0724
87: , p2_a1 DATE := fnd_api.g_miss_date
88: , p2_a2 NUMBER := 0-1962.0724
89: , p2_a3 DATE := fnd_api.g_miss_date
90: , p2_a4 NUMBER := 0-1962.0724
91: , p2_a5 NUMBER := 0-1962.0724

Line 89: , p2_a3 DATE := fnd_api.g_miss_date

85: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
86: , p2_a0 NUMBER := 0-1962.0724
87: , p2_a1 DATE := fnd_api.g_miss_date
88: , p2_a2 NUMBER := 0-1962.0724
89: , p2_a3 DATE := fnd_api.g_miss_date
90: , p2_a4 NUMBER := 0-1962.0724
91: , p2_a5 NUMBER := 0-1962.0724
92: , p2_a6 NUMBER := 0-1962.0724
93: , p2_a7 VARCHAR2 := fnd_api.g_miss_char

Line 93: , p2_a7 VARCHAR2 := fnd_api.g_miss_char

89: , p2_a3 DATE := fnd_api.g_miss_date
90: , p2_a4 NUMBER := 0-1962.0724
91: , p2_a5 NUMBER := 0-1962.0724
92: , p2_a6 NUMBER := 0-1962.0724
93: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
94: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
95: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
96: )
97: as

Line 94: , p2_a8 VARCHAR2 := fnd_api.g_miss_char

90: , p2_a4 NUMBER := 0-1962.0724
91: , p2_a5 NUMBER := 0-1962.0724
92: , p2_a6 NUMBER := 0-1962.0724
93: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
94: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
95: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
96: )
97: as
98: ddp_loc_type_rec jtf_loc_types_pvt.loc_type_rec_type;

Line 95: , p2_a9 VARCHAR2 := fnd_api.g_miss_char

91: , p2_a5 NUMBER := 0-1962.0724
92: , p2_a6 NUMBER := 0-1962.0724
93: , p2_a7 VARCHAR2 := fnd_api.g_miss_char
94: , p2_a8 VARCHAR2 := fnd_api.g_miss_char
95: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
96: )
97: as
98: ddp_loc_type_rec jtf_loc_types_pvt.loc_type_rec_type;
99: ddindx binary_integer; indx binary_integer;

Line 129: , p1_a1 DATE := fnd_api.g_miss_date

125:
126: procedure check_loc_type_req_items(p_validation_mode VARCHAR2
127: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
128: , p1_a0 NUMBER := 0-1962.0724
129: , p1_a1 DATE := fnd_api.g_miss_date
130: , p1_a2 NUMBER := 0-1962.0724
131: , p1_a3 DATE := fnd_api.g_miss_date
132: , p1_a4 NUMBER := 0-1962.0724
133: , p1_a5 NUMBER := 0-1962.0724

Line 131: , p1_a3 DATE := fnd_api.g_miss_date

127: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
128: , p1_a0 NUMBER := 0-1962.0724
129: , p1_a1 DATE := fnd_api.g_miss_date
130: , p1_a2 NUMBER := 0-1962.0724
131: , p1_a3 DATE := fnd_api.g_miss_date
132: , p1_a4 NUMBER := 0-1962.0724
133: , p1_a5 NUMBER := 0-1962.0724
134: , p1_a6 NUMBER := 0-1962.0724
135: , p1_a7 VARCHAR2 := fnd_api.g_miss_char

Line 135: , p1_a7 VARCHAR2 := fnd_api.g_miss_char

131: , p1_a3 DATE := fnd_api.g_miss_date
132: , p1_a4 NUMBER := 0-1962.0724
133: , p1_a5 NUMBER := 0-1962.0724
134: , p1_a6 NUMBER := 0-1962.0724
135: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
136: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
137: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
138: )
139: as

Line 136: , p1_a8 VARCHAR2 := fnd_api.g_miss_char

132: , p1_a4 NUMBER := 0-1962.0724
133: , p1_a5 NUMBER := 0-1962.0724
134: , p1_a6 NUMBER := 0-1962.0724
135: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
136: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
137: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
138: )
139: as
140: ddp_loc_type_rec jtf_loc_types_pvt.loc_type_rec_type;

Line 137: , p1_a9 VARCHAR2 := fnd_api.g_miss_char

133: , p1_a5 NUMBER := 0-1962.0724
134: , p1_a6 NUMBER := 0-1962.0724
135: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
136: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
137: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
138: )
139: as
140: ddp_loc_type_rec jtf_loc_types_pvt.loc_type_rec_type;
141: ddindx binary_integer; indx binary_integer;

Line 171: , p1_a1 DATE := fnd_api.g_miss_date

167:
168: procedure check_loc_type_uk_items(p_validation_mode VARCHAR2
169: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
170: , p1_a0 NUMBER := 0-1962.0724
171: , p1_a1 DATE := fnd_api.g_miss_date
172: , p1_a2 NUMBER := 0-1962.0724
173: , p1_a3 DATE := fnd_api.g_miss_date
174: , p1_a4 NUMBER := 0-1962.0724
175: , p1_a5 NUMBER := 0-1962.0724

Line 173: , p1_a3 DATE := fnd_api.g_miss_date

169: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
170: , p1_a0 NUMBER := 0-1962.0724
171: , p1_a1 DATE := fnd_api.g_miss_date
172: , p1_a2 NUMBER := 0-1962.0724
173: , p1_a3 DATE := fnd_api.g_miss_date
174: , p1_a4 NUMBER := 0-1962.0724
175: , p1_a5 NUMBER := 0-1962.0724
176: , p1_a6 NUMBER := 0-1962.0724
177: , p1_a7 VARCHAR2 := fnd_api.g_miss_char

Line 177: , p1_a7 VARCHAR2 := fnd_api.g_miss_char

173: , p1_a3 DATE := fnd_api.g_miss_date
174: , p1_a4 NUMBER := 0-1962.0724
175: , p1_a5 NUMBER := 0-1962.0724
176: , p1_a6 NUMBER := 0-1962.0724
177: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
178: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
179: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
180: )
181: as

Line 178: , p1_a8 VARCHAR2 := fnd_api.g_miss_char

174: , p1_a4 NUMBER := 0-1962.0724
175: , p1_a5 NUMBER := 0-1962.0724
176: , p1_a6 NUMBER := 0-1962.0724
177: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
178: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
179: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
180: )
181: as
182: ddp_loc_type_rec jtf_loc_types_pvt.loc_type_rec_type;

Line 179: , p1_a9 VARCHAR2 := fnd_api.g_miss_char

175: , p1_a5 NUMBER := 0-1962.0724
176: , p1_a6 NUMBER := 0-1962.0724
177: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
178: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
179: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
180: )
181: as
182: ddp_loc_type_rec jtf_loc_types_pvt.loc_type_rec_type;
183: ddindx binary_integer; indx binary_integer;