APPS.WSH_WSHRDBOL_XMLP_PKG dependencies on HZ_PARTIES

Line 346: HZ_PARTIES

342: SELECT
343: PARTY_NAME
344: INTO L_CARRIER_NAME
345: FROM
346: HZ_PARTIES
347: WHERE PARTY_ID = L_CARRIER_ID;
348: RETURN (L_CARRIER_NAME);
349: EXCEPTION
350: WHEN OTHERS THEN

Line 371: L_CUSTOMER_NAME HZ_PARTIES.PARTY_NAME%TYPE;

367: RETURN NULL;
368: END CF_MBOL_NUMBERFORMULA;
369:
370: FUNCTION CF_CUSTOMER_NAMEFORMULA(CUSTOMER_NAME IN VARCHAR2) RETURN CHAR IS
371: L_CUSTOMER_NAME HZ_PARTIES.PARTY_NAME%TYPE;
372: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
373: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
374: L_LOOKUP_TYPE VARCHAR2(20);
375: BEGIN

Line 372: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;

368: END CF_MBOL_NUMBERFORMULA;
369:
370: FUNCTION CF_CUSTOMER_NAMEFORMULA(CUSTOMER_NAME IN VARCHAR2) RETURN CHAR IS
371: L_CUSTOMER_NAME HZ_PARTIES.PARTY_NAME%TYPE;
372: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
373: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
374: L_LOOKUP_TYPE VARCHAR2(20);
375: BEGIN
376: /*SRW.REFERENCE(CUSTOMER_NAME)*/NULL;

Line 373: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;

369:
370: FUNCTION CF_CUSTOMER_NAMEFORMULA(CUSTOMER_NAME IN VARCHAR2) RETURN CHAR IS
371: L_CUSTOMER_NAME HZ_PARTIES.PARTY_NAME%TYPE;
372: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
373: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
374: L_LOOKUP_TYPE VARCHAR2(20);
375: BEGIN
376: /*SRW.REFERENCE(CUSTOMER_NAME)*/NULL;
377: SELECT

Line 383: HZ_PARTIES

379: NVL(PERSON_PRE_NAME_ADJUNCT
380: ,PERSON_TITLE) TITLE
381: INTO L_CUSTOMER_NAME,L_PERSON_TITLE
382: FROM
383: HZ_PARTIES
384: WHERE PARTY_NAME = CUSTOMER_NAME;
385: IF L_PERSON_TITLE IS NOT NULL THEN
386: BEGIN
387: L_LOOKUP_TYPE := 'RESPONSIBILITY';