APPS.AHL_MC_RULE_STMT_PVT dependencies on AHL_MC_RULE_STATEMENTS

Line 53: FROM ahl_mc_rule_statements

49: WHERE rule_id = p_rule_id;
50: --
51: CURSOR Check_rule_statement_csr (p_rule_stmt_id IN NUMBER) IS
52: SELECT 'X'
53: FROM ahl_mc_rule_statements
54: WHERE rule_statement_id = p_rule_stmt_id;
55:
56: --Checks that position_id is valid and that position_id maps to the rule's mc
57: -- by checking mc_id and version are the same.

Line 422: SELECT ahl_mc_rule_statements_s.nextval FROM DUAL;

418: p_x_rule_stmt_rec IN OUT NOCOPY AHL_MC_RULE_PVT.Rule_Stmt_Rec_Type)
419: IS
420: --
421: CURSOR next_rule_stmt_id_csr IS
422: SELECT ahl_mc_rule_statements_s.nextval FROM DUAL;
423: --
424: l_api_version CONSTANT NUMBER := 1.0;
425: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Rule_Stmt';
426: --

Line 535: INSERT INTO ahl_mc_rule_statements(

531: FETCH next_rule_stmt_id_csr INTO p_x_rule_stmt_rec.rule_statement_id;
532: CLOSE next_rule_stmt_id_csr;
533: END IF;
534:
535: INSERT INTO ahl_mc_rule_statements(
536: RULE_STATEMENT_ID,
537: OBJECT_VERSION_NUMBER,
538: LAST_UPDATE_DATE,
539: LAST_UPDATED_BY,

Line 675: FROM AHL_MC_RULE_STATEMENTS

671: IS
672: --
673: CURSOR ahl_mc_rule_stmt_csr (p_rstmt_id IN NUMBER) IS
674: SELECT *
675: FROM AHL_MC_RULE_STATEMENTS
676: WHERE rule_statement_id = p_rstmt_id;
677: --
678: l_api_version CONSTANT NUMBER := 1.0;
679: l_api_name CONSTANT VARCHAR2(30) := 'Update_Rule_Stmt';

Line 852: UPDATE ahl_mc_rule_statements SET

848: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
850: END IF;
851:
852: UPDATE ahl_mc_rule_statements SET
853: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
854: LAST_UPDATE_DATE = sysdate,
855: LAST_UPDATED_BY = fnd_global.USER_ID,
856: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID,

Line 953: FROM ahl_mc_rule_statements rs

949: x_rule_stmt_id OUT NOCOPY NUMBER) IS
950: --
951: CURSOR get_rule_stmt_csr (p_rulestmt_id IN NUMBER) IS
952: SELECT *
953: FROM ahl_mc_rule_statements rs
954: WHERE rs.rule_statement_id = p_rulestmt_id;
955: --
956: l_api_version CONSTANT NUMBER := 1.0;
957: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Rule_Stmt';

Line 1238: FROM ahl_mc_rule_statements stmt

1234: IS
1235: --
1236: CURSOR ahl_rule_stmts_csr (p_rule_id IN NUMBER) IS
1237: SELECT rule_statement_id
1238: FROM ahl_mc_rule_statements stmt
1239: WHERE rule_id = p_rule_id;
1240: --
1241: l_api_version CONSTANT NUMBER := 1.0;
1242: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Rule_Stmts';

Line 1274: DELETE FROM AHL_MC_RULE_STATEMENTS

1270: FETCH ahl_rule_stmts_csr INTO l_stmt_id;
1271: EXIT WHEN ahl_rule_stmts_csr%NOTFOUND;
1272:
1273: IF (ahl_rule_stmts_csr%FOUND) THEN
1274: DELETE FROM AHL_MC_RULE_STATEMENTS
1275: WHERE rule_statement_id = l_stmt_id;
1276: END IF;
1277:
1278: END LOOP;

Line 1538: FROM ahl_mc_rules_b rul, ahl_mc_rule_statements ruls

1534: ruls.subject_type,
1535: ruls.operator,
1536: ruls.object_type,
1537: ruls.OBJECT_ATTRIBUTE1
1538: FROM ahl_mc_rules_b rul, ahl_mc_rule_statements ruls
1539: WHERE rul.rule_id = ruls.rule_id
1540: AND rul.mc_header_id = p_mc_header_id
1541: AND ruls.object_type = 'TOT_CHILD_QUANTITY'
1542: AND TRUNC(nvl(rul.ACTIVE_START_DATE, sysdate-1)) < TRUNC(sysdate)