APPS.RLM_RLMNETCH_XMLP_PKG dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 81: ORG_ORGANIZATION_DEFINITIONS

77: CURSOR CUR_SHIP_FROM(V_SHIP_FROM IN NUMBER) IS
78: SELECT
79: ORGANIZATION_CODE
80: FROM
81: ORG_ORGANIZATION_DEFINITIONS
82: WHERE ORGANIZATION_ID = V_SHIP_FROM;
83: CURSOR CUR_P_SHIP_TO(NU_SHIP_TO IN NUMBER) IS
84: SELECT
85: ACCT_SITE.ECE_TP_LOCATION_CODE

Line 508: V_ORG_NAME ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_NAME%TYPE;

504: RETURN (NULL);
505: END SHIP_TO_NAME1FORMULA;
506:
507: FUNCTION ORG_NAME1FORMULA(SHIP_FROM_ORG_ID1 IN NUMBER) RETURN CHAR IS
508: V_ORG_NAME ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_NAME%TYPE;
509: BEGIN
510: SELECT
511: ORGANIZATION_NAME
512: INTO V_ORG_NAME

Line 514: ORG_ORGANIZATION_DEFINITIONS

510: SELECT
511: ORGANIZATION_NAME
512: INTO V_ORG_NAME
513: FROM
514: ORG_ORGANIZATION_DEFINITIONS
515: WHERE ORGANIZATION_ID = SHIP_FROM_ORG_ID1;
516: RETURN (V_ORG_NAME);
517: EXCEPTION
518: WHEN OTHERS THEN

Line 523: V_SHIP_FROM_NAME ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_NAME%TYPE;

519: RETURN (NULL);
520: END ORG_NAME1FORMULA;
521:
522: FUNCTION SHIP_FROM_NAMEFORMULA(SHIP_FROM_ORG_ID1 IN NUMBER) RETURN CHAR IS
523: V_SHIP_FROM_NAME ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_NAME%TYPE;
524: BEGIN
525: SELECT
526: ORGANIZATION_NAME
527: INTO V_SHIP_FROM_NAME

Line 529: ORG_ORGANIZATION_DEFINITIONS

525: SELECT
526: ORGANIZATION_NAME
527: INTO V_SHIP_FROM_NAME
528: FROM
529: ORG_ORGANIZATION_DEFINITIONS
530: WHERE ORGANIZATION_ID = SHIP_FROM_ORG_ID1;
531: RETURN (V_SHIP_FROM_NAME);
532: EXCEPTION
533: WHEN OTHERS THEN