APPS.AHL_MC_RULE_PUB dependencies on FND_LOOKUPS

Line 1246: FROM FND_LOOKUPS

1242: AND mc_header_id = p_mc_header_id;
1243:
1244: CURSOR chk_lookup_code_csr (p_lookup_type VARCHAR2, p_lookup_code VARCHAR2) IS
1245: SELECT 'X'
1246: FROM FND_LOOKUPS
1247: WHERE lookup_type = p_lookup_type
1248: AND lookup_code = p_lookup_code;
1249: --
1250: l_api_name CONSTANT VARCHAR2(30) := 'Convert_Rule_Values_to_Id';

Line 1256: l_rule_type_code FND_LOOKUPS.LOOKUP_CODE%TYPE;

1252:
1253: l_rule_rec AHL_MC_RULE_PVT.Rule_Rec_Type DEFAULT p_x_rule_rec;
1254: l_rule_id NUMBER;
1255: l_mc_header_id NUMBER;
1256: l_rule_type_code FND_LOOKUPS.LOOKUP_CODE%TYPE;
1257: l_return_val BOOLEAN;
1258: l_dummy VARCHAR2(1);
1259: --
1260:

Line 1518: FROM FND_LOOKUPS

1514: WHERE rule_statement_id = p_rule_stmt_id;
1515:
1516: CURSOR chk_lookup_code_csr (p_lookup_type VARCHAR2, p_lookup_code VARCHAR2) IS
1517: SELECT 'X'
1518: FROM FND_LOOKUPS
1519: WHERE lookup_type = p_lookup_type
1520: AND lookup_code = p_lookup_code;
1521: --
1522: l_api_name CONSTANT VARCHAR2(30) := 'Convert_Rule_Stmt_Values_to_Id';

Line 1528: l_rule_operator FND_LOOKUPS.LOOKUP_CODE%TYPE;

1524:
1525: l_item_id NUMBER;
1526: l_mc_id NUMBER;
1527: l_ui_rule_stmt_tbl AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type DEFAULT p_x_ui_rule_stmt_tbl;
1528: l_rule_operator FND_LOOKUPS.LOOKUP_CODE%TYPE;
1529: l_rule_rule_operator FND_LOOKUPS.LOOKUP_CODE%TYPE;
1530: l_rule_object_type FND_LOOKUPS.LOOKUP_CODE%TYPE;
1531: l_return_val BOOLEAN;
1532: l_dummy VARCHAR2(1);

Line 1529: l_rule_rule_operator FND_LOOKUPS.LOOKUP_CODE%TYPE;

1525: l_item_id NUMBER;
1526: l_mc_id NUMBER;
1527: l_ui_rule_stmt_tbl AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type DEFAULT p_x_ui_rule_stmt_tbl;
1528: l_rule_operator FND_LOOKUPS.LOOKUP_CODE%TYPE;
1529: l_rule_rule_operator FND_LOOKUPS.LOOKUP_CODE%TYPE;
1530: l_rule_object_type FND_LOOKUPS.LOOKUP_CODE%TYPE;
1531: l_return_val BOOLEAN;
1532: l_dummy VARCHAR2(1);
1533: l_flag VARCHAR2(1) := 'N';

Line 1530: l_rule_object_type FND_LOOKUPS.LOOKUP_CODE%TYPE;

1526: l_mc_id NUMBER;
1527: l_ui_rule_stmt_tbl AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type DEFAULT p_x_ui_rule_stmt_tbl;
1528: l_rule_operator FND_LOOKUPS.LOOKUP_CODE%TYPE;
1529: l_rule_rule_operator FND_LOOKUPS.LOOKUP_CODE%TYPE;
1530: l_rule_object_type FND_LOOKUPS.LOOKUP_CODE%TYPE;
1531: l_return_val BOOLEAN;
1532: l_dummy VARCHAR2(1);
1533: l_flag VARCHAR2(1) := 'N';
1534: --