APPS.PON_EMD_VALIDATION_PKG dependencies on HZ_PARTIES

Line 352: L_PERSON_FIRST_NAME HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

348:
349: FUNCTION get_user_name(P_USER_ID IN NUMBER ) RETURN VARCHAR2
350: IS
351:
352: L_PERSON_FIRST_NAME HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
353: L_PERSON_MIDDLE_NAME HZ_PARTIES.PERSON_MIDDLE_NAME%TYPE;
354: L_PERSON_LAST_NAME HZ_PARTIES.PERSON_LAST_NAME%TYPE;
355: L_PERSON_PRE_NAME_ADJUNCT HZ_PARTIES.PERSON_PRE_NAME_ADJUNCT%TYPE;
356: L_PERSON_NAME_SUFFIX HZ_PARTIES.PERSON_NAME_SUFFIX%TYPE;

Line 353: L_PERSON_MIDDLE_NAME HZ_PARTIES.PERSON_MIDDLE_NAME%TYPE;

349: FUNCTION get_user_name(P_USER_ID IN NUMBER ) RETURN VARCHAR2
350: IS
351:
352: L_PERSON_FIRST_NAME HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
353: L_PERSON_MIDDLE_NAME HZ_PARTIES.PERSON_MIDDLE_NAME%TYPE;
354: L_PERSON_LAST_NAME HZ_PARTIES.PERSON_LAST_NAME%TYPE;
355: L_PERSON_PRE_NAME_ADJUNCT HZ_PARTIES.PERSON_PRE_NAME_ADJUNCT%TYPE;
356: L_PERSON_NAME_SUFFIX HZ_PARTIES.PERSON_NAME_SUFFIX%TYPE;
357: L_PARTY_ID NUMBER;

Line 354: L_PERSON_LAST_NAME HZ_PARTIES.PERSON_LAST_NAME%TYPE;

350: IS
351:
352: L_PERSON_FIRST_NAME HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
353: L_PERSON_MIDDLE_NAME HZ_PARTIES.PERSON_MIDDLE_NAME%TYPE;
354: L_PERSON_LAST_NAME HZ_PARTIES.PERSON_LAST_NAME%TYPE;
355: L_PERSON_PRE_NAME_ADJUNCT HZ_PARTIES.PERSON_PRE_NAME_ADJUNCT%TYPE;
356: L_PERSON_NAME_SUFFIX HZ_PARTIES.PERSON_NAME_SUFFIX%TYPE;
357: L_PARTY_ID NUMBER;
358:

Line 355: L_PERSON_PRE_NAME_ADJUNCT HZ_PARTIES.PERSON_PRE_NAME_ADJUNCT%TYPE;

351:
352: L_PERSON_FIRST_NAME HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
353: L_PERSON_MIDDLE_NAME HZ_PARTIES.PERSON_MIDDLE_NAME%TYPE;
354: L_PERSON_LAST_NAME HZ_PARTIES.PERSON_LAST_NAME%TYPE;
355: L_PERSON_PRE_NAME_ADJUNCT HZ_PARTIES.PERSON_PRE_NAME_ADJUNCT%TYPE;
356: L_PERSON_NAME_SUFFIX HZ_PARTIES.PERSON_NAME_SUFFIX%TYPE;
357: L_PARTY_ID NUMBER;
358:
359: X_NAME VARCHAR2(1000);

Line 356: L_PERSON_NAME_SUFFIX HZ_PARTIES.PERSON_NAME_SUFFIX%TYPE;

352: L_PERSON_FIRST_NAME HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
353: L_PERSON_MIDDLE_NAME HZ_PARTIES.PERSON_MIDDLE_NAME%TYPE;
354: L_PERSON_LAST_NAME HZ_PARTIES.PERSON_LAST_NAME%TYPE;
355: L_PERSON_PRE_NAME_ADJUNCT HZ_PARTIES.PERSON_PRE_NAME_ADJUNCT%TYPE;
356: L_PERSON_NAME_SUFFIX HZ_PARTIES.PERSON_NAME_SUFFIX%TYPE;
357: L_PARTY_ID NUMBER;
358:
359: X_NAME VARCHAR2(1000);
360: BEGIN

Line 377: HZ_PARTIES

373: L_PERSON_LAST_NAME,
374: L_PERSON_PRE_NAME_ADJUNCT,
375: L_PERSON_NAME_SUFFIX
376: FROM
377: HZ_PARTIES
378: WHERE
379: PARTY_ID=L_PARTY_ID;
380:
381: X_NAME:=PON_LOCALE_PKG.party_display_name (