APPS.PON_LOCALE_PKG dependencies on HZ_PARTIES

Line 26: l_first_name hz_parties.PERSON_FIRST_NAME%TYPE;

22: , x_status OUT NOCOPY VARCHAR2
23: , x_exception_msg OUT NOCOPY VARCHAR2
24: )
25: IS
26: l_first_name hz_parties.PERSON_FIRST_NAME%TYPE;
27: l_last_name hz_parties.PERSON_LAST_NAME%TYPE;
28: l_mid_name hz_parties.PERSON_MIDDLE_NAME%TYPE;
29: l_prefix hz_parties.PERSON_TITLE%TYPE;
30: l_suffix hz_parties.PERSON_NAME_SUFFIX%TYPE;

Line 27: l_last_name hz_parties.PERSON_LAST_NAME%TYPE;

23: , x_exception_msg OUT NOCOPY VARCHAR2
24: )
25: IS
26: l_first_name hz_parties.PERSON_FIRST_NAME%TYPE;
27: l_last_name hz_parties.PERSON_LAST_NAME%TYPE;
28: l_mid_name hz_parties.PERSON_MIDDLE_NAME%TYPE;
29: l_prefix hz_parties.PERSON_TITLE%TYPE;
30: l_suffix hz_parties.PERSON_NAME_SUFFIX%TYPE;
31: l_prefix_space VARCHAR2(1);

Line 28: l_mid_name hz_parties.PERSON_MIDDLE_NAME%TYPE;

24: )
25: IS
26: l_first_name hz_parties.PERSON_FIRST_NAME%TYPE;
27: l_last_name hz_parties.PERSON_LAST_NAME%TYPE;
28: l_mid_name hz_parties.PERSON_MIDDLE_NAME%TYPE;
29: l_prefix hz_parties.PERSON_TITLE%TYPE;
30: l_suffix hz_parties.PERSON_NAME_SUFFIX%TYPE;
31: l_prefix_space VARCHAR2(1);
32: l_prefix_comma VARCHAR2(2);

Line 29: l_prefix hz_parties.PERSON_TITLE%TYPE;

25: IS
26: l_first_name hz_parties.PERSON_FIRST_NAME%TYPE;
27: l_last_name hz_parties.PERSON_LAST_NAME%TYPE;
28: l_mid_name hz_parties.PERSON_MIDDLE_NAME%TYPE;
29: l_prefix hz_parties.PERSON_TITLE%TYPE;
30: l_suffix hz_parties.PERSON_NAME_SUFFIX%TYPE;
31: l_prefix_space VARCHAR2(1);
32: l_prefix_comma VARCHAR2(2);
33: l_first_name_space VARCHAR2(1);

Line 30: l_suffix hz_parties.PERSON_NAME_SUFFIX%TYPE;

26: l_first_name hz_parties.PERSON_FIRST_NAME%TYPE;
27: l_last_name hz_parties.PERSON_LAST_NAME%TYPE;
28: l_mid_name hz_parties.PERSON_MIDDLE_NAME%TYPE;
29: l_prefix hz_parties.PERSON_TITLE%TYPE;
30: l_suffix hz_parties.PERSON_NAME_SUFFIX%TYPE;
31: l_prefix_space VARCHAR2(1);
32: l_prefix_comma VARCHAR2(2);
33: l_first_name_space VARCHAR2(1);
34: l_suffix_space VARCHAR2(1);

Line 49: from hz_parties

45: ELSE
46: select person_first_name , person_last_name, person_title,
47: person_name_suffix ,PERSON_MIDDLE_NAME
48: into l_first_name, l_last_name, l_prefix, l_suffix, l_mid_name
49: from hz_parties
50: where party_id = p_party_id;
51: END IF;
52: ELSE
53: l_first_name := p_firsT_name;

Line 234: l_first_name hz_parties.PERSON_FIRST_NAME%TYPE;

230: , x_exception_msg OUT NOCOPY VARCHAR2
231: )
232: IS
233:
234: l_first_name hz_parties.PERSON_FIRST_NAME%TYPE;
235: l_last_name hz_parties.PERSON_LAST_NAME%TYPE;
236: l_mid_name hz_parties.PERSON_MIDDLE_NAME%TYPE;
237: l_prefix hz_parties.PERSON_PRE_NAME_ADJUNCT%TYPE;
238: l_suffix hz_parties.PERSON_NAME_SUFFIX%TYPE;

Line 235: l_last_name hz_parties.PERSON_LAST_NAME%TYPE;

231: )
232: IS
233:
234: l_first_name hz_parties.PERSON_FIRST_NAME%TYPE;
235: l_last_name hz_parties.PERSON_LAST_NAME%TYPE;
236: l_mid_name hz_parties.PERSON_MIDDLE_NAME%TYPE;
237: l_prefix hz_parties.PERSON_PRE_NAME_ADJUNCT%TYPE;
238: l_suffix hz_parties.PERSON_NAME_SUFFIX%TYPE;
239:

Line 236: l_mid_name hz_parties.PERSON_MIDDLE_NAME%TYPE;

232: IS
233:
234: l_first_name hz_parties.PERSON_FIRST_NAME%TYPE;
235: l_last_name hz_parties.PERSON_LAST_NAME%TYPE;
236: l_mid_name hz_parties.PERSON_MIDDLE_NAME%TYPE;
237: l_prefix hz_parties.PERSON_PRE_NAME_ADJUNCT%TYPE;
238: l_suffix hz_parties.PERSON_NAME_SUFFIX%TYPE;
239:
240: BEGIN

Line 237: l_prefix hz_parties.PERSON_PRE_NAME_ADJUNCT%TYPE;

233:
234: l_first_name hz_parties.PERSON_FIRST_NAME%TYPE;
235: l_last_name hz_parties.PERSON_LAST_NAME%TYPE;
236: l_mid_name hz_parties.PERSON_MIDDLE_NAME%TYPE;
237: l_prefix hz_parties.PERSON_PRE_NAME_ADJUNCT%TYPE;
238: l_suffix hz_parties.PERSON_NAME_SUFFIX%TYPE;
239:
240: BEGIN
241:

Line 238: l_suffix hz_parties.PERSON_NAME_SUFFIX%TYPE;

234: l_first_name hz_parties.PERSON_FIRST_NAME%TYPE;
235: l_last_name hz_parties.PERSON_LAST_NAME%TYPE;
236: l_mid_name hz_parties.PERSON_MIDDLE_NAME%TYPE;
237: l_prefix hz_parties.PERSON_PRE_NAME_ADJUNCT%TYPE;
238: l_suffix hz_parties.PERSON_NAME_SUFFIX%TYPE;
239:
240: BEGIN
241:
242: -- Get the First Name and the Last Name

Line 245: from hz_parties, fnd_lookup_values fl

241:
242: -- Get the First Name and the Last Name
243: select PERSON_FIRST_NAME, PERSON_LAST_NAME , PERSON_MIDDLE_NAME,PERSON_NAME_SUFFIX, FL.MEANING
244: into l_first_name, l_last_name ,l_mid_name,l_suffix,l_prefix
245: from hz_parties, fnd_lookup_values fl
246: where PARTY_ID = p_party_id
247: AND fl.lookup_type(+) = 'CONTACT_TITLE'
248: AND fl.lookup_code(+) = person_pre_name_adjunct
249: AND fl.view_application_id(+) = 222