APPS.EDR_STANDARD dependencies on FND_LOOKUPS

Line 1493: ***** as out parameter. This uses FND_LOOKUPS View ****

1489: /*******************************************************************************
1490: ***** This procedure returns Lookup code meaning ****
1491: ***** It accepts ****
1492: ***** LOOKUP_TYPE and LOOKUP CODE as in parameter and Returns MEANING ****
1493: ***** as out parameter. This uses FND_LOOKUPS View ****
1494: ********************************************************************************/
1495:
1496: PROCEDURE GET_MEANING(P_LOOKUP_TYPE IN VARCHAR2,
1497: P_LOOKUP_CODE IN VARCHAR2,

Line 1501: FROM FND_LOOKUPS

1497: P_LOOKUP_CODE IN VARCHAR2,
1498: P_MEANING OUT NOCOPY VARCHAR2) IS
1499: CURSOR GET_LKUP_MEANING IS
1500: SELECT MEANING
1501: FROM FND_LOOKUPS
1502: WHERE LOOKUP_TYPE = P_LOOKUP_TYPE
1503: AND LOOKUP_CODE = P_LOOKUP_CODE;
1504: BEGIN
1505: OPEN GET_LKUP_MEANING;

Line 1516: ***** as out parameter. This uses FND_LOOKUPS View ****

1512: /*******************************************************************************
1513: ***** This procedure returns USER RESPONSE ****
1514: ***** It accepts ****
1515: ***** LOOKUP_TYPE and PSIG_STATUS as in parameter and Returns RESPONSE ****
1516: ***** as out parameter. This uses FND_LOOKUPS View ****
1517: ********************************************************************************/
1518:
1519: PROCEDURE GET_USER_RESPONSE(P_LOOKUP_TYPE IN VARCHAR2,
1520: P_PSIG_STATUS IN VARCHAR2,

Line 1525: FROM FND_LOOKUPS

1521: P_RESPONSE OUT NOCOPY VARCHAR2) IS
1522: L_LOOKUP_CODE VARCHAR2(30);
1523: CURSOR GET_LKUP_MEANING IS
1524: SELECT MEANING
1525: FROM FND_LOOKUPS
1526: WHERE LOOKUP_TYPE = P_LOOKUP_TYPE
1527: AND LOOKUP_CODE = L_LOOKUP_CODE;
1528: BEGIN
1529: IF(P_PSIG_STATUS = 'REJECTED') THEN