APPS.AHL_MC_RULE_STMT_PVT dependencies on FND_LOOKUPS

Line 1376: l_oper_meaning FND_LOOKUPS.MEANING%TYPE;

1372: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.validate_pos_quantity_rule';
1373: l_child_rel_id NUMBER;
1374: l_child_count NUMBER;
1375: l_dummy NUMBER;
1376: l_oper_meaning FND_LOOKUPS.MEANING%TYPE;
1377: l_obj_typ_meaning FND_LOOKUPS.MEANING%TYPE;
1378: --
1379: BEGIN
1380:

Line 1377: l_obj_typ_meaning FND_LOOKUPS.MEANING%TYPE;

1373: l_child_rel_id NUMBER;
1374: l_child_count NUMBER;
1375: l_dummy NUMBER;
1376: l_oper_meaning FND_LOOKUPS.MEANING%TYPE;
1377: l_obj_typ_meaning FND_LOOKUPS.MEANING%TYPE;
1378: --
1379: BEGIN
1380:
1381: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)THEN

Line 1669: FROM fnd_lookups fnd

1665: IS
1666: --
1667: CURSOR get_rule_oper_csr(p_oper IN VARCHAR2, p_neg IN VARCHAR2) IS
1668: SELECT fnd.meaning
1669: FROM fnd_lookups fnd
1670: WHERE fnd.lookup_code = decode (p_neg, 'T', p_oper||'_NOT', p_oper)
1671: AND fnd.lookup_type = 'AHL_MC_RULE_ALL_OPERATORS';
1672: --
1673: l_operator FND_LOOKUPS.MEANING%TYPE;

Line 1673: l_operator FND_LOOKUPS.MEANING%TYPE;

1669: FROM fnd_lookups fnd
1670: WHERE fnd.lookup_code = decode (p_neg, 'T', p_oper||'_NOT', p_oper)
1671: AND fnd.lookup_type = 'AHL_MC_RULE_ALL_OPERATORS';
1672: --
1673: l_operator FND_LOOKUPS.MEANING%TYPE;
1674: --
1675: BEGIN
1676: OPEN get_rule_oper_csr(p_rule_oper, p_neg_flag);
1677: FETCH get_rule_oper_csr INTO l_operator;

Line 1693: FROM fnd_lookups fnd

1689: IS
1690: --
1691: CURSOR get_fnd_lkup_meaning_csr(p_lookup_type IN VARCHAR2, p_lookup_code IN VARCHAR2) IS
1692: SELECT fnd.meaning
1693: FROM fnd_lookups fnd
1694: WHERE fnd.lookup_code = p_lookup_code
1695: AND fnd.lookup_type = p_lookup_type;
1696: --
1697: l_lkup_meaning FND_LOOKUPS.MEANING%TYPE;

Line 1697: l_lkup_meaning FND_LOOKUPS.MEANING%TYPE;

1693: FROM fnd_lookups fnd
1694: WHERE fnd.lookup_code = p_lookup_code
1695: AND fnd.lookup_type = p_lookup_type;
1696: --
1697: l_lkup_meaning FND_LOOKUPS.MEANING%TYPE;
1698: --
1699: BEGIN
1700: OPEN get_fnd_lkup_meaning_csr(p_lookup_type, p_lookup_code );
1701: FETCH get_fnd_lkup_meaning_csr INTO l_lkup_meaning;