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.HZ_FUZZY_PUB dependencies on FND_API

Line 9: party_id NUMBER := FND_API.G_MISS_NUM,

5:
6: -- this record structure contains only fields which are used for
7: -- generating the key in the parties table
8: TYPE party_rec_type IS RECORD(
9: party_id NUMBER := FND_API.G_MISS_NUM,
10: party_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
11: party_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
12: first_name VARCHAR2(150):= FND_API.G_MISS_CHAR,
13: last_name VARCHAR2(150):=FND_API.G_MISS_CHAR

Line 10: party_name VARCHAR2(360) := FND_API.G_MISS_CHAR,

6: -- this record structure contains only fields which are used for
7: -- generating the key in the parties table
8: TYPE party_rec_type IS RECORD(
9: party_id NUMBER := FND_API.G_MISS_NUM,
10: party_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
11: party_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
12: first_name VARCHAR2(150):= FND_API.G_MISS_CHAR,
13: last_name VARCHAR2(150):=FND_API.G_MISS_CHAR
14: );

Line 11: party_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

7: -- generating the key in the parties table
8: TYPE party_rec_type IS RECORD(
9: party_id NUMBER := FND_API.G_MISS_NUM,
10: party_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
11: party_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
12: first_name VARCHAR2(150):= FND_API.G_MISS_CHAR,
13: last_name VARCHAR2(150):=FND_API.G_MISS_CHAR
14: );
15:

Line 12: first_name VARCHAR2(150):= FND_API.G_MISS_CHAR,

8: TYPE party_rec_type IS RECORD(
9: party_id NUMBER := FND_API.G_MISS_NUM,
10: party_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
11: party_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
12: first_name VARCHAR2(150):= FND_API.G_MISS_CHAR,
13: last_name VARCHAR2(150):=FND_API.G_MISS_CHAR
14: );
15:
16: -- this record structure contains only fields which are used for

Line 13: last_name VARCHAR2(150):=FND_API.G_MISS_CHAR

9: party_id NUMBER := FND_API.G_MISS_NUM,
10: party_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
11: party_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
12: first_name VARCHAR2(150):= FND_API.G_MISS_CHAR,
13: last_name VARCHAR2(150):=FND_API.G_MISS_CHAR
14: );
15:
16: -- this record structure contains only fields which are used for
17: -- generating the key in the locations table

Line 19: location_id NUMBER := FND_API.G_MISS_NUM,

15:
16: -- this record structure contains only fields which are used for
17: -- generating the key in the locations table
18: TYPE location_rec_type IS RECORD(
19: location_id NUMBER := FND_API.G_MISS_NUM,
20: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
21: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
22: address3 VARCHAR2(240):= FND_API.G_MISS_CHAR,
23: address4 VARCHAR2(240):= FND_API.G_MISS_CHAR,

Line 20: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,

16: -- this record structure contains only fields which are used for
17: -- generating the key in the locations table
18: TYPE location_rec_type IS RECORD(
19: location_id NUMBER := FND_API.G_MISS_NUM,
20: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
21: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
22: address3 VARCHAR2(240):= FND_API.G_MISS_CHAR,
23: address4 VARCHAR2(240):= FND_API.G_MISS_CHAR,
24: postal_code VARCHAR2(60):=FND_API.G_MISS_CHAR

Line 21: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,

17: -- generating the key in the locations table
18: TYPE location_rec_type IS RECORD(
19: location_id NUMBER := FND_API.G_MISS_NUM,
20: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
21: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
22: address3 VARCHAR2(240):= FND_API.G_MISS_CHAR,
23: address4 VARCHAR2(240):= FND_API.G_MISS_CHAR,
24: postal_code VARCHAR2(60):=FND_API.G_MISS_CHAR
25: );

Line 22: address3 VARCHAR2(240):= FND_API.G_MISS_CHAR,

18: TYPE location_rec_type IS RECORD(
19: location_id NUMBER := FND_API.G_MISS_NUM,
20: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
21: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
22: address3 VARCHAR2(240):= FND_API.G_MISS_CHAR,
23: address4 VARCHAR2(240):= FND_API.G_MISS_CHAR,
24: postal_code VARCHAR2(60):=FND_API.G_MISS_CHAR
25: );
26:

Line 23: address4 VARCHAR2(240):= FND_API.G_MISS_CHAR,

19: location_id NUMBER := FND_API.G_MISS_NUM,
20: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
21: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
22: address3 VARCHAR2(240):= FND_API.G_MISS_CHAR,
23: address4 VARCHAR2(240):= FND_API.G_MISS_CHAR,
24: postal_code VARCHAR2(60):=FND_API.G_MISS_CHAR
25: );
26:
27: TYPE location_tbl_type is TABLE of hz_locations.location_id%TYPE

Line 24: postal_code VARCHAR2(60):=FND_API.G_MISS_CHAR

20: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
21: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
22: address3 VARCHAR2(240):= FND_API.G_MISS_CHAR,
23: address4 VARCHAR2(240):= FND_API.G_MISS_CHAR,
24: postal_code VARCHAR2(60):=FND_API.G_MISS_CHAR
25: );
26:
27: TYPE location_tbl_type is TABLE of hz_locations.location_id%TYPE
28: INDEX BY BINARY_INTEGER;

Line 128: | duplicate record, it sets p_duplicate to fnd_api.g_true. Also a |

124: | |
125: | DESCRIPTION |
126: | Public procedure for checking if the passed party information |
127: | is a duplicate of an existing party. If program finds that it is a |
128: | duplicate record, it sets p_duplicate to fnd_api.g_true. Also a |
129: | message is set and one matching party_id is returned. |
130: | |
131: | SCOPE - Public |
132: | |

Line 160: p_key_search_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE, --'T' for search on key, 'F' othewise

156: p_party_type IN VARCHAR2,
157: p_person_first_name IN VARCHAR2 DEFAULT NULL,
158: p_person_last_name IN VARCHAR2 DEFAULT NULL,
159: p_party_name IN VARCHAR2 DEFAULT NULL,
160: p_key_search_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE, --'T' for search on key, 'F' othewise
161: p_duplicate OUT NOCOPY VARCHAR2,
162: p_msg_count OUT NOCOPY NUMBER,
163: p_msg_data OUT NOCOPY VARCHAR2,
164: p_party_id OUT NOCOPY NUMBER

Line 175: | found, p_duplicate is set to fnd_api.g_true and a message is also set |

171: | |
172: | DESCRIPTION |
173: | Public procedure for checking if the passed location information |
174: | is a duplicate of an existing location.If a duplicate location is |
175: | found, p_duplicate is set to fnd_api.g_true and a message is also set |
176: | stating that. p_key_search_flag determines whether to do a key match |
177: | or exact match. |
178: | |
179: | SCOPE - Public |

Line 216: p_key_search_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE, --'T' for search on key, 'F' othewise

212: p_postal_code IN VARCHAR2 DEFAULT NULL,
213: p_state IN VARCHAR2 DEFAULT NULL,
214: p_city IN VARCHAR2 DEFAULT NULL,
215: p_country IN VARCHAR2 DEFAULT NULL,
216: p_key_search_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE, --'T' for search on key, 'F' othewise
217: p_duplicate OUT NOCOPY VARCHAR2,
218: p_msg_count OUT NOCOPY NUMBER,
219: p_msg_data OUT NOCOPY VARCHAR2,
220: p_location_id OUT NOCOPY NUMBER