eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_MC_RULE_PVT dependencies on AHL_MC_RULE_STATEMENTS

Line 50: FROM ahl_mc_rule_statements stmt

46: IS
47: --
48: CURSOR ahl_rule_stmt_csr (p_rule_id IN NUMBER) IS
49: SELECT rule_statement_id
50: FROM ahl_mc_rule_statements stmt
51: WHERE rule_id = p_rule_id
52: AND top_rule_stmt_flag = 'T';
53: --
54: l_api_version CONSTANT NUMBER := 1.0;

Line 148: FROM ahl_mc_rule_statements rs, fnd_lookups fnd

144: --
145: CURSOR Check_rule_operator_csr (p_rulestmt_id IN NUMBER) IS
146: SELECT rs.operator, rs.subject_id, rs.object_id,
147: fnd.meaning, rs.object_version_number
148: FROM ahl_mc_rule_statements rs, fnd_lookups fnd
149: WHERE rs.rule_statement_id = p_rulestmt_id
150: AND rs.operator = fnd.lookup_code
151: AND fnd.lookup_type = 'AHL_MC_RULE_ALL_OPERATORS';
152: --

Line 184: FROM ahl_mc_rule_statements rs, fnd_lookups fnd

180: rs.ATTRIBUTE12 ,
181: rs.ATTRIBUTE13 ,
182: rs.ATTRIBUTE14 ,
183: rs.ATTRIBUTE15
184: FROM ahl_mc_rule_statements rs, fnd_lookups fnd
185: WHERE rs.rule_statement_id = p_rulestmt_id
186: AND fnd.lookup_code = decode (rs.negation_flag, 'T', rs.operator||'_NOT', rs.operator)
187: AND fnd.lookup_type = 'AHL_MC_RULE_ALL_OPERATORS';
188: --

Line 209: l_operator AHL_MC_RULE_STATEMENTS.OPERATOR%TYPE;

205: SELECT distinct name
206: FROM ahl_mc_headers_b
207: WHERE mc_id = p_mc_id;
208: --
209: l_operator AHL_MC_RULE_STATEMENTS.OPERATOR%TYPE;
210: l_obj_ver_num NUMBER;
211: l_oper_meaning VARCHAR2(80);
212: l_subject_id AHL_MC_RULE_STATEMENTS.SUBJECT_ID%TYPE;
213: l_object_id AHL_MC_RULE_STATEMENTS.OBJECT_ID%TYPE;

Line 212: l_subject_id AHL_MC_RULE_STATEMENTS.SUBJECT_ID%TYPE;

208: --
209: l_operator AHL_MC_RULE_STATEMENTS.OPERATOR%TYPE;
210: l_obj_ver_num NUMBER;
211: l_oper_meaning VARCHAR2(80);
212: l_subject_id AHL_MC_RULE_STATEMENTS.SUBJECT_ID%TYPE;
213: l_object_id AHL_MC_RULE_STATEMENTS.OBJECT_ID%TYPE;
214: l_subject_tbl AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type;
215: l_object_tbl AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type;
216: l_max NUMBER;

Line 213: l_object_id AHL_MC_RULE_STATEMENTS.OBJECT_ID%TYPE;

209: l_operator AHL_MC_RULE_STATEMENTS.OPERATOR%TYPE;
210: l_obj_ver_num NUMBER;
211: l_oper_meaning VARCHAR2(80);
212: l_subject_id AHL_MC_RULE_STATEMENTS.SUBJECT_ID%TYPE;
213: l_object_id AHL_MC_RULE_STATEMENTS.OBJECT_ID%TYPE;
214: l_subject_tbl AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type;
215: l_object_tbl AHL_MC_RULE_PVT.UI_Rule_Stmt_Tbl_Type;
216: l_max NUMBER;
217:

Line 466: SELECT ahl_mc_rule_statements_s.nextval FROM DUAL;

462: x_rule_stmt_id OUT NOCOPY NUMBER)
463: IS
464: --
465: CURSOR next_rule_stmt_id_csr IS
466: SELECT ahl_mc_rule_statements_s.nextval FROM DUAL;
467:
468: --
469: l_stmt_rec AHL_MC_RULE_PVT.Rule_Stmt_Rec_Type;
470: l_ui_stmt_rec AHL_MC_RULE_PVT.UI_Rule_Stmt_Rec_Type;

Line 1019: FROM ahl_mc_rule_statements

1015: --
1016: --This cursor fetches all rule statements for given rule_id
1017: CURSOR get_rule_stmt_ids_csr (p_rule_id IN NUMBER) IS
1018: SELECT rule_statement_id
1019: FROM ahl_mc_rule_statements
1020: WHERE rule_id = p_rule_id;
1021: --
1022: CURSOR check_mc_status_csr (p_rule_id IN NUMBER) IS
1023: SELECT config_status_code, config_status_meaning

Line 1305: DELETE FROM AHL_MC_RULE_STATEMENTS

1301: END LOOP;
1302:
1303: --If no match, then delete the rule statement
1304: IF (NOT(l_match_flag)) THEN
1305: DELETE FROM AHL_MC_RULE_STATEMENTS
1306: WHERE rule_statement_id = l_rule_stmt_id;
1307: END IF;
1308: END LOOP;
1309:

Line 1564: FROM AHL_MC_RULE_STATEMENTS

1560: WHERE MC_HEADER_ID = p_mc_header_id;
1561: --
1562: CURSOR get_rule_stmt_id_csr (p_rule_id IN NUMBER) IS
1563: SELECT rule_statement_id
1564: FROM AHL_MC_RULE_STATEMENTS
1565: WHERE rule_id = p_rule_id
1566: AND top_rule_stmt_flag = 'T';
1567: --
1568: l_api_version CONSTANT NUMBER := 1.0;

Line 1671: UPDATE AHL_MC_RULE_STATEMENTS

1667: END IF;
1668:
1669: --Set the rule id for the new top statement. Special case
1670: -- can not be included in recursive code.
1671: UPDATE AHL_MC_RULE_STATEMENTS
1672: SET top_rule_stmt_flag = 'T'
1673: WHERE rule_statement_id = l_new_stmt_id;
1674:
1675: END IF;

Line 1882: FROM AHL_MC_RULE_STATEMENTS rst, AHL_MC_PATH_POSITIONS pst

1878: AND lookup.lookup_type = 'AHL_MC_RULE_TYPES'
1879: AND rul.mc_header_id = p_mc_header_id
1880: AND rul.rule_id IN (
1881: SELECT rst.rule_id
1882: FROM AHL_MC_RULE_STATEMENTS rst, AHL_MC_PATH_POSITIONS pst
1883: WHERE rst.subject_type = 'POSITION'
1884: AND rst.subject_id = pst.path_position_id
1885: AND p_encoded_path LIKE pst.encoded_path_position
1886: AND p_size = (select COUNT(path_position_node_id) FROM

Line 1890: FROM AHL_MC_RULE_STATEMENTS rst, AHL_MC_PATH_POSITIONS pst

1886: AND p_size = (select COUNT(path_position_node_id) FROM
1887: AHL_MC_PATH_POSITION_NODES where path_position_id=pst.path_position_id)
1888: UNION ALL
1889: SELECT rst.rule_id
1890: FROM AHL_MC_RULE_STATEMENTS rst, AHL_MC_PATH_POSITIONS pst
1891: WHERE (rst.object_type = 'ITEM_AS_POSITION'
1892: OR rst.object_type = 'CONFIG_AS_POSITION')
1893: AND rst.object_id = pst.path_position_id
1894: AND p_encoded_path LIKE pst.encoded_path_position