APPS.AHL_MC_RULE_STMT_PVT dependencies on AHL_MC_RULE_STATEMENTS_S

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 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 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';