APPS.WSH_WSHRDBOL_XMLP_PKG dependencies on HZ_PARTIES

Line 335: HZ_PARTIES

331: SELECT
332: PARTY_NAME
333: INTO L_CARRIER_NAME
334: FROM
335: HZ_PARTIES
336: WHERE PARTY_ID = L_CARRIER_ID;
337: RETURN (L_CARRIER_NAME);
338: EXCEPTION
339: WHEN OTHERS THEN

Line 360: L_CUSTOMER_NAME HZ_PARTIES.PARTY_NAME%TYPE;

356: RETURN NULL;
357: END CF_MBOL_NUMBERFORMULA;
358:
359: FUNCTION CF_CUSTOMER_NAMEFORMULA(CUSTOMER_NAME IN VARCHAR2) RETURN CHAR IS
360: L_CUSTOMER_NAME HZ_PARTIES.PARTY_NAME%TYPE;
361: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
362: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
363: L_LOOKUP_TYPE VARCHAR2(20);
364: BEGIN

Line 361: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;

357: END CF_MBOL_NUMBERFORMULA;
358:
359: FUNCTION CF_CUSTOMER_NAMEFORMULA(CUSTOMER_NAME IN VARCHAR2) RETURN CHAR IS
360: L_CUSTOMER_NAME HZ_PARTIES.PARTY_NAME%TYPE;
361: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
362: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
363: L_LOOKUP_TYPE VARCHAR2(20);
364: BEGIN
365: /*SRW.REFERENCE(CUSTOMER_NAME)*/NULL;

Line 362: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;

358:
359: FUNCTION CF_CUSTOMER_NAMEFORMULA(CUSTOMER_NAME IN VARCHAR2) RETURN CHAR IS
360: L_CUSTOMER_NAME HZ_PARTIES.PARTY_NAME%TYPE;
361: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
362: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
363: L_LOOKUP_TYPE VARCHAR2(20);
364: BEGIN
365: /*SRW.REFERENCE(CUSTOMER_NAME)*/NULL;
366: SELECT

Line 372: HZ_PARTIES

368: NVL(PERSON_PRE_NAME_ADJUNCT
369: ,PERSON_TITLE) TITLE
370: INTO L_CUSTOMER_NAME,L_PERSON_TITLE
371: FROM
372: HZ_PARTIES
373: WHERE PARTY_NAME = CUSTOMER_NAME;
374: IF L_PERSON_TITLE IS NOT NULL THEN
375: BEGIN
376: L_LOOKUP_TYPE := 'RESPONSIBILITY';